google-sheets-automation

google-sheets-automation is a skill for Claude Code, Codex from hybridlabor-api/bdb-dev-optimized-agent-skills. It costs 26 tokens per session (1,131 once invoked), scanned A, original, Apache-2.0.

A command-line integration for reading and writing Google Sheets, Google's online spreadsheet service, using OAuth sign-in. It supports spreadsheet searches, ranges, metadata, and several output formats.

In plain words
What is it for?
Use it to find spreadsheets, read whole sheets or selected ranges as text, CSV, or JSON, inspect sheet details, and update spreadsheet data.
Why use it?
It removes repetitive manual spreadsheet work and lets scripts use sheet data without needing a separate MCP server.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Needs its repository: it runs a file that does not travel with it, so clone the repository first. The line is python scripts/auth.py login.

Good fit Use it to find spreadsheets, read whole sheets or selected ranges as text, CSV, or JSON, inspect sheet details, and update spreadsheet data.

Compare 6 skills from other repositories ↓
Install

Getting it into your agent

It runs from inside its repository, so the clone comes first — what it calls does not travel with the file alone.

Clone the repo
git clone --depth 1 https://github.com/hybridlabor-api/bdb-dev-optimized-agent-skills
agentmods
npx agentmods add skills/hybridlabor-api/bdb-dev-optimized-agent-skills/google-sheets-automation

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for google-sheets-automation

README.md
[![agentmods](https://agentmods.dev/badge/skills/hybridlabor-api/bdb-dev-optimized-agent-skills/google-sheets-automation/github.svg)](https://agentmods.dev/skills/hybridlabor-api/bdb-dev-optimized-agent-skills/google-sheets-automation)
Your own site
<a href="https://agentmods.dev/skills/hybridlabor-api/bdb-dev-optimized-agent-skills/google-sheets-automation"><img src="https://agentmods.dev/badge/skills/hybridlabor-api/bdb-dev-optimized-agent-skills/google-sheets-automation/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for google-sheets-automation

Your own site · 80×15
<a href="https://agentmods.dev/skills/hybridlabor-api/bdb-dev-optimized-agent-skills/google-sheets-automation"><img src="https://agentmods.dev/badge/skills/hybridlabor-api/bdb-dev-optimized-agent-skills/google-sheets-automation.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 26 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,131 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00026 $0.01131
Opus 5 $0.00013 $0.00566
Sonnet 5 $0.00005 $0.00226
Haiku 4.5 $0.00003 $0.00113

Measured 6d ago against content hash 53612be47e2a, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-09, from the pricing page.

Security

Grade A, and why

google-sheets-automation scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 6d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

Copies of this mod

1 near-identical copy found in the catalogue:

skills/global_config/google-sheets-automation/SKILL.md · 151 lines

How it starts

The opening of the file, as written. The whole thing — 151 lines — stays where its author put it; the contents beside it link to each section on GitHub.

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

# Get spreadsheet metadata (sheets, dimensions, etc.)
python scripts/sheets.py get-metadata SPREADSHEET_ID

Write Commands

# Update a range of cells with values (JSON 2D array)
python scripts/sheets.py update-range SPREADSHEET_ID "Sheet1!A1:B2" '[["Hello","World"],["Foo","Bar"]]'

# Update with RAW input (no formula parsing, treats everything as literal text)
python scripts/sheets.py update-range SPREADSHEET_ID "Sheet1!A1:B1" '[["=SUM(A1:A5)","text"]]' --raw

# Append rows after the last data row
python scripts/sheets.py append-rows SPREADSHEET_ID "Sheet1!A:Z" '[["New Row Col A","New Row Col B"]]'

# Clear values from a range (keeps formatting)
python scripts/sheets.py clear-range SPREADSHEET_ID "Sheet1!A1:B10"

# Batch update (advanced - for formatting, merging, etc.)
python scripts/sheets.py batch-update SPREADSHEET_ID '[{"updateCells":{"range":{"sheetId":0},"fields":"userEnteredValue"}}]'

Read the full file on GitHub · 151 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 6d ago First seen · 151 lines · 26 tokens per session scan A 53612be47e2a

Subscribe to this mod's changes

google-sheets-automation is a skill published in the GitHub repository hybridlabor-api/bdb-dev-optimized-agent-skills (6 stars, last pushed 4d ago), licensed Apache-2.0. It adds 26 tokens to every session and 1,131 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.

Related

Other skills, from other repositories

composio-delivery

Delivers the finalized analyst brief to Slack, Notion, Google Sheets, and Gmail via authenticated Composio tools. Use whenever a completed, grounded brief must be distributed and logged.

suhaas/earnings-edge · 43 tokens

ai-csv-excel-merger

A tool for combining CSV and Excel materials into one organized result while identifying conflicting fields.

skillsaiagent/aiskills · 69 tokens

document-processor

Guidance for processing documents, extracting content, and transforming structured information. Use when the user asks to process, parse, extract, or transform document content such as PDFs, Word files, or spreadsheets.

vixues/LeAgent · 44 tokens

attendance-signin-sheet

A spreadsheet generator for printable attendance or meeting sign-in sheets. It turns a list of names into rows with columns such as signatures, dates, departments, or employee IDs.

vixues/LeAgent · 51 tokens

xlsx

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or…

eigent-ai/eigent · 201 tokens

google-workspace

Manage Gmail, Google Calendar, Drive, Sheets, Docs, Contacts, and Tasks via the gogcli CLI. TRIGGER: "gmail", "google calendar", "google drive", "google sheets". NOT FOR: outlook-assistant, xlsx, docx use cases.

xg-gh-25/SwarmAI · 61 tokens