Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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

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.

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

 

 

Make sure Template placeholder names do NOT have any spaces.

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

 

Terms & Conditions