Gws Sheets Append

A straightforward wrapper around Google Sheets' append API that handles both single rows and bulk inserts. You pass comma-separated values for quick additions or JSON arrays when you need to dump multiple rows at once. The range flag lets you target specific sheet tabs, which is handy when working with multi-tab spreadsheets. It's a write command so Claude will confirm before executing, which prevents accidental data insertion. The tool assumes you've already set up authentication through the gws shared components. Most useful for logging data, building simple dashboards, or automating report generation where you need to continuously add structured data to existing sheets.

skills.sh installs: 48K
GitHub stars: 32.2K
last updated: Aug 21, 2026

View on GitHub

Install

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

Installs into .claude/skills of the current project.

Files

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

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

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'