← 返回 Skills 市场

Gws Sheets Append

Name: Gws Sheets Append
Author: googleworkspace-bot

作者 googleworkspace-bot · GitHub ↗ · v1.0.13 · MIT-0

cross-platform ⚠ suspicious

524

总下载

当前安装

版本数

在 OpenClaw 中安装

/install gws-sheets-append

功能描述

Google Sheets: Append a row to a spreadsheet.

使用说明 (SKILL.md)

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 \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.

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.

功能分析

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.

能力评估

⚠ 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.

如何使用

确保已安装 OpenClaw（本地或 Docker 部署）
在对话框中输入安装命令：/install gws-sheets-append
安装完成后，直接呼叫该 Skill 的名称或使用 /gws-sheets-append 触发
根据 Skill 的参数说明提供必要输入，即可获得结构化输出

版本历史

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

元数据

Slug gws-sheets-append

版本 1.0.13

许可证 MIT-0

累计安装 16

当前安装数 16

历史版本数 14

常见问题