Score HubSpot deal conversion risk with OpenAI and Slack alerts

How it works

This workflow runs daily to review all active deals and evaluate their likelihood of closing successfully. It enriches deal data with recent engagement activity and applies AI-based behavioral scoring to predict conversion probability. High-risk or stalled deals are flagged automatically. Actionable alerts are sent to the sales team, and all analysis is logged for forecasting and tracking.

Step-by-step

• Trigger and fetch deals

  • Schedule Trigger – Runs the workflow automatically at a fixed time each day.
  • Get Active Deals from HubSpot – Retrieves all open, non-closed deals with key properties.
  • Formatting Data – Normalizes deal fields such as value, stage, age, contacts, and activity dates.

• Enrich deals with engagement data

  • If – Filters only active deals for further processing.
  • Loop Over Items – Processes each deal individually.
  • HTTP Request – Fetches engagement associations for the current deal.
  • Get an engagement – Retrieves detailed engagement records from HubSpot.
  • Extracts Data – Structures engagement content, timestamps, and metadata for analysis.

• Analyze risk, alert, and store results

  • OpenAI Chat Model – Provides the language model used for analysis.
    • AI Agent – Evaluates behavioral signals, predicts conversion probability, and recommends actions.
  • Format Data – Parses AI output into structured, machine-readable fields.
  • Filter Alerts Needed – Identifies deals that need immediate attention.
  • Send Slack Alert – Sends detailed alerts for high-risk or stalled deals.
  • Append or update row in sheet – Logs analysis results into Google Sheets for reporting.

Why use this?

• Automatically identify high-risk deals before they stall or fail
• Give sales teams clear, data-driven next actions instead of raw CRM data
• Improve forecasting accuracy with AI-powered probability scoring
• Maintain a historical deal health log for audits and performance reviews
• Reduce manual pipeline reviews while increasing response speed