Lead Qualification System

3. AI Lead Qualification & CRM Sync Pipeline

Parses incoming unstructured lead messages, qualifies them against custom budget logic using Gemini LLM, logs contact records to Google Sheets, and dispatches Telegram notifications.

⚙️ Workflow Architecture & Node Breakdown

Chat / Webhook Triggers: Captures raw lead inquiries from chat widgets or web forms.

Basic LLM Chain Node: Instructs Gemini LLM to parse unstructured text, extract contact parameters (Name, Email, Phone), and evaluate budget parameters.

Google Gemini Model: Processes inputs and outputs structured JSON metadata containing qualification statuses and summaries.

If / Router Node: Evaluates the extracted JSON to route QUALIFIED leads to instant team alerts.

Google Sheets Node: Appends structured contact details, qualification rationale, and Riyadh timestamps (Asia/Riyadh) into a Google Sheets CRM log.

Telegram Node: Dispatches structured priority alerts to Telegram channels for high-value qualified leads.