# sheets-cli

This skill gives your agent a CLI for reading Google Sheets tables, appending rows and editing cells. Useful when project data lives in a cloud spreadsheet.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · ★ 72
- Author: gmickel
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/gmickel/sheets-cli/tree/HEAD/SKILL.md
- Updated: 2026-02-11
- HTML: https://affpapa.org/en/nevibecode/skills/sheets-cli

## What it does

The skill documents `sheets-cli`, which is already on `PATH`. The agent calls it directly: `sheets find` locates a spreadsheet by name through Google Drive, `sheets list` shows the tabs, `read table` returns headers and rows as JSON, `append` adds a record, and `update key` edits cells by matching a key column.

Key-based edits beat row numbers, because inserting or deleting rows shifts the numbering. Every row from `read table` carries a `_row` field holding its absolute sheet row, and that value goes straight into `update row --row`. Counting rows by hand is a mistake the skill warns against.

Before any write, run the command with `--dry-run` and check the preview. Finding a spreadsheet by name needs the Drive API turned on in your Google project, and sign-in goes through `sheets-cli auth login --credentials <oauth-client.json>`. Each command answers with JSON that includes an `ok` field, so you can tell whether the update landed.

## Requirements
- Works with: Google Workspace

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add gmickel/sheets-cli --skill sheets-cli -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/sheets-cli/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/sheets-cli/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add gmickel/sheets-cli --skill sheets-cli -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/sheets-cli/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add gmickel/sheets-cli --skill sheets-cli -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/sheets-cli/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install gmickel/sheets-cli sheets-cli
```

2. **Manually: put the files in place**
- File: `.github/skills/sheets-cli/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add gmickel/sheets-cli --skill sheets-cli -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/gmickel/sheets-cli
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/sheets-cli/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add gmickel/sheets-cli --skill sheets-cli -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/gmickel/sheets-cli/tree/HEAD/SKILL.md

## When to use it
- pull rows from a tab and hand them to the agent as JSON
- add a new record at the end of a table
- change a status in the row matched by a key column value
- apply several edits in one batch operation
- preview writes with `--dry-run` before touching the sheet

## Example prompts
- Find the spreadsheet named Projects and list its tabs
- Read the first 100 rows from the Tasks tab
- Mark the row with ID TASK-42 as Complete, dry-run it first

## Similar
- [gws-sheets](https://affpapa.org/en/nevibecode/skills/gws-sheets.md) — skill · 58900 installs
- [gws-sheets-read](https://affpapa.org/en/nevibecode/skills/gws-sheets-read.md) — skill · 50700 installs
- [google-sheets](https://affpapa.org/en/nevibecode/skills/google-sheets.md) — skill · 24 installs
- [google-sheets-mcp](https://affpapa.org/en/nevibecode/mcp/google-sheets-mcp.md) — MCP server · ★ 13
- [sheets-automation](https://affpapa.org/en/nevibecode/skills/sheets-automation.md) — skill · 5200 installs
- [Sheets MCP](https://affpapa.org/en/nevibecode/mcp/sheets-mcp.md) — MCP server · ★ 36

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md