Gws Sheets Append
- 36.5k installs
- 30k repo stars
- Updated July 22, 2026
- googleworkspace/cli
gws sheets append is a Google Workspace CLI skill for appending rows to spreadsheets using the --values or --json-values flags.
About
gws sheets append is a Google Workspace CLI skill for programmatically adding rows to spreadsheets. Use it when integrating Google Sheets into workflows, automating data writes, or when developers need to append data to a spreadsheet via command line. It supports single-row and bulk multi-row inserts.
- Append rows to Google Sheets via CLI with --values or --json-values flags
- Target specific sheet tabs using A1 notation ranges
- Support bulk multi-row inserts with JSON array syntax
Gws Sheets Append by the numbers
- 36,535 all-time installs (skills.sh)
- +1,205 installs in the week ending Jul 28, 2026 (Skillselion tracking)
- Ranked #24 of 690 Office & Documents skills by installs in the Skillselion catalog
- Security screen: LOW risk (skills.sh audit)
- Data as of Jul 28, 2026 (Skillselion catalog sync)
gws-sheets-append capabilities & compatibility
- Capabilities
- data write · automation · spreadsheet integration
- Works with
- google drive
What gws-sheets-append says it does
Append a row to a spreadsheet
npx skills add https://github.com/googleworkspace/cli --skill gws-sheets-appendAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 36.5k |
|---|---|
| repo stars | ★ 30k |
| Security audit | 3 / 3 scanners passed |
| Last updated | July 22, 2026 |
| Repository | googleworkspace/cli ↗ |
How do you append rows to Google Sheets from CLI?
Automate spreadsheet data entry and bulk row appends via the gws CLI.
Who is it for?
Developers building workflows that write to Google Sheets, automating data entry, and integrating Sheets with scripts or apps.
Skip if: Bulk sheet imports, complex multi-range updates, or spreadsheet access without the authenticated `gws` CLI.
When should I use this skill?
Adding rows to a spreadsheet, bulk data imports, or automating spreadsheet updates.
What you get
Appended spreadsheet rows, updated sheet ranges, and Sheets API write confirmations in CLI output.
- appended sheet rows
- sheets api append responses
By the numbers
- Skill metadata version 0.22.5
- Required flag: --spreadsheet
Files
sheets +append
PREREQUISITE: Read../gws-shared/SKILL.mdfor auth, global flags, and security rules. If missing, rungws generate-skillsto create it.
Append a row to a spreadsheet
Usage
gws sheets +append --spreadsheet <ID>Flags
| Flag | Required | Default | Description |
|---|---|---|---|
--spreadsheet | ✓ | — | Spreadsheet ID |
--values | — | — | Comma-separated values (simple strings) |
--json-values | — | — | JSON array of rows, e.g. '[["a","b"],["c","d"]]' |
--range | — | A1 | Target range in A1 notation (e.g. 'Sheet2!A1') to select a specific tab |
Examples
gws sheets +append --spreadsheet ID --values 'Alice,100,true'
gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'
gws sheets +append --spreadsheet ID --range "Sheet2!A1" --values 'Alice,100'Tips
- Use --values for simple single-row appends.
- Use --json-values for bulk multi-row inserts.
- Use --range to append to a specific sheet tab (default: A1, i.e. first sheet).
[!CAUTION]
This is a write command — confirm with the user before executing.
See Also
- gws-shared — Global flags and auth
- gws-sheets — All read and write spreadsheets commands
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.474kHow it compares
Choose gws-sheets-append over custom Sheets writers when you already use `gws` and only need a single-row append from shell or agent jobs.
FAQ
How do I append a single row?
Use the --values flag: gws sheets +append --spreadsheet ID --values 'Alice,100,true'
How do I insert multiple rows at once?
Use the --json-values flag with a JSON array: --json-values '["a","b"],["c","d"]'
Is Gws Sheets Append safe to install?
skills.sh reports 3 of 3 security scanners passed. Review the Security Audits panel on this page before installing in production.