Automate daily standups using Slack, Notion, and Redis — n8n 工作流

复杂度 定时45 个节点🏷️ Project Management👁 14 次查看作者:BytezTech

概览

Run automated daily standups using Slack, Notion, and Redis

📌 Overview

This workflow fully automates your team's daily standup process using Slack for communication, Notion for structured data storage, and Redis for real-time session management.

It automatically sends standup questions to active team members, collects and stores their responses, manages conversation sessions, and generates structured summary reports for managers.

Morning and evening standups run on schedule without manual in

使用的节点

RedisSlackNotionCode

工作流预览

Automated daily standup system with Slack, No
How it works
This workflow automates daily standups for your team ac
🌙 Evening Standup Summary
How it works
1. Triggers Mon–Sat at 6:30 PM IST
2. Fetches active members from `Team_Members` Notion DB
3. Fetches today's evening standups from `Daily_Standup
⏰ Trigger
Fires Mon–Sat at 6:30 PM IST (`30 18 * * 1-6`). Kicks o
📋 Fetch Data
Fetches active members (`Team_Members`) and today's res
🔀 Merge & Build
Merges both datasets, calculates response rate, missing
📤 Send to Slack
Posts the formatted evening summary to the admin Slack
🌅 Morning Standup Summary
How it works
1. Triggers Mon–Sat at 10:10 AM IST
2. Fetches active members from `Team_Members` Notion DB
3. Fetches today's responded standups from `Daily_Stand
⏰ Trigger
Fires Mon–Sat at 10:10 AM IST (`10 10 * * 1-6`). Kicks
📋 Fetch Data
Fetches active members (`Team_Members`) and today's res
🔀 Merge & Build
Merges both datasets. Code node normalizes fields, calc
📤 Send to Slack
Posts the formatted morning standup summary to the admi
🌅 Morning Standup Initiator
How it works
1. Triggers Mon–Sat at 9:40 AM IST
2. Fetches active members from `Team_Members` Notion DB
3. Loops through each developer one at a time
4. Validates mem
📋 Fetch & Gate
Fetches active members from `Team_Members` Notion DB. I
🔁 Developer Loop
`splitInBatches` iterates one member at a time. All pat
✅ Validate Member
Code node normalizes Notion fields and checks required
🔴 Redis Session Check
GETs existing session key `morning:standup:session:{sla
📝 Create Session
Creates a `Conversation_State` record in Notion (questi
🔴 Save & Send
IF `can_write_redis` is true: SETs session in Redis (86
⏰ Trigger
Fires Mon–Sat at 9:40 AM IST (`0 40 9 * * 1-6`). Kicks
🌙 Evening Standup Initiator
How it works
Fires Mon–Sat at 6 PM IST. Fetches all active developer
⏰ Trigger, Fetch & Gate
Schedule fires Mon–Sat 6 PM IST. Fetches active members
🔁 Developer Loop & Validation
Iterates through each member one at a time. Validates r
🔴 Redis Session Check
GETs `standup:evening:{slack_user_id}`. If a session ex
📝 Session Creation & Storage
Creates a Notion record in `Conversation_State_Afternoo
💬 Send, Log & Loop Back
Sends Question 1 of 3 via Slack DM (`chat:write`). Logs
Fetch Active Members
M
Merge Data
Fetch Evening Standups
E
Evening schedule trigger
Build evening summary me…
Send to Admin Channel Ev…
Send to Admin Channel
M
Morning schedule trigger
Fetch team members (morn…
Fetch today's morning st…
M
Merge morning data
Build morning summary me…
M
Morning standup initiato…
Get active team members
C
Check if members found
D
Developer loop
Extract and validate mem…
I
Is valid member
Check existing Redis ses…
Parse session state
N
Needs new session
Create Notion session
Prepare session data
S
Session data ready
Save session to Redis
Send standup message
Update Slack channel ID …
C
Continue to next (morning)
E
Evening standup initiato…
Get active team members …
C
Check developers found
No developers found
P
Process each developer
Validate and prepare mem…
C
Check if valid member (e…
Check evening Redis sess…
Check evening session st…
S
Should proceed with even…
Create evening Notion se…
Build evening session data
E
Evening session ready
Store evening session in…
Send evening standup mes…
Log final result
C
Continue to next (evening)
45 nodes51 edges

工作原理

  1. 1

    触发器

    工作流由 定时 触发器启动,按预定计划运行。

  2. 2

    处理

    数据流经 45 个节点, connecting code, if, merge。

  3. 3

    输出

    工作流完成自动化并将结果发送到配置的目标。

节点详情 (45)

RE

Redis

redis

#1
SL

Slack

slack

#2
NO

Notion

notion

#3
CO

Code

code

#4

如何导入此工作流

  1. 1点击右侧 下载 JSON 按钮保存工作流文件。
  2. 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入
  3. 3选择下载的 automate-daily-standups-using-slack-notion-and-redis 文件并点击导入。
  4. 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
  5. 5点击 测试工作流 验证一切正常,然后激活它。

或直接在 n8n → 从 JSON 导入 中粘贴:

{ "name": "Automate daily standups using Slack, Notion, and Redis", "nodes": [...], ...}

集成

codeifmergenotionredisscheduletriggerslacksplitinbatches

获取此工作流

一键下载并导入

下载 JSON在 n8n.io 上查看
节点45
复杂度high
触发器scheduled
查看次数14

创建者

BytezTech

BytezTech

@chintan

标签

codeifmergenotionredisscheduletriggerslacksplitinbatches

n8n 新手?

n8n 是一款免费开源的工作流自动化工具,支持自托管或使用云版本。

免费获取 n8n →