Qualify open house leads and send AI follow-ups with Google Sheets and Gmail
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 AI workflow has 10 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets, Google Gemini Chat Model, Gmail and Slack.
How it runs
Trigger: On Google Sheets events (row added).
- Extract Visitor Details (Edit Fields (Set)): sets 8 fields: visitorName, visitorEmail, visitorPhone…
- Qualify & Draft Follow-Up (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- Parse AI Output (Code): runs custom JavaScript code
- Send Visitor Follow-Up Email (Gmail): uses Gmail
- Log to Open House Sheet (Google Sheets): append
- Is Lead Hot? (If): checks a condition and branches into true / false
- Notify Agent via Slack (Slack): uses Slack
- Notify Agent — Hot Lead (Gmail): uses Gmail
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 (9)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack
From the author
Quick overview When a visitor signs in at your open house, this workflow instantly scores their buying intent using Gemini AI, sends a personalized follow-up email via Gmail, logs every visitor to Google Sheets, and alerts the agent for hot leads only. How it…