gws-sheets-append
googleworkspace/cli
Append rows to Google Sheets spreadsheets via CLI.
What is gws-sheets-append?
Appends one or more rows to a Google Sheets spreadsheet using the gws CLI. Use this when you need to add data to an existing sheet programmatically, whether single rows or bulk inserts.
- Append single rows with comma-separated values
- Bulk insert multiple rows using JSON array format
- Target specific sheet tabs using A1 notation ranges
- Support for various data types (strings, numbers, booleans)
How to install gws-sheets-append
npx skills add null --skill gws-sheets-append- gws CLI installed and configured
- Google Workspace account with Sheets access
- Spreadsheet ID of the target sheet
- Authentication configured (see gws-shared)
How to use gws-sheets-append
- 1.Obtain the Spreadsheet ID from the sheet's URL
- 2.Run `gws sheets +append --spreadsheet <ID> --values '<data>'` for single rows or `--json-values '[...]'` for multiple rows
- 3.Optionally specify `--range` to target a specific sheet tab (e.g., 'Sheet2!A1')
- 4.Confirm the append operation before execution
Use cases
- Add new records to a data collection sheet
- Log results or metrics to a tracking spreadsheet
- Bulk import data from external sources into Sheets
- Append timestamped entries to a log or journal sheet
- Data analysts automating spreadsheet updates
- Developers building integrations with Google Sheets
- Teams logging or tracking data programmatically
gws-sheets-append FAQ
Use the `--range` flag with the sheet name and cell reference, e.g., `--range "Sheet2!A1"`. Default is A1 (first sheet).
Use `--values` for simple single-row appends with comma-separated data. Use `--json-values` for bulk multi-row inserts with a JSON array format like '[[\
Yes. Read the gws-shared SKILL.md for auth configuration. Run `gws generate-skills` if the shared skill is missing.
Yes. The command supports strings, numbers, and booleans in both --values and --json-values formats.
This is a write command. Always confirm with the user before executing to prevent accidental data modifications.
Full instructions (SKILL.md)
Source of truth, from googleworkspace/cli.
name: gws-sheets-append description: "Google Sheets: Append a row to a spreadsheet." metadata: version: 0.22.5 openclaw: category: "productivity" requires: bins: - gws cliHelp: "gws sheets +append --help"
sheets +append
PREREQUISITE: Read
../gws-shared/SKILL.mdfor auth, global flags, and security rules. If missing, rungws generate-skillsto 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
- gws-shared — Global flags and auth
- gws-sheets — All read and write spreadsheets commands
Related skills
More from googleworkspace/cli and the wider catalog.
gws-gmail
Send, read, and manage Gmail emails via Google Workspace CLI.
gws-drive
Manage Google Drive files, folders, and shared drives via CLI.
gws-docs
Read and write Google Docs via command line.
gws-calendar
Manage Google Calendar events, calendars, and access control via CLI.
gws-sheets
Read and write Google Sheets spreadsheets via CLI.
gws-gmail-send
Send emails via Gmail with attachments, CC/BCC, HTML support, and draft options.