| name | google-sheets-skill |
| description | Read and write Google Sheets. Use when the user asks to read spreadsheet data, update cells, create sheets, or work with Google Sheets. |
| allowed-tools | Bash, Read |
Google Sheets Skill
Read, write, and manage Google Sheets.
Setup
Uses same Google OAuth as gmail-skill. If you have gmail-skill configured, this will work automatically.
Otherwise:
- Go to https://console.cloud.google.com/apis/credentials
- Create OAuth client (Desktop app)
- Enable Google Sheets API
- Download JSON to
~/.claude/skills/google-sheets-skill/credentials.json
- Run:
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py login
Commands
List & Info
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py list [--limit N]
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py get SPREADSHEET_ID
Reading Data
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py read SPREADSHEET_ID "Sheet1!A1:C10"
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py read SPREADSHEET_ID "Sheet1"
Writing Data
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py write SPREADSHEET_ID "Sheet1!A1" --values '[["Header1","Header2"],["Row1","Data"]]'
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py append SPREADSHEET_ID "Sheet1" --values '[["New","Row"]]'
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py clear SPREADSHEET_ID "Sheet1!A1:C10"
Sheet Management
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py create --title "My Spreadsheet"
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py add-sheet SPREADSHEET_ID --title "New Tab"
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py delete-sheet SPREADSHEET_ID --sheet-id 123456
Range Notation
Sheet1!A1:C10 - Specific range
Sheet1!A:C - Entire columns A-C
Sheet1!1:10 - Rows 1-10
Sheet1 - Entire sheet
A1:C10 - Default sheet
Spreadsheet ID
Found in the URL: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit
Output
All commands output JSON.