How do I install the Gsheets skill?

Run npx skillmds@latest add the-focus-ai/gsheets 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 Gsheets safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Gsheets?

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 Gsheets free to use?

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

Who published Gsheets?

The-Focus-AI (@the-focus-ai) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Gsheets by the-focus-ai — Agent Skill

Name: Gsheets
Author: The-Focus-AI

Gsheets

This skill should be used when the user asks to "read spreadsheet", "write to sheet", "create spreadsheet", "list spreadsheets", "google sheets", "read cells", "write cells", "append rows", "sheet data", or mentions Google Sheets operations. Provides Google Sheets API integration for reading, writing, and managing spreadsheets.

The-Focus-AI 82698b9 2 files · 14.8 KB Updated Sep 17, 2026

File contents

Google Sheets Skill

Create, read, write, and manage Google Sheets spreadsheets.

First-Time Setup

Run npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gmail/scripts/gmail.ts auth to authenticate with Google. This opens a browser for OAuth consent and grants access to all Google services including Sheets.

Tokens are stored per-project in .claude/google-skill.local.json.

Using Your Own Credentials (Optional)

By default, this skill uses embedded OAuth credentials. To use your own Google Cloud project instead, save your credentials to ~/.config/google-skill/credentials.json.

Commands

# List your spreadsheets
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts list
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts list --max=50

# Get spreadsheet metadata (title, sheets, etc.)
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts get <spreadsheetId>

# Read cell values (A1 notation)
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts read <spreadsheetId> "Sheet1!A1:D10"

# Write values to cells
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts write <spreadsheetId> "Sheet1!A1" \
  --values='[["Hello","World"],["Row 2","Data"]]'

# Append rows to end of sheet
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts append <spreadsheetId> "Sheet1!A:D" \
  --values='[["New","Row","Data"]]'

# Clear a range
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts clear <spreadsheetId> "Sheet1!A1:D10"

# Create new spreadsheet
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts create --title="My Spreadsheet"
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts create --title="Project Data" --sheets="Q1,Q2,Q3,Q4"

# Add new sheet/tab to existing spreadsheet
npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts add-sheet <spreadsheetId> --title="New Tab"

A1 Notation Reference

Notation	Meaning
`Sheet1!A1`	Single cell A1 in Sheet1
`Sheet1!A1:D10`	Range from A1 to D10
`Sheet1!A:D`	Columns A through D (all rows)
`Sheet1!1:10`	Rows 1 through 10 (all columns)
`A1:D10`	Range in first sheet

Values Format

Values are JSON arrays of arrays:

[
  ["Header 1", "Header 2", "Header 3"],
  ["Row 1", 123, true],
  ["Row 2", 456, false]
]

Supported value types: strings, numbers, booleans, null (empty cell).

Output

All commands return JSON with success and data fields.

Help

npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts --help

---name: gsheetsdescription: This skill should be used when the user asks to "read spreadsheet", "write to sheet", "create spreadsheet", "list spreadsheets", "google sheets", "read cells", "write cells", "append rows", "sheet data", or mentions Google Sheets operations. Provides Google Sheets API integration for reading, writing, and managing spreadsheets.---# Google Sheets SkillCreate, read, write, and manage Google Sheets spreadsheets.## First-Time SetupRun `npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gmail/scripts/gmail.ts auth` to authenticate with Google. This opens a browser for OAuth consent and grants access to all Google services including Sheets.Tokens are stored per-project in `.claude/google-skill.local.json`.## Using Your Own Credentials (Optional)By default, this skill uses embedded OAuth credentials. To use your own Google Cloud project instead, save your credentials to `~/.config/google-skill/credentials.json`.## Commands```bash# List your spreadsheetsnpx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts listnpx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts list --max=50# Get spreadsheet metadata (title, sheets, etc.)npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts get <spreadsheetId># Read cell values (A1 notation)npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts read <spreadsheetId> "Sheet1!A1:D10"# Write values to cellsnpx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts write <spreadsheetId> "Sheet1!A1" \ --values='[["Hello","World"],["Row 2","Data"]]'# Append rows to end of sheetnpx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts append <spreadsheetId> "Sheet1!A:D" \ --values='[["New","Row","Data"]]'# Clear a rangenpx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts clear <spreadsheetId> "Sheet1!A1:D10"# Create new spreadsheetnpx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts create --title="My Spreadsheet"npx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts create --title="Project Data" --sheets="Q1,Q2,Q3,Q4"# Add new sheet/tab to existing spreadsheetnpx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts add-sheet <spreadsheetId> --title="New Tab"```## A1 Notation Reference| Notation | Meaning ||----------|---------|| `Sheet1!A1` | Single cell A1 in Sheet1 || `Sheet1!A1:D10` | Range from A1 to D10 || `Sheet1!A:D` | Columns A through D (all rows) || `Sheet1!1:10` | Rows 1 through 10 (all columns) || `A1:D10` | Range in first sheet |## Values FormatValues are JSON arrays of arrays:```json[ ["Header 1", "Header 2", "Header 3"], ["Row 1", 123, true], ["Row 2", 456, false]]```Supported value types: strings, numbers, booleans, null (empty cell).## OutputAll commands return JSON with `success` and `data` fields.## Help```bashnpx tsx ${CLAUDE_PLUGIN_ROOT}/skills/gsheets/scripts/gsheets.ts --help```

Frequently asked questions