Respond to real estate leads with Gmail and Google Sheets

Description

Quick Overview This workflow receives real estate enquiries via a webhook, normalizes and scores them, saves or updates the lead in Google Sheets, and sends automated Gmail replies plus a hot-lead alert to the agent. How it works Receives a lead submission via an HTTP POST webhook. Normalizes incoming fields, validates that an email or phone is present, classifies intent (buy/sell/rent/other), calculates a 0–100 score, and prepares reply and alert email content. Rejects invalid leads with a 422 JSON response listing validation errors. Appends or updates the lead in a Google Sheets “Leads” tab using a stable Lead ID as the matching key. If the lead includes a valid email address, sends an instant personalized reply to the lead via Gmail. If the lead score meets the hot threshold, sends an alert email to the agent via Gmail, then returns a 200 JSON response with the leadId, score, and temperature. Setup Add Google Sheets OAuth credentials and set the Google Sheet ID and “Leads” sheet/tab name used to store leads. Add Gmail OAuth credentials for the mailbox that sends the lead reply and the agent hot-lead alert. Update the configuration values (agency name, agent name/email/phone, booking link, currency symbol, and hot/warm score thresholds). Copy the webhook URL from n8n and configure your website form/lead source to POST the lead payload to that endpoint. An n8n automation workflow template by Christophe REVOIRE.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets
• gmail
• code

Capabilities

• 3 nodes

Information