gsheetlisted
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