Agent skill

google-sheets-skill

Read and write Google Sheets. Use when the user asks to read spreadsheet data, update cells, create sheets, or work with Google Sheets.

View SKILL.md on GitHub Repository
Stars 7
Forks 1

Install this agent skill to your Project

npx add-skill https://github.com/idanbeck/claude-skills/tree/main/google-sheets-skill

SKILL.md

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:

  1. Go to https://console.cloud.google.com/apis/credentials
  2. Create OAuth client (Desktop app)
  3. Enable Google Sheets API
  4. Download JSON to ~/.claude/skills/google-sheets-skill/credentials.json
  5. Run: python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py login

Commands

List & Info

bash
# List your spreadsheets
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py list [--limit N]

# Get spreadsheet info
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py get SPREADSHEET_ID

Reading Data

bash
# Read a range
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py read SPREADSHEET_ID "Sheet1!A1:C10"

# Read entire sheet
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py read SPREADSHEET_ID "Sheet1"

Writing Data

bash
# Write to range (overwrites)
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py write SPREADSHEET_ID "Sheet1!A1" --values '[["Header1","Header2"],["Row1","Data"]]'

# Append rows
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py append SPREADSHEET_ID "Sheet1" --values '[["New","Row"]]'

# Clear range
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py clear SPREADSHEET_ID "Sheet1!A1:C10"

Sheet Management

bash
# Create new spreadsheet
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py create --title "My Spreadsheet"

# Add sheet to existing spreadsheet
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py add-sheet SPREADSHEET_ID --title "New Tab"

# Delete sheet
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.

Recommended Agent Skills

Expand your agent's capabilities with these related and highly-rated skills.

idanbeck/claude-skills

fal-video-skill

7 1
Explore
idanbeck/claude-skills

godaddy-skill

Manage GoDaddy domains and DNS records. Use when the user asks to set up DNS, manage domain records, check DNS propagation, point domains to servers, or configure A/AAAA/CNAME/MX/TXT records. Supports bulk operations for quick domain setup.

7 1
Explore
idanbeck/claude-skills

gcal-skill

Read, create, and manage Google Calendar events. Use when the user asks to check calendar, view schedule, find meetings, create events, or see what's on the agenda. Supports multiple accounts.

7 1
Explore
idanbeck/claude-skills

nano-banana-pro

Generate images using AI. Use when the user asks to create, generate, or make images, pictures, graphics, illustrations, visuals, or artwork. Also use for image editing with reference images.

7 1
Explore
idanbeck/claude-skills

google-docs-skill

Create, read, update, share, and export Google Docs. Use when the user asks to create documents, write content to Google Docs, share docs, export to PDF/DOCX, or convert markdown files to Google Docs.

7 1
Explore
idanbeck/claude-skills

film-maker-skill

7 1
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results