Google Sheets: Append a row to a spreadsheet.
a3768d0PREREQUISITE: Read
../gws-shared/SKILL.mdfor auth, global flags, and security rules. If missing, rungws generate-skillsto create it.
Append a row to a spreadsheet
gws sheets +append --spreadsheet <ID>
| 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 |
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'
[!CAUTION] This is a write command — confirm with the user before executing.
Copy a source-pinned command for your client. You run it yourself.
Destination: .claude/skills/gws-sheets-append · pinned to the source commit
# Run from your project root
git clone https://github.com/googleworkspace/cli.git .skillboard-tmp
git -C .skillboard-tmp checkout a3768d0e82ad83cca2da97724e46bea4ff0e6dbd
mkdir -p ".claude/skills"
cp -r ".skillboard-tmp/skills/gws-sheets-append" ".claude/skills/"
rm -rf .skillboard-tmpReview the source before running. This copies files into your project; it is not a one-click install and does not verify runtime safety.
sudo apt update && sudo apt install -y gitnpm install -g @anthropic-ai/claude-code# Run from your project root
git clone https://github.com/googleworkspace/cli.git .skillboard-tmp
git -C .skillboard-tmp checkout a3768d0e82ad83cca2da97724e46bea4ff0e6dbd
mkdir -p ".claude/skills"
cp -r ".skillboard-tmp/skills/gws-sheets-append" ".claude/skills/"
rm -rf .skillboard-tmpDestination: .claude/skills/gws-sheets-append
Scanner static-checks@0.1.0 · commit a3768d0e82ad. Static checks cannot prove runtime safety – review the source and the exact diff before installing. How checks work.
References parent-directory traversal, which can escape a target directory.
Evidence: ../· fingerprint fa08499e14d0113b