Google Sheets Issue with the "Add rows" module

How To
1

I have an automation that added a row to one of the Google Sheets “Add Rows” modules. So, for some unknown reason, sometimes the data is not given at the end of the list but is added as the first line.

  • This greatly disrupts the further work of automation, and I do not understand how to influence it, because there are no settings in the module itself. This happens randomly, once every few months.

first row
first row810×786 74.9 KB

first row example
first row example1847×391 113 KB

advanced settings
advanced settings876×894 88.6 KB

  • It is crucial that the headers are in the first row.
2

Your cell A1 (now A2 in your screenshot) was empty. Try putting something there so that it doesn’t assume row 1 is empty.

3 Likes
3

@samliew It is very difficult when several people use the table, this kind of errors sometimes appear. Thank you very much!

4

No problem, glad I could help again!

Perhaps you can try locking the first row from editing.

2 Likes