Agent Skills
› googleworkspace/cli
› gws-sheets-append
gws-sheets-append
GitHub用于向Google电子表格追加数据行的工具，支持单行逗号分隔值或多行JSON格式插入，可指定目标工作表范围。
触发场景
用户要求向电子表格添加新记录
批量导入数据到指定表格
安装
npx skills add googleworkspace/cli --skill gws-sheets-append -g -y
SKILL.md
Frontmatter
{
"name": "gws-sheets-append",
"metadata": {
"version": "0.22.5",
"openclaw": {
"cliHelp": "gws sheets +append --help",
"category": "productivity",
"requires": {
"bins": [
"gws"
]
}
}
},
"description": "Google Sheets: Append a row to a spreadsheet."
}
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 <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.
See Also
- gws-shared — Global flags and auth
- gws-sheets — All read and write spreadsheets commands
版本历史
- a3768d0 当前 2026-08-20 07:25
