@googleworkspace/gws-sheets-append

Google Workspace CLI — one command-line tool for Drive, Gmail, Calendar, Sheets, Docs, Chat, Admin, and more. Dynamically built from Google Discovery Service. Includes AI agent skills.

View in AI SkillSafe app
151560 downloads
0 stars
0 demos
SKILL.md
namegws-sheets-append
descriptionGoogle Sheets: Append a row to a spreadsheet.
metadatagws

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'

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

Embed badges

Add these to your README to show the skill's verification status.

SkillSafe verified badge
Verified badge
[![SkillSafe verified badge](https://api.skillsafe.ai/v1/badge/@googleworkspace/gws-sheets-append/verified)](https://skillsafe.ai/skill/@googleworkspace/gws-sheets-append/)
Installs badge
Installs badge
[![Installs badge](https://api.skillsafe.ai/v1/badge/@googleworkspace/gws-sheets-append/installs)](https://skillsafe.ai/skill/@googleworkspace/gws-sheets-append/)
Scan badge
Scan badge
[![Scan badge](https://api.skillsafe.ai/v1/badge/@googleworkspace/gws-sheets-append/scan)](https://skillsafe.ai/skill/@googleworkspace/gws-sheets-append/)
Eval pass rate badge
Eval pass rate
[![Eval pass rate badge](https://api.skillsafe.ai/v1/badge/@googleworkspace/gws-sheets-append/eval)](https://skillsafe.ai/skill/@googleworkspace/gws-sheets-append/)