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.

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 @thaduraes 

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? 

@thaduraes 

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.

 

Symptoms

You've tried to add rows to the bottom of a spreadsheet, but the rows are instead being added to the top of the spreadsheet.
 

Causes

There are two reasons why this may happen:
  • Column A is missing a header: If Column A does not have a header, Zapier will not know how to interpret the data in the column and will assume that the data is all headers. As a result, when you try to add a new row, Zapier will insert it at the top of the column since that is where the headers are located.
  • Column A is being hidden: If Column A is hidden, Zapier will not be able to see the data in the column and will assume that the column is empty. As a result, when you try to add a new row, Zapier will insert it at the top of the column since that is where the empty cells are located.

How to fix it

To resolve this issue, follow these steps in Google Sheets:
  1. Ensure Column A has a header: If Column A does not have a header, add one. To do this:
    1. Select the first cell in Column A and type in a header name.
  2. Ensure Column A isn't hidden: If Column A is hidden, unhide it. To do this:
    1. Right-click on the column headers.
    2. Select Unhide Columns.

 

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 @thaduraes! Big thanks to Troy for pointing you in the right direction!

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!

Terms & Conditions