Agent skill

Google Sheet

Read, write, append, and manage Google Sheets via the Google Sheets API (Node.js SDK).

Install Google Sheet

skills CLI

$ npx skills add CraftOS-dev/CraftBot --skill google-sheet -a claude-code

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

GitHub CLI

$ gh skill install CraftOS-dev/CraftBot google-sheet --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/CraftOS-dev/CraftBot.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/google-sheet .claude/skills/google-sheet && 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-sheet" agent skill from https://github.com/CraftOS-dev/CraftBot/tree/main/skills/google-sheet into .claude/skills/google-sheet/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheet", 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/CraftOS-dev/CraftBot/tree/main/skills/google-sheet

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 CraftOS-dev/CraftBot --skill google-sheet -a codex

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

GitHub CLI

$ gh skill install CraftOS-dev/CraftBot google-sheet --agent codex

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

Manual copy

$ git clone --depth 1 https://github.com/CraftOS-dev/CraftBot.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/google-sheet .agents/skills/google-sheet && 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-sheet" agent skill from https://github.com/CraftOS-dev/CraftBot/tree/main/skills/google-sheet into .agents/skills/google-sheet/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheet", 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 CraftOS-dev/CraftBot --skill google-sheet -a cursor

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

GitHub CLI

$ gh skill install CraftOS-dev/CraftBot google-sheet --agent cursor

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

Manual copy

$ git clone --depth 1 https://github.com/CraftOS-dev/CraftBot.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/google-sheet .cursor/skills/google-sheet && 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-sheet" agent skill from https://github.com/CraftOS-dev/CraftBot/tree/main/skills/google-sheet into .cursor/skills/google-sheet/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheet", 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/CraftOS-dev/CraftBot.git --path skills/google-sheet

--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 CraftOS-dev/CraftBot --skill google-sheet -a gemini-cli

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

GitHub CLI

$ gh skill install CraftOS-dev/CraftBot google-sheet --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/CraftOS-dev/CraftBot.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/google-sheet .gemini/skills/google-sheet && 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-sheet" agent skill from https://github.com/CraftOS-dev/CraftBot/tree/main/skills/google-sheet into .gemini/skills/google-sheet/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheet", 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 CraftOS-dev/CraftBot google-sheet

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 CraftOS-dev/CraftBot --skill google-sheet -a github-copilot

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

Manual copy

$ git clone --depth 1 https://github.com/CraftOS-dev/CraftBot.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/google-sheet .github/skills/google-sheet && 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-sheet" agent skill from https://github.com/CraftOS-dev/CraftBot/tree/main/skills/google-sheet into .github/skills/google-sheet/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheet", 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 CraftOS-dev/CraftBot --skill google-sheet -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 CraftOS-dev/CraftBot google-sheet --agent opencode

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

Manual copy

$ git clone --depth 1 https://github.com/CraftOS-dev/CraftBot.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/google-sheet .opencode/skills/google-sheet && 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-sheet" agent skill from https://github.com/CraftOS-dev/CraftBot/tree/main/skills/google-sheet into .opencode/skills/google-sheet/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "google-sheet", 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-sheet
GitHub stars: 392
Token cost: ~1k tokens
SKILL.md length: 238 words
Files: 6 (incl. scripts)
Skills in repo: 89
Repo updated: Oct 7, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

Read, write, append, and manage Google Sheets via the Google Sheets API (Node.js SDK).

Works in 4 steps: Google Cloud Console → Configure credentials (one of these) → Share sheets with the service account… → …
You need to interact with spreadsheets — reading data
SKILL.md covers Setup (One-time), Usage, Commands and Examples, plus 4 more sections
Runs JavaScript scripts from its folder; calls node and npm; reaches docs.google.com; needs GOOGLE_SERVICE_ACCOUNT_KEY

What it does

Google Sheet is an agent skill from CraftOS-dev/CraftBot. Read, write, append, and manage Google Sheets via the Google Sheets API (Node.js SDK). Use when you need to interact with spreadsheets — reading data, writing/updating cells, appending rows, clearing ranges, formatting cells, managing sheets. Requires a Google Cloud service account with Sheets API enabled.

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 `_meta.json`, `env_example.md` and `package-lock.json`).

It sits in Documents & Office, covering Excel spreadsheets. It works with Google Sheets, Google Cloud and Node.js. The repository describes itself as: One agent. Every kind of work. The licence is MIT.

When your agent uses it

You need to interact with spreadsheets — reading data
Writing/updating cells
Clearing ranges
Formatting cells

Example prompts

“/google-sheet”

Requirements

Node.js
A credential in GOOGLE_SERVICE_ACCOUNT_KEY

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

Google Cloud Console
Configure credentials (one of these)
Share sheets with the service account email (found in JSON key as client_email)
Install dependencies

What it can do on your machine

