google-sheets · acedatacloud — Claude Code skill: setup
This skill reads and edits Google Sheets through the Sheets v4 REST API. Use it for ranges, rows, tabs, and spreadsheet creation from an agent conversation.
Apache-2.0 179 installs ★ 17 updated 2026-10-25
npx skills add AceDataCloud/Skills --skill google-sheets -a claude-codeWhat google-sheets does
The skill works with Google Sheets through curl, jq, and the Sheets v4 REST API. It can read A1 ranges, append rows, replace values in a fixed range, create spreadsheets, and add tabs. A spreadsheet ID comes from the URL segment between /d/ and /edit.
Requests use an OAuth bearer token stored in $GOOGLE_SHEETS_TOKEN. The default connection grants spreadsheets.readonly; edits require the broader spreadsheets scope, so the agent must confirm access before writing. Without the token, API calls cannot run.
The skill is limited to Bash tools and passes API failures through with their code, message, and status. For values, RAW keeps strings as supplied while USER_ENTERED lets Sheets interpret dates, numbers, and formulas. Data is sent row by row, and tab names containing spaces need quoting in A1 ranges.
What it helps with
- read a cell range from a spreadsheet
- append new rows to an existing tab
- replace values in a fixed range
- create a spreadsheet or add a tab
Example prompts for the agent
- Read
Sheet1!A1:D20from the spreadsheet at this URL. - Append today’s date, the customer, and the amount to
Sheet1, then ask me before writing. - Create a spreadsheet titled
Report 2026and add a tab namedQ3.
How to install google-sheets
1Skills CLI (Vercel)
npx skills add AceDataCloud/Skills --skill google-sheets -a claude-code2Manually: put the files in place
~/.claude/skills/google-sheets/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/google-sheets/
1Skills CLI (Vercel)
npx skills add AceDataCloud/Skills --skill google-sheets -a codex2Manually: put the files in place
.agents/skills/google-sheets/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add AceDataCloud/Skills --skill google-sheets -a cursor2Manually: put the files in place
.cursor/skills/google-sheets/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install AceDataCloud/Skills skills/google-sheets2Manually: put the files in place
.github/skills/google-sheets/SKILL.md1Skills CLI (Vercel)
npx skills add AceDataCloud/Skills --skill google-sheets -a gemini-cli2Platform CLI
gemini skills install https://github.com/AceDataCloud/Skills --path skills/google-sheetsManually: put the files in place
.devin/skills/google-sheets/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add AceDataCloud/Skills --skill google-sheets -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about google-sheets
How do I install google-sheets in Claude Code?
Run npx skills add AceDataCloud/Skills --skill google-sheets -a claude-code, then check ~/.claude/skills/google-sheets/SKILL.md.
What does google-sheets do?
It reads ranges and spreadsheet metadata, appends or replaces values, creates spreadsheets, and adds tabs through the Google Sheets API.
Which permissions are needed to edit a Google Sheet?
Reading uses spreadsheets.readonly. Writes require the spreadsheets scope, which must be approved when connecting the skill.
Source text
SKILL.md · Apache-2.0
---
name: google-sheets
description: Read and edit Google Sheets via the Sheets v4 REST API. Use when the user mentions Google Sheets, a spreadsheet, cells / ranges / tabs, reading or appending rows, updating values, or creating a new spreadsheet.
when_to_use: |
Trigger when the user wants to read a range from a Sheet, append or
update rows, add a tab, or create a spreadsheet. The connector grants
`spreadsheets.readonly` by default; the user opts in to the broader
`spreadsheets` scope (read + write) at install — confirm before
writes. Find the spreadsheet id from a Drive URL or a google-drive
search.
connections: [google/sheets]
allowed_tools: [Bash]
license: Apache-2.0
metadata:
author: acedatacloud
version: "1.0"
---
Drive **Google Sheets** via `curl + jq`. The user's OAuth bearer token is in
`$GOOGLE_SHEETS_TOKEN`; every call needs `Authorization: Bearer
$GOOGLE_SHEETS_TOKEN`. Base URL: `https://sheets.googleapis.com/v4/spreadsheets`.
The token carries `spreadsheets.readonly` (+ identity); writes need the broader
`spreadsheets` scope.
Failures are `{"error":{"code","message","status"}}` — show verbatim. `401` =
re-install. `403 PERMISSION_DENIED` on a write = read-only scope → re-connect
with read+write.
The spreadsheet id is the `…/spreadsheets/d/<ID>/edit` segment of the URL.
```bash
S="https://sheets.googleapis.com/v4/spreadsheets"; AUTH="Authorization: Bearer $GOOGLE_SHEETS_TOKEN"
# Tabs + title
curl -sS -H "$AUTH" "$S/SPREADSHEET_ID?fields=properties.title,sheets.properties(title,sheetId)" \
| jq '{title: .properties.title, tabs: [.sheets[].properties.title]}'
```
## Read / append / update values
```bash
ID="SPREADSHEET_ID"
# Read a range (A1 notation; values are rows of cells)
curl -sS -H "$AUTH" "$S/$ID/values/Sheet1!A1:D20" | jq '.values'
# Append rows (confirm first). valueInputOption=USER_ENTERED parses formulas/dates.
curl -sS -X POST -H "$AUTH" -H "Content-Type: application/json" \
-d '{"values":[["2026-06-21","Acme",4200]]}' \
"$S/$ID/values/Sheet1!A1:append?valueInputOption=USER_ENTERED" | jq '.updates'
# Update a fixed range: PUT /values/{range}?valueInputOption=USER_ENTERED
curl -sS -X PUT -H "$AUTH" -H "Content-Type: application/json" \
-d '{"values":[["done"]]}' \
"$S/$ID/values/Sheet1!E2?valueInputOption=USER_ENTERED" | jq '.updatedCells'
```
## Create a spreadsheet / add a tab
```bash
# New spreadsheet
curl -sS -X POST -H "$AUTH" -H "Content-Type: application/json" \
-d '{"properties":{"title":"Report 2026"}}' "$S" | jq '{spreadsheetId, spreadsheetUrl}'
# Add a tab via batchUpdate (addSheet request)
curl -sS -X POST -H "$AUTH" -H "Content-Type: application/json" \
-d '{"requests":[{"addSheet":{"properties":{"title":"Q3"}}}]}' \
"$S/$ID:batchUpdate" | jq '.replies'
```
## Gotchas
- **A1 notation:** `Sheet1!A1:D20`; quote tab names with spaces as `'My Tab'!A1`.
- `valueInputOption=RAW` stores strings as-is; `USER_ENTERED` interprets them like
the UI (numbers, dates, `=FORMULA`). Pick deliberately.
- `values` is row-major (`[[row1...],[row2...]]`); a missing trailing cell just
comes back short — don't assume rectangular.
© acedatacloud · Apache-2.0 · AceDataCloud/Skills
Similar skills
All skills for Data and databases →google-sheets by other authors comes first.