Qualify property enquiries with OpenAI and book viewings via Google Calendar, WhatsApp, and HubSpot
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI Chat Model, Google Sheets, Google Calendar and WhatsApp Business Cloud and 2 more.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Agency Settings (Edit Fields (Set)): sets 18 fields: agencyDescription, viewingThreshold, nurtureThreshold…
- Normalise The Enquiry (Code): runs custom JavaScript code
- Extract The Property Intent (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Shape The Buyer Brief (Code): runs custom JavaScript code
- Fall Back To Manual Review (Edit Fields (Set)): sets 3 fields: output, ai_status, ai_error
- Load The Available Properties (Google Sheets): read (sheet)
- Match Properties To The Brief (Code): runs custom JavaScript code
- Is The Applicant Ready To View? (If): checks a condition and branches into true / false
- Read The Viewing Diary (Google Calendar): get many (event)
- Put Them On The Follow Up List (Edit Fields (Set)): sets 2 fields: follow_up_on, follow_up_reason
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Google Calendar
n8n-nodes-base.googleCalendar - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - HubSpot
n8n-nodes-base.hubspot - Slack
n8n-nodes-base.slack - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow receives property enquiries via webhook, uses OpenAI to extract intent and score readiness, matches the brief against properties in Google Sheets, and then routes outcomes to Google Calendar, WhatsApp, HubSpot, Slack, and an…