Read from SKILL.md and the folder at commit b50970c. 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 1 file in scripts/ (JavaScript), which the agent can run.
Shell commands in SKILL.md call:
- node
- npm
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 these keys or tokens, usually read from environment variables:
- GOOGLE_SERVICE_ACCOUNT_KEY
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Google Sheet loads about 1k tokens when it runs. Until then it costs about 80 tokens; SKILL.md has 238 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~80
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 CraftOS-dev/CraftBot at commit b50970c, republished under its MIT licence (© CraftOS-dev). 238 words, ~1,034 tokens.

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

name: google-sheet
description: Read, write, append, and manage Google Sheets via the Google Sheets API (Node.js SDK). Use when you need to interact with spreadsheets — reading data, writing/updating cells, appending rows, clearing ranges, formatting cells, managing sheets. Requires a Google Cloud service account with Sheets API enabled.

Google Sheets Skill

Interact with Google Sheets using a service account.

Setup (One-time)

Google Cloud Console:
- Create/select a project
- Enable "Google Sheets API"
- Create a Service Account (IAM → Service Accounts → Create)
- Download JSON key
Configure credentials (one of these):
- Set env: GOOGLE_SERVICE_ACCOUNT_KEY=/path/to/key.json
- Place service-account.json or credentials.json in the skill directory
- Place in ~/.config/google-sheets/credentials.json
Share sheets with the service account email (found in JSON key as client_email)
Install dependencies:
bash
```
cd skills/google-sheets && npm install
```

Usage

bash

node scripts/sheets.js <command> [args]

Commands

Data Operations

Command	Args	Description
`read`	`<id> <range>`	Read cells
`write`	`<id> <range> <json>`	Write data
`append`	`<id> <range> <json>`	Append rows
`clear`	`<id> <range>`	Clear range

Formatting

Command	Args	Description
`format`	`<id> <range> <formatJson>`	Format cells
`getFormat`	`<id> <range>`	Get cell formats
`borders`	`<id> <range> [styleJson]`	Add borders
`copyFormat`	`<id> <source> <dest>`	Copy format between ranges
`merge`	`<id> <range>`	Merge cells
`unmerge`	`<id> <range>`	Unmerge cells

Layout

Command	Args	Description
`resize`	`<id> <sheet> <cols\|rows> <start> <end> <px>`	Resize columns/rows
`autoResize`	`<id> <sheet> <startCol> <endCol>`	Auto-fit columns
`freeze`	`<id> <sheet> [rows] [cols]`	Freeze rows/columns

Sheet Management

Command	Args	Description
`create`	`<title>`	Create spreadsheet
`info`	`<id>`	Get metadata
`addSheet`	`<id> <title>`	Add sheet tab
`deleteSheet`	`<id> <sheetName>`	Delete sheet tab
`renameSheet`	`<id> <oldName> <newName>`	Rename sheet tab

Examples

bash

# Read data
node scripts/sheets.js read "SPREADSHEET_ID" "Sheet1!A1:C10"

# Write data
node scripts/sheets.js write "SPREADSHEET_ID" "Sheet1!A1:B2" '[["Name","Score"],["Alice",95]]'

# Format cells (yellow bg, bold)
node scripts/sheets.js format "SPREADSHEET_ID" "Sheet1!A1:B2" '{"backgroundColor":{"red":255,"green":255,"blue":0},"textFormat":{"bold":true}}'

# Copy format from one range to another
node scripts/sheets.js copyFormat "SPREADSHEET_ID" "Sheet1!A1:C3" "Sheet1!D1:F3"

# Add borders
node scripts/sheets.js borders "SPREADSHEET_ID" "Sheet1!A1:C3"

# Resize columns to 150px
node scripts/sheets.js resize "SPREADSHEET_ID" "Sheet1" cols A C 150

# Auto-fit column widths
node scripts/sheets.js autoResize "SPREADSHEET_ID" "Sheet1" A Z

# Freeze first row and column
node scripts/sheets.js freeze "SPREADSHEET_ID" "Sheet1" 1 1

# Add new sheet tab
node scripts/sheets.js addSheet "SPREADSHEET_ID" "NewSheet"

Format Options

json

{
  "backgroundColor": {"red": 255, "green": 255, "blue": 0},
  "textFormat": {
    "bold": true,
    "italic": false,
    "fontSize": 12,
    "foregroundColor": {"red": 0, "green": 0, "blue": 0}
  },
  "horizontalAlignment": "CENTER",
  "verticalAlignment": "MIDDLE",
  "wrapStrategy": "WRAP"
}

Border Style

json

{
  "style": "SOLID",
  "color": {"red": 0, "green": 0, "blue": 0}
}

Border styles: DOTTED, DASHED, SOLID, SOLID_MEDIUM, SOLID_THICK, DOUBLE

Finding Spreadsheet ID

From URL: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit

Troubleshooting

403 Forbidden: Sheet not shared with service account email
404 Not Found: Wrong spreadsheet ID or sheet name

Files

SKILL.md and 5 other files (scripts) in skills/google-sheet of CraftOS-dev/CraftBot.

