I believe theres an issue with the current Spreadsheet API parameters where they might be incorrect at the moment. My app can insert or edit a new row in a sheet, but the given A1 range seems be incorrect.
It only takes the first column (A) from the row, but fails to insert the values when more columns need to be adressed.
Example error from API response from the AppSheet app:
ErrorDescription: “Unable to add/edit/delete row in table ‘Keywords: products’. → Google.Apis.Requests.RequestError\r\nInvalid data[0]: Requested writing within range [‘Keywords: products’!A14087], but tried writing to column [C] [400]\r\nErrors [\r\n\tMessage[Invalid data[0]: Requested writing within range [‘Keywords: products’!A14087], but tried writing to column [C]] Location[ - ] Reason[badRequest] Domain[global]\r\n]\r\n: Message[Invalid data[0]: Requested writing within range [‘Keywords: products’!A14087], but tried writing to column [C]] Location[ - ] Reason[badRequest] Domain[global]”
For instance when editing 5 columns on a single row, the range Keywords: products'!A14087 should actually be Keywords: products'!A14087:E14087.
Cheers