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 — 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

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 Original Skill: gws-sheets-append