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.

  • Home
  • Get Help
  • How Do I
  • How do I troubleshoot for Google Doc placeholders not populating from a Google Spreadsheet Zap?

Hi,

I have a Google Docs template that uses a two column table.

The placeholder is formatted as instructed, with the Google Spreadsheet’s column name in between brackets without spaces ie. {{BrandName}}.  

I made sure that there is no formatting for that text.  

The Google Docs template is pulling from a worksheet page that uses an auto population formula to pull data from another worksheet in the same spreadsheet doc.  I thought that might be the issue, but when I tried to pull it from the main source the problem remained.

 

I’m strapped for time to get this sorted.  Any suggestions for troubleshooting? 

 

Hi @TheCollectiveLMG 

Can you post screenshot about how your Zap steps are currently configured?

Perhaps outline a specific example for us.

TIP: If you are testing with your Zap ON, then check your Zap Runs for the DATA IN/OUT for each step: https://zapier.com/app/history/

 

Yes, thank you for your response.

 

Here are the steps:

Action: Create Document from Template in Google Docs
Action: Create Document from Template in Google Docs
Action:New or Updated Spreadsheet Row in Google Sheets

 

Action: New or Updated Spreadsheet Row in Google Sheets

 

 

Action: New or Updated Spreadsheet Row in Google Sheets

 

 

Here are screenshots of the Spreadsheet & Google template:

THE SPREADSHEET

 

 

THE TEMPLATE

 

Let me know any clarifications that are needed!  Much appreciated.

 

 

 

 

@TheCollectiveLMG

The provided screenshots don’t show how the data points are mapped from the GSheet trigger step to the fields in Step 2 where the GDoc Template is being created.

Please post those, thanks.

I’m sorry Troy,  can you clarify where I find that so that I can be sure I’m grabbing the correct info?

@TheCollectiveLMG 

Should be underneath this screenshot

 

Thank you!  Here we go:

 

 

@TheCollectiveLMG 

You need to map data points from the GSheet using the ‘Custom’ option OR insert static values to each of these GDoc Template fields in order for them to be populated.

 

Please excuse my ignorance...do you know if there is a tutorial that shows how to do that?

@TheCollectiveLMG 

The same way you mapped this field in the “New Document Name”.

Use the ‘Custom’ mapping option.

See help article: https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action

 

Hi again,  Hopefully this will be the final issue to address for me - I noticed that some of the mapping info (data to be inserted) was not matching what is in the spreadsheet. I corrected the issue in the live spreadsheet, but it is not refreshing in the “set up action” section.  I tried refreshing the fields, refreshing the page (both for the live spreadsheet & Zapier page).  

 

Any suggestions?

@TheCollectiveLMG 

Article about how to change the trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

Troy, I cannot begin to thank you enough for your swift and succinct responses, it worked!

 

Hi friends! I wanted to pop in and consolidate some of the responses here into in case it helps other users who stumbled on here: 

@TheCollectiveLMG

You need to map data points from the GSheet using the ‘Custom’ option OR insert static values to each of these GDoc Template fields in order for them to be populated.

 

Which can be achieved by: 

@TheCollectiveLMG

The same way you mapped this field in the “New Document Name”.

Use the ‘Custom’ mapping option.

See help article: https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action

 

If you’re having any issues with trigger test data:

@TheCollectiveLMG

Article about how to change the trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

 

Terms & Conditions