When creating a new row in Google Sheets. It is adding the row at 1257 instead of the bottom.

​@KenRambo 

How many rows are there between row 1257 and the actual bottom row of the sheet? And if there anything materially different about the rows above and below 1257.

And are there column headers in the top row of the sheet? That can sometimes cause issues if there aren’t. Google Sheets is kinda delicate!

If you post some screenshots we can take a look.

Or if you want some more hands on help with troubleshooting, I’m a Zapier partner. Feel free to reach out.

Hi ​@KenRambo 

Issue is likely due to rows having existing values or formulas.

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/integrations#help

None of the rows in google sheets have formulas. 

When created there were no rows from that row to the bottom. All columns have headers

@AndrewJDavison

When created there were no rows from that row to the bottom. All columns have headers

Here’s a screenshot from a test. 111111 should have been below 207111

​@KenRambo 

Try deleting the rows that were skipped to see if that resets where the Zap adds new rows.

Make sure there are:

• headers in row 1 including cell A1
• no gap rows/columns
• no grouped rows/columns

​@Troy Tessalone It’s a new row, there aren’t any existing values. There are no formulas on my googlesheet.

​@KenRambo 

Alternative is to use Airtable or Zapier Tables instead of GSheets since those are database apps not a spreadsheet apps which don’t have some of these limitations and quirks when used in automations/integrations.

​@Troy Tessalone 

When created there were no rows from that row to the bottom. All columns have headers

Here’s a screenshot from a test. 111111 should have been below 207111. The next row will be put above 111111.

​@KenRambo 

From your screenshot it looks like column A has no data.

Make sure column A has data and is not a column with only a header.

​@KenRambo 

Post screenshots showing how the top 3 rows are configured from cell A1.

I can’t. I’m using G sheets as an in between smartsheet and zapier in order to capture the smartsheet ROW ID into googlesheets as a column and then be able to use that to look up the row in smartsheet for updates.

​@Troy Tessalone 

Column A doesn’t have data because it will be calculated later in smartsheet. It used to work fine.

​@Troy Tessalone  So you’re saying if Column A has data then it will always add new rows to the bottom?

​@KenRambo 

Try with Column A always having a value in each row that is being created by the Zap or reference by the Zap.

Hello ​@KenRambo 
 

This usually happens when Google Sheets thinks your data continues down to row 1257 (hidden formatting, a stray value, or a formula in a far-down row).

Check around row 1257 and clear any content and formatting below your real data. After that, Zapier should append to the true bottom again.

Dr. Tanvi Sachar
Monday Certified Partner, Tuesday Wizard