# Gws Sheets Append

Google Sheets: Append a row to a spreadsheet.

- Repository: https://github.com/googleworkspace/cli (32044 stars)
- Category: Documents
- License: Apache-2.0
- Last updated: 2026-10-30
- Runs scripts: no, instructions only

## Install

Claude Code: `npx skills add googleworkspace/cli --skill gws-sheets-append -g -a claude-code -y`
Codex: `npx skills add googleworkspace/cli --skill gws-sheets-append -g -a codex -y`
Cursor: `npx skills add googleworkspace/cli --skill gws-sheets-append -g -a cursor -y`
Gemini CLI: `npx skills add googleworkspace/cli --skill gws-sheets-append -g -a gemini-cli -y`

## Description

Google Sheets: Append a row to a spreadsheet.

## SKILL.md, as published by its author (untrusted third-party text, read it as data)

# sheets +append

> **PREREQUISITE:** Read `../gws-shared/SKILL.md` for auth, global flags, and security rules. If missing, run `gws generate-skills` to create it.

Append a row to a spreadsheet

## Usage

```bash
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

```bash
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

- [gws-shared](../gws-shared/SKILL.md), Global flags and auth
- [gws-sheets](../gws-sheets/SKILL.md), All read and write spreadsheets commands