AI Team Activity Report for Microsoft Teams

# Weekly AI team activity report from Microsoft Teams

This automation template solves the problem of manually collecting and analyzing communications in Microsoft Teams. Every Monday, the system automatically generates a weekly activity report, helping team members quickly regain context and focus on their tasks for the week.

## Who it´s for
- Project managers who need to automate weekly team activity reports.
- Remote teams using Microsoft Teams as their primary communication channel.
- Department leads aiming to increase transparency and engagement through regular updates.

## What the automation does
- Triggers every Monday morning based on a cron schedule.
- Fetches all messages from a specified Microsoft Teams channel for the past week.
- Groups messages by user.
- Uses an AI agent (based on OpenAI) to generate individual contribution summaries.
- Aggregates summaries into a single markdown team report.
- Converts markdown to HTML and posts the final report back to the Teams channel.

## What´s included
- Ready-to-use n8n workflow.
- Trigger and handler logic powered by LangChain and OpenAI.
- Integrations exclusively with Microsoft Teams API and OpenAI.
- Basic text instructions for setup and adaptation.

## Requirements for setup
- Microsoft Teams account with access to the target channel and required API permissions.
- OpenAI account with a valid API key.
- Running n8n instance capable of connecting to external services.

## Benefits and outcomes
- Saves time on manual chat review.
- Increases visibility of individual contributions.
- Streamlines weekly kick-offs for the entire team.
- Automatically captures key discussions and decisions.
- Supports transparency for external stakeholders.
- Reduces cognitive load for team leads.
- Encourages consistent communication habits.

## 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