Revive Expired Real Estate Listings with OpenAI and Gmail Follow-ups

Description

How it works
This automation helps revive expired property listings by:
Reading listing data from a Google Sheet that tracks all properties.
Filtering listings where the last_activity date is older than 30 days.
Generating a personalized email using OpenAI (GPT-4) to re-engage the owner.
Sending the email to the property owner using Gmail or SMTP.
(Optional): Updating the listing's status to followed_up in the Sheet once the email is sent.
This workflow ensures no opportunity is missed by proactively reactivating cold leads.

Set Up Steps
Prepare your Google Sheet
Create a Google Sheet with these columns:
title, owner_name, email, property_type, location, last_activity
Fill in sample data for testing.

Connect Google Sheets in n8n
Add a Google Sheets node.
Use the "Read Rows" operation to load the listing data.

Filter listings inactive for 30+ days
Use a Set node to convert last_activity to a Date.
Add an IF node or Code node to check if the listing is older than 30 days.

Generate email content with OpenAI
Add an OpenAI node.
Use dynamic input (e.g. owner name, property type) to create a follow-up message.

Send the email
Add a Gmail node or SMTP node to send the email to the property owner.

(Optional) Update status
Use a Google Sheets "Update Row" node to change the listing's status to followed_up.

Test the full workflow
Manually trigger the workflow or schedule it to run daily/weekly.