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.

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?

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)

 

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

 

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