Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata.
SkillScore77Maintained
Automatic
◆Data Analyst pack
Last verified 8/28/2026
What it changes
Passed 13 of 17 test cases with the skill, and 6 of 17 without it.
Without skill36%
With skill77%
Checks it passed that the model alone missed
Includes the --limit 5 flag
Specifies the scripts/auth.py login command
Specifies the scripts/auth.py status command
and 7 more in the full report
9 fixed8 passed either way5 still failing0 broke
Pass-rate lift
+41 pp
Tokens
+11%
Agent turns
0%
Response time
-66%
Model gemini-3.6-flashMeasured 8/28/2026v117 of 22 cases passed with skill · 17 comparable
Tokens, turns and time describe resource use, not a dollar price.
See it in action
One of 9 test cases the skill fixed. Same model, same prompt, with and without the skill.
1 of 9
Prompt
Scan my Workspace repository for files matching 'Project Alpha'. Since there are hundreds, cap the returned results at exactly 5 files to prevent terminal overflow.
What was checked, without and with the skill
Checked
Without skill
With skill
Specifies the find command
Passed
Passed
Includes the --limit 5 flag
Missed
Passed
case-11 · gemini-3.6-flash · 8/28/2026 · answers are capped and redacted
What's inside
The instructions your model reads when the skill loads.
SKILL.md129 lines4 filesincludes scripts
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"