360 Secure SkillHub
360 安全技能中心

Gws Sheets Append

这是gws工具的Google Sheets子命令，核心功能是向指定表格追加数据。支持通过--values追加单行简单字符串，用--json-values批量插入多行，还能通过--range指定目标工作表。典型场景包括日常快速录入、批量导入数据。输入为命令行参数（需提供表格ID），执行前需确认写入操作，成功后数据将追加到对应表格位置。

googleworkspace-bot
googleworkspace-bot
热度 76.67
最近更新 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.

See Also