Real Estate CRM in Google Sheets: Why Top Agents Are Ditching Salesforce

Salesforce costs $75–300/user/month. For a 5-person brokerage, that's $4,500–18,000/year for a tool most agents barely use because it's too complex.

Real estate agents don't need enterprise CRM software. They need a place to track leads, manage their pipeline, remember to follow up, and calculate commissions. That's it. The $300/month per-seat cost of Salesforce or $69/month for Follow Up Boss is paying for features agents never touch.

Every top-producing agent we've worked with has the same dirty secret: they already track their real deals in a spreadsheet. The CRM is where leads go to die. The spreadsheet is where deals get done.

So why not make the spreadsheet better?

What Agents Actually Need

After building CRM systems for dozens of agents and brokerages, the requirements are remarkably consistent:

Lead tracker: Name, phone, email, source, date, status, notes
Deal pipeline: Stages from prospect through closed (Prospect → Showing → Offer → Under Contract → Closed)
Follow-up reminders: Don't let warm leads go cold
Commission tracker: Per-deal commission, splits, projected vs. actual income
Listing inventory: Active listings with status, days on market, price changes

That's 5 views. In Salesforce, setting up these 5 views requires a consultant and 3 weeks of configuration. In Google Sheets, it takes a well-structured workbook.

Building the Pipeline

The heart of any real estate CRM is the deal pipeline. Here's how we structure it in Sheets:

The Stage column uses data validation to restrict entries to your pipeline stages. Conditional formatting colors each row by stage: green for Closed, yellow for Under Contract, blue for Offer, gray for Prospect.

      Pipeline summary by stage
      =QUERY(Pipeline!A:L,
  "SELECT E, COUNT(A), SUM(H)
   WHERE E IS NOT NULL
   GROUP BY E
   LABEL COUNT(A) 'Deals',
   SUM(H) 'Commission'", 1)
    

One formula gives you a pipeline summary: how many deals at each stage and total projected commission. No Salesforce dashboard configuration required.

Commission Tracking

Commission calculations in real estate are straightforward but tedious when done manually. In Sheets, it's a formula:

      Commission calculator with splits
      // Commission column formula
=IF(F2="", "",
  F2 * G2 *
  IF(I2="Senior", 0.8,
  IF(I2="Junior", 0.6, 0.7))
)

// YTD commission by agent
=SUMIFS(H:H, I:I, "Agent Name", E:E, "Closed")
    

Follow-Up Automation

The number one complaint from agents: "I forgot to follow up." Apps Script fixes this. A daily trigger checks the Next Follow-Up column and sends email reminders.

      Apps Script - Daily Follow-Up Reminder
      function checkFollowUps() {
  const sheet = SpreadsheetApp.getActive()
    .getSheetByName('Pipeline');
  const data = sheet.getDataRange().getValues();
  const today = new Date();
  today.setHours(0,0,0,0);

  const due = data.filter((row, i) => {
    if (i === 0) return false;
    const followUp = new Date(row[10]);
    followUp.setHours(0,0,0,0);
    return followUp <= today && row[4] !== 'Closed';
  });

  if (due.length > 0) {
    const list = due.map(r =>
      `${r[1]} - ${r[2]} (${r[4]})`
    ).join('\n');

    GmailApp.sendEmail(
      Session.getActiveUser().getEmail(),
      `${due.length} follow-ups due today`,
      `These deals need attention:\n\n${list}`
    );
  }
}
    

The Cost Comparison

Tool	Monthly / User	5 Agents / Year	Features Used
Salesforce	$75–300	$4,500–18,000	~20%
Follow Up Boss	$69	$4,140	~40%
kvCORE	$499/team	$5,988	~30%
LionDesk	$25	$1,500	~50%
Google Sheets	$0	$0 + one-time build	100%

One-time build cost for a complete real estate Sheets CRM: typically $2,000–5,000. That's less than one year of Follow Up Boss for a 5-person team.

The Google Ecosystem Advantage

Real estate runs on the Google stack already. Most agents use Gmail, Google Calendar, and Google Drive. A Sheets CRM plugs directly into all of them:

Google Forms for lead capture: "Schedule a Showing" form on your website feeds directly into the CRM sheet
Gmail for automated follow-ups: Apps Script sends personalized emails triggered by pipeline stage changes
Google Calendar for showing schedules: Apps Script creates calendar events when a showing is booked
Google Drive for documents: Link contracts, inspection reports, and disclosures directly in the deal row

No Zapier. No third-party integrations. No additional cost. It's all native.

Sharing Without Per-Seat Licensing

This is the killer advantage. Share the sheet with your entire team, your assistant, your broker. Everyone sees the same pipeline in real-time. No per-seat licensing. No "you need to upgrade to add another user."

Set permissions per tab: agents see their own deals, the broker sees the full pipeline, the admin sees the commission tracker. Google Sheets' built-in sharing controls handle this natively.

The best CRM is the one your team actually uses. If your agents already live in Google Sheets, stop fighting it. Make it better.