programmatic access to google-sheets-api 'Insert Note' notes

1
votes

Given a Google Sheets document, is there any way to programmatically access the notes produced from 'Insert Note' in the Google Sheets web interface?

I searched in the Python v4 API documentation, but couldn't find a reference to 'note' anywhere:

https://developers.google.com/apis-explorer/#p/sheets/v4/

If there is a way to do it via google apps script, I would like to know how such script could be run from the command-line in Linux.

1
google-apps-scriptgoogle-sheets-api

1 Answers

3
votes

You can use spreadsheets.get:

Your notes will be at 

sheets[].data[].rowData[].values[].note

in the Response body.

FieldMask: 

sheets(data(rowData(values(note))))

API Explorer demo