How to write/read a comment in Google SpreadSheets?

Question

Google Sheets

Good afternoon. Can't find how to read/write cell comment in Google SpreadSheets? How to work with notes - found - these are the setNote ( string ) and getNote () methods. I did not find anything like this for comments, and the macro recorder did not help.

Answer 1

Use the Google Drive API.
The algorithm is like this

1. Get a list of comments (for an API test, you can make a request directly on this page)
   
2. Filter by anchorthe received object

   "anchor": "{\"type\":\"workbook-range\",\"uid\":0,\"range\":\"2121905705\"}"

   Somewhere there was a converter rangeto A1-notation, but you can google
   
3. Get the selected comments using the get method (if additional information is needed)
   
4. Reply to comments or create a new one
   
5. Delete or patch