How I Automated My Listing Appointment Prep With AI (Step by Step)

I used to spend about two hours prepping for every listing appointment.

Comps pulled and organized by hand. Seller notes reviewed. A price gap argument built from scratch each time. Objections written out. An email drafted for the night before the appointment.

Two hours. Every appointment. And that assumed I started early enough to have two hours.

Most agents I know do some version of this. Some do it thoroughly. Most compress it when the week gets full — pull a quick CMA, glance at their notes, walk in hoping the conversation goes the way they expect it to.

I found a way to do it in ten minutes. The output is better than what I was producing manually. Here's how it works.


The Problem With Listing Prep Is Not Discipline

Agents know they should prep. They do it when they have time and skip the thorough version when they don't. That's not a character flaw. That's what happens when you ask a busy person to run an unstructured process in whatever time is left over at the end of a full week.

The cost shows up in two places.

You lose listings you should have won because you walked in less sharp than the agent who came in with a tighter argument. Or you take listings at prices you know aren't right because you didn't have an organized case to hold the line on the number.

Both outcomes cost real money. Neither one gets fixed by trying harder or getting up earlier.

The fix is structural. Build a process that produces the same output every time — whether you're rested or running late, whether you did three appointments this week or one. The system does the prep. You show up.

What the System Actually Does

I built a skill file that runs inside Claude — Anthropic's AI system. When a listing appointment is coming up, I open Claude Desktop, grant it access to my Google Drive folder, and type one prompt. It reads two things I've already prepared and builds six outputs.

What it reads first: A Google Form I send to every seller before the appointment. They fill it out on their own time — their price expectation, their timeline, their situation, what they know about the market, why they're selling. Everything I'd spend the first fifteen minutes of the appointment learning, I already have in a structured format before I leave the house.

What it reads second: My comp data. Four to six comparable sales in the format the system expects. Address, sale price, beds, baths, finished square footage, days on market, sale date, and any notable differences in condition or features.

What it builds: Six outputs. A seller brief that summarizes everything I need to know in two paragraphs. A price gap analysis — the delta between their expectation and what the comps support, framed as an argument I can use in the room. A property story. Objection pre-loads for the three or four objections most likely to come up based on the seller's responses. A pre-written email for the night before the appointment. And a question list.

The whole thing in ten minutes. Not compressed prep. Complete prep.

How I Set It Up

The full setup walkthrough is on this site — the step-by-step instructions, the skill file download, and the Google Form template are all there. I'm not going to repeat that here. What I will tell you is what the setup actually involves, so you know what you're looking at before you decide whether to build it.

You need three things. A Google Form for the seller questionnaire — this is what you send sellers before every appointment. A Google Sheet where the form responses live automatically when sellers submit. And Claude Desktop with a Google Drive connection, which is what lets Claude read the sheet without you copy-pasting anything.

The skill file itself is a plain text document that tells Claude what to read, what to build, and what format to use. You fill in four pieces of information — your name, brokerage, phone number, email address — and save it in a folder on your computer. When you run it before an appointment, Claude finds the folder, reads the skill file, locates your seller's form responses, reads the comps you typed in, and generates all six outputs in a single session.

The first time you build the setup takes about an hour. Running it before each appointment takes ten minutes.

There's a beginner version that works in your browser at claude.ai — no app download, no Google connection, you paste the seller's responses into the chat manually. It produces the same outputs. It's the right place to start if you want to see what this builds before committing to the full setup.

The advanced version runs in Claude Desktop, reads your Google Sheet automatically, and creates the prep document directly in your Google Drive. You open it on your laptop or phone on the way to the appointment. That's the version I run.

What Changed When I Stopped Prepping by Hand

I walk into listing appointments differently now.

Not because I became a better presenter. Because I'm actually prepared in a way I wasn't before. Not prepared enough. Actually prepared.

I know the number I'm going in with and I have the specific argument behind it before I park the car. I've already worked through the three most likely objections. I'm not hoping the seller doesn't bring up something I haven't thought through.

The night-before email changed things more than I expected. It's a short email — specific to their situation, warm, professional. Sellers who got it walked into the appointment with a different posture. They felt like they were working with someone who had done the work. Because they were. The conversation started from a different place than it used to.

The objection pre-loads matter more on the difficult appointments than the easy ones. The easy appointments close themselves. The difficult ones — sellers with unrealistic price expectations, sellers who've already talked to three other agents, sellers who are nervous about the timeline — those are where showing up with a prepared argument for their specific objections is the difference between winning and leaving unsigned.

The prep stopped being something I did when I had time. It became something the system does before I'm involved at all.

Free AI Employee
The Listing Appointment Prep Employee

The full system — skill file, Google Form template, and step-by-step setup instructions. Free. No pitch.

Get the Free Employee →

The Part That Took the Longest to Figure Out

The seller questionnaire is the part most agents skip. It feels awkward to send a form to a seller before an appointment — like you're adding friction before you've earned the right to make requests.

The framing matters. I send it as something that makes the appointment better for them, not for me. "I want to make sure I come in already knowing your situation and your goals so we can spend our time on the conversation that actually matters, not on me catching up." Most sellers fill it out. The ones who don't still tell you something — sellers who won't engage before the appointment often won't engage on price during it.

Once the questionnaire is part of your pre-appointment process, everything downstream gets better. The AI system gets better inputs and builds better outputs. You walk in knowing what the seller is thinking before they've said a word. The conversation is qualitatively different.

The questionnaire is the unlock. The AI system turns it into something you can use in the room.

The Bottom Line

This is not an AI story. It's a preparation story.

Agents who prep consistently win more listings than agents who prep when they remember to. That's not a theory — it's a production pattern that shows up in every brokerage I've been inside, including the one I work in, which did over a billion dollars in sales volume last year with 200 agents.

The system doesn't make you a better agent. It makes thorough preparation the default instead of the exception. And preparation that happens every time, consistently, over a full year — that's what the compounding looks like.

The skill file is free. The walkthrough is on this site. If you want to build it, everything you need is there.

Free AI Employee
Build This System Today

The Listing Appointment Prep Employee is free. Beginner and advanced setup paths — both work. Takes one afternoon to build, runs in ten minutes before every appointment after that.

Get the Free Employee →
About the Author
Tyler J. Lewis

Tyler J. Lewis is the Director of Technology at Pemberton Real Estate, Minnesota's #1 independent brokerage, with over $1 billion in sales volume in 2025. He built Pemberton|ONE — the internal platform powering 200+ agents — and is the co-founder of Cirql, the builder of OpenDorz, and the founder of FINDR GEO Services.

He coaches real estate agents on building consistent businesses through AI systems and the fundamentals that have always worked. The Listing Appointment Prep Employee is one of the systems he runs himself before every listing appointment.