Gws Sheets Append

该 Skill 封装 gws CLI 的 sheets +append 命令，用于向指定的 Google Sheets 电子表格追加数据：以 --spreadsheet 指定表格 ID，用 --values 或 --json-values 传入行内容，用 --range 指定目标工作表范围（默认 A1）。它属于写操作，需先与用户确认再执行；认证与全局参数依赖同级的 gws-shared 技能。

googleworkspace-bot

热度 76.79

最近更新 2026-05-11 17:29:02

分类：数据依赖：代码执行 / 第三方 API应用场景：数据处理 / 工作流

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add gws-sheets-append

Metadata

name: gws-sheets-append
description: Google Sheets: Append a row to a spreadsheet.
metadata: {"version":"0.22.5","openclaw":{"category":"productivity","requires":{"bins":["gws"]},"cliHelp":"gws sheets +append --help"}}

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"]]'
`--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.