gws-sheets
Enables reading and writing data to Google Sheets using command-line tools. Not for local Excel/CSV files.
Install
mkdir -p .claude/skills/gws-sheets && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/19476" && unzip -o skill.zip -d .claude/skills/gws-sheets && rm skill.zipInstalls to .claude/skills/gws-sheets
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Google Sheets 读写数据。不用于：本地 Excel/CSV（用 xlsx 技能）Key capabilities
- →Read data from specific cell ranges
- →Append new rows to existing sheets
- →Overwrite cell ranges with new values
- →Retrieve spreadsheet property metadata
- →Clear data from defined ranges
How it works
The skill utilizes the gws CLI to interface with the Google Sheets API for reading, writing, and managing spreadsheet resources.
Inputs & outputs
When to use gws-sheets
- →Read data from a Google Sheet
- →Append rows to a tracking sheet
- →Overwrite specific ranges in a sheet
- →Get spreadsheet property metadata
About this skill
Requires: gws CLI installed and authenticated (gws auth login).
Command syntax
gws sheets <resource> <method> --params '{"key":"val"}' --json '{"key":"val"}'
Read cell range
{"command": "gws sheets spreadsheets.values get --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1!A1:D10\"}'", "timeout": 30000}
Read entire sheet
{"command": "gws sheets spreadsheets.values get --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1\"}'", "timeout": 30000}
Write cells (overwrite)
{"command": "gws sheets spreadsheets.values update --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1!A1\",\"valueInputOption\":\"USER_ENTERED\"}' --json '{\"values\":[[\"Name\",\"Score\"],[\"Alice\",95],[\"Bob\",87]]}'", "timeout": 30000}
Append rows
{"command": "gws sheets spreadsheets.values append --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1!A:A\",\"valueInputOption\":\"USER_ENTERED\"}' --json '{\"values\":[[\"Charlie\",92]]}'", "timeout": 30000}
Get spreadsheet metadata
{"command": "gws sheets spreadsheets get --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"fields\":\"sheets.properties\"}'", "timeout": 30000}
Clear range
{"command": "gws sheets spreadsheets.values clear --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1!A1:D10\"}'", "timeout": 30000}
Batch read multiple ranges
{"command": "gws sheets spreadsheets.values batchGet --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"ranges\":\"Sheet1!A1:B5\",\"ranges\":\"Sheet2!A1:C3\"}'", "timeout": 30000}
Rules
- spreadsheetId is in the URL:
https://docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit. valueInputOption:USER_ENTERED(parses formulas/dates) orRAW(literal text).- Range notation:
Sheet1!A1:D10,Sheet1!A:A(whole column),Sheet1(whole sheet). - Always use
fieldsparameter onspreadsheets.getto limit metadata size. - Use
gws schema sheets.spreadsheets.values.updateto discover all parameters.
When not to use it
- →Local Excel or CSV file manipulation
Prerequisites
Limitations
- →Requires specific spreadsheetId from the URL
- →Range notation must follow standard sheet syntax
How it compares
This provides a programmatic command-line interface for cloud-based sheets rather than manual browser-based editing.
Compared to similar skills
gws-sheets side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| gws-sheets (this skill) | 0 | 3mo | No flags | Beginner |
| google-sheets-automation | 0 | 2mo | Review | Intermediate |
| xlsx | 87 | 5mo | Review | Intermediate |
| excel-analysis | 22 | 9mo | No flags | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
You might also like
google-sheets-automation
TJSNDHU
Lightweight Google Sheets integration with standalone OAuth authentication. No MCP server required. Full read/write access.
xlsx
anthropics
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
excel-analysis
davila7
Analyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.
spreadsheet-formula-helper
ComposioHQ
Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.
segment-cdp
davila7
Expert patterns for Segment Customer Data Platform including Analytics.js, server-side tracking, tracking plans with Protocols, identity resolution, destinations configuration, and data governance best practices. Use when: segment, analytics.js, customer data platform, cdp, tracking plan.
developing-in-lightdash
lightdash
Build, configure, and deploy Lightdash analytics projects. Supports both dbt projects with embedded Lightdash metadata and pure Lightdash YAML projects without dbt. Create metrics, dimensions, charts, and dashboards using the Lightdash CLI.