Back
Real estate prospect information spread across WhatsApp, a spreadsheet, CRM, email, and Google Drive.
Automation

What happened to the information in this leaflet?

How to organize real estate leads across WhatsApp, Google Sheets, and a CRM.

By ReliaHouse

10 min read
Last updated:

You already recorded the prospect’s information.

Their name, the property they asked about, what they are looking for, where they are in the process, and what needs to happen next—you wrote all of it down.

So far, everything seems organized.

The problem appears when you ask a slightly different question: where did all that information actually end up?

Imagine a prospect messages you on WhatsApp asking about an apartment. As you talk, they tell you they want to move in October, they need a parking space, and their maximum budget is $3,000,000.

You write part of it down in a spreadsheet. The full conversation stays in WhatsApp. Later, you add a note to the CRM because you scheduled a viewing.

🗒️ Three different places for one person.

And that probably does not cause any trouble that same day. You still remember exactly who they are and what you discussed.

The problem shows up later, when you come back to that prospect and need to piece together the history of the follow-up.

  • What was their budget again?

  • Had they already ruled out any properties?

  • Who spoke with them last?

  • What had we agreed to do next?

The information exists. It is simply scattered across different places.

A conversation on WhatsApp

A prospect asks about an apartment. You reply, send a few photos, and after several messages, details start coming up that were not part of the original inquiry.

They want to move in October. They need a parking space. They can stretch their budget a little. One of the areas they had been considering is no longer an option.

So far, nothing unusual.

This kind of information naturally comes up as the conversation moves forward. WhatsApp works well for that: asking questions, answering them, sharing a property, scheduling a viewing, or clearing up a doubt.

With WhatsApp Business, you can even use tools such as labels to help organize conversations.

The difficulty begins when those same messages also become the place where you leave details you will need to remember later.

Let’s put it into practice

Think about Laura.

You have been talking to her for several days. You already know she is looking for a two-bedroom apartment, needs a parking space, and ruled out one of the options because it was too far from work.

It is all there in the conversation.

Now ten days go by, and Laura messages you again:

📱 Hi, do you have any other options you can show me?

But something has changed.

Your recent chats now include Camila, Andrés, José, and several other people asking about different properties, changing their budgets, ruling out options, and leaving follow-ups for different days.

💡 The information did not disappear. It is still there. What starts getting harder is finding it when you need it.

And simply opening the chat does not immediately answer questions like:

  • What is she looking for now?

  • Which properties have we already sent her?

  • Which one did she rule out?

  • Has she visited any of them yet?

  • What is still pending?

  • When are we supposed to contact her again?

WhatsApp can still be the place where you talk to your prospects.

But what is the bigger problem? You are not always going to remember exactly who you are talking to and everything that has happened so far.

WhatsApp cannot reconstruct the prospect’s history for you.

A simple way to start

So then... how can we solve this?

One of the simplest ways is to take out of the chat the information you will actually need to remember later.

Not the entire conversation. Just the important parts.

For example:

  • Prospect’s name.

  • Phone number.

  • The property they asked about.

  • What they are looking for.

  • Current status.

  • Last contact.

  • Next step.

And for that, a spreadsheet may be enough.

Laura again, here we go

Get ready, we are going back to Laura.

Do you remember what she was looking for? You probably just thought about scrolling back to the previous section to check.

No worries. I saved it in my spreadsheet:

Laura is looking for a two-bedroom apartment with a parking space. She previously ruled out some options because she wants something closer to work.

While you were trying to remember, the spreadsheet helped recover that context almost immediately.

Instead of searching through old messages, you open the sheet and see that Laura wants a two-bedroom apartment, needs parking, has a budget of up to $3,000,000, and is waiting for you to send new options.

The full conversation is still in WhatsApp, but you no longer need to reread it just to understand where things left off.

💡 You do not need to start with a complicated system.

Sometimes a well-organized spreadsheet solves something surprisingly important: you can open one record, understand what you already know about that person, and see what needs to happen next.

Now you have another place to remember

The spreadsheet solved part of the problem: you now have a place where you can quickly check what is happening with each prospect.

But it also created a new task: keeping that place up to date.

Let’s go back to the same example.

Laura messages you on WhatsApp and tells you she is no longer planning to move in October, but in November instead. She can also stretch her budget a little, and she wants to visit one of the apartments you sent her.

You already know all of that because you just talked to her.

But your spreadsheet does not.

For it to reflect what happened, you have to open it, find Laura, and update the information.

Doing that once does not sound like much.

But we are back to the same problem as before. Remember Andrés, Camila, José, and all those other prospects sitting in your chats?

Their information needs to be updated too.

Now you have two jobs: talk to the prospect, and then record what happened.

Only two tasks.

Now multiply them by every prospect you are handling.

It starts adding up, doesn’t it?

Maybe you updated Laura’s status but forgot to change her budget. Maybe you wrote down that a viewing happened but never recorded what she thought about the property. Or another message came in, and you decided you would update the spreadsheet later.

