---
name: gog-sheets
description: "Google Sheets operations through gog."
---

# Google Sheets

<!-- Generated by scripts/gen-agent-skills.mjs; do not edit. -->

Use `gog` for Google Sheets operations. Read `../gog/SKILL.md` first for shared auth,
output, safety, and live-write rules.

## Safe start

```bash
gog auth list --check --json --no-input
gog schema sheets --json
gog --readonly --account user@example.com sheets get SHEET_ID 'Sheet1!A1:D20' --json --wrap-untrusted
```

- Select the account explicitly with `--account`.
- Use `--json --wrap-untrusted` for agent-readable Google content.
- Use `--readonly` when the task must not mutate Google data.
- Use `--no-input` in automation and `--dry-run` before supported writes.
- Confirm the exact account, object, and mutation before any write or delete.

## Commands

| Command | Purpose |
| --- | --- |
| `add-tab` | Add a new tab/sheet to a spreadsheet |
| `append` | Append values to a range |
| `banding` | Manage alternating color banding |
| `batch-request` | Submit an atomic structural request array (requires confirmation or --force) |
| `batch-update` | Update values in multiple ranges with one API request |
| `chart` | Manage spreadsheet charts |
| `clear` | Clear values in a range |
| `conditional-format` | Manage conditional formatting rules |
| `copy` | Copy a Google Sheet |
| `copy-paste` | Copy a range's values/formulas/format to another range (tiles to fill down/across) |
| `create` | Create a new spreadsheet |
| `datasource` | Manage Connected Sheets data sources and extracts |
| `delete-dimension` | Delete rows or columns while preserving intersecting tables |
| `delete-tab` | Delete a tab/sheet from a spreadsheet (use --force to skip confirmation) |
| `duplicate-tab` | Duplicate a tab within a spreadsheet |
| `export` | Export a Google Sheet (pdf\|xlsx\|csv) via Drive |
| `filter` | Manage basic filters |
| `find-replace` | Find and replace text across a spreadsheet |
| `format` | Apply cell formatting to a range |
| `freeze` | Freeze rows and columns on a sheet |
| `get` | Get values from a range |
| `insert` | Insert empty rows or columns into a sheet |
| `links` | Get or set cell hyperlinks |
| `merge` | Merge cells in a range |
| `metadata` | Get spreadsheet metadata |
| `named-ranges` | Manage named ranges |
| `notes` | Get cell notes from a range |
| `number-format` | Apply number format to a range |
| `raw` | Dump raw Google Sheets API response as JSON (Spreadsheets.Get; lossless; for scripting and LLM consumption) |
| `read-format` | Read cell formatting from a range |
| `rename-tab` | Rename a tab/sheet in a spreadsheet |
| `reorder-tab` | Move a tab/sheet to a specific 0-based position in the spreadsheet |
| `resize-columns` | Resize sheet columns |
| `resize-rows` | Resize sheet rows |
| `table` | Manage Google Sheets tables |
| `unmerge` | Unmerge cells in a range |
| `update` | Update values in a range |
| `update-note` | Set or clear a cell note |
| `validation` | Manage cell data validation rules |

Run `gog sheets <command> --help` for flags and `gog schema sheets <command> --json`
for the machine-readable contract. Do not guess command syntax.