๐Ÿ Property & Real Estate ยท Step-by-step guide

Get a weekly list of expired and for-sale-by-owner homes to call, all in one spreadsheet

Homes whose listing expired, was cancelled or that owners are selling themselves are some of the best leads an agent can call, but finding them by hand takes hours. A Boston-area team had a simple tool built in Claude that gathers these listings each week into one spreadsheet with the address and the owner's contact details, so agents spend their time talking to people instead of searching.

โฑ๏ธ 1-2 hours to set up, then about 15 minutes a week๐ŸŽฏ Medium๐Ÿ’ต Claude Pro USD 20/month; paid contact-data services are extra๐Ÿ“‹ 8 steps
๐Ÿงก Claude๐Ÿข Named company
๐ŸŽฏ What you'll have at the endYou'll have one spreadsheet each week of expired, cancelled and owner-sold homes in your area, cleaned up and ready for your team to call.

๐Ÿ‘€ What you'll get

Example

Here's the kind of thing you'll have at the end:

๐Ÿงฎ SpreadsheetWeekly call list ยท Week 44, Ampang and Cheras
AddressStatusDays listedPrice cutsContactNext step
No. 12 Jalan KenariExpired1402as listedCall Tue
No. 8 Lorong DamaiOwner selling350as listedCall Tue
No. 3 Jalan SerojaCancelled981not listedSend letter

31 homes this week, 6 duplicates removed, 2 on the do-not-call list

Best lead type last month: expired with 2+ price cuts (4 valuations booked)

๐Ÿงช Made-up sample to show the kind of result. Your output will vary.

๐Ÿ’ธ What will this really cost me?

Prices checked 27 Oct 2026
๐Ÿงช To try it once
Free: Claude's free plan can tidy one week's export into a call list.
๐Ÿ” To keep it running
Claude Pro: USDย 20 a month, or USDย 17 a month paid yearly. Max (from USDย 100 a month) is only for very heavy daily use. The listing exports come from tools you already pay for.
โš ๏ธ Watch out for
Services that look up owners' phone numbers charge separately and may break privacy rules: check the provider's pricing page and your local law first. Large exports use more of your Claude limit, so upload one week at a time.

๐Ÿ”— Official pricing: Claude pricing

Prices change often, so check the links before you pay. Amounts exclude tax. Prices are shown in each provider's own currency.

๐Ÿงพ Which plan do I need?

๐Ÿช™ Small upgrade ยท MYR 82/mo

A saved Claude Project or connectors used every week need Claude Pro or Max.

Tick what you already pay for:

๐Ÿช™ Small = up to MYR 250 a month more ยท ๐Ÿ’Ž Big = over MYR 250 a month more ยท prices from each provider's pricing page, checked 21 Oct 2026.
โ„น๏ธ How we work this outPrices come from each provider's own pricing page (checked 21 Oct 2026; amounts exclude tax). Small upgrade = up to MYR 250 a month more than you pay now. Big upgrade = more than MYR 250 a month more. Check pricing = the provider doesn't publish a price we could confirm. The badges are worked out in MYR at USD 1 = MYR 4.08 (Bank Negara Malaysia, 19 Oct 2026). Each guide's needs come from its own "What will this really cost me?" box. Your ticks stay in this browser only (no account, nothing sent to us).
Tick all your plans on the home page โ†’

โฑ๏ธ Try it in 10 minutes

โœ… Free plan ยท nothing to connect

What you'll see: A cleaned, sorted call list with duplicates removed and two honest call openers, from made-up listings.

Copy the prompt, paste it into one of the free AI apps below and press send. The sample is made up, so swap in your own details if you like.

๐Ÿ’ฌ Your 10-minute test
Here is a made-up export of listings:
1. 12 Jalan Kenari, Ampang. Expired. Listed 140 days. Price cut twice from MYR 980,000 to MYR 899,000. Owner phone as listed: 012-000 1111.
2. 12, Jln Kenari, Ampang. Expired. Same as above (duplicate).
3. 8 Lorong Damai, Cheras. For sale by owner. Listed 35 days at MYR 650,000. Contact: owner email as listed.
4. 3 Jalan Seroja, Cheras. Cancelled. Listed 98 days. One price cut. No contact listed.

Remove duplicates, then make a table: address, status, days listed, price cuts, contact as published, next step. Sort the most promising first. For the top two, write an honest 2-sentence call opener that mentions one real fact from the listing.

โœ… Works on: Claude Free ยท ChatGPT Free ยท Gemini app (free)

Links go to the official plan pages. Free plans have daily limits and can change, so check before you rely on them.

โžก๏ธ Like it? The full setup adds: The full setup runs each week on your real portal exports in a saved Claude Project, with do-not-call checks and outcome tracking. Go to the steps โ†“