SKILL.md
_meta.json
env_example.md
package-lock.json
package.json
scripts/sheets.js

Open the folder on GitHubat commit b50970c

Compare with similar skills

Google Sheet 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 Sheet compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Google Sheet this skillCraftOS-dev/CraftBot	392	—	~1k	Automated safety check: Pass	MIT	today
Spreadsheet Managementfreema/mcp-gsheets	100	—	~486	Automated safety check: Pass	MIT	3 days ago
Google Workspacetaracodlabs/aiden	849	—	~1.1k	Automated safety check: Pass	Apache-2.0	24 days ago
XLSXrvdbreemen/OTGW-firmware	207	35 repos	~2.9k	Automated safety check: Pass	Proprietary	today
Verify Sheets Argentoferminrp/google-sheets-argento	151	—	~2.4k	Automated safety check: Pass	None	20 days ago
XLSXK-Dense-AI/claude-scientific-writer	2.4k	—	~2.1k	Automated safety check: Notes	Proprietary	7 days ago

Similar skills

Spreadsheet Management
freema/mcp-gsheets
This skill should be used when the user asks about Google Sheets, spreadsheets, cells, rows, columns, charts, or data tables.
100 GitHub stars~486 tokensUpdated 3 days ago
Documents & OfficeAuto-check passed
Google Workspace
taracodlabs/aiden
Gmail, Calendar, Drive, Sheets, Docs via Google API (SA / OAuth)
849 GitHub stars~1.1k tokensUpdated 24 days ago
Documents & OfficeAuto-check passed
XLSX
rvdbreemen/OTGW-firmware
Use this skill any time a spreadsheet file is the primary input or output.
207 GitHub starsUsed in 35 repos~2.9k tokens
Documents & OfficeAuto-check passed
Verify Sheets Argento
ferminrp/google-sheets-argento
Verify Google Sheets Argento locally: launch the Node build/Jest stack and the static docs site, then prove formula behavior (DOLAR, CEDEAR, caución) and the public CEDEAR JSON.
151 GitHub stars~2.4k tokensUpdated 20 days ago
Documents & OfficeAuto-check passed
XLSX
K-Dense-AI/claude-scientific-writer
Create, edit, analyze, or convert Excel spreadsheets (.xlsx, .xlsm, .xltx) where the workbook file is the primary deliverable.
2.4k GitHub stars~2.1k tokensUpdated 7 days ago
Documents & OfficeAuto-check: notes
Streaming Export Safety
doccker/cc-use-exp
当代码涉及 Excel/CSV/JSON/PDF 大文件导出、批量序列化、内存里构建大对象时触发。防止 OOM、临时文件残留、同步导出阻塞 HTTP 线程等内存安全陷阱。
1.1k GitHub stars~1.9k tokensUpdated 1 mo ago
Documents & OfficeAuto-check passed

Questions about Google Sheet

What does Google Sheet do?

Read, write, append, and manage Google Sheets via the Google Sheets API (Node.js SDK). Google Sheet is an agent skill from CraftOS-dev/CraftBot.js SDK).

When should I use Google Sheet?

Google Sheet fits situations like: you need to interact with spreadsheets — reading data; writing/updating cells; clearing ranges; formatting cells.

How do I install Google Sheet in Claude Code?

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

How do I install Google Sheet in Codex?

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

Can I use Google Sheet 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 CraftOS-dev/CraftBot --skill google-sheet -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-sheet, .gemini/skills/google-sheet, .github/skills/google-sheet and .opencode/skills/google-sheet in your project.

What does Google Sheet need to run?

Going by SKILL.md and its folder, Google Sheet needs JavaScript for the scripts in its folder, the command-line tools its instructions call (node and npm) and credentials named GOOGLE_SERVICE_ACCOUNT_KEY. Our summary lists: Node.js; A credential in GOOGLE_SERVICE_ACCOUNT_KEY.

Does Google Sheet 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 Sheet 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 Sheet use?

Google Sheet is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Google Sheet 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 Sheet?

Skills that share tags, products or a category with Google Sheet: Spreadsheet Management (freema/mcp-gsheets, 100 stars), Google Workspace (taracodlabs/aiden, 849 stars), XLSX (rvdbreemen/OTGW-firmware, 207 stars) and Verify Sheets Argento (ferminrp/google-sheets-argento, 151 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Google Sheet?

CraftOS-dev (a GitHub user) maintains it in CraftOS-dev/CraftBot, which has 392 GitHub stars. The repository holds 89 skills in this directory. The repository was last updated on October 7, 2026.

Source: CraftOS-dev/CraftBot 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 Sheet

Facts

At a glance

What it does

When your agent uses it

Example prompts

Requirements

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Google Sheets Skill

Setup (One-time)

Usage

Commands

Data Operations

Formatting

Layout

Sheet Management

Examples

Format Options

Border Style

Finding Spreadsheet ID

Troubleshooting

Files

Compare with similar skills

Similar skills

More from CraftOS-dev/CraftBot

Related

Questions about Google Sheet