gws-sheets-append
SolidGoogle Sheets: Append a row to a spreadsheet.
AI & Automation 32,385 stars
1999 forks Updated 2 weeks ago Apache-2.0
Install
Quality Score: 90/100
Stars 20%
Recency 20%
Frontmatter 20%
Documentation 15%
Issue Health 10%
License 10%
Description 5%
Skill Content
# 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
Details
- Author
- googleworkspace
- Repository
- googleworkspace/cli
- Created
- 8 months ago
- Last Updated
- 2 weeks ago
- Language
- Rust
- License
- Apache-2.0
Integrates with
Similar Skills
Semantically similar based on skill content — not just same category
Data & Documents Listed
gws-sheets-append
Google Sheets: Append a row to a spreadsheet.
487 Updated today
aiskillstore Code & Development Listed
gws-sheets-append
This skill should be used when the user says "add a row to a sheet", "append data to a spreadsheet", "log data to Sheets", "insert a new row", "write values to the bottom of a sheet", or wants to append one or more rows to a Google Sheets spreadsheet. Covers single-row and multi-row bulk inserts.
5 Updated 3 months ago
RadOrigin-LLC AI & Automation Listed
gws-sheets-append
Google Sheets: Append a row to a spreadsheet.
11 Updated today
raffaelefarinaro