<aside>

Goal: To automatically classify leads based on predefined logic and send personalized onboarding emails tailored to their status (e.g., HOT/VIP or General).

Problem: Manually sorting leads and writing emails takes time, introduces delays, and risks missing high-priority contacts.

Solution: Automated flow using Zapier and Python to:

• Instantly classify incoming lead data
• Route them through dynamic email sequences
• Eliminate manual work while improving responsiveness and personalization

🔹 Step 1 – Trigger: Webhook by Zapier receives booking form data or webhook POST payload.

🔹 Step 2 – Action: Code by Zapier (Python) parses + flattens JSON and sets lead_status = hot/cold based on rules.

Python Script: https://github.com/AlvLeoAI/zapier/blob/main/qualifier_parser.py

🔹 Step 3 – Action: Paths by Zapier splits flow based on lead_status.

🔹 Step 4 – Action: Path for HOT/VIP leads (e.g., Keeton, VIP tag, Gmail), sends premium onboarding message via Gmail.

🔹 Step 5 – Action: Gmail sends personalized email + booking link.

🔹 Step 6 – Action: Path for cold/general leads — sends warmer nurturing message.

🔹 Step 7 – Action: Gmail sends alternative message with optional future booking CTA.

Tools Used:

• Zapier (core automation)
• Python (Zapier Code block) – data processing + logic
• Gmail (personalized comms)
• Postman (test payloads)
• JSON Prompt Builder (simulation/formatting)

Impact:

• Replaces manual classification & email writing
• Responds to leads in real-time based on business logic
• Improves lead conversion by prioritizing hot leads
• Demonstrates advanced logic, conditional flows, and custom code integration within Zapier </aside>