wecomcli-smartsheet

Name: wecomcli-smartsheet
Availability: InStock
Author: Pinvou

Manage WeCom smartsheet records, fields, views, and charts via wecom-cli.

2.0k|291|Updated Jul 24, 2026

Search Tags:#dashboard #records #wecom #smartsheet #sql query #wecom-cli #enterprise wechat

Ready to run

npx skills add https://github.com/Pinvou/pinvou-agent --skill wecomcli-smartsheet-pinvou

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: wecomcli-smartsheet
Source: https://github.com/Pinvou/pinvou-agent/tree/main/pinvou3-app/src-tauri/resources/common/bundle/wecom-skills/wecomcli-smartsheet
Command: npx skills add https://github.com/Pinvou/pinvou-agent --skill wecomcli-smartsheet-pinvou

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? It lets an AI agent read, create, and modify WeCom (Enterprise WeChat) smartsheet documents through the wecom-cli command line, covering data records, table structure, views, dashboards, and cell styling without manual UI operations. ## Core Features & Use Cases - Data and structure management: Query records with SQL, add/update/delete records, and manage sub-sheets, fields, views, and dashboard charts. - Styling and formulas: Apply row/column/cell coloring and conditional formatting, and create formula fields with a structured formulaModel syntax. - Permission fallback: When record writes return error 851003 (no authority), it switches to a Webhook-based write path. - Use Case: Ask the agent to build a task-tracking smartsheet from scratch with priority and owner fields, then add a dashboard chart summarizing tasks by status. ## Quick Start Ask the agent to read the records from your WeCom smartsheet by pasting its doc.weixin.qq.com/smartsheet link and stating what you want to query or change.

Frequently Asked Questions about wecomcli-smartsheet

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

FAQPage Schema

How do I read data from a WeCom smartsheet with wecom-cli?▼

Use wecom-cli smartsheet records query with a read-only SELECT SQL statement against the sheet title. If you lack full table permission (error 538005), fall back to smartsheet records list for paginated reads.

How do I create a WeCom smartsheet with fields via CLI?▼

Run wecom-cli smartsheet create with a JSON body containing name, sheet_title, and a fields array defining field_title and field_type. After creation, adjust column widths through the views update command.

What is the difference between WeCom smartsheet and online sheet?▼

Smartsheet (doc type smartsheet, links containing /smartsheet/) is a structured database with fields, views, and dashboards. Online sheets (links containing /sheet/) are spreadsheet-style documents handled by a separate sheet skill.

Why does adding records to a smartsheet return error 851003?▼

Error 851003 means the CLI identity lacks write authority on that smartsheet. Stop retrying the CLI and use the Webhook fallback flow, which requires the user to provide a Webhook URL and schema example.

Can I export a WeCom smartsheet to Excel or CSV?▼

No. Exporting to Excel or CSV, viewing historical versions, and restoring deleted records are not supported by the current interfaces. The skill will inform you directly rather than attempt a workaround.

How do I add a chart to a smartsheet dashboard?▼

Use wecom-cli smartsheet charts add with a charts array specifying type, datasource sheet, category field, series, and layout. Filtered charts require option IDs from fields list, not display text.