Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add AceDataCloud/Skills --skill google-sheets -a claude-code
Open on GitHub

What 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:D20 from 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 2026 and add a tab named Q3.

How to install google-sheets

1Skills CLI (Vercel)

npx skills add AceDataCloud/Skills --skill google-sheets -a claude-code

2Manually: put the files in place

~/.claude/skills/google-sheets/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/google-sheets/

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.

google-sheets sanjay3290 Skill for reading and writing Google Sheets directly from Claude Code, Cursor, Codex and other platforms. Uses OAuth, no MCP server required. CX Codex +1 483installs google-sheets official OpenAI Helps your agent create and edit Google Sheets with range precision using connectors or MCP. Useful for building clean tables, writing formulas, and fixing charts. CX Codex GP ChatGPT +1 24installs google-sheets membrane This skill connects an agent to Google Sheets through the Membrane CLI. Use it to read, write, and manage spreadsheet data from coding workflows. CX Codex +1 575installs FGAC.ai: Multiple Gmail Accounts, Google Sheets & Docs fgac-ai FGAC.ai: Multiple Gmail Accounts, Google Sheets & Docs is an MCP server for Claude Code that controls agent access to Google accounts. It gives the agent mail and spreadsheets, not your whole Drive. CX Codex +1 Google Sheets googlesheets Connects Google Sheets to coding agents via an HTTP endpoint. It lets tools search files, read grid data, batch edit rows, and manage comment threads. CX Codex +1 56,138installs google-sheets-mcp henilcalagiya Lets your agent create, read, update and delete Google Sheets tabs and spreadsheets. Auth runs through a service account key. CX Codex +1 ★ 13repo stars gws-sheets official googleworkspace The gws-sheets skill lets an agent read and edit Google Sheets through the CLI. Use it when a coding workflow needs spreadsheet data or table updates. CX Codex +1 61,900installs gws-sheets-read official googleworkspace gws-sheets-read reads cell values and sheets from Google Spreadsheets via CLI. Useful when an agent needs spreadsheet data without risk of altering it. CX Codex +1 52,800installs sheets-cli gmickel The sheets-cli skill gives your agent a CLI for reading Google Sheets tables, appending rows and editing cells. Useful when project data lives in a cloud spreadsheet. CX Codex +1 ★ 73repo stars

From the same set67

The whole set →

Project sponsors

Companies that keep this analytics open