Monitor HubSpot deal risk with OpenAI scoring and Slack alerts Workflow Solution

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building.

How it works This workflow runs on a daily schedule to analyze all active HubSpot deals and their latest engagement activity. It applies AI-driven behavioral scoring to predict conversion probability and deal health. High-risk or stalled deals automatically trigger Slack alerts. All insights are logged in Google Sheets for forecasting and performance tracking. Step-by-step Step 1 – Trigger and collect active deals** Schedule Trigger – Runs the workflow automatically at a fixed time each day. Get Active Deals from HubSpot – Retrieves all non-closed deals with key properties like value, stage, and activity dates. Formatting Data – Cleans and normalizes deal data while calculating metrics such as deal age and inactivity duration. Step 2 – Enrich deals with engagement data** If – Filters only active deals to ensure closed deals are excluded. Loop Over Items – Processes each deal individually to handle enrichment safely. HTTP Request – Fetches engagement associations linked to each deal. Get an engagement – Retrieves detailed engagement records from HubSpot. Extracts Data – Structures engagement content, timestamps, and internal notes for AI analysis. Step 3 – Analyze risk and notify the team** AI Agent – Analyzes behavioral signals and predicts conversion probability, risk level, and next actions. Format Data – Parses the AI output into structured fields and risk indicators. Filter Alerts Needed – Identifies deals that require immediate attention. Send Slack Alert – Sends a detailed alert with risks, signals, and recommended actions. Append or update row in sheet – Stores analysis results in Google Sheets for tracking and forecasting. Why use this? Detect deal risk early using consistent, AI-based analysis Reduce manual pipeline reviews for sales managers Provide clear, actionable next steps to sales reps Keep a historical log of deal health and forecasts Improve close rates through timely, data-driven intervention

Best fit

Need another direction?