Skip to main content
Best answer

Populate an image from a Google Slide?

  • October 11, 2020
  • 5 replies
  • 1102 views

(I mean from a Google Sheet, can’t edit title...)

 

Hi everyone! 

I run a swim school, and I’m looking for a way to automate the population of a Google Slide (or similar - I’m not aware of any other platform we might use for this) from a Google Sheet. The aim is to create a custom image for each one of our students, each week, showing what progress they have made that week, that we then email out to them week once their lesson progress has been updated on the Sheet.

Each Slide would be customised based on one row - so I guess I’d create a Slide template, then have placeholders for name, current level, and progress this week.

Is there a way to do this for each of our 500+ students, so they get an updated image every week showing their progress?

Best answer by Troy Tessalone

Tip: To pass images onto the template, you just need to create a text placeholder variable on your presentation template, then pass on a URL to a hosted image on your Zap template.

Article: https://zapier.com/help/doc/how-use-set-google-slides-presentation-action

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • October 11, 2020

Tip: To pass images onto the template, you just need to create a text placeholder variable on your presentation template, then pass on a URL to a hosted image on your Zap template.

Article: https://zapier.com/help/doc/how-use-set-google-slides-presentation-action


  • New
  • December 7, 2020

I have these setup. But when i sent a zap. the {{signature}} is not being replaced. The history indicate the variable has been passed over.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 7, 2020

Please provide screenshots of your Zap step configurations and Zap Task History Details in order for us to troubleshoot further.


  • New
  • December 8, 2020

Here is my zap: https://zapier.com/shared/398bcf3ed0b8692815347e9aef71ec23a5983e08

History is below

 

is_shared:

true

presentation_id:

1updhvAKf4ZDgZcuN4kAPFR-jTEbqj2c5Ukv1rqaeCEs

template_fields__New Company Name:

Alamak

template_fields__Signature1:

https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ux0T8dsWJbVDV3m8svb5/pub/V0IVJAXIfxW9MsqRC2sd.png

template_fields__Signature2:

https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ux0T8dsWJbVDV3m8svb5/pub/V0IVJAXIfxW9MsqRC2sd.png

template_fields__Signature 3:

https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ux0T8dsWJbVDV3m8svb5/pub/V0IVJAXIfxW9MsqRC2sd.png

template_fields__dir1:

Loo Yu Yen

template_fields__dir ic 1r:

redacted-redacted

template_fields__dir2 :

Faris Jasni

template_fields__dir ic 2:

121121

template_fields__dir3:

Akmal

template_fields__dir ic 3:

121212

title:

Loo Yu Yen

Fields with no value:

template_fields__Sign Date

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 8, 2020

Make sure Template placeholder names do NOT have any spaces.

Which Signature placeholder field? (1, 2, or 3)