Automated sales leaderboard with HighLevel CRM, GPT-4o, Notion & Slack

📘 Description: This workflow automates sales performance tracking and motivational updates by integrating HighLevel CRM, Notion, GPT-4o, and Slack. It pulls all deals from HighLevel, cleans and summarizes sales data per representative, creates performance dashboards in Notion, and uses GPT-powered AI to generate personalized motivational Slack messages. It eliminates manual leaderboard tracking and boosts sales engagement with real-time insights and daily motivation — ensuring every sales rep stays informed, recognized, and inspired.

What This Workflow Does (Step-by-Step) 🟢 Manual Trigger – Starts the automation manually for data refresh or testing.

📦 Fetch All Deals from HighLevel CRM – Retrieves all opportunities from HighLevel CRM, including deal names, reps, values, and stages for full visibility.

🔍 Validate Deal Fetch Success (IF Node) – Verifies that fetched data contains valid deal IDs. - ✅ True Path: Continues to data cleaning. - ❌ False Path: Logs failed records to Google Sheets for debugging.

🧹 Clean & Structure Deal Data – Normalizes raw deal data into a consistent schema (deal ID, rep ID, client name, value, status). Ensures clean inputs for analytics.

📊 Summarize Sales by Representative – Aggregates deals per sales rep and computes: - Total deals handled - Total deal value - Total deals won - Average deal value

🧾 Generate Notion Performance Dashboard – Creates personalized Notion dashboards for each rep with daily updated performance summaries and motivation metrics.

⚙️ Transform Data for AI Input – Converts summarized data into AI-readable format for GPT-4o processing.