Instant Real Estate Lead Response with Gmail and Google Sheets

📋 HOW IT WORKS • Any website form (WordPress, Webflow, Typeform, Jotform, Zapier…) posts the enquiry to the webhook • The lead is normalized (any field names), validated and scored 0-100: phone, timeline, budget, property reference, financing keywords • It is saved in Google Sheets; repeat enquiries update the same row (stable Lead ID) • The lead instantly receives a personalized email for buying, selling (valuation offer) or renting, with your booking link • Hot leads trigger an alert to you; the form receives a JSON answer (invalid posts get HTTP 422) ⚙️ SETUP STEPS • About 10 minutes: create a Google Sheet with a "Leads" tab (columns below), import the workflow, connect Google Sheets and Gmail, fill the Config node (Sheet ID, agency, email, booking link), publish and paste the webhook URL into your form • Requires n8n 2.x (Cloud or self-hosted) and a Google account. No community nodes, no API keys ℹ️ ADDITIONAL INFORMATION • "Leads" tab header row: Lead ID,Last Enquiry At,Name,Email,Phone,Intent,Property Ref,Budget,Timeline,Preferred Areas,Min Bedrooms,Property Type,Message,Source,Score,Temperature,Status,Follow-up Step,Last Contact At,Next Follow-up At,Notes • Sticky-note documentation inside the workflow; email texts and scoring weights are easy to edit in one Code node • No credentials or personal data inside • Tested on n8n 2.41 with an automated test suite and a live run on real Google Sheets and Gmail • Part of the Real Estate Automation Kit (5 workflows) by the same seller