Labsco
googleworkspace logo

gws-sheets-append

✓ Official29,400

by Google · part of googleworkspace/cli

Google Sheets: Append a row to a spreadsheet.

🔥🔥✓ VerifiedFreeQuick setup
🧰 Not standalone. This skill ships with googleworkspace/cli and only works together with that tool — install the tool first, then add this skill.

Google Sheets: Append a row to a spreadsheet.

Inspect the full instructions your agent will receiveExpand

This is the exact playbook injected into your agent when the skill activates — shown here so you can audit it before installing. You don't need to read it to use the skill.

by Google

Google Sheets: Append a row to a spreadsheet. npx skills add https://github.com/googleworkspace/cli --skill gws-sheets-append Download ZIPGitHub29.4k

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

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"]]' --rangeA1 Target range in A1 notation (e.g. 'Sheet2!A1') to select a specific tab

Examples

Copy & paste — that's it
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