gws-sheets-append
作者: Google
在Google Sheets中:向电子表格追加一行。
npx skills add https://github.com/googleworkspace/cli --skill gws-sheets-appendsheets +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
来自 Google 的更多技能
gws-modelarmor-sanitize-response
Google
通过Model Armor模板对模型响应进行消毒处理。
gws-people
Google
管理联系人和个人资料。
gws-shared
Google
gws CLI:用于身份验证、全局标志和输出格式化的共享模式。
gws-sheets
Google
读取和写入电子表格。
gws-sheets-read
Google
从电子表格中读取值。
gws-slides
Google
Google Slides:读取和编写演示文稿。
gws-tasks
Google
Google Tasks:管理任务列表和任务。
gws-workflow
Google
跨服务生产力工作流。