Skip to content

feat: add sheets notes command to read cell notes #207

@andybergon

Description

@andybergon

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions