Google Sheets

Build production-quality native spreadsheets with goog sheets. Use target/debug/goog from the goog-cli repository, or cargo run --, while developing the CLI.

Required workflow

1. Define the workbook's audience, decisions, inputs, outputs, and update cadence.
2. Plan the tabs, table boundaries, formulas, formats, and validation rules before writing values.
3. Run target/debug/goog auth list and record the active account before any live mutation.
4. Run target/debug/goog sheets --help and the relevant nested --help command before the first mutation.
5. Create or inspect the workbook.
6. Write source data in bounded tables, then add formulas and formatting.
7. Prefer high-level goog sheets values and goog sheets sheet commands over batch-update.
8. Re-read important ranges after every write phase.
9. Inspect metadata and grid data for formulas, formats, and sheet structure.
10. Open the live workbook at 100% zoom and inspect each delivered tab in its normal reading position.
11. Return the live Google Sheets URL and summarize the finished workbook.