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