Daily Team Progress Checks & Reports with Slack, ChatGPT and Google Sheets — n8n 工作流
概览
Overview
This workflow is a daily progress check flow that runs automatically at 17:00. It integrates Google Sheets, Slack, and ChatGPT to automate progress inquiries to team members and generate daily reports.
Overall Workflow Steps Triggered every day at 17:00. Reads the specified WBS management sheet. Automatically sends a Slack DM to each member based on their Slack ID. After 30 minutes, retrieves and aggregates progress information for the day. Sending Report to Slack Channel (e.g., "#dai
使用的节点
Google SheetsSlackOpenAI
工作流预览
G
Group Member Info
⚡
S
Start Daily at 17:00
Get Project WBS
F
Filter Uncompleted Tasks
Send Messages to Members
W
Wait 30 Minutes for Memb…
Agent: Compile Report Su…
G
Generate Daily Report
Send Report to Client
Agent: Update task statu…
10 nodes9 edges
工作原理
- 1
触发器
工作流由 定时 触发器启动，按预定计划运行。
- 2
处理
数据流经 10 个节点, connecting cron, function, googlesheets。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (10)
GO#1
Google Sheets
googleSheets
SL#2
Slack
slack
OP#3
OpenAI
n8n-nodes-langchain.openAi
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
daily-team-progress-checks-reports-with-slack-chatgpt-and-google-sheets文件并点击导入。 - 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
- 5点击 测试工作流 验证一切正常，然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴：
{ "name": "Daily Team Progress Checks & Reports with Slack, ChatGPT and Google Sheets", "nodes": [...], ...}
集成
cronfunctiongooglesheetsifopenaislackwait
创建者
Satoshi
@satoshi
标签
cronfunctiongooglesheetsifopenaislackwait