Capture Gmail website leads in Google Sheets with internal email alerts
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 15 nodes and runs on Gmail events. Along the way it connects Gmail and Google Sheets.
How it runs
Trigger: On Gmail events.
- Extract Classify And Score Lead (Code): runs custom JavaScript code
- Has Email Address? (If): checks a condition and branches into true / false
- Find Existing Lead (Google Sheets): uses Google Sheets
- Alert Missing Email (Gmail): uses Gmail
- Prepare CRM Record (Edit Fields (Set)): sets 18 fields: createdAt, name, email…
- Is Duplicate Lead? (If): checks a condition and branches into true / false
- Send Duplicate Lead Alert (Gmail): uses Gmail
- Add Lead To CRM Sheet (Google Sheets): append
- Send Personalized Auto Reply (Gmail): uses Gmail
- Create Activity Log Entry (Google Sheets): append
…plus 4 more steps. See the full node list below.
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.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (New Real Estate Inquiry).
Nodes used (7)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch
From the author
Quick overview Qualify Real Estate Leads From Gmail And Build A Google Sheets Mini CRM Automatically classify real estate inquiries from Gmail, score lead urgency, prevent duplicate records, save new leads to Google Sheets, create an activity log, send…