How to nurture past clients and sphere of influence on Mac: a weekly routine for realtors

Why past clients slip off your radar

A closed deal ends the work on your calendar, but not in your client's life. The next lead lands in your inbox that same afternoon. The past client stays quiet. Nothing on your screen asks you to call them, so the relationship fades without a single decision.

The numbers show why this matters. The 2026 Member Profile from the National Association of REALTORS reports that the typical REALTOR earned 28% of business from repeat clients and customers. Another 22% came from referrals from past clients and customers. Both figures use 2025 data.

Those shares describe the typical agent, not you. They do not say how many past clients an agent keeps in touch with. They also do not measure the time that upkeep takes. Use them as a reason to check your own numbers, not as a forecast.

What the income figures do and do not show

NAR also reports median gross real estate income by years in the business. The gap between groups is wide. Read the table as a pattern, not as a plan.

A longer career brings more past clients to call. That is one reason the gap may exist. Experience brings other advantages too, and this data does not separate them. A database cannot explain the whole gap. It is one part you can control right now.

Build one list you can trust

Start with what you already have. Many agents keep contacts in more than one place. You might have Apple Contacts on your Mac, a Gmail list, a CRM export, and an old spreadsheet from a previous job. Pick one master for each kind of detail.

Use Contacts as the master for names, phone numbers, and addresses, since it already lives on your Mac. Use Google Sheets as the working list for dates, notes, and next steps. The sheet tells you who to call next. Contacts holds the details.

Merge duplicates in Contacts

Open Contacts and choose Card > Look for Duplicates. Review each pair, then click Merge. Apple says merging keeps all unique information in one card. Still, read each pair before you accept it, since two different people can share a name.

For cards you spotted yourself, select them first. Then choose Card > Merge Selected Cards. This works well when a past client changed a work email after a sale, and you have two cards for the same person.

Watch for cards from different accounts. Apple's guide says you can link cards from accounts such as Yahoo and Google instead of merging them. Linking is the better choice when you want both accounts left alone.

Back up before you change anything

Choose File > Export > vCard to save selected people as a .vcf file. Choose File > Export > Contacts Archive to save every contact as an .abbu file, with no selection needed. Check Contacts > Settings > vCard first. Unchecking Export notes or Export photos leaves those fields out.

Apple's page does not say whether those vCard settings also apply to Contacts Archive files. Test the archive by checking a few cards that have notes and photos before you rely on it.

Turn the list into a weekly working sheet

Make one tab in Google Sheets and keep it plain. Each row is one person. Each column answers one question you ask every week. The columns below work for most realtors, and you can change them later.

• Name: spelled the same way as in Contacts.
• Relationship: past client, sphere, referral partner, or lender.
• Last contact: the date of your last real conversation, not a mass email.
• Next touch: the date you want to reach out next.
• Personal detail: only what the person shared with you, such as a school event or a trip.
• Notes: one line on what they asked for or said they liked.

The Next touch column does most of the work. Filter it so only this week's names show. In Google Sheets, select your header row and choose Data > Create a filter. Our guide to adding a filter walks through each click.

Duplicates in the sheet fool you just as badly as duplicates in Contacts. Clear them first with our guide to removing duplicate rows. Then sort with our guide to sorting by column, so the earliest due dates sit on top.

A worked example

Say a family closed on a house a few years ago. Their Last contact cell is blank. You set the closing anniversary as their Next touch date. When that week arrives, the row appears in your filter. You send a short note, then type today's date into Last contact.

The row then drops out of the week's view. It returns when its next date comes up. That loop is the whole system: a date, a filter, a note, and a fresh date.

Write notes past clients are glad to get

A past client does not need a weekly newsletter from you. They need a short message that sounds like you. Keep it to a few sentences. Mention one thing you know about them. Ask one question they can answer in a line.

Write three templates in Gmail: a sale anniversary note, a short local market update, and a simple check-in. Replace one detail each time, such as the street or a shared memory from the Notes column. A template that reads like a form gets skimmed. See our Gmail guide for realtors for more setup ideas.

If you send a market update with a graphic, build it in Canva first, then attach it to the Gmail note. Our Canva guide for realtors covers flyers and postcards. Keep the graphic simple, so the message still reads like a note from you.

Before any bulk send, check your brokerage's rules on client data and marketing email. Your brokerage may set rules for how contact data is stored and used. Follow those rules, not a guess from this page.

Mistakes that keep the list dead

• Two masters. When Contacts and the sheet disagree, nobody trusts either one.
• Logging closings only. A list with no conversations gives you no reason to call.
• Mass blasts with no personal line. Readers tend to skim a message that could go to anyone.
• Deleting old contacts instead of archiving them. Export first, then remove.
• Waiting for a perfect list. A list that is mostly clean still gets used.
• Skipping the weekly review. A list stays dead without a set time on the calendar.

Clients who asked not to be contacted need a clear marker. Write it in the Notes column, and keep those rows out of any filter that feeds a send. Ask your brokerage how long to keep those records, since rules differ.

People who are not clients belong on the sheet too. Lenders and referral partners often matter to your business. Mark them in the Relationship column so they do not crowd out your client filter.

If you work on a team, decide who owns the master list before you clean it. Two people editing two masters creates the same mess again within weeks. Write the owner's name at the top of the sheet.

Start with one cleanup this week

Do not start with the whole system at once. Export a backup, run Look for Duplicates, and merge only the pairs you have checked. Then build the sheet with a short set of columns and a Next touch date for each person.

After that, run the weekly loop: filter, write, send, update. The first month will feel slow. The routine gets easier once the list stops fighting you.