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 
Can you share screenshots? I'm not seeing the same issue yet
Hi @thisbeali, I also just encountered this bug. It seems to happen whenever one of your columns doesn't have a name. In our case, we can probably work around it by giving all intermediate columns a heading/name.
Thank you for chiming in!
(To clarify, this is not the only case in which it happens, but I couldn't nail down a root cause for other cases.)
