Darshan Hiranandani : How can I troubleshoot problems with appending rows in Google Sheets?

In our app, when we use the "Append Data to a Spreadsheet" feature and provide an object that matches each column, the data is being appended to the next blank row but starts from the column after the intended one.

For instance, if the sheet has data in columns A10 to C10, and we want to insert data into A11, B11, and C11, it instead gets added to D11, E11, and F11. Is this a recognized issue?

Regards
Darshan Hiranandani

Hello @darshanhiranandani23!

Sorry you are experiencing this issue, very odd.

Could you share a screenshot of the query you are running with the "Append Data to a Spreadsheet" feature?

I would like to take a look and see if there might be something set with the 'Values to Append' input field :thinking:

I can try to reproduce the behavior to see if this is a bug or if we might need to make a tweak to the query, as it should know to skip to a new line when appending in more data!

1 Like