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

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.