Employee Resource Group (ERG) Slack Engagement Tracker & Monthly Insights Report
Automatically track every message and reaction in your ERG Slack channel -- then get a monthly AI-powered insights report delivered to your leadership channel, with no manual counting required.
Click and drag to move around the canvas and pinch to zoom.
Frequently asked questions
What does this template do?
This template automatically captures every message and emoji reaction posted in your chosen ERG Slack channel and logs them to a Zapier Table. On the first day of each month, a Zapier Agent reads the previous month’s data, analyzes it using AI, and posts a formatted engagement report to your private leadership Slack channel -- including total posts, total reactions, total comments, top-performing posts, and engagement trends.
What Zapier products does this use?
The template uses two Zaps (one for message tracking, one for reaction tracking), a Zapier Table as the engagement database, and a Zapier Agent that runs monthly to generate and deliver the insights report. It also uses ChatGPT (OpenAI) inside the Agent to analyze the data.
Do I need to know how to code to use this?
No coding required. Once you install the template, you will need to connect your Slack account, update the channel selections to point to your ERG Slack channel and leadership channel, and update the leadership lookup table with the first names of your ERG leadership team members. Everything else runs automatically.
What does the monthly insights report include?
The AI-generated report includes: total number of posts for the month, total reactions, total comments, the post with the most reactions, the post with the most comments, the best-performing Watercooler post, and additional analysis on engagement patterns and content trends. The report is delivered as a Slack thread in your leadership channel for easy reading.
Can I use this for any Slack channel, not just ERGs?
Yes. While this template was built by and for an ERG team, it works for any Slack channel where you want to track engagement -- team channels, community channels, interest groups, and more. Just point the Zaps and Agent to your channel of choice.
How does reaction tracking work for threaded conversations?
When someone reacts to a reply inside a thread, that reaction is counted against the parent (top-level) post, not the individual reply. This means each row in your table reflects total engagement for the parent post and all of its replies combined, giving you a true picture of how much activity a given post generated.
What happens to messages posted before I turn on the Zaps?
The Zaps only capture new activity from the moment they are turned on. Historical messages and reactions will not be backfilled automatically. If you want to include past data, you would need to manually enter those records into the Zapier Table.
Can I change when the monthly report runs?
Yes. The Agent is triggered by a Schedule by Zapier step set to the 1st of every month at 8 AM. You can adjust the day and time in the Agent’s trigger settings to match your team’s preferences.
What AI model is used to generate the report?
The template defaults to ChatGPT (gpt-4o and gpt-4o-mini), but you can swap in any AI model supported by Zapier -- you are not locked to OpenAI. You also do not need your own API key. Zapier provides free built-in model authentication, so you can use Zapier's model access without connecting a separate AI account.