Slack standup digest with OpenAI
Summarizes a Slack standup channel each weekday. This n8n template runs every weekday morning on a cron schedule. It fetches the day's messages from a Slack standup channel and filters out bot and system messages; if none remain, it posts a notice in Slack. The remaining updates are formatted into a prompt with date, team name and message count and sent to OpenAI (gpt-4.1-mini), which returns a JSON digest with a summary, highlights, blockers, per-user updates and mood. The workflow creates a Notion page for the digest, posts it to a Slack summary channel and appends a run record to a Google Sheets audit log.
Steps
- Trigger: Runs every weekday morning on a cron schedule
- Fetches recent messages from the Slack standup channelSlack
Filters out bot and system messages. - Posts a Slack notice if none are foundSlack
- Formats the remaining Slack updates into a prompt
Date, team name and message count. - Sends the standup text to OpenAIOpenAI
gpt-4.1-mini; summary, highlights, blockers, mood. - Output: Creates a new page in a Notion databaseNotion
- Output: Posts the digest to a Slack summary channelSlack
- Output: Appends a run record to Google SheetsGoogle Sheets
Audit Log sheet.
Limits
- Needs a Google Sheets service account.
- The Notion database needs the Date, Team, Message Count and Mood properties.
What it does well
- Posts a notice when no standup messages are found.
- Keeps an audit log of each run in Google Sheets.
Before you import
After the import, add Slack, OpenAI, Notion and Google Sheets service account credentials and set the channel and database IDs.
Similar templates
Daily RSS digest scored by Gemini
Also for scheduling and ops, 7 steps.
Facebook mention sentiment alerts
Also for scheduling and ops, 8 steps.
Book appointments by voice with Vapi
Also for scheduling and ops, 8 steps.
Google Sheets and OpenAI: 24 templates compared
Same two apps, different steps.
OpenAI and Slack: 17 templates compared
Same two apps, different steps.
Google Sheets and Slack: 16 templates compared
Same two apps, different steps.
Notion and OpenAI: 4 templates compared
Same two apps, different steps.
Google Sheets and Notion: 3 templates compared
Same two apps, different steps.
Notion and Slack: 3 templates compared
Same two apps, different steps.
Notify a team
Other templates that do this task.