Automate Weekly Team Reports with Microsoft Teams & OpenAI in n8n

Workflow Inputs, Processing, and Outputs

Inputs

• You provide Microsoft Teams team and channel IDs.


• n8n gets messages from the last 7 days using Microsoft Teams node.


• Your OpenAI API Key is needed for AI summarization.

Processing Steps

1. Schedule trigger runs every Monday at 6 AM.
   


2. Microsoft Teams node fetches all messages and replies from the previous week.
   


3. Code node groups all messages by user ID. It links reply messages to their parents for context.
   



const messages = $input.all().map(item => item.json);

const groupByUserId = messages.reduce((acc, msg) => {
  return {
    ...acc,
    [msg.from.user.id]: acc[msg.from.user.id]
      ? acc[msg.from.user.id].concat(msg)
      : [msg]
  };
}, {});

const output = Object.keys(groupByUserId).map(userId => {
  const userMessages = groupByUserId[userId];
  for (let i = 0; i < userMessages.length; i++) {
    if (userMessages[i].replyToId) {
      userMessages[i].parent = messages.find(msg => msg.id === userMessages[i].replyToId);
    }
  }
  return {
    user: userMessages[0].from.user,
    messages: userMessages
  };
});

return { output };

The above script prepares user-based conversation groups with reply context.




4. SplitOut node separates each user’s grouped messages into single workflow items.
   


5. Chain LLM node uses OpenAI to read all messages from one user and make a short report. It highlights wins, challenges, and notes team changes.
   


6. Set node combines the user's data with their AI report.
   


7. Aggregate node collects all user reports into one list.
   


8. Another Chain LLM node reads all individual reports and writes a unified team summary in markdown.
   


9. Markdown node converts the markdown text into HTML for better display.
   


10. Microsoft Teams node posts the final HTML report to the channel.
    

Output

The end result is a clear, nicely formatted weekly report in Microsoft Teams.
It shows each member’s contributions and a team overview.
This saves time and improves team communication.