Lead triage system that receives inbound submissions via webhook, classifies them with OpenAI, computes timing context, and routes each lead into OUT OF SCOPE, CRITICAL, or STANDARD branches with dedicated Google Sheets logging and email notifications.
Make · workflow canvasproduction build
Context
The team received many unstructured leads and needed a fast, consistent way to separate high‑urgency or out‑of‑scope queries from standard opportunities while keeping records and notifications logically segregated.
Approach
Built a single Make.com scenario that starts with a custom webhook, runs lead classification and JSON parsing, calculates days until start, then routes each lead through a router into OUT OF SCOPE, CRITICAL, or STANDARD branches, each of which logs to its own Google Sheets tab and sends the appropriate email or error alert.
Architecture
Custom webhook (Zephyr Lead Intake)
OpenAI categorization
JSON parsing
Calculate Days Until Start
Router
OUT OF SCOPE: Google Sheets log + error/notice email
