Summary
Add a gog sheets notes <spreadsheetId> <range> command to read cell notes (annotations) from a Google Sheets range.
Motivation
The current sheets get command uses the Values API which only returns cell values. Cell notes (the small annotations/comments attached to individual cells) are stored in CellData.Note and require the full Spreadsheets.Get API to access.
Proposed behavior
gog sheets notes <spreadsheetId> "Sheet1!A1:Z100"
gog sheets notes <spreadsheetId> "Sheet1!A1:Z100" --json
- Text mode: tabwriter table with ROW, COL, VALUE, NOTE columns (only cells with notes)
- JSON mode:
{"range": "...", "notes": [{row, col, value, note}]}
- Uses a narrow
fields mask (sheets(data(rowData(values(note,formattedValue))))) to minimize API payload
Summary
Add a
gog sheets notes <spreadsheetId> <range>command to read cell notes (annotations) from a Google Sheets range.Motivation
The current
sheets getcommand uses the Values API which only returns cell values. Cell notes (the small annotations/comments attached to individual cells) are stored inCellData.Noteand require the full Spreadsheets.Get API to access.Proposed behavior
{"range": "...", "notes": [{row, col, value, note}]}fieldsmask (sheets(data(rowData(values(note,formattedValue))))) to minimize API payload