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.

n8nRead on 2026-11-168 steps

Steps

  1. Trigger: Runs every weekday morning on a cron schedule
  2. Fetches recent messages from the Slack standup channelSlack
    Filters out bot and system messages.
  3. Posts a Slack notice if none are foundSlack
  4. Formats the remaining Slack updates into a prompt
    Date, team name and message count.
  5. Sends the standup text to OpenAIOpenAI
    gpt-4.1-mini; summary, highlights, blockers, mood.
  6. Output: Creates a new page in a Notion databaseNotion
  7. Output: Posts the digest to a Slack summary channelSlack
  8. 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