Slack activity summary for team visibility
Build a workflow that summarizes activity from public Slack channels into a single page. The goal is to give managers and team leads a quick view of what's being discussed and worked on across channels, without having to hop between them manually. Trigger it on a schedule to refresh the summary, and serve it as a web page. Main steps, at a high level: Pull recent messages from a defined set of public Slack channels. Summarize activity per channel — key topics, notable threads, and volume — using an LLM. Render a single dashboard page showing the per-channel summaries, refreshed on a schedule so it's always current. Tools used: Slack, an LLM for summarization (e.g. Claude, OpenAI, or Gemini)
What this prompt builds
This workflow aggregates activity from public Slack channels into a single summary page, giving managers and team leads visibility into what team members are working on. It creates a centralized view of ongoing discussions and projects without manual channel-hopping. Best suited for distributed teams or managers overseeing multiple projects who need quick status awareness.
The problem
Managers and team leads struggle to keep track of what everyone is working on when conversations are scattered across multiple Slack channels. This workflow aggregates activity from public Slack channels into a single summary page, giving leaders a quick overview of ongoing discussions, projects, and team focus areas without manually checking each channel throughout the day.
Solution and impact
The workflow delivers a centralized view of team activity that saves managers time spent channel-hopping and provides real-time visibility into project progress and team priorities. It enables better coordination across distributed teams and helps leaders spot blockers or collaboration opportunities faster.