Revive expired real estate listings with OpenAI and Gmail follow-ups
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 5 nodes and runs on a schedule (every 30 days). Along the way it connects Google Sheets, Gmail and OpenAI.
How it runs
Trigger: On a schedule (every 30 days).
- Get Listings (Google Sheets): uses Google Sheets
- Check >30 Days (If): checks a condition and branches into true / false
- OpenAI: uses OpenAI
- Send Email (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 (5)
- Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
How it works 1. This automation helps revive expired property listings by: 2. Reading listing data from a Google Sheet that tracks all properties. 3. Filtering listings where the lastactivity date is older than 30 days. 4. Generating a personalized email…