CUSTOMER STORIES Obliguard Finance

How a mortgage advisor turned a Google Sheet into a working CRM.

WITH SAGIV BOXER, OBLIGUARD FINANCE

Mortgage-review booking
84%
Pipeline influenced
$14M
WhatsApp first reply
< 90s
REGION
Israel
INDUSTRY
Mortgage advisory
KEY FEATURES USED
WhatsApp Google Sheets sync Outbound from rows
AT A GLANCE

Sagiv Boxer runs Obliguard Finance, a one-person mortgage advisory practice in Israel. Refinancing, restructuring, first-time buyer files, the usual spread. The business runs on WhatsApp. The "CRM" runs on a single, very tidy Google Sheet.

When a homeowner messages +972 53-450-8644 about restructuring a mortgage, three things need to happen in the next few minutes. The advisor needs the essential facts captured. The homeowner needs a clear next step. And the row in the Google Sheet needs to be ready for Sagiv to read on his phone between client meetings.

MessageMind handles all three. The chatbot runs the WhatsApp conversation, writes a clean summary back to the sheet, and lets Sagiv trigger an outbound follow-up by typing a single word in a spreadsheet cell.

WhatsApp-first mortgage desk
+972 53-450-8644 answers in seconds
Google Sheets as CRM
every chat writes a clean row back to the sheet
Outbound from a single cell
one word in the NEXT column triggers the message
THE NUMBERS UNDERNEATH
Booking rate
84%
qualified homeowners to file review
Pipeline influenced
$14M
mortgage value in review
First reply
< 90s
on +972 53-450-8644, 24/7
Rows written by AI
100%
no more evening data entry
SHEETS AS CRM, WALKED THROUGH

How a WhatsApp message becomes a row.

Below is a stylised version of the actual sheet. A homeowner messages on WhatsApp. The chatbot has the conversation. When it is done, the sheet has a fresh row with a clean two-line summary and a next-step column ready for Sagiv to flag.

obliguard_pipeline.xlsx
NAME
FILE
RATE
SUMMARY
NEXT
Yael K.
Refinance
4.85 → 3.95
3-property portfolio, wants 25y term, kid in 11th grade.
Call
Avi M.
First buy
1.4M ILS budget, 30% down, looking in Modiin.
Send pack
Nofar R.
Restructure
5.20 → ?
Locked rate from 2022, wants to break and re-lock. Has 8 months left on penalty window.
Call
Tomer B.
Refinance
4.10 → 3.85
Self-employed, two years of tax returns ready. Wants a 20y line.
Quote
The row in red is the one MessageMind just wrote, three minutes after Nofar's last WhatsApp message.

The same Google Sheet is also the outbound desk. Sagiv reviews the sheet in the morning. For any row where he wants the chatbot to nudge the homeowner, he types one word in the NEXT column. MessageMind picks it up on the next poll and sends a templated message from the same WhatsApp number the homeowner already knows.

"Send pack" sends the rate comparison pack. "Quote" sends the most recent quote. "Call" books a 30-minute review on Sagiv's calendar. Three words drive the entire outbound queue.

My CRM is a column in a Google Sheet. That is the entire configuration screen.
SAGIV BOXER, OBLIGUARD FINANCE
WHY A SHEET

A mortgage advisor does not need Salesforce. He needs his sheet to be honest.

Sagiv has tried CRMs. Three of them, over the years. Every one of them lasted about six weeks. The problem is not that the CRMs were bad. The problem is that a mortgage advisor lives between bank portals, property listings, and client WhatsApp threads. The CRM was a fourth place that nothing else talked to.

The Google Sheet, on the other hand, had one job. Phone number, name, file type, current rate, target rate, next step, last contacted. Seven columns, hundreds of rows, no plugins. The problem was that Sagiv was the one filling it in after every call. Most rows were a day behind, a few were a week behind, and a handful never got written at all.

The sheet was honest when I wrote it. The trouble was finding the hour every evening to actually write it.
SAGIV BOXER, OBLIGUARD FINANCE
THE RESULTS

A practice that runs from anywhere, on one number.

1.

The sheet is always honest.

Every WhatsApp conversation writes back to the sheet within a few minutes of the last message. Sagiv reads it on the train. The data entry that used to eat his Wednesday evening no longer exists.

2.

Outbound is one cell, not a campaign tool.

A column. A word. The chatbot does the rest. 84% of those nudged homeowners come back into a booked file review, against a pipeline that has already crossed $14M in mortgage value.

3.

The work stays personal.

The homeowner is still talking to one number, one name, one advisor. The fact that Sagiv can take eight of every ten qualified homeowners through a file review without losing his evenings is the entire point.

4.

Replies inside ninety seconds, 24/7.

The +972 53-450-8644 number answers homeowners on the same evening they message. The chat captures the file, the rate, the next step, and the row is on Sagiv's phone before he reads the rest of his inbox in the morning.

CONCLUSION

A spreadsheet that does the work.

Mortgage advisory in Israel is a relationship business. The advisor is the brand. The sheet is the memory. MessageMind keeps both honest, all at the same number the homeowner already trusts, with the next-step column doubling as the outbound desk.

The practice runs on one number and one sheet. That used to be the limit. Now it is the architecture.
SAGIV BOXER, OBLIGUARD FINANCE

Want this for your practice?

A 20-minute walkthrough, with your own Google Sheet on the screen. No slide deck.