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.

Latest update at:

View on GitHub
sheets-cli install-skill
73Stars6ForksRepository last pushed

About this 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.

Why we picked it

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.

What it helps with

  • 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

Before you use it

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

Supported agents

Claude CodeCodex CLIGitHub Copilot

Sources & references

Original sources are linked below. Practical starting points are editorial suggestions from SkillHey.