Agent skill

Google Sheets

Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata.

Apache-2.0Auto-check passedDocuments & Office

Install Google Sheets

skills CLI

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

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install sanjay3290/ai-skills google-sheets --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/sanjay3290/ai-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/google-sheets .claude/skills/google-sheets && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Paste into Claude Code

Install the "google-sheets" agent skill from https://github.com/sanjay3290/ai-skills/tree/main/skills/google-sheets into .claude/skills/google-sheets/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheets", then confirm the skill loads.

Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

$skill-installer

$skill-installer install https://github.com/sanjay3290/ai-skills/tree/main/skills/google-sheets

Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.

skills CLI

$ npx skills add sanjay3290/ai-skills --skill google-sheets -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install sanjay3290/ai-skills google-sheets --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/sanjay3290/ai-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/google-sheets .agents/skills/google-sheets && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "google-sheets" agent skill from https://github.com/sanjay3290/ai-skills/tree/main/skills/google-sheets into .agents/skills/google-sheets/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheets", then confirm the skill loads.

Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add sanjay3290/ai-skills --skill google-sheets -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install sanjay3290/ai-skills google-sheets --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/sanjay3290/ai-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/google-sheets .cursor/skills/google-sheets && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "google-sheets" agent skill from https://github.com/sanjay3290/ai-skills/tree/main/skills/google-sheets into .cursor/skills/google-sheets/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheets", then confirm the skill loads.

Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

gemini skills install

$ gemini skills install https://github.com/sanjay3290/ai-skills.git --path skills/google-sheets

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add sanjay3290/ai-skills --skill google-sheets -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install sanjay3290/ai-skills google-sheets --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/sanjay3290/ai-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/google-sheets .gemini/skills/google-sheets && rm -rf skills-src

Use ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.

Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/

Paste into Gemini CLI

Install the "google-sheets" agent skill from https://github.com/sanjay3290/ai-skills/tree/main/skills/google-sheets into .gemini/skills/google-sheets/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheets", then confirm the skill loads.

Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

GitHub CLI

$ gh skill install sanjay3290/ai-skills google-sheets

Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).

skills CLI

$ npx skills add sanjay3290/ai-skills --skill google-sheets -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/sanjay3290/ai-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/google-sheets .github/skills/google-sheets && rm -rf skills-src

Use ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.

GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/

Paste into GitHub Copilot

Install the "google-sheets" agent skill from https://github.com/sanjay3290/ai-skills/tree/main/skills/google-sheets into .github/skills/google-sheets/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheets", then confirm the skill loads.

GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add sanjay3290/ai-skills --skill google-sheets -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install sanjay3290/ai-skills google-sheets --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/sanjay3290/ai-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/google-sheets .opencode/skills/google-sheets && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "google-sheets" agent skill from https://github.com/sanjay3290/ai-skills/tree/main/skills/google-sheets into .opencode/skills/google-sheets/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheets", then confirm the skill loads.

OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

Facts

Skill name: google-sheets
GitHub stars: 430
Token cost: ~1k tokens
SKILL.md length: 201 words
Files: 6 (incl. scripts)
Skills in repo: 24
Repo updated: Sep 10, 2026
First seen: Oct 7, 2026
Licence: Apache-2.0

At a glance

Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata.

User asks to: read a spreadsheet
SKILL.md covers First-Time Setup, Read Commands, Write Commands and Spreadsheet ID, plus 4 more sections
Runs Python scripts from its folder; calls python; reaches docs.google.com
Add data to Google Sheets

What it does

Google Sheets is an agent skill from sanjay3290/ai-skills. Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata. Use when user asks to: read a spreadsheet, update cells, add data to Google Sheets, find a spreadsheet, check sheet contents, export spreadsheet data, or get cell values. Lightweight integration with standalone OAuth authentication supporting full read/write access.

Its SKILL.md is about 1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 6 other files, including scripts (for example `README.md`, `scripts/auth.py` and `scripts/sheets.py`).

It sits in Documents & Office, covering Excel spreadsheets. It works with Google Sheets. The repository describes itself as: 24 cross-platform agent skills for Claude Code, Cursor, Codex & Gemini CLI — databases, messaging, research, TTS, DevOps, and Google Workspace. The licence is Apache-2.0.

When your agent uses it

