Instant Lead Capture & Agent Alert System for Real Estate 

This automation captures new real estate leads, checks for duplicates, routes them to the right agent, saves them to a CRM, and instantly notifies the agent - all without manual intervention. 

Real estate agents typically check emails or form notifications manually to catch new leads, then manually enter them into a spreadsheet - a process prone to delays and typos. Leads can also get duplicated when entered more than once. This delay often means a lead loses interest or moves on to a competing agency before ever hearing back.  

An n8n-powered workflow that automatically captures leads the moment they come in, cleans and standardizes the data, checks for duplicates, routes the lead to the correct agent based on rules, saves it to a CRM, and sends an instant notification - with no manual steps required.  

New Lead (Webhook) → Data Normalization → Duplicate Check → Agent Routing → Save to CRM (Google Sheets) → Instant Notification (Telegram) → Confirmation Email (Gmail) 

• Automatic data normalization (name formatting, phone number standardization)

• Duplicate lead detection before saving

• Rule-based lead routing (agent assignment based on property budget)

• Real-time agent notification via Telegram

• Automatic lead confirmation email

• n8n

• Google Sheets

• Telegram Bot API

• Gmail

• Reduces manual data entry

• Significantly faster lead response, since agents are notified the instant a lead comes in

• Eliminates duplicate lead entries

• Leads reach the right agent automatically, without manual sorting

• Designed and built the complete workflow logic (from webhook to notification)

• Wrote data normalization expressions (name formatting, phone number standardization)

• Configured duplicate detection logic (Google Sheets lookup + conditional check)

• Set up rule-based agent routing

• Configured Telegram and Gmail integrations