LinkedIn employee advocacy leaderboard with weekly tracking
Build an internal workflow that produces a weekly leaderboard of employees whose LinkedIn posts tag our company page, and renders it as an internal web page. It's a post-count board (ranked by number of tagging posts, not engagement), meant to celebrate and encourage employee advocacy. Alongside it, build a searchable staff directory page sourced from our chat tool. Trigger the leaderboard pipeline on a weekly schedule (a cron, e.g. Monday afternoon). The web pages are triggered by people visiting their routes. Keep all routes restricted to authenticated members (space or tenant), not public. Main steps, at a high level: Fetch recent company-page mentions from LinkedIn — query the org's mention/notification feed via the LinkedIn Community Management API (or your equivalent social API), hydrate each post with author, URL and timestamp, filter to the last 7 days, and de-dupe. Since this API is partner-gated, make the step fall back to a realistic mock fixture when no access token is present, and switch to live automatically once one is, so the whole pipeline works end-to-end before approval. Build the leaderboard — pull the employee roster from Slack (or your team's chat/HR tool), fuzzy-match LinkedIn author names against it to exclude non-employees, aggregate and rank by post count (ties share a rank), and write a weekly snapshot to a persistent volume, keeping history for future trend charts. Serve the latest snapshot as a JSON API endpoint, and build a polished leaderboard web page that fetches it client-side (gold/silver/bronze styling, graceful empty state). Build a companion staff directory: a JSON endpoint that lists workspace members from Slack (or your chat tool), filtering out bots and deleted accounts, and a searchable web page that renders them as cards, defaulting to internal staff with a toggle for everyone. Link to it from the leaderboard page header. Read-only against all external services; the only writes are leaderboard snapshots to the workflow's own volume. Tools used: LinkedIn Community Management API, Slack (users.list) via Slack connector, cron trigger, persistent named volume, React web pages
What this prompt builds
This workflow monitors LinkedIn for employee posts that mention the company, aggregates them into a weekly leaderboard, and publishes it as an internal web page. It cross-references LinkedIn authors against an employee roster pulled from Slack or an HR system to verify they're current staff. The leaderboard celebrates employee advocacy and includes a companion staff directory for easy lookup.
The problem
Employees who post about their company on LinkedIn are valuable advocates, but their efforts often go unnoticed and uncelebrated. Companies lack a simple way to track which team members are actively championing the brand on social media, making it hard to recognise advocacy or encourage others to join in. This workflow solves that by automatically monitoring LinkedIn for employee posts that mention the company, verifying them against an internal roster, and publishing a weekly leaderboard that the whole organisation can see. It turns individual advocacy into visible, inspiring recognition.
Solution and impact
The workflow pulls recent company mentions from LinkedIn using the Community Management API, cross-references post authors against an employee list from Slack or an HR system, and ranks them by post count. Each week, it publishes a polished internal leaderboard page with gold, silver, and bronze styling, complete with a searchable staff directory for easy lookup. This gives leadership and teams a clear, ongoing view of who's championing the company, celebrates their efforts publicly, and inspires others to get involved in employee advocacy.