Real Estate
Lead Management System

The agency was generating enquiries from four different channels and losing most of them to slow response times.

Property buyers move fast. When someone sends a DM asking about a listing, they have usually already messaged two or three other agents. The first to respond with useful information wins the conversation. The agency knew this, but their process could not keep up. Leads came in across Instagram, Facebook, WhatsApp, and the website. Someone on the team checked each channel separately, wrote manual replies, attempted to book viewings over back-and-forth messages, and kept records in a spreadsheet that was always slightly out of date.

Beyond the initial response problem, there was no system for what happened after the first contact. Cold leads who did not book immediately were forgotten. New listings went out as manual posts with no connection to the existing lead database. Agents started each morning with no structured view of who needed attention that day.

Five separate problems. Five workflows. One Airtable base holding everything together.

The first thing I established in the discovery session was that this was not one automation problem. It was five distinct operational failures that happened to share a lead database. Trying to solve them in a single monolithic workflow would have produced something fragile and impossible to maintain. I scoped five modular workflows with Airtable as the shared data layer between them.

The AI qualification logic required careful prompt design. Real estate enquiries are varied. Some people know exactly what they want. Others are exploratory. A scoring model that applied rigid criteria would route good leads incorrectly. I built a confidence threshold into the qualification workflow so that genuinely ambiguous leads were escalated to a human rather than misclassified by the AI. The system was designed to know what it did not know.

The cold lead reactivation workflow was the piece the client had not asked for but needed most. A lead that does not book a viewing in week one is not necessarily dead. Thirty days later, their situation may have changed. A well-timed, personalised message to a cold lead costs nothing and converts at a meaningful rate. I built that in from the start.

Five workflows covering the full lead lifecycle from first contact to cold reactivation.

• 01
  Multi-channel lead capture and AI qualification

  Webhooks on Instagram, Facebook, WhatsApp Business API, and the website contact form all feed into the first workflow. Every inbound message is passed to OpenAI for qualification: the AI assesses property type interest, budget signals, urgency, and buyer readiness. HOT leads receive a personalised response with a Cal.com viewing booking link within 90 seconds. Ambiguous leads trigger a human escalation flag in Airtable. All leads are logged with the full message, channel, qualification score, and timestamp.
• 02
  Automated viewing booking and confirmation

  When a lead books a viewing via Cal.com, the booking triggers workflow two. It creates an Airtable record, sends a branded confirmation email via Gmail with property details and viewing instructions, and sets a post-viewing follow-up task 24 hours after the scheduled time. The agent receives a morning summary of all viewings booked for the day without needing to check Cal.com manually.
• 03
  Post-viewing follow-up sequence

  Twenty-four hours after each viewing, an automated follow-up email goes out asking for feedback and offering to arrange a second viewing or answer questions. If the lead does not respond within 48 hours, a second follow-up fires. Responses update the Airtable record and remove the lead from the automated sequence so the agent can take over personally.
• 04
  New listing property matching

  When a new property is added to Airtable, workflow four queries the lead database for buyers whose recorded preferences match the listing criteria, including budget range, property type, location, and bedroom count. Matched leads receive a personalised email introducing the new property. This turned every new listing into an automated outreach campaign against an existing warm audience.
• 05
  Cold lead reactivation and daily agent brief

  Every 30 days, workflow five identifies leads who enquired but never booked and have not interacted since. Each receives a re-engagement message referencing their original enquiry and highlighting relevant new listings. Separately, at 7am every morning, all agents receive a structured daily brief covering new leads from the previous 24 hours, viewings scheduled for the day, and any leads awaiting follow-up action.

The agency stopped losing leads to slow response times and started competing on speed.

The sub-90-second response time was the change the client felt first. Within the first week, they reported leads commenting that the agency had replied faster than anyone else they had contacted. In a market where every agent is competing for the same buyers, speed of first response is a genuine competitive advantage.

The property matching workflow produced results the client had not anticipated. Two leads who had enquired six weeks earlier and gone cold received matching alerts when new listings came in. Both booked viewings. Those were deals that would have been entirely lost under the old process.

The 7am daily brief changed how the agents started their mornings. Instead of logging into four different platforms and building a mental picture of what needed attention, they had a structured view waiting for them. The team lead described it as the first time they felt in control of the pipeline rather than constantly catching up with it.