Tencent Docs Weekly Report Auto Sync

Problem

Engineers often keep daily notes in a Tencent Docs document but still copy last week’s entries into a shared summary sheet by hand. The annoying part is not the daily note itself; it is locating the right week, matching the person’s name column, and writing the correct cell on Monday morning. This skill turns that routine into a pure API-based scheduled flow.

How It Works And Limits

It runs at 10 9 * * 1, i.e. Monday 09:10. The main steps are:

• Obtain a Tencent Docs access_token using client_id and client_secret
• Read the full content of the daily-report document doc_a_id
• Read the summary sheet sheet_b_id headers and locate the column for user_name
• Calculate the previous week’s date range and extract the matching fragment from the daily report
• Write the extracted content into the target sheet cell
• Optionally send a WeCom text notification through wecom_webhook

Note: The provided steps mainly demonstrate extracting and writing mon_content, so the current configuration is best for syncing a single daily entry or a Monday-based weekly summary. To cover the full week, the workflow needs extension to extract and write each day separately. It assumes Tencent Docs permissions doc:read sheet:read sheet:write, correct document and sheet IDs, and a name present within the header range A1:Z1.