gws-sheets-append
🤖 AI Summary
This CLI tool appends rows to a Google Sheets spreadsheet by ID, accepting either comma-separated values or a JSON array of rows, with optional range targeting for specific tabs.
How to Install
Claude Code:
git clone --depth 1 https://github.com/googleworkspace/cli.git && cp cli/skills/gws-sheets-append ~/.claude/skills/gws-sheets-append -r# 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
```
## 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
| Category | Security → vulnerability |
| Source | googleworkspace/cli |
| SKILL.md | View on GitHub → |
| Repo Stars | ★ 27.3K |
| Est. per Skill | 546 (shared across 50 skills from this repo) |
| Difficulty | Intermediate |
| Risk Level | N/A |
Related Skills
seo
SEO: Universal SEO Analysis Skill Comprehensive SEO analysis across all industries (SaaS, local serv
varlock
Varlock Security Skill Secure-by-default environment variable management for Claude Code sessions. R
codebase-cleanup-deps-audit
Dependency Audit and Security Analysis You are a dependency security expert specializing in vulnerab
scanning-tools
Security Scanning Tools Purpose Master essential security scanning tools for network discovery, vuln
Works Well With
Skills from the same repository — often designed to work together
gws-admin-reports
admin-reports (reportsv1) > PREREQUISITE: Read ../gws-shared/SKILL.md for auth, global flags, and se
gws-calendar-agenda
calendar +agenda > PREREQUISITE: Read ../gws-shared/SKILL.md for auth, global flags, and security ru
gws-calendar-insert
calendar +insert > PREREQUISITE: Read ../gws-shared/SKILL.md for auth, global flags, and security ru