Use a sign-in sheet with five fields and an unticked consent box, then paste only each visitor's first name, buyer type and note into an AI tool within an hour of closing. It drafts one short message per visitor with a placeholder for the name, and you personalise and send each one yourself.
The hour matters because open house visitors tour several homes in a weekend. The agent who writes first, and mentions something the visitor said, is the one they remember. The trap is volume: twelve groups can sign in, and by Sunday evening you are tired and send one identical "thanks for coming" email to everybody. AI fixes the drafting problem, as long as the sheet collects the right few details to draft from.
The sign-in sheet: a printable layout
Every field you add costs you completed sign-ins, so each one has to earn its place. Here is a layout that fits on a clipboard sheet and works equally well as a form on a tablet.
OPEN HOUSE: [address] DATE: [date]
Thanks for visiting. Please sign in so I can send you the details of this home.
First name | Last name | Best way to reach you (email or mobile)
Working with an agent? [ ] Yes [ ] No
What are you looking for? (e.g. first home, more space, investment)
____________________________________
One thing you liked, or want to know more about: ____________________
[ ] Yes, you may contact me about this home and similar properties
by email / text / phone (circle all that apply). I can ask you to stop at any time.
Agent: [name], [brokerage]. Your details are used only for this purpose
and are not sold.Three details make this better than the free templates that simply list name, phone and email.
- "One thing you liked." This is the line the AI drafts from. A visitor who writes "the south-facing garden" gives you the first sentence of the message.
- "Working with an agent?" It decides whether you send a follow-up at all (see below).
- A circle-all consent line. Visitors choose the channels. A person who circles "email" only has not agreed to a text.
Don't ask about family status, age, income, religion, or anything else about who the person is. Ask about the home they want. That keeps the sheet respectful, and it keeps a record that cannot be read as screening people by who they are. If your brokerage has its own form, use its approved fields and add the "one thing you liked" line only if your broker is happy.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowConsent wording and the call and text basics
I am not a lawyer, and the rules on contacting people differ by place, so read this as the practical minimum and ask your broker what applies to you. Here is what one regulator says, to show the shape of the rules. The FCC's consumer guide says callers need prior written consent before a prerecorded telemarketing call, and consent before an autodialled or prerecorded call or text to a mobile number. For autodialled texts it adds that commercial texts require written consent, while informational ones may rely on oral consent. It also says anyone can opt out of a robocall or robotext at any time in any reasonable manner, even after giving consent, and that a free National Do Not Call Registry exists for telemarketing calls. A follow-up offering similar homes is a commercial message, which is one more reason to get the permission in writing on the sheet rather than by a nod at the door.
The practical habits that follow from that, wherever you work:
- Get the permission on the sheet. A ticked box with the channel named is much better evidence than "they gave me their number".
- Keep the sheet. Scan it the same day and store it with the lead. If someone later asks why you contacted them, you can show the line they ticked.
- Match the channel to the consent. If a visitor gave an email and ticked email, do not text the mobile number you spotted elsewhere.
- Honour stop requests the same day. A reply of "stop" or "please don't text me" goes straight into your sheet as Do not contact.
- Check call lists before cold calling. A sign-in with a ticked phone box is different from a name you found elsewhere. The cold-calling scripts tutorial goes into the do-not-call side.
Keep the AI out of the permission decision. Whether you may message someone is a yes or no in your sheet, set by what they ticked, and the tool is only asked to write text for people who are already marked yes.
The 60-minute plan after the doors close
| Minutes | What you do | Output |
|---|---|---|
| 0-10 | Photograph the sheet, or export the tablet form; mark each row Yes or No for consent, with channel | One sheet row per visitor group |
| 10-20 | Tag each row with a buyer type and write a five-word note from memory | Buyer type + note columns filled |
| 20-30 | Paste rows into the AI prompt (first name, type, note, no contact details) | Draft messages |
| 30-50 | Read each draft, add one real detail, add the name and send | Messages sent |
| 50-60 | Log what was sent and set a next date on each row | Next step recorded |
Notice that the AI step is only ten minutes of the hour. Most of the value is in the first twenty, where you turn a messy clipboard into clean rows. If you do the typing during the open house (a tablet form that drops into a spreadsheet), you will save that time entirely.
Buyer types that change what you write
Six types cover nearly every visitor. You tag them from the sheet and your memory of the conversation; you do not ask the visitor to pick a label.
| Type | What they usually want to hear | Next step to offer |
|---|---|---|
| First-time buyer | Plain steps, monthly cost clarity, reassurance | A short call about the process |
| Moving up | How this home compares with their space needs | Similar homes with more rooms |
| Downsizer | Low maintenance, single-level living | A shortlist of easier-to-run homes |
| Investor | Numbers, rent potential, condition | A one-page summary of figures you can verify |
| Neighbour or browser | Local market news | A sold-prices summary for the street, if they want it |
| Has an agent | Nothing that invites a switch | A polite thank-you only |
The prompt, and what comes back
You are drafting follow-up messages for a real estate agent after an open house.
Property: 3-bed house, south-facing garden, new kitchen, listed at [price].
For each row below, write one message of 60 words or fewer.
Use "[first name]" as a placeholder. Mention their note naturally.
Channel is given per row: email gets a subject line; text gets no subject.
Never mention price negotiation, never claim market predictions, and
never say anything about the visitor beyond what is in their note.
Rows marked "Has an agent": write a two-line thank-you only.
Rows:
1 | email | first-time | liked the south-facing garden; worried about the deposit
2 | text | moving up | needs a third bedroom for a home office
3 | email | has an agent | noneIllustrative output for row 1:
Subject: The garden at [address], and a quick word on deposits
Hi [first name], thank you for coming along. You mentioned the south-facing
garden: it does get the afternoon sun, which is the first thing the owners
say about it. On the deposit, I can walk you through the typical steps in
ten minutes if useful. Would Tuesday or Wednesday evening suit?
[your name]What you fix: check "the owners say" is true, because the model invented it as a plausible detail and you cannot send what you cannot back up. Check also that the message offers help with the process and does not tell the visitor what they can afford. Keep that habit for every draft: read for claims about the house, claims about the market and claims about the person.
Four message templates you can copy
These are reusable skeletons. Use them with or without AI, and put a real detail into the highlighted slot each time.
First-time buyer, email:
Subject: Thanks for visiting [address]
Hi [first name], thanks for coming today. You mentioned [their note].
If it helps, I can explain how an offer, the inspection and the closing
steps usually fit together, in a short call at a time that suits you.
No pressure either way. [your name]Moving up, text (only where text was ticked):
Hi [first name], [your name] from today's open house at [address].
You said you need a third bedroom: I have two similar homes with one.
Shall I send the details? Reply STOP and I won't text again.Investor, email:
Subject: Figures for [address]
Hi [first name], thanks for coming. I have the annual property tax figure, the
recent sold prices on the street and the current rent range from two
rental agents. Shall I send them as a one-page summary?Before you send an investor message, make sure every figure you promise to send is one you have checked from an official or recent source. If you are not certain, say you will confirm it.
Has an agent, email:
Subject: Thank you for visiting [address]
Hi [first name], thank you for taking the time to see the home today.
I hope it was useful, and good luck with the search. [your name]Worked example: a Saturday with 14 sign-ins
Say an agent holds a two-hour open house and 14 visitor groups sign in. Of the 14: 3 say they are working with an agent, 9 ticked consent (6 for email, 3 for email and text), and 2 left the consent box empty. The agent's sheet reads:
| Group | Type | Consent | Action |
|---|---|---|---|
| 3 groups | Has an agent | Any | Thank-you only, by email if consented |
| 9 groups | Mixed (4 first-time, 3 moving up, 1 investor, 1 browser) | Ticked | Personal message in ticked channel |
| 2 groups | Unknown | Empty | No message; note in sheet; give a flyer at the door next time |
That leaves 9 personal messages plus 3 thank-yous. Writing 9 messages by hand at about 6 minutes each is 54 minutes. With AI drafts, reading and adjusting each one takes about 2 to 3 minutes, so roughly 25 minutes, and the 12 sends fit inside the hour. Those timings are an illustration; run it once and time yourself.
The two empty-consent groups are the point. Without the box, an agent would likely have messaged them anyway. With it, the sheet tells you not to, and you hold the line.
Paper or tablet: which sign-in method suits you
| Method | Strength | Weakness |
|---|---|---|
| Paper clipboard | Fast at the door, no battery, nobody needs a login | Illegible handwriting; typing takes 10-20 minutes afterwards |
| Tablet form | Rows arrive typed; consent saved as data | Queues at the door; visitors dislike typing on a shared screen |
| QR code to the visitor's own phone | No shared surface; clean data | Some visitors will not scan, and signal in some houses is poor |
A sensible default is paper plus a QR code printed at the bottom of the sheet. Visitors who prefer a pen use the pen; those who prefer their phone scan. Whichever route they take, the same fields and the same consent line apply, so your data lands in one shape.
Dealing with illegible and incomplete rows
Paper sheets always produce a few rows you cannot read. Photograph the page before anything else, then type the legible rows first. For a doubtful email address, do not guess: a wrong guess sends a stranger a message about a house they did not visit. Mark the row "Unclear contact", and ask a colleague who was at the door whether they remember. An AI tool with image reading can transcribe a photographed sheet, but treat its transcription as a first pass. Compare it against the photo for every email address and every phone number, since one wrong character makes a contact useless.
A before and after shows the point (illustrative). The photographed line reads "[initial]. [surname], name@exmple.com, 1st home". The transcription gives name@example.com and "first home". The tool has quietly corrected a misspelt domain, which may or may not match what the visitor wrote. The right move is to flag it, and confirm with the visitor at the next contact, not to send on a corrected guess.
Beyond the first hour: a short follow-up sequence
The first message is not the whole job. A short, consent-led sequence keeps good visitors warm without nagging. Here is one that fits within a week, written as a policy you can adjust.
- Within the hour: the personal message above, with one clear offer.
- Day 3: if they replied, answer fully. If they did not, send one useful item such as the sold prices for the street or a link to the listing's floor plan. No question mark at the end.
- Day 7: a short note asking whether they want to hear about similar homes, with an easy way to say no.
- After that: stop, unless they have asked for updates. Move them to a monthly list only where their consent covers it.
Ask the AI to draft the Day 3 and Day 7 messages from the same row, with the instruction to make each message different in opening and purpose from the first. Without that, drafts tend to repeat "just following up", which readers recognise instantly and ignore. A good test is whether the Day 3 message would still be useful to the visitor if they had never heard from you before.
Small cases that trip agents up
- A couple signs once with two emails. Send one message to the first email and name both in the greeting only if both gave consent. If the second person gave an address on the sheet, a single message addressed to both is usually clearer than two separate ones.
- A visitor asks you not to contact them. Write "Do not contact" in the sheet before you leave the house, so it is not undone by a tired follow-up later.
- A neighbour wants to know what the house will sell for. Treat it as a different conversation. Offer a valuation call if they want one, and leave price predictions out of the message.
- A visitor writes a long note. The AI will condense it, and sometimes flatten it. If their note mentions a worry, such as a school catchment or a noisy road, make sure the message answers it with facts you can verify, or says you will find out.
- A fake number. It happens. A bounced email or a wrong number is useful information: mark the row and move on, and do not hunt for the real contact elsewhere.
Quick sum: what the hour is worth
Take the Saturday above. Nine personal messages written by hand at 6 minutes each is 54 minutes, plus 3 minutes for the three thank-yous pasted from the template: 57 minutes, which overruns the hour once logging is added. With AI drafts at 3 minutes of reading and editing each, the nine take 27 minutes and the whole batch 30. The saving is 27 minutes per open house. Over a month with four open houses that is 1.8 hours, which an agent can use to make the three calls that actually book a viewing. The tool is not winning clients; it is returning time to the work that does. These sums are illustrative, so replace them with your own timings after the first event.
Bulk-sending drafts past the consent column
Picture this (illustrative): an agent pastes all rows, including mobile numbers, into a chat tool, then copies the whole output into a bulk-send app. Two messages go to visitors who had ticked email only, and one to a visitor who had said they already had an agent. Nothing malicious has happened, but one recipient replies asking where the agent got their number. The fix is structural: keep a Channel column the drafts must respect, keep numbers out of the tool, and send individually. A bulk-send app should be used only for people whose consent covers it.
Setting up the sheet so the next one takes ten minutes
- Build one spreadsheet with these columns: Date, Address, First name, Contact (email or mobile), Consent channels, Has agent, Type, Their note, Message sent, Next step, Do not contact.
- Save the AI prompt from above in a note, with the listing's two or three headline features swapped in each time.
- Have a tablet or phone version of the form so sign-ins land in the sheet directly. Many CRMs offer one, so check what yours has before building something new; the real estate CRM comparison covers what the main options do with incoming leads.
- Set the next step as a date, not a feeling: "Call Tuesday", "Send two homes Friday".
For the longer game, a visitor who never answers is not a lost lead; they are a contact to add to a monthly update if they consented to ongoing messages. The no-bought-lists tutorial explains how to turn these sign-ins into a list you own, and the open house prompts tutorial has further prompts for the promotion side of the event.
Facts about the house stay with you
The prompt gives the AI three headline features of the listing, and nothing else. That is deliberate. If the model is left to describe the house, it fills gaps with plausible features: a "recently updated bathroom", "quiet street", "great schools". Any of those, sent under your name, becomes a claim you made. Keep a short fact sheet for each listing (size, rooms, what was updated and when, what is included in the sale), paste it into the prompt, and tell the model to use nothing outside it. Then your read-through has one question: does each statement about the house appear on the fact sheet?
How you know it worked
Track three numbers over your next five open houses: the share of visitors who sign in, the share of messages sent within the hour, and the number of replies. If sign-in completion drops after you add the consent line, shorten the sheet rather than removing the line. If replies are low, look at whether your messages mention the visitor's note, since generic ones tend to get ignored. After five events you will have a clear view of which message types are worth the effort.
If you would rather map this with someone, my AI implementation consultation covers that on a 1:1 call.
Questions agents ask about open house sign-in sheets
How many fields should a sign-in sheet have?
Four to six. Name, a preferred contact method with the number or email, a consent tick box, whether they are working with an agent and one question about what they are looking for. Every extra field lowers the number of visitors who finish signing in.
Can I text everyone who signs in?
Only where they have agreed to be texted. Messaging rules differ by place and by how you send, so check with your broker or a lawyer. A clear, unticked consent box on the form is the usual starting point, and you must honour any request to stop.
Should I paste visitor phone numbers into ChatGPT?
You do not need to. Give the AI the first name, buyer type and notes, and let it write the message with a placeholder. Add the name and send from your own phone or email. That keeps contact details out of the tool.
What if a visitor says they already have an agent?
Send a short thank-you and nothing that invites them to switch. Record the fact in your sheet so they are not added to a prospecting sequence by mistake.
Further reads
- AI Marketing for Real Estate Agents: A Four-Week Content Plan — Fitting open houses into a month of marketing.
- AI Real Estate Listing Presentation: Build the Seller Deck — The listing pitch that wins the next open house.
- AI Receptionist for Realtors: Cost, Call Routing and Showing Cover — Handling the calls that follow a busy weekend.
- AI Real Estate Social Media: A Month of Posts From Your Listings — Posting around the event before and after.
- Claude vs ChatGPT for Real Estate Agents: Listings, Follow-Up and Limits — Writing the listing copy that fills the open house.
- Virtual Assistant or AI for a Real Estate Agent: What Goes Where — Which real estate tasks suit AI and which need a virtual assistant, with costs, client-data rules and a 30-day trial plan.
- AI Sales Role-Play for Solo Real Estate Agents: Free Tools Compared — Which free AI tools can play a seller or buyer, what each free tier allows, and an objection bank and weekly routine to practise with.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: FCC consumer guide 'Stop Unwanted Robocalls and Texts' (consent, opt-out, commercial texts and the Do Not Call Registry), read 4 November 2026; message templates and workflow are the author's own.