Respond instantly to real estate leads with Gmail and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Config (Edit Fields (Set)): sets 9 fields: googleSheetId, agencyName, agentName…
- Normalize and score lead (Code): runs custom JavaScript code
- Is the lead valid? (If): checks a condition and branches into true / false
- Save lead to Google Sheets (Google Sheets): append or update (sheet)
- Reject invalid lead (Respond to Webhook): sends the response back to the webhook caller
- Lead has an email? (If): checks a condition and branches into true / false
- Send instant reply to lead (Gmail): send (message)
- Is it a hot lead? (If): checks a condition and branches into true / false
- Alert agent about hot lead (Gmail): send (message)
- Confirm lead received (Respond to Webhook): sends the response back to the webhook caller
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail
From the author
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 1. Receives a lead submission…