Google Sheets Append New Row(s) Bug?

In our app, when we "Append Data to a Spreadsheet" and give it an object with each matching column it appends them to the next blank row - but it starts at the column AFTER.

Example:

Sheet has data in columns A10 to C10

If we submit data we want in A11, B11, C11, they will get added on D11, E11, F11 for some reason.

Is this a known issue?

Hi @thisbeali Thanks for reaching out!

Append adds to the next row in the sheet, but the update and bulk update query types will modify existing rows if there is a match. It sounds like you may need to switch your query to an update action type:

But we do want to append new rows to the data sheet, not update existing rows.

It is doing the correct actions and adding new rows with the correct data, but for some reason it is offsetting the columns despite the rows it's adding being new and empty.

I.e. It adds the correct data to the correct new rows, but offsets the columns by the existing columns even (which leaves a big gap).

Ah I see :thinking: Can you share screenshots? I'm not seeing the same issue yet