---
id: ssh-gws-sheets-append
name: "gws-sheets-append"
url: https://skills.yangsir.net/skill/ssh-gws-sheets-append
author: googleworkspace
domain: ai-productivity-automation
tags: ["google-sheets-api", "cli-automation", "data-entry", "spreadsheet-integration", "google-workspace"]
install_count: 23000
rating: 4.60 (300 reviews)
github: https://github.com/googleworkspace/cli
---

# gws-sheets-append

> 用于向Google Sheets电子表格的末尾追加一行数据，实现数据的批量录入。

**Stats**: 23,000 installs · 4.6/5 (300 reviews)

## Before / After 对比

### 中文

## Readme

# 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"]]' |

## Examples

```bash
gws sheets +append --spreadsheet ID --values 'Alice,100,true'
gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'
```

## Tips

- Use --values for simple single-row appends.
- Use --json-values for bulk multi-row inserts.

> [!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


---
*Source: https://skills.yangsir.net/skill/ssh-gws-sheets-append*
*Markdown mirror: https://skills.yangsir.net/api/skill/ssh-gws-sheets-append/markdown*