Open-house follow-ups that turn sign-ins into showings

Sunday open house. 22 people walked through. By Wednesday you’ve contacted maybe 3 of them, and two of those got generic “thanks for visiting” emails. By Friday the leads are cold. AI doesn’t fix the volume problem — it fixes the quality-at-scale problem so all 22 get a real follow-up by Monday morning.

What a useful open-house follow-up is NOT

It’s NOT “Thanks for visiting [property]! Let me know if you have any questions.”

That email teaches the lead that you’re a generic agent who runs through a list. Twenty-two of those go out from every open house in town. They all blend together. Yours has to be different.

What a useful one IS

It references something specific about THEM that they revealed during the walkthrough. That’s the only differentiator that matters.

The Sunday-night data capture

The trick is capturing the right data at the open house, not in the follow-up. Add three columns to your sign-in sheet beyond name + email:

| What brought you in today? |
| What's your timeline? |
| Anything specific you're hoping to find? |

Most attendees will write something. Even half-answers are gold. If they won’t fill out the column, write your own observations in a small notebook right after they leave: “couple, mid-30s, asked twice about the garage, mentioned they’re at a different open house at 3.”

This is the input AI needs.

The Sunday-night batching workflow

Sunday evening, 30 minutes. You’ll come out with 22 personalized emails ready to send Monday morning at 9am.

Step 1 — Categorize quickly

Sort the sign-ins into three buckets:

Hot: specifically interested in this property, has a timeline, asked detailed questions
Warm: in the market for this neighborhood / type, but this specific property isn’t quite right
Cold: just looking, no timeline, neighbors curious, etc.

Each bucket gets a different email.

Step 2 — The follow-up generator prompt

📋 Prompt — copy & paste v1

Generate personalized open-house follow-up emails for the leads
below. Three different templates depending on their bucket; SAME core
structure.

CONTEXT FOR ALL EMAILS:
- Property visited: [address + 1-line summary, e.g. "3-bed Craftsman on
Maple, listed at $675k"]
- Open house date: [date]
- My name: [first name + brokerage]
- My booking link or phone: [link/phone]

LEADS (give me each in this format and I'll paste a list):
- Name: [first name]
- Bucket: HOT / WARM / COLD
- Specific thing they said or did at the open house: [their question, comment,
or a clear behavior I noticed]
- Timeline they mentioned: [if any]
- Email: [for my reference, don't include in body]

OUTPUT — for each lead, generate:

SUBJECT LINE: 4–7 words, specific to what they said. NOT "Following up on
the open house" or "Thanks for visiting".

BODY (90–140 words):
- Open with a SPECIFIC reference to what they said/did — proves I remember
- ONE sentence answering or addressing the thing they cared about
- For HOT: include 2 honest specifics about the property they may not have
caught + suggest a private second walk-through
- For WARM: pivot to "based on what you said, here are 2 other listings I
think fit better" (I'll provide the addresses)
- For COLD: brief, friendly, no pitch. Plant a seed: "if your timeline shifts,
here's how to reach me."
- Close with ONE clear, low-pressure next step
- Sign off: first name only

CONSTRAINTS:
- No "Hope this finds you well", no "great meeting you", no "circling back"
- Never reference price unless they did
- Match a warm professional tone — sound like a person, not an agent
- Fair Housing: no demographic language about who the property is "for"

Works in: ChatGPT · Claude · Gemini · Run the prompt once, paste in all 22 leads, get all 22 emails back

Step 3 — Edit one phrase per email

AI will draft 22 emails. Spend 5 minutes total adding ONE personal phrase to each — the kind only you would say. This is what makes them feel real to the recipient and stops them blending together.

Step 4 — Schedule send for Monday 9am

Don’t send Sunday at 11pm. Don’t send Monday at 6am. Monday between 9-10am gets the highest open rate for real-estate follow-ups. Use your email client’s scheduler or BCC into Mailtrack/Mixmax.

Example outputs by bucket

HOT (Sara — said “I love the kitchen but worried about the basement”):

Subject: The basement on Maple — quick honest take Sara — quick note on the basement you flagged Sunday. The seller’s disclosure shows water mitigation in 2022; I have the receipts and the sump-pump warranty. Happy to walk you through the full story before you decide. If it’d help, I can hold a private 30-min walkthrough with the listing agent on Wednesday afternoon — just reply with a time. Either way, the kitchen really is special. — Diego

WARM (Marcus — said “love the area but need a bigger lot”):

Subject: Bigger lots in the same area Marcus — based on the lot-size question Sunday, two listings just hit the MLS that I think fit you better than Maple did. Both are within a half-mile in your same school zone, lot sizes 0.4 and 0.5 acres respectively. Want me to send the details, or schedule a quick drive-by? — Diego

COLD (Karen — was just curious, neighbor):

Subject: Open house Sunday Karen — thanks for stopping in Sunday. Always good to meet a neighbor. If your timeline ever shifts and you’re curious what the block is doing price-wise, just reply and I’ll send a quick comparable. No rush either way. — Diego

What NOT to do

Don’t send the same email to all 22 with mail-merge. AI lets you batch variant emails — use that, not mass-send.
Don’t follow up more than 3 times for a single open-house lead. Touch 1: Monday. Touch 2: 2 weeks if no reply. Touch 3: 6 weeks. Then archive.
Don’t sell hard in the first email. The job is to keep the conversation open, not to close.

What to expect

Agents who run this workflow consistently see:

Email reply rates of 25-40% vs the industry average of 5-8% on open-house follow-ups
Showings booked from open-house leads roughly triple
Better word-of-mouth because even the “no thanks” replies are warmer

The deeper truth: AI doesn’t replace knowing your buyers — it lets the knowing scale. The notebook entries you make during the open house are your competitive advantage. AI just turns them into something the lead opens.