wecomcli-manage-smartsheet-data

Original：🇨🇳 Chinese

Translated

WeCom Smart Table data (record) management Skill. Provides add, delete, modify and query capabilities for smart table records. Applicable scenarios: (1) Query all records of a sub-table (2) Add one or more rows of records (3) Update existing records (4) Delete records. This Skill is triggered when users need to read table data, write new data, modify or delete table rows. It supports locating documents via docid or document URL.

946installs

Sourcewecomteam/wecom-cli

Added on2026-03-30

NPX Install

npx skill4agent add wecomteam/wecom-cli wecomcli-manage-smartsheet-data

SKILL.md Content (Chinese)

View Translation Comparison →

WeCom Smart Table Data Management

wecom-cli
is a command line program provided by WeCom, and all operations are completed by executing the
wecom-cli
command.

Manage records (row data) in smart tables. All interfaces support locating documents by either

docid

or

url

.

CLI Calling Method

Called via

wecom-cli

, with the category as

doc

:

bash

wecom-cli doc <tool_name> '<json_params>'

Return Format Description

All interfaces return JSON objects, including the following public fields:

Field	Type	Description
`errcode`	integer	Return code, `0` means success, non- `0` means failure
`errmsg`	string	Error message, which is `"ok"` when the call is successful

When

errcode

is not

, it means the interface call failed, you can retry once; if it still fails, display the

errcode

and

errmsg

to the user.

smartsheet_get_records

Query all records of the sub-table.

bash

wecom-cli doc smartsheet_get_records '{"docid": "DOCID", "sheet_id": "SHEETID"}'

Or via URL:

bash

wecom-cli doc smartsheet_get_records '{"url": "https://doc.weixin.qq.com/smartsheet/xxx", "sheet_id": "SHEETID"}'

See API Details.

smartsheet_add_records

Add one or more rows of records, it is recommended to add no more than 500 rows at a time.

Before calling, you must first understand the field types of the target table (via

smartsheet_get_fields

).

bash

wecom-cli doc smartsheet_add_records '{"docid": "DOCID", "sheet_id": "SHEETID", "records": [{"values": {"任务名称": [{"type": "text", "text": "完成需求文档"}], "优先级": [{"text": "高"}]}}]}'

For the value format of each field type, see Cell Value Format Reference.

smartsheet_update_records

Update one or more rows of records, no more than 500 rows at a time. You need to provide the record_id (obtained via

smartsheet_get_records

).

bash

wecom-cli doc smartsheet_update_records '{"docid": "DOCID", "sheet_id": "SHEETID", "records": [{"record_id": "RECORDID", "values": {"任务名称": [{"type": "text", "text": "更新后的内容"}]}}]}'

Note: Fields such as creation time, last edit time, creator, and last editor cannot be updated.

smartsheet_delete_records

Delete one or more rows of records, no more than 500 rows at a time. The operation is irreversible. The record_id is obtained via

smartsheet_get_records

.

bash

wecom-cli doc smartsheet_delete_records '{"docid": "DOCID", "sheet_id": "SHEETID", "record_ids": ["RECORDID1", "RECORDID2"]}'

Typical Workflow

Read data →

bash

wecom-cli doc smartsheet_get_records '{"docid":"DOCID","sheet_id":"SHEETID"}'

Write data → First use
```
smartsheet_get_fields
```
to understand the column types → If member (USER) fields are involved, first find the user's userid via the
```
get_userlist
```
interface of
```
wecomcli-lookup-contact
```
→ Write data via
```
smartsheet_add_records
```
Update data → First obtain record_id via
```
smartsheet_get_records
```
→ If member (USER) fields are involved, first find the user's userid via the
```
get_userlist
```
interface of
```
wecomcli-lookup-contact
```
→ Update data via
```
smartsheet_update_records
```
Delete data → First confirm the record_id via
```
smartsheet_get_records
```
→ Delete data via
```
smartsheet_delete_records
```

Note: Member (USER) type fields require filling in
user_id
, and you cannot directly use the name. You must first find the corresponding
userid
by name through the
get_userlist
interface of the
wecomcli-lookup-contact
Skill before using it.

wecomcli-manage-smartsheet-data

NPX Install

Tags

SKILL.md Content (Chinese)

WeCom Smart Table Data Management

CLI Calling Method

Return Format Description

smartsheet_get_records

smartsheet_add_records

smartsheet_update_records

smartsheet_delete_records

Typical Workflow