
Gws Sheets Append
Append rows to Google Sheets from your agent via the gws CLI so leads, metrics, or ops logs land in a spreadsheet without manual copy-paste.
Install
npx skills add https://github.com/googleworkspace/cli --skill gws-sheets-appendWhat is this skill?
- Appends one row with --values or bulk inserts with --json-values through gws sheets +append.
- Targets a spreadsheet ID with optional --range (e.g. Sheet2!A1) to hit the right tab.
- Documents CLI examples for simple strings and multi-row JSON arrays.
- Flags as a write command: agent should confirm with you before executing.
- Depends on gws-shared for auth, global flags, and security rules (metadata v0.22.5).
Adoption & trust: 24.5k installs on skills.sh; 26.9k GitHub stars; 3/3 security scanners passed (skills.sh audits).
Recommended Skills
Journey fit
Grow/analytics is the canonical shelf because append is how solo builders log outcomes, funnel events, and lightweight dashboards after the product exists. Analytics fits repeated row inserts into tracking spreadsheets—single-row --values or bulk --json-values for experiment and revenue logs.
Common Questions / FAQ
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.
SKILL.md
READMESKILL.md - Gws Sheets Append
# sheets +append > **PREREQUISITE:** Read `../gws-shared/SKILL.md` for auth, global flags, and security rules. If missing, run `gws generate-skills` to create it. Append a row to a spreadsheet ## Usage ```bash 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 ```bash 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](../gws-shared/SKILL.md) — Global flags and auth - [gws-sheets](../gws-sheets/SKILL.md) — All read and write spreadsheets commands