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.