Good evening, when I try to write (write method: "append") a row of data into a Google sheet, I obtain the following error:
[response] => {
"error": {
"code": 400,
"message": "Unable to parse range: Sheet1!A1:J1",
"status": "INVALID_ARGUMENT"
}
}
Why is the "range" involved? "Append" will append to the end of the file, despite of the range if I well understood. What could be the problem here? Thank you very much.
The problem was simply that my sheet was named "Foglio1" (as I am from Italy). Renamed the sheet as "Sheet1" and all errors were removed. Maybe it'll be better in the future to have the possibility to set the name of the sheet as a parameter, in my opinion.
Thank you, I have added this to the next update!
A full tutorial is here:
https://www.chronoengine.com/faqs/chronoforms/chronoforms8/how-to-use-the-google-sheets-write-action
You need to login to be able to post a reply.
