How do I install the Google Sheets Skill skill?

Run npx skillmds@latest add idanbeck/google-sheets-skill in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Google Sheets Skill safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: executes scripts, makes network calls. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Google Sheets Skill?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Google Sheets Skill free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Google Sheets Skill?

idanbeck (@idanbeck) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Google Sheets Skill by idanbeck — Agent Skill

Name: Google Sheets Skill
Rating: 4.2 (5 reviews)
Author: idanbeck

File contents

Google Sheets Skill

Read, write, and manage Google Sheets.

Setup

Uses same Google OAuth as gmail-skill. If you have gmail-skill configured, this will work automatically.

Otherwise:

Go to https://console.cloud.google.com/apis/credentials
Create OAuth client (Desktop app)
Enable Google Sheets API
Download JSON to ~/.claude/skills/google-sheets-skill/credentials.json
Run: python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py login

Commands

List & Info

# List your spreadsheets
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py list [--limit N]

# Get spreadsheet info
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py get SPREADSHEET_ID

Reading Data

# Read a range
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py read SPREADSHEET_ID "Sheet1!A1:C10"

# Read entire sheet
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py read SPREADSHEET_ID "Sheet1"

Writing Data

# Write to range (overwrites)
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py write SPREADSHEET_ID "Sheet1!A1" --values '[["Header1","Header2"],["Row1","Data"]]'

# Append rows
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py append SPREADSHEET_ID "Sheet1" --values '[["New","Row"]]'

# Clear range
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py clear SPREADSHEET_ID "Sheet1!A1:C10"

Sheet Management

# Create new spreadsheet
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py create --title "My Spreadsheet"

# Add sheet to existing spreadsheet
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py add-sheet SPREADSHEET_ID --title "New Tab"

# Delete sheet
python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py delete-sheet SPREADSHEET_ID --sheet-id 123456

Range Notation

Sheet1!A1:C10 - Specific range
Sheet1!A:C - Entire columns A-C
Sheet1!1:10 - Rows 1-10
Sheet1 - Entire sheet
A1:C10 - Default sheet

Spreadsheet ID

Found in the URL: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit

Output

All commands output JSON.

---name: google-sheets-skilldescription: Read and write Google Sheets. Use when the user asks to read spreadsheet data, update cells, create sheets, or work with Google Sheets.--- # Google Sheets Skill Read, write, and manage Google Sheets. ## Setup Uses same Google OAuth as gmail-skill. If you have gmail-skill configured, this will work automatically. Otherwise: 1. Go to https://console.cloud.google.com/apis/credentials 2. Create OAuth client (Desktop app) 3. Enable Google Sheets API 4. Download JSON to `~/.claude/skills/google-sheets-skill/credentials.json` 5. Run: `python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py login` ## Commands ### List & Info ```bash # List your spreadsheets python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py list [--limit N] # Get spreadsheet info python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py get SPREADSHEET_ID ``` ### Reading Data ```bash # Read a range python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py read SPREADSHEET_ID "Sheet1!A1:C10" # Read entire sheet python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py read SPREADSHEET_ID "Sheet1" ``` ### Writing Data ```bash # Write to range (overwrites) python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py write SPREADSHEET_ID "Sheet1!A1" --values '[["Header1","Header2"],["Row1","Data"]]' # Append rows python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py append SPREADSHEET_ID "Sheet1" --values '[["New","Row"]]' # Clear range python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py clear SPREADSHEET_ID "Sheet1!A1:C10" ``` ### Sheet Management ```bash # Create new spreadsheet python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py create --title "My Spreadsheet" # Add sheet to existing spreadsheet python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py add-sheet SPREADSHEET_ID --title "New Tab" # Delete sheet python3 ~/.claude/skills/google-sheets-skill/sheets_skill.py delete-sheet SPREADSHEET_ID --sheet-id 123456 ``` ## Range Notation - `Sheet1!A1:C10` - Specific range - `Sheet1!A:C` - Entire columns A-C - `Sheet1!1:10` - Rows 1-10 - `Sheet1` - Entire sheet - `A1:C10` - Default sheet ## Spreadsheet ID Found in the URL: `https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit` ## Output All commands output JSON.

Frequently asked questions

Google Sheets Skill

File contents

Google Sheets Skill

Setup

Commands

List & Info

Reading Data

Writing Data

Sheet Management

Range Notation

Spreadsheet ID

Output

Related skills

Frequently asked questions

How do I install the Google Sheets Skill skill?

What does the Google Sheets Skill skill do?

Is Google Sheets Skill safe to use?

Which AI agents work with Google Sheets Skill?

Is Google Sheets Skill free to use?

Who published Google Sheets Skill?