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.

Hi @Danvers 
Directly coming to the point . In my Trigger i have a google form that is collecting data like First Name , Last Name , Address , Zip Cide , Phone etc . 
I have a google sheet template in which positions of these values are fixed. 
 


In action i want to copy this sheet and in that copied sheet i want to update the values according to the positions of the cells like First Name should be at <First Name> in the sheet and Zip Code should be at <Zip Code> in the sheet like that only .
In end result what i want is every time when i get a google form response i should get a new google sheet with updated values according to their cells places in the sheet .
is it possible to do this in Zapier.
if it is possible then how ? . please help me .
Thanks

Hi @ajay6688, welcome to the Community! 👋

The Google Sheets app requires spreadsheets to be set up in a specific way, so I don’t think it’s going to be possible to have it update cells on a spreadsheet that’s setup as per your screenshot. See our Work with Google Sheets in Zaps guide for more details on the set up requirements.

Do the form submissions need to be added into a spreadsheet specifically? As an alternative perhaps you could create a Google Doc for each submission instead - suggesting that as it’s possible to set up templated fields which would allow you to add values into specific fields. Would that be a suitable alternative? 

Looking forward to hearing from you!

Hi @ajay6688 

To do what you are trying to do would require using the GSheets API via one of these actions:

  • API Request
  • Custom Action (with the help of AI)

https://developers.google.com/sheets/api

Terms & Conditions