User asks to: read a spreadsheet
Add data to Google Sheets
Find a spreadsheet
Check sheet contents

Example prompts

“/google-sheets”

Requirements

Python 3

What it can do on your machine

Read from SKILL.md and the folder at commit 281d88d. It shows what the files ask for, not the result of running them.

Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Ships 3 files in scripts/ (Python), which the agent can run.
Shell commands in SKILL.md call:
- python
From the folder's file list and the shell code blocks in SKILL.md.
Network
Hosts in commands or code, which the agent is likely to contact:
- docs.google.com
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Google Sheets loads about 1k tokens when it runs. Until then it costs about 108 tokens; SKILL.md has 201 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~108
When it runs · the whole SKILL.md, loaded when a task matches: ~1k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from sanjay3290/ai-skills at commit 281d88d, republished under its Apache-2.0 licence (© sanjay3290). 201 words, ~1,037 tokens.

Download SKILL.mdSave it as .claude/skills/google-sheets/SKILL.md (or your agent's skills folder). This skill also uses 5 other files; get the full folder from GitHub.

name: google-sheets
description: Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata. Use when user asks to: read a spreadsheet, update cells, add data to Google Sheets, find a spreadsheet, check sheet contents, export spreadsheet data, or get cell values. Lightweight integration with standalone OAuth authentication supporting full read/write access.
license: Apache-2.0
metadata.author: sanjay3290
metadata.version: 1.0

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 (sheets, dimensions, etc.)
python scripts/sheets.py get-metadata SPREADSHEET_ID

Write Commands

bash

# 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"}}]'

Spreadsheet ID

You can use either:

The spreadsheet ID: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms
The full URL: https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit

The script automatically extracts the ID from URLs.

Output Formats

Text (default)

Human-readable format with pipe separators:

Spreadsheet Title: Sales Data
Sheet Name: Q1
Name | Revenue | Units
Product A | 10000 | 50
Product B | 15000 | 75

CSV

Standard CSV format, suitable for further processing:

Name,Revenue,Units
Product A,10000,50
Product B,15000,75

JSON

Structured data format:

json

{
  "Q1": [
    ["Name", "Revenue", "Units"],
    ["Product A", "10000", "50"]
  ]
}

A1 Notation Examples

Sheet1!A1:B10 - Range A1 to B10 on Sheet1
Sheet1!A:A - All of column A on Sheet1
Sheet1!1:1 - All of row 1 on Sheet1
A1:C5 - Range on the first sheet

Value Input Options

USER_ENTERED (default): Values are parsed as if typed by a user. Numbers, dates, and formulas are interpreted.
RAW (--raw flag): Values are stored exactly as provided. No parsing of formulas or number formatting.

Token Management

Tokens stored securely using the system keyring:

macOS: Keychain
Windows: Windows Credential Locker
Linux: Secret Service API (GNOME Keyring, KDE Wallet, etc.)

Service name: google-sheets-skill-oauth

Tokens automatically refresh when expired using Google's cloud function.

Files

SKILL.md and 5 other files (scripts) in skills/google-sheets of sanjay3290/ai-skills.

SKILL.md
README.md
requirements.txt
scripts/auth.py
scripts/requirements.txt
scripts/sheets.py

Open the folder on GitHubat commit 281d88d

Compare with similar skills

Google Sheets next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Google Sheets compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Google Sheets this skillsanjay3290/ai-skills	430	—	~1k	Automated safety check: Pass	Apache-2.0	26 days ago
Managing Google Workspacetaylorwilsdon/google_workspace_mcp	3.3k	—	~2.9k	Automated safety check: Pass	MIT	today
Gdoc To Markdowniurykrieger/claude-bedrock	105	1 repos	~3.8k	Automated safety check: Notes	MIT	5 mo ago
XLSXzzhonglei/GeoCode-Release	186	—	~3.1k	Automated safety check: Pass	MIT	3 days ago
List Buildergrowthenginenowoslawski/coldoutboundskills	740	—	~4.7k	Automated safety check: Notes	MIT	yesterday
Gws Sheets Appendgoogleworkspace/cli	31k	1 repos	~389	Automated safety check: Pass	Apache-2.0	today

Similar skills

Managing Google Workspace
taylorwilsdon/google_workspace_mcp
Manages Google Workspace operations across 12 services (Gmail, Drive, Calendar, Docs, Sheets, Slides, Forms, Tasks, Contacts, Chat, Apps Script, Custom Search).
3.3k GitHub stars~2.9k tokensUpdated today
Documents & OfficeAuto-check passed
Gdoc To Markdown
iurykrieger/claude-bedrock
Internal fetcher module for Google Docs and Sheets. An agent skill from iurykrieger/claude-bedrock.
105 GitHub starsUsed in 1 repo~3.8k tokens
Documents & OfficeAuto-check: notes
XLSX
zzhonglei/GeoCode-Release
Create, edit, analyze, or convert Excel spreadsheets (.xlsx, .xlsm) where the workbook file is the primary deliverable.
186 GitHub stars~3.1k tokensUpdated 3 days ago
Documents & OfficeAuto-check passed
List Builder
growthenginenowoslawski/coldoutboundskills
META skill — build the largest possible qualified lead list for any request, end to end.
740 GitHub stars~4.7k tokensUpdated yesterday
Documents & OfficeAuto-check: notes
Gws Sheets Append
googleworkspace/cli
Google Sheets: Append a row to a spreadsheet. An agent skill from googleworkspace/cli.
31k GitHub starsUsed in 1 repo~389 tokens
Documents & OfficeAuto-check passed
Gws Sheets Read
googleworkspace/cli
Google Sheets: Read values from a spreadsheet. An agent skill from googleworkspace/cli.
31k GitHub starsUsed in 1 repo~279 tokens
Documents & OfficeAuto-check passed

Questions about Google Sheets

What does Google Sheets do?

Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata. Google Sheets is an agent skill from sanjay3290/ai-skills. Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata.

When should I use Google Sheets?

Google Sheets fits situations like: user asks to: read a spreadsheet; add data to Google Sheets; find a spreadsheet; check sheet contents.

How do I install Google Sheets in Claude Code?

Run `npx skills add sanjay3290/ai-skills --skill google-sheets -a claude-code`. Or copy the skill folder (skills/google-sheets in sanjay3290/ai-skills) into .claude/skills/google-sheets in your project. Claude Code loads it when a task matches its description.

How do I install Google Sheets in Codex?

Run `npx skills add sanjay3290/ai-skills --skill google-sheets -a codex`. Or copy the skill folder (skills/google-sheets in sanjay3290/ai-skills) into .agents/skills/google-sheets in your project. Codex loads it when a task matches its description.

Can I use Google Sheets in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add sanjay3290/ai-skills --skill google-sheets -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/google-sheets, .gemini/skills/google-sheets, .github/skills/google-sheets and .opencode/skills/google-sheets in your project.

What does Google Sheets need to run?

Going by SKILL.md and its folder, Google Sheets needs Python for the scripts in its folder and the command-line tools its instructions call (python). Our summary lists: Python 3.

Does Google Sheets access the network?

SKILL.md names 1 domain. In commands or code: docs.google.com; the agent is likely to contact it when it follows the instructions. This is read from the text; nothing was executed.

Is Google Sheets safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Google Sheets use?

Google Sheets is published under the Apache-2.0 licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Google Sheets use?

About 1k tokens (SKILL.md is roughly 4.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Google Sheets?

Skills that share tags, products or a category with Google Sheets: Managing Google Workspace (taylorwilsdon/google_workspace_mcp, 3.3k stars), Gdoc To Markdown (iurykrieger/claude-bedrock, 105 stars), XLSX (zzhonglei/GeoCode-Release, 186 stars) and List Builder (growthenginenowoslawski/coldoutboundskills, 740 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Google Sheets?

sanjay3290 (a GitHub user) maintains it in sanjay3290/ai-skills, which has 430 GitHub stars. The repository holds 24 skills in this directory. The repository was last updated on September 10, 2026.

Source: sanjay3290/ai-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Install Google Sheets

Facts

At a glance

What it does

When your agent uses it

Example prompts

Requirements

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Google Sheets

First-Time Setup

Read Commands

Write Commands

Spreadsheet ID

Output Formats

Text (default)

CSV

JSON

A1 Notation Examples

Value Input Options

Token Management

Files

Compare with similar skills

Similar skills

More from sanjay3290/ai-skills

Related

Questions about Google Sheets