Best answer

Populate an image from a Google Slide?

  • 11 October 2020
  • 5 replies
  • 907 views

Userlevel 1

(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?

icon

Best answer by Troy Tessalone 11 October 2020, 17:13

View original

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

Userlevel 7
Badge +14

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

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.

Userlevel 7
Badge +14

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

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

 

 

Userlevel 7
Badge +14

Make sure Template placeholder names do NOT have any spaces.

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