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.

Objective: I am trying to automate a process where a new spreadsheet row triggers the creation of a dynamic QR code using QR Tiger, which then leads to the generation of a Google Document from a template. In this Google Doc, it now just comes as a dynamic URL to a QR png. I wish to replace the URL placeholder with the actual QR code image (sourced from the QR code URL).
 

Problem: While I have successfully set up the first three steps of my Zap (New Spreadsheet Row -> Create QR Code -> Create Document from Template), I am struggling with the step where the URL in the Google Document is replaced with the actual QR code image.

I've attempted to use Google Apps Script to detect the URL placeholder and replace it with the QR code image, but I consistently giving me errors. Not sure how to solve this problem any maybe there’s a smarter way.

Here's a brief overview of my Zap:

  1. New Spreadsheet Row in Google Sheets: Trigger.
  2. Create Dynamic QR Code (URL) in QR Tiger: Generates a QR code URL like “https://qrtiger.com/qr/TNL5.png”.
  3. Create Document from Template in Google Docs: Uses a A4-template that has a placeholder for the QR code URL.
  4. POST in Webhooks by Zapier: This is where I'm attempting to trigger the Google Apps Script to replace the URL with the image. (Maybe there’s a smarter and easier way?)

I've confirmed that the placeholder URL is present in the newly created Google Document. Despite various attempts and modifications to the script (written by ChatGPT), I'm unable to make this work.

Would appreciate any guidance, insights, or alternative solutions to achieve this. Thank you in advance!

Bump.

Anyone?

The impossible question it seems? :)

Hi, i’m responding to let you know that the dev team is already reviewing your concern. I will get back to you within the next 12 hours. 

Hi @Matadoren 

Good question.

You can use GSlides instead of GDocs. (Help)

 

 

 

Or you’d need to use GDocs API: https://developers.google.com/docs/api/reference/rest

 

Thank you for the reply. But unfortunately Google Presentation doesn’t allow A4 formats as far as I’m aware.

In addition, the code (at least made from ChatGPT4) for GDocs API doesn’t work either to convert .png URL to image in Google doc.

@Matadoren 

In GSlides you can specify the page size as part of the page setup.

 

Thanks Troy, unfortunately it still just gives me a https://XXX.XX/X.png text instead of the image of the .png..

Are there any additional adjustments I would need to do to my {{QRCode}} tag in the Google Slides Template?

Just noticed now that if I set it up as a “create dynamic QR” it works and the URL automatically becomes a URL. But when I just a “Static QR Code” URL it doesn’t work. Any ideas?

 

 

Terms & Conditions