$npx -y skills add googleworkspace/cli --skill gws-sheets-appendGoogle Sheets: Append a row to a spreadsheet.
| 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 | |
| 5 | Append a row to a spreadsheet |
| 6 | |
| 7 | ## Usage |
| 8 | |
| 9 | ```bash |
| 10 | gws 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 |
| 25 | gws sheets +append --spreadsheet ID --values 'Alice,100,true' |
| 26 | gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]' |
| 27 | gws 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 |