Gmail Property Enquiry Auto-Reply with GPT-4o + Google Sheets

Instant Gmail property enquiry replies—auto-drafted with GPT-4o and matched to your Google Sheets listings

This n8n workflow scans your Gmail inbox for new property enquiries, extracts key details with GPT-4o, matches each enquiry to the right property in Google Sheets, logs everything, and then either creates a threaded Gmail draft for approval or auto-sends a safe, personalised reply.

What this workflow does

• Polls Gmail every minute (or runs manually using a test message) and lists unread emails.
• Deduplicates by message ID, fetches each full email via the Gmail API, and parses headers and body text.
• Filters out non-enquiry emails by classifying the enquiry source (Rightmove, Zoopla, OnTheMarket, SpareRoom, or website) and dropping admin/irrelevant messages.
• Uses OpenAI (GPT-4o) to extract structured contact, property, and qualification details, normalises the data, and detects which qualification fields are missing.
• Matches to your property catalogue by searching the Properties tab in Google Sheets (by reference or address), determines availability, and prepares a pre-qualification link or suggests similar properties.
• Generates a personalised HTML reply that acknowledges already-provided details and follows the correct call-to-action.
• Logs outcomes to the Enquiry Log tab in Google Sheets and either creates a Gmail thread draft for staff approval or auto-sends the reply and marks the original email as read.

Use cases

• Reduce response times for Rightmove / Zoopla / OnTheMarket enquiries without missing qualification details.
• Automate consistent pre-qualification follow-ups for website enquiries.
• Give your team an approval queue via threaded Gmail drafts while keeping your Google Sheets enquiry history up to date.

Technical details

• n8n workflow using: if, code, sticky note, http request, google sheets, manual trigger.
• Integrations: Gmail OAuth2 (Gmail API), OpenAI GPT-4o, and Google Sheets (Properties + Enquiry Log tabs).
• Requires an OAuth2 Gmail credential configured for the mailbox you want to monitor.