Sort Slack Messages → Generate Weekly Report → Share Results

beginner12 minPublished May 2, 2026
No ratings

Automatically collect and categorize important Slack messages from key channels, then generate a weekly summary report for leadership.

Workflow Steps

1

Zapier

Collect starred/important Slack messages

Set up a Zapier trigger that captures messages from specific Slack channels (like #product-updates, #customer-wins, #blockers) when they're starred or contain specific keywords. Configure it to run weekly and collect all qualifying messages.

2

ChatGPT

Categorize and summarize messages

Feed the collected Slack messages to ChatGPT via Zapier's OpenAI integration. Use a prompt that categorizes messages into themes (Product Updates, Customer Feedback, Blockers, Wins) and creates bullet-point summaries for each category.

3

Notion

Create formatted weekly report

Use Zapier to create a new Notion page with a standardized template containing the categorized summaries, key metrics, and action items. Include date stamps and team member mentions for accountability.

Workflow Flow

Step 1

Zapier

Collect starred/important Slack messages

Step 2

ChatGPT

Categorize and summarize messages

Step 3

Notion

Create formatted weekly report

Why This Works

Transforms scattered Slack conversations into structured reports, ensuring important information doesn't get lost in chat history while saving manual compilation time.

Best For

Team leads and managers who need to track cross-functional updates

Explore More Recipes by Tool

Comments

0/2000

No comments yet. Be the first to share your thoughts!

Related Recipes