Generate Slack Weekly Team Activity Reports with n8n & Google Gemini

What This Automation Does

This workflow collects Slack messages from last week and makes a summary report automatically.
It helps save hours of manual reading by showing what each team member did, their challenges, and wins.
The final report posts back to Slack every Monday morning.

The process gets messages by user, grabs replies, and uses AI to create easy-to-read summaries.
You get a full team overview and detailed individual reports without reading all messages yourself.

Tools and Services Used

• Slack API: Used to get channel messages, user info, and post reports.
• Google Gemini AI: Summarizes message threads and generates report text.
• n8n Automation Platform: Runs the workflow including data fetching, processing, and posting.

Inputs, Processing Steps, and Output

Inputs

• Slack channel ID to read messages from.
• Slack API credentials to access messages and users.
• Google Gemini API credentials to summon AI text summaries.
• Schedule trigger set to Monday 6am.

Processing Steps

• Fetch all Slack messages from past week.
• Group messages by user ID.
• Get replies for each message thread.
• Fetch user details for both message senders and repliers.
• Simplify data to main fields: timestamp, user ID, username, text.
• Send grouped data to Google Gemini to summarize each thread.
• Create personal weekly reports for each user.
• Combine all personal reports into a final team report.
• Post final report back to Slack channel.

Output

The final output is a clear, concise weekly report in Slack showing team activities, achievements, and challenges.

Who Should Use This Workflow

Team leaders or managers who use Slack for communication and want to save time reading messages.
It suits remote teams needing updates about conversations and progress.

Users who want AI-made summaries without technical steps for building from scratch.
People that want easy weekly reports automatically posted where the team already chats.

Beginner Step-by-Step: How To Use This Workflow in n8n

Step 1: Import Workflow

1. Download the workflow file using the Download button on this page.
2. Open n8n editor where you want to run this workflow.
3. Click “Import from File” and select the downloaded workflow.

Step 2: Set Credentials and IDs

1. In n8n, open the Slack nodes and add Slack API credentials.
2. Add Google Gemini API credentials in the respective AI nodes.
3. Update the Slack channel ID in the “Get Last Week’s Messages” node to your team’s channel.
4. If the workflow uses emails or folders, update those details accordingly.
5. If a Code or AI prompt is shown, copy-paste them as is in the nodes.

Step 3: Test the Workflow

1. Run the workflow manually once to see if messages are fetched properly.
2. Check the AI summaries or debug output in n8n.

Step 4: Activate for Production

1. Enable the Schedule Trigger node to start automatic runs every Monday at 6am.
2. Monitor workflow runs and logs in n8n dashboard.
3. If self hosting n8n, consider self-host n8n for better control.

Customization Ideas

• Change the Slack channel monitored by updating the channel ID.
• Modify AI prompts in Google Gemini nodes to change summary tone or focus.
• Add an email node like SMTP to send the report by email.
• Integrate project tools for deeper report insights.
• Filter users to exclude some team members or focus on specific people.

Troubleshooting

• Slack API token invalid or unauthorized
  Update Slack API credentials and verify permissions.
• No messages fetched for last week
  Check channel ID correctness and that messages exist for the chosen period.
• AI returns generic or irrelevant summaries
  Adjust AI prompts to be clearer about expected summary style and details.

Pre-Production Checklist

• Test Slack credentials and channel ID manually.
• Validate Google Gemini API credentials.
• Run AI nodes with test data to check summary quality.
• Confirm the scheduled trigger activates workflow as expected.
• Backup workflow JSON before major edits.

Summary / Results

✓ Save over 3 hours weekly by automating Slack message reviews.
✓ Get clear, personalized insights for each team member.
✓ Receive a concise team-wide report showing wins and challenges.
✓ Avoid missed updates and improve team motivation.
✓ Post reports automatically in Slack every Monday morning.