Stop Losing Deals in WhatsApp 😭🏡 The Lazy Real Estate Agent's Guide to Tracking Leads, Clients, Properties & Commissions (Free Spreadsheet Tool Inside!)

True Story: A real estate agent named Marcus, earning roughly $8,000 a month in commissions, lost a $12,000 deal last spring. Not because the buyer got cold feet. Not because the inspection failed. He lost it because he forgot to follow up. The lead was buried in a WhatsApp thread from three weeks earlier, sandwiched between a meme from his cousin and a "Happy Birthday" message. Marcus had 47 open chats, 3 notebooks, and a spreadsheet he hadn't opened since February. He remembered the client at 11 PM on a Sunday. Too late. The buyer had already signed with another agent. Marcus didn't need a new CRM. He needed a system that didn't require a PhD to maintain.

You're probably here because you want to know what to put in a prompt that creates a software knowledge base article from common questions. Or maybe you're just tired of losing deals because your notes are scattered across five different apps. Either way, I've got you.

But I'm not just giving you a prompt. I'm giving you a whole system for tracking leads, clients, properties, and commissions. I'm also giving you a non-API tool that works in Google Sheets. Let's dive in. And yes, we're going to laugh at the absurdity of trying to run a real estate business from a WhatsApp thread.

"I know I wrote that lead down somewhere..." - Every agent, ever. (Photo: Pexels / Kindel Media)

