sheets +append
PREREQUISITE: Read ../gws-shared/SKILL.md for auth, global flags, and security rules. If missing, stop and repair the declarative skill deployment.
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
1---2name: gws-sheets-append3description: sheets +append4---5# sheets +append67> **PREREQUISITE:** Read `../gws-shared/SKILL.md` for auth, global flags, and security rules. If missing, stop and repair the declarative skill deployment.89Append a row to a spreadsheet1011## Usage1213```bash14gws sheets +append --spreadsheet <ID>15```1617## Flags1819| Flag | Required | Default | Description |20|------|----------|---------|-------------|21| `--spreadsheet` | ✓ | — | Spreadsheet ID |22| `--values` | — | — | Comma-separated values (simple strings) |23| `--json-values` | — | — | JSON array of rows, e.g. '[["a","b"],["c","d"]]' |24| `--range` | — | `A1` | Target range in A1 notation (e.g. 'Sheet2!A1') to select a specific tab |2526## Examples2728```bash29gws sheets +append --spreadsheet ID --values 'Alice,100,true'30gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'31gws sheets +append --spreadsheet ID --range "Sheet2!A1" --values 'Alice,100'32```3334## Tips3536- Use --values for simple single-row appends.37- Use --json-values for bulk multi-row inserts.38- Use --range to append to a specific sheet tab (default: A1, i.e. first sheet).3940> [!CAUTION]41> This is a **write** command — confirm with the user before executing.4243## See Also4445- [gws-shared](../gws-shared/SKILL.md) — Global flags and auth46- [gws-sheets](../gws-sheets/SKILL.md) — All read and write spreadsheets commands