name: 周报自动同步(纯API版)
version: 1.0.0
cron: "10 9 * * 1" # 每周一09:10
inputs:
- name: client_id
title: 腾讯文档ClientID
type: string
required: true
- name: client_secret
title: 腾讯文档ClientSecret
type: string
required: true
- name: doc_a_id
title: 日报文档ID(doc)
type: string
required: true
- name: sheet_b_id
title: 汇总表ID(sheet)
type: string
required: true
- name: user_name
title: 表格中你的姓名
type: string
required: true
- name: wecom_webhook
title: 企业微信通知(可选)
type: string
required: false
steps:
# ==============================================
# 步骤1：获取AccessToken（必须先调用）
# ==============================================
- name: 获取访问令牌
action: http.post
args:
url: "https://docs.qq.com/open/api/oauth2/token"
headers:
Content-Type: "application/x-www-form-urlencoded"
body:
grant_type: "client_credentials"
client_id: "${{inputs.client_id}}"
client_secret: "${{inputs.client_secret}}"
scope: "doc:read sheet:read sheet:write"
# 输出：access_token
# ==============================================
# 步骤2：读取日报文档A内容
# ==============================================
- name: 读取日报文档
action: http.get
args:
url: "https://docs.qq.com/open/api/doc/v1/content?doc_id=${{inputs.doc_a_id}}"
headers:
Authorization: "Bearer ${{steps.获取访问令牌.output.access_token}}"
# 输出：content（全文）
# ==============================================
# 步骤3：读取汇总表B的表头（找姓名列）
# ==============================================
- name: 读取汇总表表头
action: http.get
args:
url: "https://docs.qq.com/open/api/sheet/v1/headers?sheet_id=${{inputs.sheet_b_id}}&range=A1:Z1"
headers:
Authorization: "Bearer ${{steps.获取访问令牌.output.access_token}}"
# 输出：headers = [姓名1, 姓名2, ...]
# ==============================================
# 步骤4：计算上周日期（模板表达式）
# ==============================================
- name: 计算上周日期
action: var.set
args:
last_mon: "{{date.add(date.startOfWeek(date.now()), -7) | date 'YYYY-MM-DD'}}"
last_tue: "{{date.add(steps.计算上周日期.vars.last_mon, 1) | date 'YYYY-MM-DD'}}"
last_wed: "{{date.add(steps.计算上周日期.vars.last_mon, 2) | date 'YYYY-MM-DD'}}"
last_thu: "{{date.add(steps.计算上周日期.vars.last_mon, 3) | date 'YYYY-MM-DD'}}"
last_fri: "{{date.add(steps.计算上周日期.vars.last_mon, 4) | date 'YYYY-MM-DD'}}"
# 输出：last_mon、last_tue...
# ==============================================
# 步骤5：按日期提取日报（示例：提取周一）
# ==============================================
- name: 提取周一内容
action: var.set
args:
mon_content: |
{{
substring(
steps.读取日报文档.output.content,
indexOf(steps.读取日报文档.output.content, steps.计算上周日期.vars.last_mon),
indexOf(steps.读取日报文档.output.content, steps.计算上周日期.vars.last_tue)
)
}}
# ==============================================
# 步骤6：找到姓名所在列号
# ==============================================
- name: 定位姓名列
action: var.set
args:
col_index: "{{indexOf(steps.读取汇总表表头.output.headers, inputs.user_name)}}"
# ==============================================
# 步骤7：写入周一数据到汇总表
# ==============================================
- name: 写入周一数据
action: http.post
args:
url: "https://docs.qq.com/open/api/sheet/v1/write"
headers:
Authorization: "Bearer ${{steps.获取访问令牌.output.access_token}}"
Content-Type: "application/json"
body:
sheet_id: "${{inputs.sheet_b_id}}"
range: "${{char(65 + steps.定位姓名列.vars.col_index)}}2" # A=0,B=1...
values: [["${{steps.提取周一内容.vars.mon_content}}"]]
# ==============================================
# 步骤8：企业微信通知（可选）
# ==============================================
- name: 发送完成通知
action: http.post
args:
url: "${{inputs.wecom_webhook}}"
headers:
Content-Type: "application/json"
body:
msgtype: "text"
text:
content: |
✅ 周报同步完成
姓名：${{inputs.user_name}}
上周：${{steps.计算上周日期.vars.last_mon}}~${{steps.计算上周日期.vars.last_fri}}
