Buyer Criteria Matcher
Example prompt: "Every morning, read the 'New Listings' tab in my Google Sheet — each row has a listing URL, asking price, bedrooms, postcode, and a notes field. For each new listing, extract the property details from the listing URL. Then read my 'Registered Buyers' sheet which has each buyer's budget range, minimum bedrooms, target postcodes, and any must-haves. Match each new listing against the buyer list and, for every buyer whose criteria the listing meets, draft a short email from my Gmail telling them about the property, why it matches their brief, and offering a viewing. Log every match in a 'Matches Sent' tab with the listing, buyer, and date."
The Problem
Most agents keep a book of registered buyers — people who have told you the kind of property they are looking for and the budget they have. In theory, matching a new listing to that book is the most valuable thing an agent does. In practice, when a new instruction lands the agent rushes to get it on portals and the buyer book goes unchecked for days. Good leads sit warm while the agent hopes the listing will find them organically.
How GloriaMundo Solves It
We build a daily workflow that treats the buyer book as a first-class source of leads. An integration step reads the 'New Listings' tab from Google Sheets. A url_extract step pulls the property details from each listing URL — price, bedrooms, key features. A second integration step reads the 'Registered Buyers' sheet. A code step does a structured comparison: budget within range, bedrooms at or above minimum, postcode on the target list. An LLM step then judges the softer criteria from the buyer's notes — "south-facing garden", "near a good primary school" — against the listing description. A conditional step filters to only the real matches. For each match, an LLM step drafts a short email saying exactly why the listing fits their brief. An integration step sends the emails via Gmail and logs every match to a 'Matches Sent' tab. Glass Box preview shows the match list and drafted emails before anything sends.
Example Workflow Steps
- Trigger (schedule): Runs every morning at 9am.
- Step 1 (integration): Read the 'New Listings' tab from Google Sheets.
- Step 2 (url_extract): For each new listing URL, extract the property details from the listing page.
- Step 3 (integration): Read the 'Registered Buyers' tab with each buyer's criteria.
- Step 4 (code): For each listing, filter buyers by hard criteria — budget range, minimum bedrooms, target postcodes.
- Step 5 (llm): For each shortlisted buyer, score how well the listing matches their softer notes and must-haves; drop weak matches.
- Step 6 (conditional): Only proceed for buyer-listing pairs that clear both the hard and soft checks.
- Step 7 (llm): Draft a short, specific email per match explaining why the property fits the brief.
- Step 8 (integration): Send the emails via Gmail.
- Step 9 (integration): Append each sent match to the 'Matches Sent' tab with listing, buyer, and date.
Integrations Used
- Google Sheets — stores the new listings, the registered buyer book, and the match log
- Gmail — sends the personalised match emails to buyers
Who This Is For
Estate agents with an active buyer book of 30+ registered buyers who want every new instruction matched against that book the same day it is taken, without spending the morning reading through buyer notes one row at a time.
Time & Cost Saved
Manually matching three new listings against a buyer book of 40 registered buyers — re-reading each buyer's brief, checking the listing details, drafting individual emails — takes around two hours. This workflow reduces that to a 15-minute review of the matches before they send. More importantly, it runs every day, so buyer book matches happen when the listing is fresh, not a week later.