Adding new rows to a Googlesheet

I am trying to add a new row inside a Googlesheet using the Add a row module which says that it appends a new row to the bottom of the table. Indeed when I run the module, a new row is generated, but it is added to the beginning of the column, not to the end.

As you can see the new row is generated and C1 gets the value TEST, what I want to achieve is that every time the module is executed, a new row is created below the other with the associated value.

The question I have, in order to get to add the record inside the new row, do I have to do some kind of iteration over the existing records of the column?

Thank you!

Hey there,

yeah it gets added to the first empty row starting from the top. And in your case Row 1 is empty, so that’s where the new row goes.

Quick and dirty solution is to add something in the A column with the same color as the background so these rows are no longer considered empty.

1 Like

You can’t leave column A empty. I recommend moving the notes column to another place if it’s not always going to be filled with content.