/gws-sheets-append

allowed-tools: Bash, Read, Write, Edit
argument-hint: [resource] [method] [flags]
description: Google Sheets: Append a row to a spreadsheet.

Google Workspace Sheets Append

Execute Google Workspace Sheets Append operations: $ARGUMENTS

Prerequisites

• Google Workspace CLI (`gws`) must be installed
• Authentication configured: Run `gws auth status` to verify
• Review `gws sheets-append --help` for all available commands

Available Resources and Methods

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"]]' |

Examples

gws sheets +append --spreadsheet ID --values 'Alice,100,true'
gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'

Tips

• Use --values for simple single-row appends.
• Use --json-values for bulk multi-row inserts.

> [!CAUTION] > This is a **write** command — confirm with the user before executing.

See Also

• [gws-shared](../gws-shared/SKILL.md) — Global flags and auth
• [gws-sheets](../gws-sheets/SKILL.md) — All read and write spreadsheets commands

Usage

# List available resources and methods
gws sheets-append --help

# Inspect method schema before calling
gws schema sheets-append.<resource>.<method>

# Execute command with arguments
gws sheets-append $ARGUMENTS

Task

Execute the requested Sheets Append operation: $ARGUMENTS

1. **Verify Prerequisites**

• Check `gws` is installed: `gws --version`
• Verify authentication: `gws auth status`
• Review available commands: `gws sheets-append --help`

2. **Inspect Method Schema**

• Before calling any method, inspect its parameters
• Use `gws schema` to understand required fields
• Review parameter types and constraints

3. **Execute Operation**

• Build command with appropriate flags
• Use `--params` for query/path parameters
• Use `--json` for request body
• Handle pagination with `--max-results` or `--page-token`

4. **Error Handling**

• Check command output for errors
• Review API quotas and rate limits
• Handle authentication issues
• Retry transient failures

---

**License**: Apache License 2.0 **Source**: [Google Workspace CLI](https://github.com/googleworkspace/cli) **Original Skill**: `gws-sheets-append`