Real Estate CRM on WhatsApp: HomeNex Automates Lead Tracking

Introduction

In India’s fast‑paced real‑estate market, agents juggle dozens of prospects across multiple platforms. When a potential buyer or tenant drops a message on WhatsApp, the agent must remember who last spoke with that lead, when, and what was discussed. A missed follow‑up can mean a sale slipping away.

HomeNex, an AI‑powered CRM built for Indian real‑estate agents, tackles this pain point head‑on. By storing the most recent speaker directly on each lead record, agents gain instant visibility into who last contacted a prospect, whether it was the agent, a client, or a chatbot. The feature is part of HomeNex’s core real‑estate CRM offering, fully integrated with the WhatsApp Business API and designed to keep property‑management workflows tight and efficient.

The Problem

A typical agent’s day begins with a flood of messages: inquiries, requests for property details, price negotiations, and status updates. Without a clear indicator of the last interaction, agents often:

1. Duplicate outreach – sending the same follow‑up email or message to a lead who has already responded.
2. Lose context – forgetting the tone or content of the previous conversation, leading to fragmented communication.
3. Miss deadlines – failing to reach a lead within the optimal time window because they cannot quickly identify which leads are awaiting a response.

These issues not only waste time but also erode the credibility of the agent and the agency’s brand.

How HomeNex Solves It

HomeNex solves the problem by introducing a dedicated field, who_spoke_last, on every lead record. The field stores the identifier of the participant who most recently sent a message—whether it’s the agent, a client, or an automated bot.

Key Benefits

• Instant context – Agents can glance at a lead’s detail page and see exactly who last communicated.
• Reduced redundancy – The UI highlights leads that have been inactive for a while, prompting timely follow‑ups.
• Seamless integration – The who_spoke_last column is exposed through HomeNex’s API, allowing the front蛅 end and the WhatsApp Business API to share a single source of truth.

The feature is a direct response toకీయ
commit perf(leads): keep who-spoke-last on the lead row, not one scan per lead per poll, which streamlined lead polling and ensured that the agent always has up‑to‑date information.

Behind the Scenes

HomeNex is built on a robust stack: Node.js for the server, React for the client, PostgreSQL for data storage, and the official WhatsApp Business API for communication. The database schema now includes:
Tahoma

ALTER TABLE leads ADD COLUMN who_spoke_last TEXT;

Whenever a message is received or sent—through the WhatsApp API or the internal chatbot—the backend updates who_spoke_last with the sender’s ID. The update occurs in a single transaction, guaranteeing consistency even under high load.

The React UI fetches this field waited for the lead detail via a GraphQL query. If the value matches the current agent’s ID, a subtle icon appears next to the lead’s name. If the value belongs to a client or bot, the icon changes color, making it immediately apparent who last reached out.

Because the data lives on the lead row itself, HomeNex no longer needs to perform a full scan of all leads to determine the last speaker. This change dramatically reduces server load and improves response times for agents navigating large portfolios.

Using the Feature

1. Open a Lead – From the dashboard, click on a lead to view details.
2. Check the Icon – Look for the small avatar next to the lead’s name. A gray icon indicates the agent spoke last; a green icon indicates a client; a blue icon indicates a bot.
3. Respond Promptly – If the icon shows a client or bot as the last speaker, click the Message button to continue the conversation via WhatsApp. If the icon shows the agent, consider whether a follow‑up is needed or if the lead is satisfied.
4. Leverage Filters – In the lead list, use the Last Speaker filter. This lets agents quickly see all leads where a client or bot has been waiting for a response.

Because the feature is a core part of the HomeNex UI, agents do not need to perform any extra steps or run custom queries. The information is there, by default, whenever they inspect a lead.

Conclusion

The addition of a who_spoke_last field turns HomeNex into a more intelligent real‑estate CRM, giving agents instant, reliable context for every lead. By integrating this data with the WhatsApp Business API, HomeNex ensures that every message—whether human or automated—contributes to a single, up‑to‑date conversation history. Agents save time, avoid duplication, and keep their communication tight, all while workingstvo within a property‑management‑friendly platform.

With HomeNex, the hardest part of lead management—knowing who last spoke—becomes a single glance. That focus lets agents concentrate on what they do best: closing deals and building relationships in India’s competitive real‑estate landscape.