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.

Question

Importing Google Sheet information into Google Doc Template

  • 18 May 2020
  • 3 replies
  • 324 views
A

Here is the backstory to my questions below.

I have created a Google Doc template in my gsuite.

I have a Google Sheet that when a row is added I want Zapier to create a new Google Doc from the Google Doc Template I assign.

It creates the document and puts the document into the folder i assigned in my google drive, however, what i need assistance with is how do i get it to put the information from the sheet into the doc.

 

I assume it would be something like {{header column name}} but I cant figure out how to do it so that is what i need assistance with.

 

My question is how do i get Zappier to transfer the data in the row of the sheet into specific parts of the google doc?

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

3 replies

J
Userlevel 1

Hi

  1. Select Google Sheets as your trigger with new spreadsheet row as your trigger event. 
  2. Add placeholders in the google doc template {{placeholder}}
  3. Use dynamic content from Google Sheets to populate the placeholders (you can use all of the data in the row captured in Step 1)

 

G

hey @jg97  

I placed {{placeholders}} and now the file is created but the data I entered in the google sheet row does not replace the header name in the placeholders.

this is after i set the triger, (triger is add row)

 please your advice

 

Danvers
Userlevel 7
Badge +12

Hi @gash! I can see from your screenshot that the Zap wasn’t turned on when you last posted a reply. Were you testing the Google Docs step and that didn’t work? Or were you adding a new row to Google Sheets and nothing happened. 

 

If it’s the second of those two, you’ll need to turn on your Zap first. 

 

If you’re still having trouble with getting the fields from Google Sheets to populate the placeholders in the document, there’s a handy tutorial here: How to Create and Autopopulate a Google Docs Template

Terms & Conditions