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.

I am attempting to create a dynamic playbook that will generate out of google docs.  I have a google form created that loads responses into sheets.  I also have a google sheet that defines strategies for specific pain point areas.  My zaps are currently set up as:

1 → New response in google sheet A from google form

2 → Column in google sheet B corresponds to google sheet A

3 → Create from google doc template

All tests run successfully, but when I open the google doc the fields that need to be mapped (example: {{pain point}} is not populated. I’ve double checked that the fields in the google doc template match those in the spreadsheets and that there is no weird formatting.  Any suggestions would be welcome!

Hi ​@BethT1017 

Help us have more info by posting screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.

 

Help links for using GDocs in Zaps: https://zapier.com/apps/google-docs/integrations#help

​@Troy Tessalone thank you for your help, please see the screen shots below

Step 1: The Responses from the Google Form 

Step 2 -look up spreadsheet row from the worksheet with the pain points and corresponding strategies

Step 3: Create Document From Template

Output Generated

 

Hi there ​@BethT1017,

Before we dig deeper into this, have you mapped the fields of the Google Docs step with the data from the Google Sheets step? You can learn more about mapping fields here: https://help.zapier.com/hc/en-us/articles/8496343026701-Send-data-between-steps-by-mapping-fields

I'll be keeping an eye out for your response!

Hi ​@ken.a, I’ve mapped the fields of the google sheet.  When I choose the google doc, I’m not seeing where specific fields would map in zapier? The only two fields, potentially, would be Date and Industry that show at the bottom of the screen. But when I map those two, the other fields still do not populate.

 

 

Hi ​@BethT1017,

Thanks for the update here.

There might be HTML formatting on your template fields in Google Doc. Could you please try following this help doc that tackles these kind of issues: https://help.zapier.com/hc/en-us/articles/8495982583053-Common-Problems-with-Google-Docs#my-template-fields-aren-t-appearing-in-zapier-or-they-all-have-generic-names-0-1

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

HI ​@ken.a I tried completely rewriting the template in google docs, as well as clearing the formats, and it will still not map.

Thanks for giving that a try ​@BethT1017.

I’d recommend reaching out to our Support Team to take a closer look at the issue that you’re encountering. Our Support Team has the correct tools to look closer at the Zap and its logs.

You can reach our Support Team here: https://zapier.com/app/get-help

Hopefully, this helps.

Reply


Terms & Conditions