Revive expired real estate listings with OpenAI and Gmail follow-ups

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 using OpenAI (GPT-4) to re-engage the owner. 5. Sending the email to the property owner using Gmail or SMTP. 6. (Optional): Updating the listing's status to followedup in the Sheet once the email is sent. 7. This workflow ensures no opportunity is missed by proactively reactivating cold leads.

Set Up Steps 1. Prepare your Google Sheet - Create a Google Sheet with these columns: - title, ownername, email, propertytype, location, lastactivity - Fill in sample data for testing.

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

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

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

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

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

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