OpenSkillIndex← back to search
claude-codeproductivity

Cli gws-sheets-append

Google Sheets: Append a row to a spreadsheet.

install
source · Clone the upstream repo
git clone https://github.com/googleworkspace/cli
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/googleworkspace/cli "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/gws-sheets-append" ~/.claude/skills/googleworkspace-cli-gws-sheets-append && rm -rf "$T"
manifest: skills/gws-sheets-append/SKILL.md
tags
#google-sheets#data-append#spreadsheet#automation#gws-cli
source 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

gws sheets +append --spreadsheet <ID>

Flags

FlagRequiredDefaultDescription
--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'

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