{"product_id":"whatsapp-property-sales-agent-n8n-with-gemini-google-sheets","title":"WhatsApp Property Sales Agent (n8n) with Gemini \u0026 Google Sheets","description":"\u003ch3\u003eTurn WhatsApp property inquiries into instant, qualified leads—with n8n + Gemini + Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eWhatsApp Property Sales Agent (n8n)\u003c\/strong\u003e workflow automatically receives customer messages on WhatsApp, identifies the right broker and buyer in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates an AI reply using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, and sends qualified leads to the broker—plus it can support listing search and site visit booking via connected tools.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives WhatsApp messages\u003c\/strong\u003e using a \u003cstrong\u003eMeta WhatsApp webhook\u003c\/strong\u003e. It extracts the sender, the \u003cstrong\u003ephone number ID\u003c\/strong\u003e, and message text, while ignoring delivery\/read status events and non-text messages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches broker + buyer\u003c\/strong\u003e in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e by looking up the broker using the WhatsApp \u003cstrong\u003ePhone Number ID\u003c\/strong\u003e, and checking the \u003cstrong\u003eBuyers\u003c\/strong\u003e sheet for the sender’s phone number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates buyer records when new\u003c\/strong\u003e: if the buyer is new, the workflow appends a buyer row and sends \u003cstrong\u003eWhatsApp interactive quick-reply buttons\u003c\/strong\u003e (Buy Property, Rent Property, Book Site Visit).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates AI replies with Gemini\u003c\/strong\u003e (language-matching, short responses). If buyer handling is not paused, it can use Gemini with Google Sheets tools to \u003cem\u003esearch listings\u003c\/em\u003e, \u003cem\u003eupdate buyer requirements\u003c\/em\u003e, and \u003cem\u003ebook site visits\u003c\/em\u003e (triggering visit notifications and sending property media via a linked workflow).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and sends the response\u003c\/strong\u003e by sanitizing generated text (removing markdown\/symbols) and sending it through the \u003cstrong\u003eWhatsApp Cloud API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs conversations + qualifies leads\u003c\/strong\u003e: records messages and AI replies to a \u003cstrong\u003eConversation_Log\u003c\/strong\u003e sheet, then checks for qualification signals such as \u003cstrong\u003eBHK\u003c\/strong\u003e, \u003cstrong\u003ebudget\u003c\/strong\u003e, or \u003cstrong\u003elocation\u003c\/strong\u003e. Qualified leads trigger a \u003cstrong\u003eWhatsApp alert to the broker\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProperty teams receiving WhatsApp inquiries who want \u003cstrong\u003einstant AI responses\u003c\/strong\u003e and \u003cstrong\u003elead alerts\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eBrokerages using \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as a lightweight CRM to track buyers and conversation history.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building \u003cstrong\u003eWhatsApp-to-sales\u003c\/strong\u003e funnels with n8n, Gemini, and booking workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: if, code, no op, webhook, http request, Google Sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Meta WhatsApp webhook, WhatsApp Cloud API, Google Sheets, Google Gemini\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData outputs\u003c\/strong\u003e: Buyers sheet, Conversation_Log sheet, broker lead alerts\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45872783458483,"sku":"N8N-18496","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kOFqpMs-G6lr1ZCCIk_CI_UGyAeioC.png?v=1787216466","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-property-sales-agent-n8n-with-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}