Quick Overview
Quick Overview This workflow captures real estate leads from a Lovable webhook, stores them in Google Sheets, qualifies them via a Groq-powered AI agent, and uses Twilio WhatsApp messaging to route HOT/WARM/COLD leads into agent assignment, property matching, and nurture follow-ups. How it works Receives a POST webhook request from a Lovable form submission and responds with “OK”. Appends the incoming lead details to a Google Sheets “Leads” sheet. Sends an initial WhatsApp greeting via Twilio and passes the message to an AI agent using Groq with conversation memory. Extracts the AI reply and parses an embedded JSON block to determine whether the lead is qualified and what score/criteria (intent, budget, location, timeline) were captured. If qualified, sends the AI’s reply to the lead via Twilio and updates the lead record in Google Sheets with the extracted qualification fields, score, and probability/value. Routes qualified leads by score: HOT assigns an available agent from Google Sheets and notifies them plus sends a 1-hour reminder, WARM sends day 1 and day 5 follow-ups after a 2-day wait, and COLD sends a nurture message. For HOT leads, also loads properties from Google Sheets, matches up to three listings to the lead’s budget and location, and sends an intro plus property cards and booking message via Twilio before updating the lead stage in Google Sheets. Setup Create and publish the Lovable form/webhook integration, then copy the n8n webhook URL for the real-estate-lead path into Lovable. Connect Google Sheets OAuth credentials and update the spreadsheet ID and sheet names/IDs for the Leads, Agents, and Properties reads/writes. Connect Twilio credentials and configure a WhatsApp-enabled Twilio sender plus the message “to”/“from” fields used in each Twilio message step. Add Groq credentials for the LangChain Groq Chat Model and adjust the AI agent system instructions if you want different qualification rules or output JSON fields. Ensure your Google Sheets tabs include the columns referenced by the workflow (for example Availability/Lead Count/Agent Name/Phone in Agents, and Price (₦)/Location/Image URL/WhatsApp Link in Properties). An n8n automation workflow template by Chijioke Ogbonna.
Chijioke Ogbonna
web
free
Others in the same category, ranked by how often they are opened.
