Monitor HubSpot deal risk with OpenAI scoring and Slack alerts

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