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!

 

I want to create a Zap from Gravity Form submission which creates a new spreadsheet then in THAT spreadsheet creates new rows with data from form submission. I got the first step in creating the new sheet but can’t figure out how to then enter new rows into that just created sheet.

 

When I try an set it up ask which sheet to send to but I don’t see an option for it to go to the sheet it just created.

 

Is this even possible?

 

Thanks!

I suggest trying this…

  1. Trigger: Gravity Forms - New Form Submission
  2. Action: GDrive - Copy File (should be a template that already has headers)
  3. Action: GSheets - Add Row (will get the Spreadsheet ID from Step 2 and Worksheet ID = 0)

I think you should create  a spreadsheet beforehand because it s not an action you wanna be doing each time you get a new subscription (you want to create a spreadsheet you re gonna use to receive your leads) so as @Troy Tessalone suggested you should create a spreadsheet, then a single action is needed I think wich is action : Gsheets add row

 

so I don’t think the copy file from Gdrive step is a good idea, since it will be creating a new spreadsheet file each time you get a submission

 i suggest you create one spreadsheet with as many sheets as many forms you have and dedicate each sheet to a specific form or create multiple spreadsheets each one dedicated to a form, then use that spreadsheet and its several sheets or the several spreadsheets to create your zaps

@artisticweb42 
Just checking in to see if you still need help with this? 

Terms & Conditions