gws-sheets
bygoogleworkspace· 58 skills
Google Sheets: Read and write spreadsheets.
How to install gws-sheets?
googleworkspace/cli/gws-sheets
$npx -y skills add googleworkspace/cli --skill gws-sheetsInstalls into the current project.
›Prefer a prompt? Paste this to your agent
Run `npx skills use "https://github.com/googleworkspace/cli" --skill "googleworkspace/cli/gws-sheets"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/googleworkspace/cli" that are relevant to the current task. Run `npx skills add "https://github.com/googleworkspace/cli"` and select the relevant skills, then follow their instructions.
SKILL.md
| 1 | # sheets (v4) |
| 2 | |
| 3 | > **PREREQUISITE:** Read `../gws-shared/SKILL.md` for auth, global flags, and security rules. If missing, run `gws generate-skills` to create it. |
| 4 | |
| 5 | ```bash |
| 6 | gws sheets <resource> <method> [flags] |
| 7 | ``` |
| 8 | |
| 9 | ## Helper Commands |
| 10 | |
| 11 | | Command | Description | |
| 12 | |---------|-------------| |
| 13 | | [`+append`](../gws-sheets-append/SKILL.md) | Append a row to a spreadsheet | |
| 14 | | [`+read`](../gws-sheets-read/SKILL.md) | Read values from a spreadsheet | |
| 15 | |
| 16 | ## API Resources |
| 17 | |
| 18 | ### spreadsheets |
| 19 | |
| 20 | - `batchUpdate` — Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid then the entire request will fail and nothing will be applied. Some requests have replies to give you some information about how they are applied. The replies will mirror the requests. For example, if you applied 4 updates and the 3rd one had a reply, then the response will have 2 empty replies, the actual reply, and another empty reply, in that order. |
| 21 | - `create` — Creates a spreadsheet, returning the newly created spreadsheet. |
| 22 | - `get` — Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: * Specify a [field mask](https://developers.google.com/workspace/sheets/api/guides/field-masks) listing your desired fields using the `fields` URL parameter in HTTP * Set the includeGridData URL parameter to true. |
| 23 | - `getByDataFilter` — Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. For more information, see [Read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). This method differs from GetSpreadsheet in that it allows selecting which subsets of spreadsheet data to return by specifying a dataFilters parameter. Multiple DataFilters can be specified. |
| 24 | - `developerMetadata` — Operations on the 'developerMetadata' resource |
| 25 | - `sheets` — Operations on the 'sheets' resource |
| 26 | - `values` — Operations on the 'values' resource |
| 27 | |
| 28 | ## Discovering Commands |
| 29 | |
| 30 | Before calling any API method, inspect it: |
| 31 | |
| 32 | ```bash |
| 33 | # Browse resources and methods |
| 34 | gws sheets --help |
| 35 | |
| 36 | # Inspect a method's required params, types, and defaults |
| 37 | gws schema sheets.<resource>.<method> |
| 38 | ``` |
| 39 | |
| 40 | Use `gws schema` output to build your `--params` and `--json` flags. |
Related
6 picksType
- lark-base飞书多维表格（Base）操作：建表、字段、记录、视图、统计、公式/lookup、表单、仪表盘、workflow、角色权限；遇到 Base/多维表格/bitable 或 /base/ 链接时使用。文件导入转 lark-drive，认证/授权转 lark-shared。Jul 2026
- lark-drive飞书云空间（云盘/云存储）：管理 Drive 文件和文件夹，包含上传/下载、创建文件夹、复制/移动/删除、查看元数据、评论/权限/订阅、标题、版本、飞书文档密级标签（secure labels）和本地文件导入。用户需要整理云盘目录、处理云空间资源 URL/token、判断链接类型/真实 token/标题，或导入…Jul 2026
- lark-sheets飞书电子表格：创建和操作电子表格。支持创建表格、管理工作表与行列结构（增删/合并/调整尺寸/隐藏/冻结）、读写单元格（值/公式/样式/批注/单元格图片）、查找替换、多操作原子批量更新，以及图表、透视表、条件格式、筛选器、迷你图、浮动图片等对象的创建与维护。当用户需要创建电子表格、管理工作表、批量读写或编辑数据、统计汇…Jul 2026
- lark-mail飞书邮箱：Use when user mentions 起草邮件、写邮件、草稿、发送/回复/转发邮件、查阅邮件、看邮件、搜索邮件、邮件文件夹、邮件标签、邮件联系人、监听新邮件、邮件收信规则等；use for mail/email intent only.Jul 2026
- lark-slides飞书幻灯片：创建和编辑幻灯片。创建演示文稿、读取幻灯片内容、管理幻灯片页面（创建、删除、读取、局部替换）。当用户需要创建或编辑幻灯片、读取或修改单个页面时使用。当用户给出 doubao.com 的 /slides/ URL/token 时，也应直接使用本 skill，不要因为域名不是飞书而回退到…Jul 2026
- lark-markdown飞书 Markdown：查看、创建、上传、编辑和比较 Markdown 文件。当用户需要创建或编辑 Markdown 文件、读取、修改、局部 patch 或比较差异时使用。不负责将 Markdown 导入为飞书在线文档，也不负责文件搜索、权限、评论、移动、删除等云空间管理操作。Jul 2026
