Rows in Google Sheets added above header row.

[Magda]

I am trying to create an integration go to Google Sheets (add row). Everything is working except that the row are being added at the top of the sheet, both above the header row and above row previously added by the Pabbly integration. Each new entry pushes all previous entries down.

I think this issue is the Updates UpdatedRange line in the Google Sheets Action which specifies that the updated range is A1 to F1, but don't know how to correct it.

 

[Pabblymember11]

Hey @Magda

It looks like you may not have mentioned the header in the respective Google Sheet. So, could you please check that have you selected the 1st sheet of that spreadsheet?

Moreover, if you still face any issues please reconnect the Add Row Action step and place the sheets in the first index of the spreadsheet and remove the filters if any were installed.

Thanks!!

 

[Magda]

It is the first (and only) sheet, Sheet 1. In fact, I haven't even renamed it (as is my custom), just to make sure there are any issues.

I have reconnected to the sheet repeatedly, there are no filters.

But, I have played with it a bit more and it seems that the problem was that the first column was empty (which is my standard procedure). Removing that has the sheet populating as expected. Thank you.