AUTOMATION

Automated Deal Stage & Lead Lifecycle Status Routing Pipeline

The client lacked an automated way to handle post-qualification deal progression, leaving won, ghosted, and lost leads stagnating in their pipeline. By connecting custom Webhooks to a multi-branch Router in Make.com, incoming deal updates automatically trigger targeted multi-platform actions tailored specifically to Won, Ghosted/Re-engagement, or Lost lifecycle stages.

The Challenge

Managing deal stage transitions manually forced team members to update multiple disconnected platforms every time a deal changed status. Won deals required manual handover notifications, ghosted leads sat idle without structured re-engagement sequences, and lost leads went untracked, creating operational bottlenecks and inconsistent post-qualification outreach.

What We Did

We engineered an advanced Make.com automation scenario that intercepts incoming lead payloads, checks CRM records, and executes dedicated multi-channel workflows based on deal outcome filters.

Webhook Listener & Table Parsing: Receives real-time status updates via Webhooks, utilizing custom tool variables and a text parser to extract structured contact data from HTML tables. HubSpot Object Search & State Router: Searches HubSpot CRM for matching deal records and evaluates the stage via a 3-way router (Won, Ghosted/Re-engagement, Lost/Archived). Won Deal Onboarding Branch: Updates HubSpot, shifts ActiveCampaign deal stages, posts internal reminders in Slack, sends onboarding emails via Gmail, triggers SMS alerts through Twilio, and updates Google Sheets records. Ghosted Lead Re-engagement Branch: Updates HubSpot CRM, moves ActiveCampaign deal status, enrolls contacts in automated nurture sequences, adds subscribers to Mailchimp lists, dispatches follow-up SMS via Twilio, and logs the update to Google Sheets. Lost/Archived Deal Branch: Updates HubSpot and ActiveCampaign deal states, sends a close-out email via Gmail, and appends/updates archival logs in Google Sheets.

The Result

Eliminated manual status cross-posting across six different platforms. Deal stage changes now instantly execute their respective multi-channel onboarding, re-engagement, or archiving workflows, keeping sales pipelines accurate and team members notified in real time.

Tools used

  • Make.com

  • Webhooks by Make

  • Tools by Make

  • Text Parser by Make

  • Router by Make

  • HubSpot CRM

  • ActiveCampaign

  • Slack

  • Gmail

  • Twilio

  • Mailchimp

  • Google Sheets

Want a project like this?

Book a free consultation and we’ll show you what a strategy built for your business would look like.