Sheets CLI: work with Google Sheets through an agent

À propos de ce Skill

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.

Pourquoi ce choix

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.

À quoi il sert

• 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

Avant de l’utiliser

• 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.

Agents compatibles