← Back to Skills Marketplace
Gws Sheets Append
by
googleworkspace-bot
· GitHub ↗
· v1.0.13
· MIT-0
524
Downloads
0
Stars
16
Active Installs
14
Versions
Install in OpenClaw
/install gws-sheets-append
Description
Google Sheets: Append a row to a spreadsheet.
README (SKILL.md)
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 \x3CID>
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
Usage Guidance
Before installing, inspect the referenced ../gws-shared/SKILL.md to see exactly what authentication method and environment variables or files the gws CLI expects (service account JSON, GOOGLE_APPLICATION_CREDENTIALS, OAuth tokens, etc.). Verify the provenance of the 'gws' binary (where it comes from and what access it requires). Because this is a write operation, test on a non-sensitive spreadsheet and confirm the user before any append. If you are concerned about undisclosed credential access, do not install until the shared SKILL.md and any generated files are reviewed; consider restricting the agent's ability to access system files or disabling autonomous invocation for this skill until you verify its requirements.
Capability Analysis
Type: OpenClaw Skill
Name: gws-sheets-append
Version: 1.0.13
The skill bundle for 'gws-sheets-append' is a standard documentation file (SKILL.md) that instructs an AI agent on how to use the 'gws' CLI tool to append data to Google Sheets. It includes clear usage instructions, parameter definitions, and a safety caution requiring user confirmation for write operations, with no evidence of malicious intent or suspicious behavior.
Capability Assessment
Purpose & Capability
The skill calls a gws CLI to append rows, which matches the name/description. However, the SKILL.md explicitly points to ../gws-shared/SKILL.md for authentication, global flags, and security rules, yet the registry metadata declares no required environment variables or primary credential. That omission is inconsistent: a Google Sheets write operation normally requires Google credentials (API key, OAuth token, or service account), so required credentials are likely present but undeclared.
Instruction Scope
The instructions are limited to invoking 'gws sheets +append' which is in-scope, but they also instruct the agent to read ../gws-shared/SKILL.md (outside this skill's directory) for auth and rules, and to run 'gws generate-skills' if missing. That directs the agent to read other skill files and potentially write files, which expands scope beyond a self-contained append command. The SKILL.md does not list exactly which auth artifacts or env vars the agent will read or need at runtime.
Install Mechanism
This is an instruction-only skill with no install spec and no code files, so nothing will be written to disk by the skill itself. Low install risk.
Credentials
The registry metadata lists no required environment variables or primary credential, but the runtime instructions explicitly defer auth to a separate gws-shared SKILL.md. This likely means required credentials (Google OAuth tokens, service account JSON path, or CLI-stored tokens) are managed outside this skill. The absence of declared env vars is disproportionate to the likely need for Google Sheets credentials and hides which secrets the agent will access.
Persistence & Privilege
always is false and there is no explicit request for permanent presence or cross-skill configuration changes. The instruction to run 'gws generate-skills' could create files, but that is an expected operational helper rather than a privilege escalation. Still, the skill's dependence on sibling skill files slightly increases its effective reach.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install gws-sheets-append - After installation, invoke the skill by name or use
/gws-sheets-append - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.13
- Added a new --range flag to let users specify a target range or sheet/tab for row appends.
- Updated examples and tips to demonstrate and explain usage of the new --range flag.
- All other functionality and usage remain unchanged.
v1.0.12
- Updated skill metadata version from 0.22.4 to 0.22.5 in SKILL.md.
- No changes to usage, flags, functionality, or documentation content.
v1.0.11
- Updated metadata version from 0.22.3 to 0.22.4 in SKILL.md.
- No functional or usage changes.
v1.0.10
- Updated metadata version from 0.22.2 to 0.22.3 in SKILL.md.
- No other content changes.
v1.0.9
- Updated version in metadata from 0.22.1 to 0.22.2 in SKILL.md.
v1.0.8
- Updated skill version metadata from 0.22.0 to 0.22.1 in SKILL.md.
v1.0.7
- Updated version in SKILL.md to 0.22.0.
- No changes to functionality or usage; documentation version only.
v1.0.6
- Updated skill version in documentation from 0.21.1 to 0.21.2.
- No changes to functionality; documentation update only.
v1.0.5
- Updated version metadata from 0.20.1 to 0.21.1 in SKILL.md.
- No other functional or documentation changes.
v1.0.4
- Updated the metadata version from 0.20.0 to 0.20.1 in SKILL.md.
- No other changes were made.
v1.0.3
- Bumped metadata version from 0.19.0 to 0.20.0 in SKILL.md.
- No usage, interface, or flag changes. Documentation remains otherwise the same.
v1.0.2
- Updated metadata to use separate version field (now version 0.19.0) within the metadata block.
- Removed redundant top-level version field from the skill definition.
v1.0.1
- Minor formatting adjustments in SKILL.md for metadata consistency
- No user-facing functionality changes
v1.0.0
Initial release of gws-sheets-append.
- Adds command to append rows to a Google Spreadsheet using `gws sheets +append`
- Supports appending with simple comma-separated values or JSON arrays for bulk inserts
- Includes detailed usage, flag documentation, examples, and safety tips
- Requires the gws binary and authentication as set in gws-shared
Metadata
Frequently Asked Questions
What is Gws Sheets Append?
Google Sheets: Append a row to a spreadsheet. It is an AI Agent Skill for Claude Code / OpenClaw, with 524 downloads so far.
How do I install Gws Sheets Append?
Run "/install gws-sheets-append" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Gws Sheets Append free?
Yes, Gws Sheets Append is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Gws Sheets Append support?
Gws Sheets Append is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Gws Sheets Append?
It is built and maintained by googleworkspace-bot (@googleworkspace-bot); the current version is v1.0.13.
More Skills