Real Estate Lead Response Workflow: Gmail + Google Sheets

Instant real estate lead responses with Gmail + Google Sheets

This Real Estate Lead Response Workflow: Gmail + Google Sheets automatically receives property enquiries via a webhook, validates and scores each lead, stores it in a Google Sheet, and sends a personalized Gmail reply—plus a hot-lead alert to your agent.

What this workflow does

• Receives leads via an n8n Webhook (HTTP POST) from your website form or lead source.
• Normalizes and validates input: it validates that an email or phone is present and structures the lead data consistently.
• Classifies intent and scores the lead (buy/sell/rent/other) and calculates a 0–100 score, including prepared reply and alert email content.
• Rejects invalid leads: if validation fails, it returns a 422 JSON response listing the validation errors.
• Upserts the lead in Google Sheets: it appends or updates the lead in the “Leads” tab using a stable Lead ID as the matching key.
• Sends an instant Gmail reply to the lead when a valid email address is included.
• Alerts your agent for hot leads: if the lead score meets the hot threshold, it sends a hot-lead alert via Gmail and returns a 200 JSON response with leadId, score, and temperature.

Use cases

• A property inquiry form posts to the webhook, and the lead gets an immediate email response.
• Your team tracks every enquiry in Google Sheets “Leads”, updating records by Lead ID.
• High-intent enquiries trigger a hot lead notification so agents can act fast.

Technical details

• Nodes/blocks used: webhook, if, set, code, gmail, sticky note
• Integrations: Google Sheets OAuth + Gmail OAuth
• Configuration: Google Sheet ID, “Leads” tab name, agency/agent details, booking link, currency symbol, and hot/warm score thresholds.

Ideal for n8n users, automation engineers, and SaaS operators who want a reliable real estate lead response workflow with Gmail and Google Sheets.