Gws Sheets Append
Google Sheets: Append a row to a spreadsheet.
$ npx claude-code-templates@latest --command="google-workspace/gws-sheets-append" --yesRequires Claude Code. The command adds this command to your project's .claudedirectory — nothing runs on ToolZip's servers.
What's inside this command
Component source
Google Workspace Sheets Append
Execute Google Workspace Sheets Append operations: $ARGUMENTS
Prerequisites
- Google Workspace CLI (
gws) must be installed - Authentication configured: Run
gws auth statusto verify - Review
gws sheets-append --helpfor all available commands
Available Resources and Methods
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"]]' |
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 — Global flags and auth
- gws-sheets — 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
- Verify Prerequisites
gws is installed: gws --version
- Verify authentication: gws auth status
- Review available commands: gws sheets-append --help
- Inspect Method Schema
- Use gws schema to understand required fields
- Review parameter types and constraints
- Execute Operation
- Use --params for query/path parameters
- Use --json for request body
- Handle pagination with --max-results or --page-token
- Error Handling
- Review API quotas and rate limits
- Handle authentication issues
- Retry transient failures
License: Apache License 2.0 Source: Google Workspace CLI Original Skill:
gws-sheets-appendRelated Claude Code Commands
Gws Events Renew
Google Workspace Events: Renew/reactivate Workspace Events subscriptions.
Gws Sheets Read
Google Sheets: Read values from a spreadsheet.
Gws Calendar Insert
Google Calendar: Create a new event.
Gws Gmail Watch
Gmail: Watch for new emails and stream them as NDJSON.
Gws Alertcenter
Google Workspace Alert Center: Manage Workspace security alerts.
Gws Apps Script
Google Apps Script: Manage and execute Apps Script projects.
Catalog data and component content are sourced from the open-source davila7/claude-code-templates project (MIT license). ToolZip curates the listing and writes original descriptions; every component links back to its original source. Claude Code is a product of Anthropic. ToolZip is an independent catalog and is not affiliated with or endorsed by Anthropic.