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
gws sheets +append --spreadsheet <ID>
| 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 |
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'
[!CAUTION] This is a write command — confirm with the user before executing.