{"product_id":"ai-whatsapp-lead-qualifier-for-real-estate-with-gemini-airtable-calendar","title":"AI WhatsApp Lead Qualifier for Real Estate with Gemini, Airtable \u0026 Calendar","description":"\u003ch3\u003eQualify Real Estate Leads on WhatsApp—Automatically with Gemini, Airtable \u0026amp; Google Calendar\u003c\/h3\u003e\n\u003cp\u003eTurn incoming WhatsApp messages into actionable real estate leads. This n8n workflow uses an AI WhatsApp assistant to answer property questions from a live Airtable database, classify leads as \u003cstrong\u003ehot\u003c\/strong\u003e, \u003cstrong\u003ewarm\u003c\/strong\u003e, or \u003cstrong\u003ecold\u003c\/strong\u003e, and check \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e availability before helping book viewings—escalating to a human agent only when it’s time.\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 via a WhatsApp Trigger when customers send a text or voice note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes and processes input\u003c\/strong\u003e: text messages are handled directly; voice notes are downloaded and \u003cstrong\u003etranscribed using Google Gemini\u003c\/strong\u003e first.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnswers from your live listings\u003c\/strong\u003e by querying \u003cstrong\u003eAirtable\u003c\/strong\u003e (your selected Properties base and table) to look up real property data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks scheduling availability\u003c\/strong\u003e using \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e before proposing or preparing viewing times.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns structured results\u003c\/strong\u003e with a reply plus lead status (hot\/warm\/cold) and whether \u003cstrong\u003eescalation\u003c\/strong\u003e to a human is needed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the reply back to the customer\u003c\/strong\u003e and \u003cstrong\u003elogs the lead to Google Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies your agent when ready\u003c\/strong\u003e for hot leads (duplicate alerts prevented). If the AI fails, the customer still receives a fallback reply while the developer is alerted separately.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA prospect asks about availability, pricing, or features—your AI answers instantly from Airtable.\u003c\/li\u003e\n  \u003cli\u003eA voice note comes in with viewing intent—Gemini transcribes, qualifies the lead, then checks Calendar availability.\u003c\/li\u003e\n  \u003cli\u003eHot leads trigger a human notification, while warm\/cold inquiries continue automated follow-up logic.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp Business Cloud API\u003c\/strong\u003e: WhatsApp Trigger, Send WhatsApp Reply, Notify Agent, and Send Unsupported Notice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e: Gemini Chat Model and Analyze Audio for voice transcription.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAirtable\u003c\/strong\u003e: search_properties tool using your Properties base\/table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e: availability checks for viewings.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses nodes such as \u003cstrong\u003eif, set, code, switch,\u003c\/strong\u003e and \u003cstrong\u003esticky note\u003c\/strong\u003e, plus structured output parsing.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938280104115,"sku":"N8N-18998","price":71.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/798ZWWobu5VormUKcH2b__TmkMkeqz.png?v=1788341156","url":"https:\/\/buyflowscripts.com\/products\/ai-whatsapp-lead-qualifier-for-real-estate-with-gemini-airtable-calendar","provider":"N8N Commerce","version":"1.0","type":"link"}