And “later” is often where the differences start to appear.

The warning sign comes when keeping the spreadsheet updated starts taking almost as much time as the spreadsheet was supposed to save you.

When a spreadsheet starts asking too much from you

At this point, you might be thinking: Then I need something that helps me manage all of this without spending the whole day updating columns.

And that is usually where a CRM comes in.

The name may sound more complicated than what you actually need to understand. For a real estate agent, the idea is fairly simple: open Laura’s record and see her information, what has happened with her, and what should happen next.

Instead of having just one row, you can start building a small history around each prospect.

For example:

  • Laura asked about apartment 304.

  • Later, she became interested in two other properties.

  • A call took place.

  • She has a viewing pending.

  • There is a task to contact her again on Friday.

  • Another agent on the team can review what already happened before speaking with her.

That is one of the biggest differences compared with a spreadsheet: you are no longer just storing data about the prospect. You can also keep track of what is happening with them over time.

You can also organize prospects based on where they are in the process. One may have just arrived, another may be waiting for a viewing, and someone else may be expecting new property options.

That makes it much easier to answer a question that starts becoming important once you have several conversations going at the same time:

Who do I need to pay attention to today?

So far, it looks like we solved the problem.

WhatsApp stays where the conversations happen. The CRM keeps the information, activities, and follow-ups.

But one condition has not disappeared.

If Laura tells you something new on WhatsApp and that information never makes it into the CRM, you now have two places telling different versions of the same story.

And that brings us to one of the biggest operational problems in real estate today.

Each tool knows a different part of Laura

Let’s go back to Laura one more time.

The conversation started on WhatsApp. That is where she told you what she was looking for, changed her budget, and scheduled a viewing.

In the CRM, you have her name, the apartment she asked about, and a task to follow up with her.

The property photos and documents are in Google Drive.

And maybe some additional information came in by email.

None of this seems unusual. In fact, each tool is doing exactly what you use it for.

The problem appears when you need to understand what is actually happening with Laura.

You open the CRM and see a budget of $3,000,000.

But you remember that a few days ago, she told you on WhatsApp that she could go up to $3,300,000.

The CRM says she is still planning to move in October.

In your most recent conversation, she told you she is now thinking about November.

And the viewing you scheduled yesterday still appears as a pending task because nobody had time to update it.

Then something interesting happens: you have more tools and more information than before, but you still have to do part of the work yourself.

⚠️ The problem appears in what happens between one tool and the next.

And this can happen even when you are using a good CRM.

Because a CRM only knows the information that actually makes it into the system.

If something changes in a WhatsApp conversation, a new document arrives by email, or someone updates information in another tool and that change never reaches the place where you manage the follow-up, small differences start to appear.

Let’s do a simple test

After everything we have covered so far, we could make this more complicated by talking about integrations, automations, or which tool is better.

But there is a much simpler way to tell whether your prospect information is actually organized.

Think about someone you spoke with this week and try to answer these questions:

  1. Who are they?

  2. Which property did they originally ask about?

  3. What are they looking for right now?

  4. Which properties have you already sent or shown them?

  5. What has happened since the conversation started?

  6. Where are they in the process now?

  7. What needs to happen next?

Now comes the important part.

How many places did you have to open to answer them?

Maybe the budget is in WhatsApp, the property they were interested in is in the CRM, the viewing is sitting on your calendar, and you only remember the next follow-up because you talked about it yesterday.

You have all the answers.

But you still have to go looking for them.

Ideally, whether you work with a spreadsheet, a CRM, or another tool, you should be able to open that prospect’s record and quickly understand their history.

You do not need to reread every message you have exchanged since day one. You need enough context to continue from where things left off.

You want to know who they are, what changed since the last conversation, and what needs to happen now.

💡 Good organization is not just about storing information. It is about being able to find the context when it is time to use it.

Let’s go back to the original question

We started this article with a fairly common problem: you spoke with a prospect, learned several things about them, and a few days later you need to remember where all that information ended up.

First, there was WhatsApp.

Then came a spreadsheet to take out of the conversation the details you did not want to forget.

Later, maybe a CRM came in to help organize prospects, activities, and follow-ups more clearly.

Each step can help.

But none of these tools help much if you still have to open four different places just to understand what happened.

So maybe the question should not be:

Do I need WhatsApp, Google Sheets, or a CRM?

A more useful question is:

When a prospect messages me again two weeks from now, will I be able to continue from where we left off?

If you work with a spreadsheet and you can do that, the spreadsheet is doing its job.

If you use a CRM and your team can open a prospect, understand what happened, and see what comes next, then the CRM is doing its job.

The problem begins when the answer depends on rereading a conversation, searching for a note, asking another agent, and then checking what was actually recorded.

💡 Organizing your work better does not mean storing more information. It means being able to continue from where things left off, without rebuilding the whole story every time.

Try 30 days free

Digitize your real estate operation from day one.

Start for free

Try ReliaHouse free for 30 days

Digitize your real estate operation and work with more control from day one.