skills.rest
Liangdi
LiangdiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

wecomcli-manage-smartsheet-data

Query, add, update, and delete records in WeCom smartsheet documents via CLI.

3|Updated Apr 2, 2026
Search Tags:#cli#spreadsheet#crud#records#wecom#smartsheet#wecom-pro
One-click install
npx skills add https://github.com/Liangdi/wecom-pro --skill wecomcli-manage-smartsheet-data-liangdi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: wecomcli-manage-smartsheet-data
Source: https://github.com/Liangdi/wecom-pro/tree/main/skills/wecomcli-manage-smartsheet-data
Command: npx skills add https://github.com/Liangdi/wecom-pro --skill wecomcli-manage-smartsheet-data-liangdi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires wecom-pro, and includes references (resource) components.

What problem does it solve? Managing rows in WeCom (企业微信) smartsheets normally requires manual work in the web UI; this Skill lets an AI agent read, insert, update, and delete smartsheet records directly through the wecom-pro command line. ## Core Features & Use Cases - Record CRUD: Query all records of a sub-sheet, add one or more rows, update existing rows by record_id, and delete rows, all via wecom-pro doc commands. - Flexible document targeting: Locate the smartsheet by either docid or its document URL. - Typed cell values: Detailed reference for every field type (text, number, select, date, user, URL, image, location), including option style colors and key_type selection for updates. - Use Case: Sync a task list into a WeCom smartsheet: look up member userids, then batch-add rows with text, priority, and due-date fields in a single command. ## Quick Start Ask the agent to list all records in a WeCom smartsheet by providing the document URL and sheet ID, then add or update rows as needed.

Frequently Asked Questions about wecomcli-manage-smartsheet-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I add records to a WeCom smartsheet from the command line?▼

Run wecom-pro doc smartsheet_add_records with a JSON payload containing docid (or url), sheet_id, and a records array. Check field types first with smartsheet_get_fields, since each field type requires a specific value format.

How do I update existing rows in a WeCom smartsheet?▼

Use smartsheet_update_records with the record_id values obtained from smartsheet_get_records. You can set key_type to address values by field title or field ID. Creation and edit metadata fields cannot be updated.

Can I locate a smartsheet by URL instead of docid?▼

Yes. All record APIs accept either docid or the document URL (for example https://doc.weixin.qq.com/smartsheet/xxx); pass one of the two together with the sheet_id of the target sub-sheet.

Why does writing a member (USER) field fail in a smartsheet?▼

USER fields require a user_id, not a display name. First call wecom-pro contact get_userlist to find the person's userid by name or alias, then pass it as {"user_id": "..."} in the values array.

What are the batch limits for smartsheet record operations?▼

Adding or updating records is recommended at up to 500 rows per call, and deletion is limited to 500 rows per call. Deletes are irreversible, so confirm record_ids with smartsheet_get_records first.

Related Skills

Explore More Product & Management Skills→
DaTingLiDaTingLi

wecom-contact-lookup

Query visible WeCom directory contacts and return userid, name, and alias.

Community
Intermediate
AstorYHAstorYH
15

smartsheet-sheet-snapshot

Capture complete Smartsheet sheet data and formatting via the Smartsheet API.

Community
Intermediate
sunnoysunnoy
706

wecom-smartsheet-schema

Manage WeCom smart sheet structures via CRUD operations on sheets and fields.

Community
Intermediate
openakitaopenakita
2.0k

openakita/skills@wecom-cli

Operate WeCom contacts, todos, meetings, messages, schedules, documents, and smartsheets via CLI.

Community
Intermediate