AutoGineer
Generated banner for Gws Sheets Append
Generated logo for Gws Sheets Append

Gws Sheets Append

Google WorkspaceOfficialPublished by Google Workspace

  • Skill
  • Tool integration
  • Automation and integrations
  • Apache-2.0
  • No issues found
Download ZIP

From the author

Google Sheets: Append a row to a spreadsheet.
— the description by Google Workspace

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

The gws-sheets-append skill provides a command-line interface for adding new data to Google Sheets. It supports both simple single-row appends via comma-separated values and bulk multi-row inserts using JSON arrays, allowing for flexible data entry into specific spreadsheet tabs.

What it does

  • Appends a single row of data to a specified Google Sheet.
  • Supports bulk insertion of multiple rows using JSON formatting.
  • Allows targeting specific spreadsheet tabs using A1 notation.
  • Integrates with the gws CLI for automated spreadsheet updates.

When to use it

  • When you need to automate adding log entries or data records to a Google Sheet.
  • When performing bulk data imports from a script or automated workflow.
  • When you need to append data to a specific tab within a spreadsheet.

Advantages

  • Simplifies spreadsheet data entry through command-line automation.
  • Supports both simple and complex data structures for insertion.
  • Provides granular control over the target sheet and range.

Usage examples

“Append the values Alice, 100, and true to the spreadsheet with ID 12345.”
The agent executes the command to add a new row containing these values to the default sheet.
“Add two rows of data to the Sheet2 tab of my spreadsheet.”
The agent uses the --json-values flag to append the specified rows to the designated tab.

Install

  1. Download the skill as a ZIP:

    https://mp-staging.autogineer.com/agent-skills/googleworkspace/gws-sheets-append/download

  2. Unzip it into the cross-client skills folder of your project:

    mkdir -p .agents/skills && unzip gws-sheets-append.zip -d .agents/skills

Documentation by Google Workspace

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

FlagRequiredDefaultDescription
--spreadsheet✓—Spreadsheet ID
--values——Comma-separated values (simple strings)
--json-values——JSON array of rows, e.g. '[["a","b"],["c","d"]]'
--range—A1Target 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

Files

Requirements and compatibility

Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Security

No issues found by our static scan· No issues found

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Attribution and licence

Published by
Google Workspace
Publisher
Google Workspace (Official)
Source
googleworkspace/cli · skills/gws-sheets-append · commit cd3697e
Licence
Apache License 2.0 (redistribution allowed)
  • LICENSE (added by AutoGineer from LICENSE)
  • ATTRIBUTION.md (written by AutoGineer)
Synced

AutoGineer is not affiliated with or endorsed by Google Workspace.

Download ZIP

The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download gws-sheets-append.zip