Google Sheets

This is a standalone OAuth integration for reading and writing Google Sheets without needing an MCP server. You can pull spreadsheet data in text, CSV, or JSON formats, update specific cell ranges, append rows, and search across your sheets. It handles authentication through your system keyring and auto-refreshes tokens. The write commands support both parsed formulas and raw text input depending on whether you want Google to interpret your values. One catch: it requires a Google Workspace account, so personal Gmail users are out of luck. If you're already scripting against spreadsheets and want something lightweight that doesn't require running a separate server, this does the job.

skills.sh installs: 479
GitHub stars: 454
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add sanjay3290/ai-skills --skill google-sheets --agent claude-code

Installs into .claude/skills of the current project.

Files

Google Sheets

Lightweight Google Sheets integration with standalone OAuth authentication. No MCP server required. Full read/write access.

Requires Google Workspace account. Personal Gmail accounts are not supported.

First-Time Setup

Authenticate with Google (opens browser):

python scripts/auth.py login

Check authentication status:

python scripts/auth.py status

Logout when needed:

python scripts/auth.py logout

Read Commands

All operations via scripts/sheets.py. Auto-authenticates on first use if not logged in.

# Get spreadsheet content as plain text (default)
python scripts/sheets.py get-text SPREADSHEET_ID

# Get spreadsheet content as CSV
python scripts/sheets.py get-text SPREADSHEET_ID --format csv

# Get spreadsheet content as JSON
python scripts/sheets.py get-text SPREADSHEET_ID --format json

# Get values from a specific range (A1 notation)
python scripts/sheets.py get-range SPREADSHEET_ID "Sheet1!A1:D10"
python scripts/sheets.py get-range SPREADSHEET_ID "A1:C5"

# Find spreadsheets by search query
python scripts/sheets.py find "budget 2024"
python scripts/sheets.py find "sales report" --limit 5

SKILL.md on GitHub