I have created a nutrition label template in google sheet and a form to collect the data needed to populate it. Is there a way, using Zapier, to take the data from a form submission and use it populate the template in a new google sheet document?
How can I use the data in a new row of a Google Sheets (from form submission) to populate a template?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 24279 replies
-
28 August 2023
Hi
Good question.
That will depend on how your GSheet template is configured.
Can you post screenshots?
Generally, to use GSheets in Zaps, the GSheet needs to be configured a specific way with row 1 as headers.
Sure thing, here are some screen shots. I am happy to update the template in any way needed to make this work!
It is quite simple!
Userlevel 7
+14
- Certified Zapier Expert
- 24279 replies
-
28 August 2023
Reference this help article: https://help.zapier.com/hc/en-us/articles/8495978765965-How-to-set-up-your-Google-spreadsheet-to-work-with-Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.