Summary

• sheets write-note: Write or clear a cell note via UpdateCells BatchUpdate. Uses ForceSendFields to ensure empty notes serialize correctly for clearing.
• sheets find-replace: Find and replace text across a spreadsheet using the native FindReplaceRequest. Supports --sheet (scope to single sheet), --match-case, --match-entire, --regex, and --formulas flags.

Usage

# Write a note
gog sheets write-note <spreadsheetId> Sheet1!A1 "reminder text"

# Clear a note
gog sheets write-note <spreadsheetId> Sheet1!A1 --clear

# Find and replace across all sheets
gog sheets find-replace <spreadsheetId> "old text" "new text"

# Scoped to a single sheet, case-sensitive
gog sheets find-replace <spreadsheetId> "foo" "bar" --sheet Sheet1 --match-case

Test plan

• make build passes
• TestSheetsWriteNoteCmd — write note, clear note (verifies ForceSendFields serialization)
• TestSheetsFindReplaceCmd — basic replace, sheet scoping, match-case, regex

🤖 Generated with Claude Code