Making Google Sheets the single source: a 30-minute sync

The sneakiest cost of any new system is “entering things in a second place.” If an office already keeps its portfolio in Google Sheets and the new system insists on its own separate database, agents end up entering every listing twice. Before long the two records drift apart: the price in the sheet is current and the one in the system is stale — or the other way round. That “which one is right?” uncertainty is where most portfolio tools quietly rot.

The single-source principle

Realtiq cuts this problem off at the source: your Google Sheets operates as the single source of truth. The question of where to enter a listing disappears — you enter it in the sheet, nowhere else. The system reads the sheet; you never feed the system. This reversed flow makes “duplicate records” structurally impossible.

What the 30-minute sync does

Every 30 minutes the system re-reads your sheet and does three things:

• Reprocesses what changed: A listing whose price or description you updated is re-evaluated and made ready for matching.
• Picks up what’s new: A listing you add to the sheet appears in the system within half an hour and becomes suggestible to customers.
• Closes what’s off market: When you remove a sold or withdrawn listing from the sheet, the system deactivates it automatically; no customer is ever pointed at a sold home.

Half an hour is not “instant” — and that’s a deliberate choice. A property portfolio is not second-by-second data; a listing reaching the system within 30 minutes disrupts no real-world scenario. Chasing instant updates on every small change, by contrast, produces a fragile and needlessly complex machine. A simple, predictable cycle holds up better in the field.

Never having to leave Sheets

The real win here isn’t technical — it’s about habit. The agent keeps working in the tool they already know and are comfortable with: a spreadsheet. No new interface to learn, no field placements to memorise. The answer to “how do I update the portfolio?” is the same answer you’ve known since day one: you write it in the sheet.

The limit — and the responsibility

Being the single source has a price: if the sheet is right, the system is right; if the sheet is messy, the system mirrors the mess. That’s why we organise your sheet’s structure together during setup — which column means what, how budget and room count are written. Once it settles, the daily routine stays single and familiar: write the listing in the sheet, and let the system keep everything in sync.

← All articles