How get comments from cells with Google Sheets api

Question

How i can get comments using Google sheets api?

fields=sheets/data/rowData/values/note return only notes

For example it's note note and it's comment comment

So how i can get comments?

Answer 1

You can list comments using the Google Drive API. Using the spreadsheet ID you can reference the file in Google Drive too.

To list the comments of your spreadsheet call the Comments: list endpoint.

curl \
  'https://www.googleapis.com/drive/v3/files/[YOUR_SPREADSHEET_ID]/comments?fields=*&key=[YOUR_API_KEY]' \
  --header 'Authorization: Bearer [YOUR_ACCESS_TOKEN]' \
  --header 'Accept: application/json' \
  --compressed

Answer 2

It's available as the note field in CellData which you can get through spreadsheets.get with the includeGridData parameters set to true