google-sheetslisted

# Google Sheets ## Overview Use this skill when the artifact is a **Google Sheet**. Sheets is the one Google type where the local `gog` CLI is genuinely strong: it supports values read/write, append, clear, cell formatting, and metadata. Two tested-good paths: 1. **`gog sheets`** for create + values + formatting. Best when you need cell formatting, formulas, or incremental edits. 2. **Drive convert-on-upload of CSV/TSV/XLSX** for bulk data load. Best for dumping a large dataset into a fresh native Sheet quickly. ## Prerequisites - **`gog` CLI** (steipete/gogcli) installed and authorized in the operating-system user's real `$HOME`. Authentication commands have changed across gog releases: inspect `gog auth --help`, then configure credentials and add the account using the commands supported by the installed version. The bundled `scripts/gworkspace.py` reuses gog's stored OAuth refresh token for Drive import/export helpers. - **`python3`** on `PATH` (the helper is stdlib-only — no `pip install` required). - For `gog sheets` commands, run `gog sheets --help` once if the local gog version is unknown; the verified flag for 2D matrices is `--values-json`. - The helper resolves credentials in this order: explicit `--refresh-token-file` / `--client-secret-file`, environment variables, then gog's stored token. If lookup fails it exits with `{"error": "missing_credentials"}` — see Common Pitfalls. > **Run helper commands from the skill directory** so `scripts/