About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

How do I substitute a quickchart.io chart into a Google Doc template?

  • 27 April 2022
  • 4 replies
  • 83 views
M

Hi all,

I’ve got a whole workflow already created and working which creates a complex, well-formatted Google Doc from a Google Doc template, filling it in with data from a Google Sheet and exporting it to a PDF. 

Now I want to enhance this document by inserting custom images--namely charts created by the Quickchart.io action (created with data from the same Google Sheet). 

I’ve got it to the point where I can insert the URL produced by Quickchart.io, but I cannot figure out a way to insert the IMAGE produced by the URL. I know that one can create a Google Doc from HTML and create an image that way, but that’s not what I need--this is a Google Doc template that’s already formatted exactly the way I want, and I cannot recreate that with HTML.

Google Docs created manually via the browser can have an image inserted based on a URL, which is what I would use if I were creating this manually, but I can’t figure out a way to do that via Zapier’s template-filling action or similar hack.

Any ideas? Thanks.

/mike

icon

Best answer by christina.d 10 May 2022, 17:55

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.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @mikegriefkey 

Good question.

I’ve run into this issue where a GDoc Template being created via a Zap cannot handle HTML unfortunately.

You can try using a different PDF creator app: https://zapier.com/apps/categories/documents

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M

Hi @Troy Tessalone, thanks for your thoughts. 

Unfortunately, I’ve already pretty exhaustively explored other document creation solutions and in spite of some of them being quite expensive, none of them really provide the same ability that the Google Doc template filler provides, which is to easily fill a pre-formatted document with data, and easily export to a PDF. The tools that allow creation of PDFs assume that it’s going to be used in certain ways or is part of some business process workflow that they facilitate. If you have a SPECIFIC one you want to point me to that actually solves my problem and is just as easy to use, by all means, please let me know which one you’re referring to.

But as of right now, all the other document integrations in Zapier’s list seem to be far harder to use, don’t do the more basic things I’m already doing with Google Docs, and are very expensive.  

/mike

Danvers
Userlevel 7
Badge +12

Hi @mikegriefkey!

I spent some time playing with Google doc templates and I can’t find a way to embed an image placeholder.

One workaround that some folks use is to create a Google Slide template and use Zapier to create a document based on that. I’ve not tried it myself, but my understanding is that you change the page set up of the slide to be A4 portrait, add everything that you need in the template and use Zapier to fill in the placeholders. I hope that helps!

christina.d
Userlevel 7
Badge +9

Hi there, friends! 👋🏽 I wanted to pop in and consolidate some of these answers into one in case it’s helpful! 

I’ve run into this issue where a GDoc Template being created via a Zap cannot handle HTML unfortunately.

You can try using a different PDF creator app: https://zapier.com/apps/categories/documents

 

I spent some time playing with Google doc templates and I can’t find a way to embed an image placeholder.

One workaround that some folks use is to create a Google Slide template and use Zapier to create a document based on that. I’ve not tried it myself, but my understanding is that you change the page set up of the slide to be A4 portrait, add everything that you need in the template and use Zapier to fill in the placeholders. I hope that helps!

 

Terms & Conditions