Gws Sheets Append
googleworkspace/cliThis skill allows users to append rows to a Google Spreadsheet via command-line interface, supporting both simple comma-separated values and bulk multi-row inserts using JSON arrays. It is useful for developers and automation workflows that need to programmatically update spreadsheets, offering features like confirmation prompts and multiple authentication methods. The skill is ideal for users familiar with CLI operations who require efficient, structured data management in Google Sheets.
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"]]'
Examples
gws sheets +append --spreadsheet ID --values 'Alice,100,true'
gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'
Tips
- Use --values for simple single-row appends.
- Use --json-values for bulk multi-row inserts.
[!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
GitHub Owner
Owner: googleworkspace
GitHub Links
- Website: https://developers.google.com/workspace
- Twitter: https://twitter.com/workspacedevs
Files
gws-shared
- View: https://github.com/googleworkspace/cli/blob/HEAD/skills/gws-sheets-append/../gws-shared/SKILL.md
gws-sheets
- View: https://github.com/googleworkspace/cli/blob/HEAD/skills/gws-sheets-append/../gws-sheets/SKILL.md
SKILL.md
name: gws-sheets-append version: 1.0.0 description: "Google Sheets: Append a row to a spreadsheet." metadata: openclaw: category: "productivity" requires: bins: ["gws"] cliHelp: "gws sheets +append --help"
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"]]' |
Examples
gws sheets +append --spreadsheet ID --values 'Alice,100,true'
gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'
Tips
- Use --values for simple single-row appends.
- Use --json-values for bulk multi-row inserts.
[!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