← ClaudeAtlas

gsheetlisted

Read and write Google Sheets data including specific sheets and ranges. Auto-triggers when user shares a Google Sheets URL (docs.google.com/spreadsheets). Supports listing sheets, reading/writing cells, inserting rows, batch updates, and outputting as markdown tables.
smorrel1/claude-code-skills · ★ 2 · Data & Documents · score 65
Install: claude install-skill smorrel1/claude-code-skills
# Google Sheets Reader/Writer Read and write Google Sheets data using Python with OAuth credentials. ## Usage ```bash python3 ~/.claude/skills/gsheet/scripts/read_gsheet.py <url-or-id> [options] ``` ## Read Options | Option | Description | |--------|-------------| | `--sheet, -s` | Sheet name (default: first sheet) | | `--range, -r` | Cell range like `A1:D10` or row range like `1:5` | | `--list-sheets, -l` | List all sheet names in the spreadsheet | | `--format, -f` | Output format: `markdown` (default), `json`, or `csv` | | `--rows N` | Limit output to first N data rows | | `--find VALUE` | Find row containing VALUE | | `--find-col COL` | Column to search in (default: A) | ## Write Options | Option | Description | |--------|-------------| | `--edit CELL` | Cell to edit (e.g., 'A1', 'B5') | | `--value VALUE` | Value to write (use with --edit) | | `--insert-row N` | Insert new row after row N | | `--append` | Append new row at end of sheet | | `--row-values "a,b,c"` | Comma-separated values for new row | | `--batch-edit JSON` | Batch update cells with JSON array | ## Examples ### Reading ```bash # List all sheets python3 ~/.claude/skills/gsheet/scripts/read_gsheet.py "https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit" --list-sheets # Read first 10 rows of a specific sheet python3 ~/.claude/skills/gsheet/scripts/read_gsheet.py "SPREADSHEET_ID" --sheet "Sheet1" --rows 10 # Read a specific range python3 ~/.claude/skills/gsheet/scripts/read_gsheet.py "SPREADSH