Sheets CLI: work with Google Sheets through an agent

このスキルについて

Gordon Mickel's Skill teaches an agent to use sheets-cli to locate spreadsheets, read tables and ranges, append rows and update cells. The author recommends reading the current state, previewing changes with dry-run and then applying them. Commands return structured JSON.

おすすめする理由

The Skill documents a read, decide, dry-run, apply workflow. The CLI, Google Cloud APIs and OAuth setup are separate prerequisites; source review does not constitute a live Google Sheets test.

役立つこと

• Read a project tracker and update a task by its ID.
• Append structured rows or inspect a range before preparing changes.

Read before writing

The author recommends key-based updates when possible because row positions can change. Use --dry-run before a write, check the JSON result, and apply the change once it is correct. The README includes a task-status example and separate Codex installation command.

Repository and setupSkill instructions

使う前に

• Build sheets-cli with Bun and make the binary available on PATH; installing the Skill alone does not install the CLI.
• Enable the Google Sheets API, configure desktop OAuth credentials and authenticate. Spreadsheet search also requires the Google Drive API.

対応エージェント