Google sheets - Make adds row to the very TOP instead of the BOTTOM

[TM]

What is your goal?

To have Make add a row at the BOTTOM. Not the TOP.

What is the problem & what have you tried?

I just automated and connected my woo commerce with Google sheets so I don’t have to manually put my orders on my Google sheet

The thing is instead of adding the orders at the bottom, it is adding a row at the very top, even above the header, which makes absolutely no sense

I checked my Google sheet there is no filtering.

Does anyone know what I can do?

Screenshots (scenario flow, module settings, errors)

[Stoyan_Vatov]

Hey there,

the add rows module will add a new row at the first empty row. Are the rows above the header empty? Put something there (some dashes for example and change the color to white so you don’t see them) and it should add at the bottom.

[TM]

Hey! Nope, there are no empty rows at the start

[Stoyan_Vatov]

In your screenshot A6 is empty. I assume this is the start of the header? Try adding something in there.

Also you are adding data in the B column first, so A will always be empty, try adding some symbol there and make the entire column white so you dont see it. But this will trick it to seeing exactly where the next empty row is.

[TM]

Oh sorry i shouldve mentioned, my sheet actually starts from A6, the previous rows were added by Make. So A6 is actually A1. But Make added five new rows ABOVE A6

[Stoyan_Vatov]

Yeah cause A1 was empty at the time, which confused it. So it thought that the sheet was empty. So delete the rows added by Make and add something in A1. Then it should start bellow.

But also, make sure the rows that Make adds also have something in the A column.

[TM]

YES! this worked. Thank you so much!!

[Marina]

Thanks for coming back here to let us know it worked, @TM Always helpful for the Community to know