Luxury property lead workflow that normalizes new lead submissions from Google Sheets, classifies them as VIP ($2.5M+ budget) or standard, checks Airtable for duplicates, updates existing records or creates new ones, merges results, sends Slack VIP Platinum alerts to the founder for VIP leads, and includes a workflow error trigger that posts Slack admin alerts on failures.
n8n · workflow canvasproduction build
Context
A luxury real estate team needed to automatically distinguish VIP leads with high budgets from standard leads, prevent duplicate CRM records, and escalate VIP Platinum leads to the founder immediately while maintaining accurate Airtable records.
Approach
Built a two-part n8n workflow system with a Google Sheets lead intake trigger and a workflow error trigger. The main flow normalizes lead data, checks whether the budget exceeds $2.5M to route VIP or standard leads, loops each category through Airtable duplicate searches, updates existing records or creates new ones accordingly, merges the record results, and sends Slack VIP Platinum alerts to the founder for VIP leads; the error trigger posts Slack admin alerts on pipeline failures.
Architecture
Workflow 1
New Lead Submission (Google Sheets)
Set: Normalize Lead Data
If: Is VIP Budget? (> $2.5M)
Yes: Loop: VIP Leads
Airtable: Search Existing Lead (VIP)
If: Does VIP Lead Exist?
Existing: Airtable: Update Existing VIP Lead
Merge: VIP Record Result
Slack: VIP Platinum Alert
New
Airtable: Create VIP Lead Record
Merge: VIP Record Result
Slack: VIP Platinum Alert
No
Loop: Standard Leads
Airtable: Search Existing Lead (Standard)
If: Standard Lead Exist?
Existing: Airtable: Update Existing Standard Lead
Merge: Standard Record Result
New
Airtable: Create Standard Lead Record
Merge: Standard Record Result. Workflow 2: Workflow Error Trigger
