wecomcli-smartsheet

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

287|46|Updated Feb 5, 2026
One-click install
npx skills add https://github.com/YanHaidao/wecom --skill wecomcli-smartsheet-yanhaidao
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: wecomcli-smartsheet
Source: https://github.com/YanHaidao/wecom/tree/main/skills/wecomcli-smartsheet
Command: npx skills add https://github.com/YanHaidao/wecom --skill wecomcli-smartsheet-yanhaidao

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) components.

What problem does it solve? Working with WeCom (Enterprise WeChat) smartsheets through APIs requires knowing dozens of field types, view configurations, chart schemas, and record value formats. This Skill gives the AI a complete operational playbook for reading and writing smartsheet data, structure, and styling through the wecom-cli tool, including a Webhook fallback when CLI writes hit permission limits. ## Core Features & Use Cases - Full data operations: Query records with SQL (filtering, aggregation, JOIN, TopN), and add, update, or delete records in batches of up to 2000. - Structure and visualization management: Create sheets, fields (27 field types including formula, lookup, and two-way link), views with filters/sorting/grouping, and dashboard charts (bar, column, line, pie, combo, and more). - Styling and templates: Apply cell/row/column coloring and conditional formatting, and bootstrap new tables from built-in templates. - Use Case: Ask the AI to build a task-tracking smartsheet with priority and owner fields, add a dashboard chart of tasks by status, then insert 50 records—if the CLI returns error 851003 (no authority), the Skill automatically switches to Webhook-based writing. ## Quick Start Ask the AI to read the records from your WeCom smartsheet link and summarize the count of items grouped by status.

Frequently Asked Questions about wecomcli-smartsheet

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

FAQPage Schema
How do I add or update records in a WeCom smartsheet?

Use wecom-cli smartsheet records add or records update with the docid, sheet_title, and a records array keyed by field names. Read a few existing records first to align wording and option IDs, then verify the result with a read query afterward.

How to query WeCom smartsheet data with SQL?

Use wecom-cli smartsheet records query with --docid and one or more --sql SELECT statements. Only read-only SELECT is allowed, field and sheet names use backticks, and date fields are stored as Excel serial numbers formatted with DATE_FORMAT.

What is the difference between WeCom smartsheet and online sheet?

Smartsheet is a database-like table with sheets, fields, records, views, and charts, identified by docid prefix s3_. Online sheet is a traditional spreadsheet handled by a separate skill; when unspecified, smartsheet is the default choice.

Why does smartsheet record writing fail with error 851003 no authority?

Error 851003 usually means the enterprise visible range exceeds 10 people, which restricts CLI write APIs. Stop retrying the CLI, ask the user for the sheet's Webhook URL and schema example, and write through the Webhook fallback instead.

Can I create charts and dashboards in a WeCom smartsheet?

Yes, add a dashboard-type sheet then use smartsheet charts add with a chart type such as column, bar, line, pie, or combo. Layout must fit a 12-column grid, and filtered charts require option IDs rather than display text.

What are the limitations of smartsheet record operations?

A single sheet supports up to 20000 records and 150 fields, and each write request carries at most 2000 records. Deleting the last sheet, field, or view is blocked, and historical versions, export to Excel, and trend prediction are not supported.