# Gws Sheets Append

> Google Sheets: Append a row to a spreadsheet.

Source: https://skillsagentes.com/skills/googleworkspace/cli/gws-sheets-append
Repository: https://github.com/googleworkspace/cli
Author: googleworkspace
License: Apache-2.0
Updated: hace 4 meses
Context cost: 11 tok installed, 394 tok once triggered, 394 tok with every bundled file
Bundle: 1 file, 2 KB
Permissions requested: none declared

## Install

```bash
npx -y skills add googleworkspace/cli --skill gws-sheets-append --agent claude-code
```

## What it does

- Añade una fila (o varias) a una hoja de cálculo de Google Sheets usando `gws sheets +append`
- Permite indicar valores simples con --values o filas en JSON con --json-values
- Permite seleccionar una pestaña concreta con --range en notación A1

## Use it when

- Necesitas insertar datos nuevos al final de una hoja de Google Sheets
- Quieres hacer inserciones masivas de varias filas usando JSON
- Necesitas añadir datos a una pestaña específica de una hoja de cálculo

## What triggers it

- "Añade una fila con 'Alice,100,true' a la hoja de cálculo ID"
- "Inserta estas filas en formato JSON en la pestaña Sheet2 de mi spreadsheet"
- "Agrega estos datos al final de mi Google Sheet"

## Before you install

- Requiere el binario `gws` y haber leído ../gws-shared/SKILL.md para autenticación, flags globales y reglas de seguridad; es un comando de escritura que debe confirmarse antes de ejecutar.

## Files

- SKILL.md — 2 KB

## SKILL.md

Reproduced verbatim from googleworkspace/cli under Apache-2.0. This section is the upstream document and is in English.

# 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

---

Skills Agentes — https://skillsagentes.com/skills/googleworkspace/cli/gws-sheets-append