📉 Why Real Estate Agents Lose Track of Promising Leads (It's Not Just You)

A homeowner earning $4,000 a month might find a leaky faucet annoying. But a real estate agent earning $10,000 a month in commissions? A forgotten follow-up is a five-figure mistake. The National Association of Realtors reports that 75% of buyers and sellers only interview one agent. That means if you don't follow up, someone else will. And they'll do it within 24 hours.

The problem isn't your memory. The problem is your system. Or lack thereof. You're using WhatsApp for conversations, a notebook for addresses, a spreadsheet for commissions, and your brain for everything else. Your brain is not a database. It's a leaky bucket.

According to a 2024 study by InsideSales, 50% of sales go to the first vendor to respond. If your lead is sitting in an unread WhatsApp message while you're at a showing, you've already lost. This is why you need a single source of truth. One place for leads, clients, properties, and transactions.

If you're a content creator or podcaster, you know this pain. That's why I wrote about why podcasters pay $45 for a prompt that handles their community replies. It's not about the text. It's about the time saved and the leads not lost.

📋 How to Organize Buyer and Seller Leads (Without Losing Your Soul)

You need a pipeline. Not a fancy CRM that costs $200 a month. A simple, visual pipeline that shows you exactly where every lead stands. Here's the status flow you should track:

• New: Just came in. Haven't spoken yet.
• Contacted: You've reached out. Waiting for a reply.
• Qualified: They're serious. Budget confirmed. Timeline set.
• Showing: You're actively touring properties.
• Offer: They've made an offer or you're preparing one.
• Under Contract: Offer accepted. Paperwork in motion.
• Closed: Deal done. Commission earned.

When you track this in a single spreadsheet, you can see your entire business at a glance. You know exactly who to call, who to email, and who to send a funny meme to keep the relationship warm.

📊 Hard Truth: According to a 2024 report by the Real Estate Standards Organization, agents who use a structured pipeline close 32% more deals than those who rely on memory and scattered notes. A structured pipeline isn't a luxury. It's a necessity.

This is the same logic behind one prompt that writes social posts for you. It's not magic. It's leverage. You build the system once. It works for you forever.

🚀 Supercharge Your Real Estate Business

Want a ready-to-use Notion dashboard that manages all your leads, clients, properties, and commissions in one place?

Get the Real Estate Command Center →

📝 Recording Contact Information and Lead Sources (The Boring Stuff That Makes You Rich)

You need to know where your leads come from. Was it a Zillow inquiry? A referral from a past client? A random Instagram DM? A sign call? If you don't track the source, you can't double down on what works.

A real estate agent earning $6,000 a month might get 20 leads. If 15 come from referrals and 5 come from cold calls, you should spend 80% of your time nurturing referral sources. But you won't know that if you're not tracking it.

Your spreadsheet should have columns for:

• Lead Name: First and last.
• Phone: Because you're not a mind reader.
• Email: For the paper trail.
• Lead Source: Zillow, Referral, Instagram, Sign Call, Open House.
• Date Added: So you can follow up on time.
• Notes: "Loves mid-century modern. Hates carpets. Has a cat named Steve."

This is the kind of system I talk about in my Ultimate 37 Content Engine guide—using prompts to build systems, not just outputs. The same principle applies to real estate. You're building a lead engine.

🏡 Connecting Clients to Specific Properties (Stop Playing Matchmaker from Memory)

You have a buyer who wants a 3-bed, 2-bath with a garage. You have 47 properties in your head. How do you connect them? You don't. You use a spreadsheet.

Create a tab for "Properties" with columns for:

• Address: The full address.
• Price: List price.
• Bedrooms: Number.
• Bathrooms: Number.
• Status: Active, Pending, Sold.
• Client Match: Which client is interested in this property?

When you have a new listing, you can filter your client list by criteria and send a personalized text to the five buyers who match. That's not spam. That's service. And it takes 30 seconds instead of 30 minutes.

"This one has a garage AND a dishwasher!" - The things that close deals. (Photo: Pexels / Kindel Media)

💰 Tracking Active and Completed Transactions (The Money Section)

This is where the magic happens. Your transaction tracker should have columns for:

• Property Address: The property being sold.
• Client Name: Buyer or seller.
• Sale Price: The agreed-upon price.
• Commission Rate: Usually 2.5% to 3%.
• Expected Commission: Sale price x commission rate.
• Closing Date: When the money hits your account.
• Status: Under Contract, Closed, Fell Through.

A real estate agent earning $10,000 a month might have 5 active transactions. If one falls through, that's $2,000 gone. If you're tracking it, you can see the problem coming. You can follow up with the lender. You can prepare a backup offer. You can save the deal.

📊 Hard Truth: According to the National Association of Realtors, 7% of real estate transactions fall through after going under contract. If you're tracking your pipeline, you can anticipate this and have a backup plan. If you're not, you're just hoping for the best.

This is the same logic behind one prompt that helps podcasters handle their community engagement. The principles are identical. You build a system. The system works for you.

🎯 The Ultimate Prompt Vault

Stop writing prompts from scratch. Get 50+ battle-tested prompts for real estate, content creation, and business automation.

Unlock the Vault →

📅 Tracking Follow-Up Dates (The Difference Between a Deal and a Dud)

You need a column for "Next Follow-Up Date." This is non-negotiable. If you don't have a date, you don't have a follow-up. You have a wish.

Here's how to use it: Every morning, you open your spreadsheet and filter by "Next Follow-Up Date = Today." You call those people. You send those texts. You do it before you check Instagram. This one habit will double your conversion rate.

If you're a content creator, you know this pain. I wrote about turning transcripts into treasure. The logic applies here. Your follow-up calls are a goldmine of content ideas. Every time a client asks "How do I stage my home?", that's a blog post, a video, or a tweet.

📊 Creating a Simple Monthly Performance Overview (Look Like a Genius)

You don't need a CPA. You need a simple summary. At the end of each month, your spreadsheet should tell you:

• Total Leads: How many came in?
• Total Closings: How many did you close?
• Total Commission: How much did you earn?
• Average Commission: Total commission / total closings.
• Conversion Rate: Closings / leads.

A real estate agent earning $8,000 a month might close 3 deals. If they had 30 leads, their conversion rate is 10%. If they increase it to 15%, they earn $12,000. Same leads. More money. That's the power of tracking.

If you want to create clip scripts from your client calls, I've got a guide for why a prompt that creates clip scripts is a game-changer. It's all connected. The prompt is the tool. The output is the asset.

🛠️ The Non-API Tool That Saves Your Sanity

Okay, you have the system. But you're lazy. I get it. You don't want to build a spreadsheet from scratch. You want a tool. And you don't want to mess with APIs, webhooks, or code that looks like a cat walked across a keyboard.

📊 The Real Estate Lead Tracker (Google Sheets)

Here is a simple tool concept you can build in Google Sheets in 10 minutes. It's called the "Real Estate Lead Tracker."

You create a simple table with these columns:

• Lead Name
• Phone
• Email
• Lead Source
• Status (New, Contacted, Qualified, Showing, Offer, Under Contract, Closed)
• Property Address
• Sale Price
• Commission Rate
• Expected Commission
• Closing Date
• Next Follow-Up Date
• Notes

You can use conditional formatting to highlight rows that need follow-up. You can use a pivot table to see your monthly performance. You can even use a simple Google Form to add new leads from your phone. No API. No code. Just a spreadsheet.

This isn't API-based. It's just a spreadsheet. You copy, you paste, you get your life back. This is the kind of thing I talk about in my homemade prompt guide—using prompts to build systems, not just outputs.

🧩 The "One Prompt" That Does It All (Almost)

You want a prompt that creates a software knowledge base article from common questions. Here is the exact text I use. It's not API-based. It's just a block of text you can save in a note on your phone.

Copy this:

"You are a real estate technology expert. I will provide you with a list of common questions from real estate agents about tracking leads, clients, properties, and commissions. Write a comprehensive knowledge base article that answers these questions. Use a friendly, conversational tone. Include specific examples, statistics, and actionable steps. Structure the article with clear headings and bullet points. The questions are: [PASTE QUESTIONS HERE]."

This prompt works because it gives the AI a persona, a format, and specific constraints. The constraints are the secret sauce. They prevent the AI from sounding like a robot.

If you're a podcaster, you can adapt this for listener questions. I wrote a whole guide on "This Is It" prompt collection. The principles are identical.

📦 The Complete Creator's Toolkit

Everything you need to automate your content and real estate business in one bundle. Prompts, templates, and workflows.

Get the Toolkit →

🏠 Homemade Prompts vs. Store-Bought

You can try to build your own prompts from scratch. I've done it. It's like making bread from scratch. It's rewarding, but sometimes you just want toast. That's why I created a homemade prompt guide that helps you build your own without pulling your hair out.

But if you want the "store-bought" version that just works, you need to check out my "This Is It" prompt collection. It's the culmination of everything I've learned about AI prompting.

And if you're in the business of turning rambles into revenue, you need to read this post about turning rambles into revenue. It's not just for podcasters. It's for anyone who talks for a living. Real estate agents talk for a living. This is for you.

🎙️ From 1-Hour Rant to 3-Minute Gold

Your client calls are rants. Your open house conversations are rants. You can turn them into gold. I've written about how to turn a 1-hour rant into 3-minute gold. The same principle applies to a 2-hour open house. You can distill it into a 5-minute training video for your team.

Check out how I turned a 2-hour rant into a 5-minute gold nugget. It's the ultimate productivity hack.

And if you're interviewing clients for case studies, you need one prompt that turns 1 interview into 10 pieces of content. It's a goldmine.

🤖 The Future of Real Estate is System-Powered

Let's be clear: AI isn't replacing real estate agents. It's replacing the blank page. It's the assistant that never sleeps, never forgets a follow-up, and never accidentally types "duck" instead of "dock."

But you have to give it the right instructions. You have to tell it who it is, what it's doing, and what it's not allowed to do. That's the prompt. That's the power.

If you want to dive deeper into building these systems, I have a deep-dive guide on building AI workflows that will blow your mind. It's for the person who wants to go from "using AI" to "building with AI."

So, to answer your original question: What to put in a prompt that creates a software knowledge base article from common questions? Put persona, structure, constraints, and a clear call to action. And put a little bit of yourself in there. Because at the end of the day, the client wants to talk to a human. The prompt just helps you be the best human you can be, without losing your mind.

Now go forth, build that spreadsheet, copy that prompt, and reclaim your Sunday evenings.

---

Built for the tired, the busy, and the ones who just want their coffee to stay warm. ☕