Google Sheets Add a Row - Automation is adding a new row above the header, not in the first empty row

[alexandr.e]

Hi, the Add a Row module adds a new row above the header, not in the first empty row (or in this case it is the last row).

I found this topic but without a solution.

How can I fix it? Thanks.

Automation is adding a new row above the header, not in the first empty row

New Orders are added to the first row, not the next empty available row. The first row contains titles. I wanted to add a column to my google sheets and once I did it and updated it, all my new orders were added to the first row, not like before when they were added to the next empty row available. How can I fix this? It’s happening to 2 scenarios of mine. Please help. [Screenshot_363]

[Abhishek]

Hey @alexandr.e
Remove this module and connect same module

I think it will work

[ThakurHemansh]

Replace it with a new “Add a row module”
make sure table contains header is turned on and unformated is set to no

[samliew]

Welcome to the Make community!

Previously-asked similar questions were asked on this forum, but were inconclusive:

• Automation is adding a new row above the header, not in the first empty row

You’ll need to use Google Sheets “Make an API Call” module to call the spreadsheets.batchUpdate endpoint to request for a “InsertDimensionRequest”.

You may get something that looks similar to this by following the above documentation (this example is for DeleteDuplicatesRequest)

[alexandr.e]

This worked for me - Google Sheets - Fixing the issue of row Insert happening at top of sheet

The client changed the spreadsheet without notice, and cell A1 was empty, causing the problem.

[samliew]

You can try locking the spreadsheet so that there is a warning when trying to edit it manually (doesn’t affect APIs)