I’m using a Form to send responses to a Spreadsheet with the “creat a spreadsheet row” option on, but it only sends the responses at the row 1, making everything else go down.
Is there a way to make it create this row at the bottom of the sheet?
I’m using a Form to send responses to a Spreadsheet with the “creat a spreadsheet row” option on, but it only sends the responses at the row 1, making everything else go down.
Is there a way to make it create this row at the bottom of the sheet?
Hi
Which spreadsheet app are you trying to use?
If using GSheets, then reference this article: https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps
Hey Troy!
Yes, I'm using GSheets. Thank you for the article, there are a lot of rules I didn't know in there!
It's all good according to the article too, and I ran new tests but it keeps creating it a the top row (rows 1and 2 in the image below).
I'm sure there's something I'm missing here, but no idea of what it is.. Any other ideas?
GSheet help articles: https://zapier.com/apps/google-sheets/help
Another option to explore is to use Airtable instead of GSheets, where you won’t have this problem because it’s a database app.
OOOOOH Ok! Problem solved then, I think! The column A was in fact hidden, I opened it just to print and show it has a written header.
Thank you so much, Troy!
That’s great news
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Thank you, Ken.a! Everything's working out really well right now. I'm new on zapier and I'm loving it!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.