Sheets CLI: work with Google Sheets through an agent

gmickel/sheets-cli

Read and update Google Sheets from an agent using a CLI with JSON output and dry-run support.

Inhalt aktualisiert:

Auf GitHub ansehen
sheets-cli install-skill
73Sterne6ForksLetzter Repository-Push

Über diesen 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.

Warum wir es empfehlen

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.

Wobei es hilft

  • 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

Vor der Nutzung

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

Unterstützte Agents

Claude CodeCodex CLIGitHub Copilot

Quellen und Referenzen

Die Originalquellen sind unten verlinkt. Praktische Einstiegsideen sind redaktionelle Vorschläge von SkillHey.