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.

Contenido actualizado:

Ver en GitHub
sheets-cli install-skill
73Estrellas6ForksÚltimo push del repositorio

Acerca de este 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.

Por qué lo elegimos

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.

Para qué sirve

  • 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

Antes de usarlo

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

Agentes compatibles

Claude CodeCodex CLIGitHub Copilot

Fuentes y referencias

Las fuentes originales se enlazan a continuación. Los puntos de partida prácticos son sugerencias editoriales de SkillHey.