When using a Zap to update your Google Sheet, you wanted it to add a new row to the bottom of the spreadsheet. Instead, the Zap adds a new row 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:
-
Ensure Column A has a header: If Column A does not have a header, add one. To do this:
- Select the first cell in Column A and type in a header name.
-
Ensure Column A isn't hidden: If Column A is hidden, unhide it. To do this:
- Right-click on the column headers.
- Select Unhide Columns.
Still need help?
If this article did not fix the issue, Zapier has a few other options to get you the help you need:
- Contact Zapier Support. Our Support team can investigate your account to find solutions.
- Ask in the Zapier Community. Get advice from experienced Zapier users in the Zapier Community.
- Learn more about getting help. Read our guide on how to get help and support with Zapier to find the best resources for your specific problem.
0 comments
Article is closed for comments.