AI Weekly Team Activity Reports from Slack

# Weekly AI-powered Slack activity reports: personalized and team summaries

This automation template helps Slack-heavy teams maintain visibility into individual and collective contributions. Every Monday morning, it collects last week’s messages, analyzes them using Google Gemini, and posts a structured summary—eliminating manual reporting and sync meetings.

## Who it´s for
- Project managers in remote teams who need transparency and visibility.
- Department leads aiming to automate weekly reports without manual data collection.
- Teams using Slack as their primary communication channel and losing key info in message floods.
- HR and internal comms professionals looking to boost engagement through automated activity reviews.

## What the automation does
- Triggers weekly via cron_schedule on Sunday night or Monday morning.
- Collects all messages from a specified Slack channel over the past week.
- Groups messages by user and extracts thread conversations.
- Sends context to Google Gemini via LangChain for analysis.
- Identifies wins, challenges, and key decisions per team member.
- Generates personalized summaries and compiles them into a unified team report.
- Posts the final report directly into Slack to kick off the week.

## What´s included
- Ready-to-use n8n workflow with processing and AI logic.
- Trigger and scheduling configuration.
- Integrations with Slack and Google Gemini (PaLM) API.
- Basic text instructions for setup and adaptation.

## Requirements for setup
- n8n account (cloud or self-hosted).
- Slack access with permissions to read target channels.
- Google Gemini (PaLM) API key.
- Basic understanding of JavaScript and API usage.

## Benefits and outcomes
- Saves time on manual report compilation.
- Increases team awareness of individual contributions.
- Simplifies onboarding for new hires.
- Automatically captures decisions and blockers.
- Enhances engagement through regular feedback.
- Supports async workflows in distributed teams.

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat