· Back to the setup

AI Setups That Work

Open house sign-ins to follow-ups

Tested by AI Setups That Work. Ran on Claude in a Claude Code session, Nov 17, 2026: 5 made-up open house sign-ins typed in as text became a visitor table, email drafts for the 2 visitors who could be emailed, and one text draft for the only visitor who ticked the text box. The visitor who wrote do not contact got no draft, and an unreadable email address came back as Check the sheet. No photo of a sheet was tried and nothing was sent.

What it does

Turn an open house sign-in sheet into a clean visitor list and one personal follow-up draft per visitor, with consent checked before any text.

Who it is for

Agents who hold open houses and end the day with a paper sheet of names and no time to write to each person.

Tools

Steps

  1. On the sign-in sheet itself, ask for consent in writing: one box for email and one for text. A visitor who leaves the text box empty does not get a text.
  2. After the open house, type the sign-ins into a chat, or dictate them. Add a few words on what each visitor said if you remember.
  3. A photo of the sheet can work in ChatGPT, which accepts image uploads. Handwriting is often misread, so compare every name, email and phone number with the paper before you use it.
  4. Paste the prompt below with the address and the sign-ins.
  5. Read the visitor list first. Fix any name or address the draft got wrong, and remove anyone who asked not to be contacted.
  6. Read each draft. It should mention only what that visitor told you. Add your brokerage details and a way to opt out to each email, then send each one yourself from your own account.

The prompt

You are helping a real estate agent follow up after an open house. Use ONLY the sign-in details and notes below.

First, make a VISITOR LIST as a table: name, email, phone, said yes to email (yes, no or not stated), said yes to text (yes, no or not stated), what they told me, and anything you could not read or are unsure of.

Then write FOLLOW-UP DRAFTS, one per visitor:
- An email draft only if the visitor gave an email address. Under 110 words. Thank them, mention one thing they told me, and offer one next step.
- A text draft only if the visitor said yes to text in writing. Under 300 characters.
- If a visitor cannot be contacted, say so and write no draft.

Rules:
- Do not guess a name, email or phone number. If something is unclear, write "Check the sheet:" and what is unclear.
- Do not assume anything about a visitor from their name, such as family, age, background or budget. Use only what they said.
- Describe the home, not who it would suit, and do not describe the neighborhood by the people who live there.
- Do not say the home is still available or that there are other offers unless my notes say so.
- Leave a line at the end of each email that reads: [your name, brokerage, license number if required, postal address, and how to opt out].
- Draft only. I will check every name against the paper sheet and send each message myself.

Open house address: [address]
Date: [date]
Sign-ins and my notes: [type, paste or dictate them here]

Tips

Sources