Re-engage dormant real estate leads with Google Sheets, Gemini 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 12 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets, Google Gemini Chat Model, Gmail and Slack.
How it runs
Trigger: On a schedule (every day at 08:00).
- Fetch All Leads (Google Sheets): uses Google Sheets
- Filter: Dormant Leads Only (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model
- Parse AI Output (Code): runs custom JavaScript code
- Send Re-Engagement Email (Gmail): uses Gmail
- Update Lead Record (Google Sheets): update
- Aggregate Run Results (Code): runs custom JavaScript code
- Send Summary Digest Email (Gmail): uses Gmail
- Send Summary to Slack (Slack): uses Slack
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 (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow runs daily to find dormant real estate leads in Google Sheets, uses Google Gemini to draft personalized winback emails, sends them via Gmail, updates the lead records, and then posts a run summary digest to Gmail and optionally to…