โšก One-click install

Checked install pages (app stores, official sites and template pages): tap to get it straight away.

๐Ÿงฐ Before you start

โฑ๏ธ Time needed1-2 hours to set up, then about 15 minutes a week
๐Ÿ’ต Rough costClaude Pro USD 20/month; paid contact-data services are extra

๐Ÿชœ Step by step

๐Ÿฃ Beginner mode: showing the 7 essential steps only. Extra steps are hidden; tap ๐Ÿš€ Advanced at the top to see all 8.
โœ… 0 of 8 steps done ๐Ÿ“„ Printable page
  1. 1
    โ˜

    Decide which leads you want

    Pick the types (expired, cancelled, for-sale-by-owner), the areas and price range. Write them down in two lines: that's your brief.

  2. 2
    โ˜

    Make a Claude Project

    In Claude, create a Project (a saved workspace that remembers files and instructions) called Weekly Call List and paste in your brief.

  3. 3
    โ˜

    Download the listings

    Export expired and cancelled listings for the last 7 days from your portal or MLS as a spreadsheet. For owner-sold homes, save the public listing pages or copy their details.

  4. 4
    โ˜

    Let Claude build the sheet

    Upload the files and paste the 'Weekly call list' prompt. Claude removes duplicates and builds one table with address, price, days listed, status and the contact details the owner published.

  5. 5
    โ˜

    Check do-not-call before dialling

    Check every number against your country's do-not-call register and your privacy rules. Only use contact details the owner made public or that come from a data service you're licensed to use.

  6. 6
    โ˜

    Prepare what to say

    Use the 'Call opener' prompt so each agent has a short, honest reason to call based on that home's history (how long it was listed, any price cuts).

  7. 7
    โ˜

    Track results

    Add columns for 'called', 'outcome' and 'next step'. Each Monday, ask Claude which lead types turned into appointments.

  8. 8
    โ˜

    Optional: make it a weekly routine

    Save the prompt in the Project's instructions so next week you only upload the new exports and say 'run this week's list'.

    โž• Extra step: hidden in ๐Ÿฃ Beginner mode

๐Ÿ’ฌ Copy-paste prompts

Tap Copy prompt, paste it into your AI (Grok, ChatGPT, Claude or Gemini), then replace the [yellow bits] with your own details.

๐Ÿ’ฌ Weekly call list
You build my weekly property call list. My brief: [lead types], in [areas], priced [range].
From the attached files:
1. Keep only listings that are expired, cancelled or for sale by owner, from the last 7 days.
2. Remove duplicates (same address, even if spelt differently).
3. Make one table: address, area, last price, days on market, number of price cuts, status, owner contact as published, source, and empty columns for 'do-not-call checked', 'called', 'outcome', 'next step'.
4. Sort with the most promising first (longest on market with price cuts, then owner-sold).
Only use details that are in the files. If a contact detail is missing, write 'not listed'. Never guess or look up private phone numbers.
๐Ÿ’ฌ Call opener
For each of the top 10 homes in this week's list, write a 2-sentence, honest opening line for a phone call from an agent at [agency name]. Mention one real fact from the listing (for example days on market or a price change), say why I'm calling, and ask one open question. No pressure, no claims about buyers I don't have. British English.

โš ๏ธ Tips & common mistakes

๐ŸŒŸ Why it's worth it

๐Ÿ’ก Why it mattersOwners whose home didn't sell, or who are selling alone, often want help but nobody has called them yet. A clean weekly list means every agent starts the week calling instead of searching, and you can track which calls turn into valuations and listings.
๐Ÿท๏ธ Real exampleSven Andersen, who leads the Keller Williams-affiliated Andersen Realty Group near Boston, told Banker & Tradesman (4 Oct 2026) that his team hired a college student to build a tool in Claude that finds expired, cancelled and for-sale-by-owner listings, and puts addresses and phone numbers into a spreadsheet the team calls from. He says it freed his time for talking to people and led to USD 4 million in 'unseen opportunities' (possible deals, not sales). He also prepaid Claude for his team for the year.
๐Ÿ”Œ Connects to:Your listings-portal or MLS export (a spreadsheet download)Public for-sale-by-owner listingsGoogle Sheets or Excel
๐Ÿข Proof level: Named companyA real, named business written up by the press or on its own website. You can look the business up yourself.
๐Ÿ“ฐ Found via News ยท Banker & Tradesman: Banker & Tradesman: Teams, indie brokerages get ahead with AI (Sam Lattof) โ†—

๐Ÿ”— Helpful links

๐Ÿ“ฌ Every Monday: new things AI can do for you, with the exact prompt to copy

Sign up free and get our PDF of 20 copy-paste AI prompts straight away. One short email a week, unsubscribe in one click.

โ† Back to all use cases