gws-sheets-append▌
googleworkspace/cli · updated Apr 8, 2026
Append rows to a Google Sheet with simple or bulk input modes.
- ›Supports single-row appends via comma-separated values or multi-row bulk inserts using JSON array format
- ›Requires spreadsheet ID and optional values; defaults to appending to the first available row
- ›Write operation that should be confirmed with the user before execution
- ›Depends on gws binary and shared Google Workspace authentication from gws-shared
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
Discussion
Product Hunt–style comments (not star reviews)- No comments yet — start the thread.
Ratings
4.5★★★★★43 reviews- ★★★★★Aisha Garcia· Dec 20, 2024
Solid pick for teams standardizing on skills: gws-sheets-append is focused, and the summary matches what you get after install.
- ★★★★★Benjamin Lopez· Dec 8, 2024
gws-sheets-append has been reliable in day-to-day use. Documentation quality is above average for community skills.
- ★★★★★Zaid Reddy· Nov 27, 2024
Solid pick for teams standardizing on skills: gws-sheets-append is focused, and the summary matches what you get after install.
- ★★★★★Layla Iyer· Nov 11, 2024
gws-sheets-append has been reliable in day-to-day use. Documentation quality is above average for community skills.
- ★★★★★Dhruvi Jain· Oct 2, 2024
Registry listing for gws-sheets-append matched our evaluation — installs cleanly and behaves as described in the markdown.
- ★★★★★Noah Jain· Oct 2, 2024
Useful defaults in gws-sheets-append — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.
- ★★★★★Benjamin Jackson· Sep 25, 2024
Keeps context tight: gws-sheets-append is the kind of skill you can hand to a new teammate without a long onboarding doc.
- ★★★★★Rahul Santra· Sep 21, 2024
Useful defaults in gws-sheets-append — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.
- ★★★★★Oshnikdeep· Sep 9, 2024
gws-sheets-append reduced setup friction for our internal harness; good balance of opinion and flexibility.
- ★★★★★Zaid Choi· Sep 9, 2024
Registry listing for gws-sheets-append matched our evaluation — installs cleanly and behaves as described in the markdown.
showing 1-10 of 43