Skip to main content
Best answer

How do I map out dynamic data from Google sheets to Google docs

  • May 5, 2025
  • 3 replies
  • 44 views

Im currntly creating a automated workflow. Where users input data into a Google Form(Sheets), then I have a Google Docs template. I’m trying to have it where the data within Google Form is automated to fill in the correct fields. But when I go setup the “Create Documents From Template” option. I do not see anywhere to map out the data to specfic fields.

I was following this guide https://zapier.com/blog/create-autopopulate-google-docs-template/ but get stuck at “map the data...” step due to not finding it when I do it.

Here is a picture of what I see(I do not see and option to map out fields from the sheets):


Here is a picture of the test. None of the fields pop up other then the “title? and I see no option to map them out:


 

Best answer by Troy Tessalone

Hi ​@tenzin 

Reference the help link for GDocs and make sure you GDoc Template placecholders are created correctly: https://help.zapier.com/hc/en-us/articles/8495982583053-Common-Problems-with-Google-Docs#remove-any-html-formatting-0-2

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34079 replies
  • Answer
  • May 5, 2025

Hi ​@tenzin 

Reference the help link for GDocs and make sure you GDoc Template placecholders are created correctly: https://help.zapier.com/hc/en-us/articles/8495982583053-Common-Problems-with-Google-Docs#remove-any-html-formatting-0-2


  • Author
  • New
  • 1 reply
  • May 5, 2025

@Troy Tessalone Thanks, it was a formatting issue! 


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 3527 replies
  • May 6, 2025

Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.