Real Estate Follow-Up Automation: Google Sheets + Gmail

Automate real estate follow-ups every weekday with Google Sheets + Gmail

This Real Estate Follow-Up Automation workflow automatically checks your real estate leads in Google Sheets every weekday at 9am, sends the correct next follow-up email through Gmail, and updates each lead’s row with the new follow-up step and next due date—so you never miss a scheduled outreach.

What this workflow does

• Scheduled run: Executes every weekday at 9am using an n8n schedule trigger.
• Reads leads: Pulls lead rows from the Google Sheets tab named “Leads”.
• Determines who is due: Checks each lead’s Status, Last Contact (Last Contact At/Last Enquiry At), and Follow-up Step against your configured follow-up day sequence.
• Skips stop statuses: Leaves out leads in stop statuses (for example “replied” or “unsubscribed”).
• Builds personalized HTML email: Generates a tailored follow-up email using the lead’s Intent (buy/sell/rent) and includes your booking link and unsubscribe text.
• Sends via Gmail: Sends each due email using the configured Gmail mailbox.
• Updates the lead: Writes back the new status, increments Follow-up Step, records the last contact timestamp, and sets the next follow-up date.

Use cases

• Keep consistent follow-up cadences for property buy/sell/rent enquiries without manual checking.
• Automatically resume outreach at the right time based on intent, last contact timing, and follow-up sequence.
• Enforce email hygiene by preventing follow-ups for replied/unsubscribed leads.

Technical details

• Triggers: Schedule Trigger (weekday at 9am)
• Data source: Google Sheets (reads from “Leads” using your Spreadsheet ID)
• Email sending: Gmail node (sends HTML follow-up emails)
• Logic: Set + Code nodes to evaluate follow-up steps, stop statuses, email limits per run, and to update rows
• Notes/documentation: Sticky Note nodes for workflow guidance

Ideal for n8n users, automation engineers, and SaaS operators running a real estate lead follow-up automation with Google Sheets and Gmail.