Automate Google Sheets operations via CLI — read, write, format, and manage spreadsheets programmatically.
What it does
The Google Sheets API requires OAuth setup, specific scope declarations, and API calls that differ significantly from what you'd expect if you've worked with the Sheets UI. Claude generates Google Sheets API code that misses authentication scope, uses the wrong batch update format, or calls the API in ways that work for small operations but hit quota limits at scale. This skill loads the correct Google Sheets API patterns via CLI: authentication with correct scopes, read/write/format operations in the right structure, batch operations that stay within quota, and the specific gspread or API patterns that work reliably. Made by gmickel.
Use case
Automating Google Sheets operations from the terminal: reading data for processing, writing results back, formatting sheets programmatically, or building Sheets-based data pipelines.
"Read all rows from this Google Sheet and return them as a JSON array." "Write these 1000 rows to the sheet in a single batch operation." "Format column A as a date and bold all rows where column B is over 100." "Create a new tab, populate it with this data, and apply a header style." "Set up a CLI script that syncs this CSV to the sheet every hour."
Provide the spreadsheet ID (from the URL) and describe the operation.
Claude handles authentication scope, batch formatting, and quota-aware operations.
For recurring operations: Claude generates a standalone script with correct credential management.
Input
A Google Sheet ID, a description of the read/write/format operation, and any data to write.
Output
Google Sheets API code with correct authentication, quota-aware batch operations, and proper error handling. Works for both one-off operations and recurring scripts.
npx skillsadd gmickel/skills/google-sheets-cli
Requires skills.sh CLI
Collection of scientific skills for working with specialized libraries, databases, and research workflows.
Orchestrate ML model evaluation jobs — benchmarks, metrics, reports, and comparison dashboards.
Analyze CSV files and generate insights with automatic visualizations, statistics, and data profiling.