WeCom Group Task Board

Problem

Daily reports in WeCom group chats often end up as scattered messages. When team members send today's plan or completed work, the text is usually free-form, inconsistent, and hard to follow up on later. Copying it into a sheet by hand adds repetitive work and can miss context.

How it works

The skill turns natural-language reports from WeCom group chats into structured records. Key steps include:

• Trigger: the message @mentions the bot and contains the keyword today's plan or completed work.
• Extraction: it captures submitter, submit date, today's plan, completed work, and status, with defaults when a field is missing.
• Write: it runs python3 scripts/write_to_smartsheet.py to write the record into a WeCom Smart Sheet, where it can be viewed as a board.

This is useful when recurring daily reports need to become queryable, follow-up-friendly table data.

Limits and caveats

It assumes a WeCom Smart Sheet webhook_url is available and that messages follow the expected keyword pattern. Reports without the expected keywords, or with highly free-form wording, may be extracted incompletely. The skill is focused on office data entry and does not handle complex task decomposition, permissions, or cross-group analytics.