{"product_id":"n8n-real-estate-lead-routing-gmail-google-sheets","title":"n8n Real Estate Lead Routing: Gmail + Google Sheets","description":"\u003ch3\u003eAutomatically route real estate inquiries—dedupe, score, notify, and escalate in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures property lead submissions from an n8n Form Trigger, checks Google Sheets for duplicates, scores and assigns the right agent, and uses Gmail to send confirmation, agent notifications, timed follow-ups, and escalation alerts when a lead remains uncontacted.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives new inquiry submissions\u003c\/b\u003e from an \u003cb\u003en8n Form Trigger\u003c\/b\u003e for a property inquiry.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eStandardizes fields\u003c\/b\u003e and checks \u003cb\u003eGoogle Sheets\u003c\/b\u003e for an existing lead by matching the \u003cb\u003ephone number\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePrevents duplicate leads\u003c\/b\u003e: if a matching phone number is found, it sends a \u003cb\u003erepeat-inquiry notification via Gmail\u003c\/b\u003e and stops.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eScores and prioritizes new leads\u003c\/b\u003e using the \u003cb\u003ebudget range\u003c\/b\u003e and \u003cb\u003eproject timeline\u003c\/b\u003e, then determines \u003cb\u003eagent assignment\u003c\/b\u003e (agent email included) based on \u003cb\u003epriority\u003c\/b\u003e and \u003cb\u003eservice type\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePersists the lead record\u003c\/b\u003e by appending the full lead (including \u003cb\u003eassignment\u003c\/b\u003e and \u003cb\u003escore\u003c\/b\u003e) to a \u003cb\u003eGoogle Sheets Leads\u003c\/b\u003e worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNotifies stakeholders\u003c\/b\u003e:\n    \u003cul\u003e\n      \u003cli\u003eSends a \u003cb\u003ecustomer confirmation email\u003c\/b\u003e via \u003cb\u003eGmail\u003c\/b\u003e.\u003c\/li\u003e\n      \u003cli\u003eEmails the \u003cb\u003eassigned agent\u003c\/b\u003e via \u003cb\u003eGmail\u003c\/b\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eTimed follow-up loop\u003c\/b\u003e:\n    \u003cul\u003e\n      \u003cli\u003eWaits \u003cb\u003e1 hour\u003c\/b\u003e, re-reads the lead in Google Sheets by \u003cb\u003eLead ID\u003c\/b\u003e, and if status is \u003cb\u003e“New Lead”\u003c\/b\u003e, emails a \u003cb\u003efollow-up reminder\u003c\/b\u003e to the agent.\u003c\/li\u003e\n      \u003cli\u003eWaits another \u003cb\u003e1 hour\u003c\/b\u003e, checks status again, and if still \u003cb\u003e“New Lead”\u003c\/b\u003e, updates the record to \u003cb\u003e“Escalated”\u003c\/b\u003e and emails an \u003cb\u003eescalation alert to the sales manager\u003c\/b\u003e via Gmail.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReal estate teams routing inbound leads from property inquiry forms to the correct agent based on priority.\u003c\/li\u003e\n  \u003cli\u003ePreventing duplicate outreach by deduping via phone number in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eEnsuring leads are actively worked through automated 1-hour and 2-hour reminders and escalation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n Form Trigger for lead intake\u003c\/li\u003e\n  \u003cli\u003eGoogle Sheets lookup and append to the \u003cb\u003eLeads\u003c\/b\u003e worksheet; status updates by \u003cb\u003eLead ID\u003c\/b\u003e\n\u003c\/li\u003e\n  \u003cli\u003eGmail OAuth2 for sending customer confirmations, agent notifications, follow-ups, and manager escalation\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic using nodes such as \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ewait\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003emerge\u003c\/b\u003e, and \u003cb\u003esticky note\u003c\/b\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eBuild faster real estate lead routing\u003c\/b\u003e with this n8n workflow—designed for practical deduplication, scoring, assignment, and accountable follow-up using Google Sheets and Gmail.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45891852468403,"sku":"N8N-18612","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/C6flxI5ZB-qbgkCVm1BRK_7lK8LGRC.png?v=1787562620","url":"https:\/\/buyflowscripts.com\/products\/n8n-real-estate-lead-routing-gmail-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}