0

I'm looking at the following documentation for Google Sheets and I'm wondering how do I add/update a cell with a Note attached to it.

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update

PUT https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}

I can't seem to find a sample request body of what it looks like to add a note. I've tried to send a PUT request but of course it returned a 400.

{
  "values": [
    [
      {
        "note": "sample note"
      }
    ]
  ]
}

This returns the following error:

{
  "error": {
    "code": 400,
    "message": "Invalid values[17][0]: struct_value {\n  fields {\n    key: \"note\"\n    value {\n      string_value: \"sample note\"\n    }\n  }\n}\n",
    "status": "INVALID_ARGUMENT"
  }
}
CHEWWWWWWWWWW
  • 169
  • 3
  • 20

0 Answers0