gws-sheets-append

1# sheets +append
2 
3> **PREREQUISITE:** Read `../gws-shared/SKILL.md` for auth, global flags, and security rules. If missing, run `gws generate-skills` to create it.
4 
5Append a row to a spreadsheet
6 
7## Usage
8 
9```bash
10gws sheets +append --spreadsheet <ID>
11```
12 
13## Flags
14 
15| Flag | Required | Default | Description |
16|------|----------|---------|-------------|
17| `--spreadsheet` | ✓ | — | Spreadsheet ID |
18| `--values` | — | — | Comma-separated values (simple strings) |
19| `--json-values` | — | — | JSON array of rows, e.g. '[["a","b"],["c","d"]]' |
20| `--range` | — | `A1` | Target range in A1 notation (e.g. 'Sheet2!A1') to select a specific tab |
21 
22## Examples
23 
24```bash
25gws sheets +append --spreadsheet ID --values 'Alice,100,true'
26gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'
27gws sheets +append --spreadsheet ID --range "Sheet2!A1" --values 'Alice,100'
28```
29 
30## Tips
31 
32- Use --values for simple single-row appends.
33- Use --json-values for bulk multi-row inserts.
34- Use --range to append to a specific sheet tab (default: A1, i.e. first sheet).
35 
36> [!CAUTION]
37> This is a **write** command — confirm with the user before executing.
38 
39## See Also
40 
41- [gws-shared](../gws-shared/SKILL.md) — Global flags and auth
42- [gws-sheets](../gws-sheets/SKILL.md) — All read and write spreadsheets commands