Free template · Reporting & Analytics

Know who's actually closing. Reward them.

Tracks closes, conversions, response times per team member. Posts a weekly leaderboard. The recognition your top performers earn but never get because nobody runs the numbers.

Setup time~25 minutes
Run cost~$0.05/mo
ValidationTested + ready to run
LicenseFree, yours forever

One ranking. Two audiences.

  1. 1
    Schedule Trigger — every Sunday at 6pm
    Cron: 0 18 * * 0. Posts before Monday so reps and managers walk into the week with the standings already in their channel.
  2. 2
    Fetch Team Activity — HTTP Request
    Pulls one row per team member with closes, response time, leads worked, and conversion rate. Replace the URL with your CRM or PM tool (HubSpot, Salesforce, Follow Up Boss, ClickUp, Asana) and add your bearer token.
  3. 3
    Sample Team Data (replace this)
    Four sample reps with realistic numbers let the workflow run out of the box. Once Fetch Team Activity is wired up, delete this node.
  4. 4
    Calculate KPIs — Code
    JavaScript blends three metrics into one score: closes weighted 50%, conversion rate 30%, response speed 20%. Returns the ranked list, the top performer, the bottom performer, and team averages.
  5. 5
    Write Recognition + Coaching — OpenAI
    gpt-4o-mini writes two sections: warm public recognition naming the top rep's specific number, and a private coaching note for the manager naming the bottom rep's specific gap with one concrete thing to try next week.
  6. 6
    Post Leaderboard to Slack
    Posts the recognition note plus the full ranked list to your team channel. Names, closes, conversion percent, response time per rep.
  7. 7
    Email Manager — Gmail
    Sends the manager a separate email with the full standings and the private coaching note that did not go to Slack. Keeps the public channel positive while the manager gets the candid version.

Vertical-specific framing

Real estate team
Pulls per-agent activity from Follow Up Boss: showings booked, contracts signed, lead response time. Posts standings in the team channel Sunday night so the morning meeting is unnecessary.
Agency
Pulls account manager activity from HubSpot or ClickUp: contracts closed, projects moved forward, client response time. Manager gets the coaching note for the AM who is slipping before reviews.
Sales team
Pulls SDR or AE numbers from Salesforce: deals closed, deals advanced, time to first reply on inbound. Sales leader gets the coaching note privately so it does not become a public callout.
Inside sales / call center
Pulls call volume, talk time, and conversion from your dialer. Floor manager sees the leaderboard, supervisor sees the coaching note, reps see only the recognition.
Get the template
Three quick questions, then we send the JSON. We use the answers to recommend templates that fit your business.

No spam. Unsubscribe anytime. The JSON link arrives instantly after submit.

Four accounts. Free or close to it.

n8nFree self-hosted, or n8n Cloud starting $20/mo
OpenAI API keyPay-as-you-go, ~$0.0005 per run
Slack workspaceFree, OAuth for posting
Gmail or OutlookOAuth credentials for the manager email

What this is worth, conservatively

Revenue lift when productivity is publicly measured20 to 30% per rep
SourceGartner, Aberdeen
5-rep team at $250K avg revenue per rep$250K to $375K/yr lift
Time saved building scorecards by hand3 hrs/week
Cost to run this template forever~$3/year

Numbers from Gartner and Aberdeen research on transparent performance management. Real lift varies with team culture and follow-through on the coaching note.

Related

Want this customized to your stack?

If you'd rather have us connect this to your actual CRM or PM tool, set the score weights to match how your team actually wins, and hand it back working, that's our $9,000 reporting build. 2 to 4 weeks.

Book a 15-min walkthrough