How do I install the Google Sheets skill?

Run npx skillmds@latest add acedatacloud/google-sheets 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 safe to use?

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

Which AI agents work with Google Sheets?

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

Yes. Installing skills from SkillMD is free. This skill is licensed under Apache-2.

Who published Google Sheets?

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

Google Sheets by acedatacloud — Agent Skill

Name: Google Sheets
Rating: 4.5 (4 reviews)
Author: acedatacloud

File contents

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.

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

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

# 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.

---name: google-sheetsdescription: 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.license: Apache-2.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.

Frequently asked questions

Google Sheets