{ "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."> Error when writing into a Google sheet - Forums

Forums

Error when writing into a Google sheet

Mmax2 07 Oct, 2024

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.

Mmax2 29d ago

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.

You need to login to be able to post a reply.