DingTalk AI Table Writer
Paste the following prompt into your AI chat to install this skill:
Follow https://skillhub.cn/install/skillhub.md to install @user_5e4c54ff/dingtalkaisheetyxlv1 into your AI assistant.
About this skill
Problem
Syncing local data or task output to DingTalk AI Table (Notable) often requires juggling DingTalk open-platform credentials, access tokens, baseId, sheetIdOrName, records shape, and exact column-name matching. This skill packages that write path into a repeatable workflow: provide the target sheet and records, then bulk-write them and receive the document link.
Workflow and limits
- Credentials: includes default
appKey,appSecret, andoperatorId; custom values can be passed via--app-key,--app-secret, and--operator-id. - Required parameters:
baseId,sheetIdOrName, andrecords.recordsis a JSON array, and each record's keys must exactly match the DingTalk sheet column names. - Key steps: fetch an access token from the
accessTokenAPI, then call the Notable records API, and finally return a document link such ashttps://alidocs.dingtalk.com/i/nodes/{baseId}. - Caveats: missing columns, type mismatches, insufficient
operatorIdpermission, or network failures can affect the result; the skill handles token refresh and retry logic, but it does not replace correct permission setup.
Use Cases
- After a job finishes, write generated JSON records into a specified Notable sheet using exact DingTalk column names.
- After consolidating local files, write records once into a fixed worksheet in a shared DingTalk AI Table.
- When debugging sync failures, locate issues using missing-column, type-mismatch, or permission error messages.
- When a shareable link is needed, retrieve the DingTalk AI Table node URL after the write completes.
Best For
- Operations owners maintaining business ledgers: write repeated metrics and notes into one DingTalk AI Table.
- Data-sync engineers: bulk-write job results to Notable and retain a trackable document link.
- Support engineers debugging integrations: locate issues using column, type, or permission error messages.
- Product managers managing shared sheets: record approval or inspection results into a specified worksheet.
Related Skills
Turns files, references, or chat context into styled single-page HTML reports with built-in templates and preset themes.
An engineering-oriented email automation solution for batch sending, Jinja2 templates, attachments, scheduled sending, inbox monitoring, and rule-based auto-reply.
An engineering workflow for creating, editing, reviewing, analyzing, and image-converting .docx files using pandoc, docx-js, OOXML, and LibreOffice.
Pre-submission scanner for Word/PDF blind-bid files that checks margins, fonts, page numbers, and metadata against tender requirements and flags residual bidder identities.