n8n Property Enquiry Qualifier: OpenAI Scoring + Calendar Booking

Turn property enquiries into qualified leads—and offer real viewing times automatically

n8n Property Enquiry Qualifier: OpenAI Scoring + Calendar Booking instantly processes incoming property leads from a webhook, uses OpenAI to extract intent and readiness, matches the brief against listings in Google Sheets, and—when the lead is ready—proposes viewing slots and creates a tentative Google Calendar event. The workflow then updates HubSpot, notifies Slack, and logs everything in Google Sheets.

What this workflow does

• Receives enquiries via a POST webhook and normalizes the payload (name, email, E.164 phone, message, and extra fields).
• Uses OpenAI to extract requirements such as budget, bedrooms, areas, finance/chain status, and produces a readiness score. Includes a manual-review fallback if AI fails.
• Scores listings from Google Sheets against the extracted brief, selecting up to three best matches and assigning a verdict: VIEWING, NURTURE, WATCH, or UNSCORED.
• If verdict is VIEWING: checks Google Calendar availability for the next week, proposes two free viewing slots within working hours, and creates a tentative calendar event for the top-matched property.
• If enabled and a phone number exists: sends the viewing slots via a WhatsApp Business template message.
• Upserts the applicant into HubSpot with enquiry details, readiness score, verdict, summary, and references to matched properties.
• Notifies Slack with a formatted summary and appends an enquiry log to a Google Sheets spreadsheet.

Use cases

• Qualify every property enquiry automatically and route leads by readiness (VIEWING vs NURTURE vs WATCH).
• Auto-schedule tentatively and send WhatsApp booking options to prospects with valid E.164 numbers.
• Maintain a complete, searchable CRM + audit trail in HubSpot and Google Sheets while keeping staff updated in Slack.

Technical details

• Webhook in n8n for incoming enquiries
• OpenAI for requirement extraction + readiness scoring
• Google Sheets (OAuth2) for property matching + enquiry logging
• Google Calendar for availability checks and tentative event creation
• HubSpot for contact upserts (app token)
• Slack for workflow summaries
• Workflow logic using nodes such as if, set, code, and no op