Gws Sheets
- 46.6k installs
- 30k repo stars
- Updated July 22, 2026
- googleworkspace/cli
gws-sheets is a CLI skill providing zero-boilerplate access to Google Sheets APIs with structured output.
About
gws-sheets is a CLI skill that provides programmatic access to Google Sheets without writing REST calls. It returns structured JSON output for AI agents. Includes 40+ helper agents for spreadsheet operations like reading, appending, and bulk data manipulation.
- CLI for Google Sheets with zero boilerplate and structured JSON output
- 40+ agent skills for spreadsheet operations and automation
- Helper commands like +append and +read for common workflows
Gws Sheets by the numbers
- 46,618 all-time installs (skills.sh)
- +1,651 installs in the week ending Jul 28, 2026 (Skillselion tracking)
- Ranked #19 of 690 Office & Documents skills by installs in the Skillselion catalog
- Security screen: MEDIUM risk (skills.sh audit)
- Data as of Jul 28, 2026 (Skillselion catalog sync)
gws-sheets capabilities & compatibility
- Works with
- google drive
- Use cases
- data analysis
- Pricing
- Free
npx skills add https://github.com/googleworkspace/cli --skill gws-sheetsAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 46.6k |
|---|---|
| repo stars | ★ 30k |
| Security audit | 2 / 3 scanners passed |
| Last updated | July 22, 2026 |
| Repository | googleworkspace/cli ↗ |
How do you read and write Google Sheets from CLI?
Access Google Sheets programmatically via CLI with structured output for data automation
Who is it for?
Developers building agents for spreadsheet automation and data operations
Skip if: Interactive spreadsheet editing, desktop Excel-like workflows
When should I use this skill?
A developer wants to append rows, read spreadsheet values, or automate Sheets updates via gws sheets.
What you get
Updated spreadsheet rows, read cell value ranges, and reusable gws sheets command scripts.
- Spreadsheet row updates
- Read value ranges
- gws sheets shell commands
By the numbers
- Targets Google Sheets API v4 at skill version 0.22.5
- Documents two helper commands: +append and +read
Files
sheets (v4)
PREREQUISITE: Read../gws-shared/SKILL.mdfor auth, global flags, and security rules. If missing, rungws generate-skillsto create it.
gws sheets <resource> <method> [flags]Helper Commands
| Command | Description |
|---|---|
| `+append` | Append a row to a spreadsheet |
| `+read` | Read values from a spreadsheet |
API Resources
spreadsheets
batchUpdate— Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid then the entire request will fail and nothing will be applied. Some requests have replies to give you some information about how they are applied. The replies will mirror the requests. For example, if you applied 4 updates and the 3rd one had a reply, then the response will have 2 empty replies, the actual reply, and another empty reply, in that order.create— Creates a spreadsheet, returning the newly created spreadsheet.get— Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: Specify a [field mask](https://developers.google.com/workspace/sheets/api/guides/field-masks) listing your desired fields using the `fields` URL parameter in HTTP Set the includeGridData URL parameter to true.getByDataFilter— Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. For more information, see Read, write, and search metadata. This method differs from GetSpreadsheet in that it allows selecting which subsets of spreadsheet data to return by specifying a dataFilters parameter. Multiple DataFilters can be specified.developerMetadata— Operations on the 'developerMetadata' resourcesheets— Operations on the 'sheets' resourcevalues— Operations on the 'values' resource
Discovering Commands
Before calling any API method, inspect it:
# Browse resources and methods
gws sheets --help
# Inspect a method's required params, types, and defaults
gws schema sheets.<resource>.<method>Use gws schema output to build your --params and --json flags.
Related skills
Lark DocGenerate, update, and maintain structured documentation directly inside Lark/Feishu using natural language and agentic workflows.475kLark DriveLet their coding agents read, create, update and search documents stored in Lark (Feishu) Drive directly from prompts.475kLark SheetsConnect Claude, Cursor or other agents directly to Feishu/Lark spreadsheets for live data reads, writes, and structured automation.474kLark WikiGenerate, update, and sync structured knowledge bases inside Lark (Feishu) directly from code, specs, or agent output.474kLark WhiteboardGenerate, edit, and collaborate on visual diagrams and flowcharts directly inside Claude, Cursor or other agents.474kLark SlidesInstantly generate polished, professional slide decks from specs, roadmaps, or meeting notes using Lark/Feishu.474kForks & variants (1)
Gws Sheets has 1 known copy in the catalog totaling 6 installs. They canonicalize to this original listing.
- jetbrains - 6 installs
How it compares
Choose gws-sheets when spreadsheet I/O should flow through the gws CLI rather than custom Google Sheets REST integrations.
FAQ
How does gws-sheets read spreadsheet data?
gws-sheets documents the +read helper and gws sheets resource methods to fetch values from Google Sheets API v4 ranges directly from the terminal.
How does gws-sheets write new rows?
gws-sheets provides the +append helper to add a row to a spreadsheet through the gws CLI after auth is configured in the gws-shared skill.
Is Gws Sheets safe to install?
skills.sh reports 2 of 3 security scanners passed. Review the Security Audits panel on this page before installing in production.