CRM for Mortgage Brokers — Free, From Google Sheets

A mortgage pipeline is a row of ticking clocks. Every file has a rate lock counting down, a closing date the realtor promised the sellers, and an underwriter who wants one more document. Miss a lock expiry and it costs real money — an extension fee at best, a blown rate at worst, and a borrower asking why nobody told them.

Most brokers and loan officers track all this in a spreadsheet, because the loan origination system is where files get processed, not where pipelines get managed. The LOS knows everything about a file and nothing about your morning: which locks expire this week, which pre-quals went cold, which realtor partner hasn't sent a deal since March. And that last one matters more than brokers like to admit — realtors are a second pipeline. The LO who updates the listing agent before being asked is the LO who gets the next buyer.

The fix isn't a $100-a-month mortgage CRM with a video-email studio bolted on. It's the sheet you already keep, with an AI-built interface that watches the clocks.

Step 1: Start With Your Pipeline Sheet

One row per loan file. A working setup looks like:

Add a referred-by column if you don't track it yet — it's how you'll finally see which partners feed you and which just take pre-approval letters. The sheet stays the system of record; nothing about it needs restructuring.

Step 2: Create a Free Account

Go to lovespreadsheets.com and sign up free. That covers the build and daily use; logins for multiple LOs on your own domain are the paid tier.

Step 3: Describe a File's Life, Deadlines Included

Pick the CRM template and write out the journey the way you'd walk a new LO through it:

• "Files move Lead → Pre-qual → Application → Processing → Underwriting → Clear to close → Funded. Denied or withdrawn files get parked, not deleted."
• "Once a rate is locked, the lock expiry is the most important date on the file."
• "Every purchase file has a realtor attached, and I want to see my pipeline grouped by partner, not just by stage."

The three asks that change your week:

• Lock-expiry alerts — anything inside 7 days flagged loud, so extensions get negotiated on your schedule
• Per-LO views if you run a branch, so each originator works their own board while you see the branch pipeline and what's funding this month
• A realtor-partner view that answers, at a glance, who sent what and when they last heard from you

Upload the sheet and run it. The AI Optimize button firms up a thin description, the AI may ask a clarifying question, and the build lands in about 15–20 minutes.

Step 4: The Pipeline Board Your LOS Never Gave You

The URL opens to your files by stage, with lock countdowns visible without clicking. Move the Trans from Underwriting to Clear to close and the Google Sheet records it instantly — which also means your pipeline history sits in a sheet you control, timestamped, when a branch manager or auditor asks what happened on a file and when. Notes typed into the sheet show up in the app the same moment.

Keep it private, or put it on your own domain so the branch treats it like the internal tool it is.

Why Brokers Keep the Sheet

A missed lock costs more than a year of any CRM. One extension fee avoided pays for this setup many times over — and this setup is free. The math isn't close.

Partner data is your marketing plan. When the sheet shows Whitfield sent four deals this quarter and another agent sent none since spring, you know exactly who gets the coffee meeting.

Your pipeline survives a branch change. LOs move. CRMs and LOS access stay behind. A sheet in your own Google account is the one system that transfers with your career.

Common Questions from Mortgage Brokers

Is this compliant to use? It's your own Google Sheet with an interface on top, so your existing policies about borrower data in Google Workspace apply unchanged. The app adds structure and a clean edit trail rather than a new place data lives.

Can my processor update files too? Yes — share access and stage changes or next actions they enter flow straight to the sheet. No more status-update emails at 4:55.

Can realtor partners see anything? Only if you choose. Some LOs share a filtered view of a partner's own transactions; most just use the partner view internally to run better check-ins.

One more lead-gen note: the same platform can turn a sheet of loan math into a mortgage web calculator for your site, which pairs naturally with the CRM catching the leads it generates.

Build Yours

Take the pipeline sheet you already update every morning, head to lovespreadsheets.com, and describe a file's path from lead to funded — locks and all. Twenty minutes later, the clocks are watching themselves.