google-sheets-automation
Lightweight Google Sheets integration with standalone OAuth authentication. No MCP server required. Full read/write access.
Profile →npx skills add sickn33/agentic-awesome-skills --skill google-sheets-automation --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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): ```bash python scripts/auth.py login ``` Check authentication status: ```bash python scripts/auth.py status ``` Logout when needed: ```bash python scripts/auth.py logout ``` ## Read Commands All operations via `scripts/sheets.py`. Auto-authenticates on first use if not logged in. ```bash # 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 # Get spreadsheet metadata
- First-Time Setup
- Read Commands
- Write Commands
- Spreadsheet ID
- Output Formats
- Text (default)
- CSV
- JSON
- A1 Notation Examples
- Value Input Options
- Token Management
- When to Use
- Limitations
python scripts/auth.py login python scripts/auth.py status python scripts/auth.py logout 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)
What does the google-sheets-automation skill do?
Lightweight Google Sheets integration with standalone OAuth authentication. No MCP server required. Full read/write access.
How do I install it?
Run `npx skills add sickn33/agentic-awesome-skills --skill google-sheets-automation --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From sickn33/agentic-awesome-skills, a repository with 44,414 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.