Reply to property enquiries with Gmail, Google Sheets and GPT-4o
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 20 nodes and runs on Gmail events (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Google Sheets and Gmail.
How it runs
Trigger: On Gmail events (plus 1 other trigger).
- Classify Enquiry Source (Code): runs custom JavaScript code
- Generate Test Enquiry (Code): runs custom JavaScript code
- Extract Enquiry Fields (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Extraction Model
- Normalise Fields and Detect Gaps (Code): runs custom JavaScript code
- Read Properties Sheet (Google Sheets): uses Google Sheets
- Match Property and Build Links (Code): runs custom JavaScript code
- Generate AI Draft Reply (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Draft Model
- Prepare WhatsApp Message (Code): runs custom JavaScript code
- Build Branded Email (Code): runs custom JavaScript code
- Send WhatsApp Template Message (HTTP Request): calls an HTTP API (POST)
…plus 6 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.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Watch Inbox for New Enquiries).
Nodes used (10)
- Code
n8n-nodes-base.code - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - If
n8n-nodes-base.if - Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Gmail Trigger
n8n-nodes-base.gmailTrigger - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow polls a Gmail inbox for new property enquiries, uses OpenAI (GPT-4o) to extract applicant details and draft a personalised reply, matches the enquiry to a property list in Google Sheets, logs each enquiry, and either creates a…