AI-Powered WhatsApp Property Agent: Automate Sales with Google Sheets

Transform your WhatsApp Business into an intelligent property sales machine that works around the clock. This AI-powered workflow automatically handles customer inquiries, searches your Google Sheets property inventory in real-time, and delivers instant responses with relevant listings and PDF brochures.

What this workflow does

When customers message your WhatsApp Business number asking about properties, budgets, or availability, the workflow springs into action. A GPT-4o-mini AI agent processes each inquiry and searches your Google Sheets inventory using dedicated Tool nodes for different property blocks or categories. The AI instantly replies with matching property details tailored to the customer's requirements.

Smart automation takes it further: a JavaScript Code node extracts Property IDs from the agent's responses using regex patterns, while a Switch node validates the results. When a specific property is discussed, the system automatically retrieves and sends the corresponding PDF brochure from your MASTER sheet. Simultaneously, your sales team receives live lead notifications containing the customer's name, WhatsApp number, and their complete inquiry.

Window Buffer Memory ensures contextual conversations by remembering previous interactions within each customer session, creating a natural dialogue flow.

Use cases

• Real estate agencies handling high-volume property inquiries across multiple developments
• Property developers showcasing new projects with instant brochure delivery
• Rental companies managing apartment availability and pricing queries
• Commercial real estate firms qualifying leads outside business hours

Technical details

This n8n workflow integrates WhatsApp Business API for messaging, OpenAI's GPT-4o-mini for intelligent responses, and Google Sheets for property data management. Key nodes include Set nodes for data preparation, Code nodes for property ID extraction, Switch nodes for conditional logic, and multiple Google Sheets nodes organized by property categories.

Setup requires WhatsApp Business API credentials, OpenAI API access, and Google Sheets OAuth2 authentication. The workflow scales efficiently across multiple property portfolios while maintaining conversation context and delivering instant customer service.