Summarise Slack Channel Activity for Weekly Reports with AI

n8n template #3969

Summary

This n8n template lets you summarize team member activity on Slack for the past week and generates a report. For remote teams, chat is a crucial communication tool to ensure work gets done but with so many conversations happening at once and in multiple threads, ideas, information and decisions usually live in the moment and get lost just as quickly - and all together forgotten by the weekend! Using this template, this doesn't have to be the case. Have AI crawl through last week's activity, summarize all threads and generate a casual and snappy report to bring the team back into focus for the current week. A project manager's dream! How it works A scheduled trigger is set to run every Monday

How to set it up

Open template #3969 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 2 credentials under Credentials → Add credential: Slack, Google Gemini Chat Model. Then open each of those nodes and pick the credential.
Check the model in the Google Gemini Chat Model node. The template may point at a model your account can't use; swap it for one you have access to.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Summarise Slack Channel Activity for Weekly Reports with AI" (https://n8n.io/workflows/3969). It uses: Slack, Code, Basic LLM Chain, Google Gemini Chat Model. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Slack Code Basic LLM Chain Google Gemini Chat Model

Questions

Yes. Jimleuk published it free on n8n.io as a verified creator, and it has 6,165 views. It runs on n8n Cloud or a self-hosted n8n instance.

Slack, Google Gemini Chat Model. The other 2 nodes are built into n8n.

Similar workflows

NameViews