The Seller Weekly Update Email, Built With AI in 10 Minutes

It's day 19 on the market. Your seller texts you on a Thursday night: "Haven't heard much, is anything happening?" Something is happening. You had four showings, a decent open house, and feedback that keeps mentioning the same dated bathroom. You just haven't written it up, because writing it up takes 45 minutes you didn't have.

That text is the sound of a seller losing confidence. And in my experience it's usually a communication problem before it's a pricing problem.

A good seller weekly update email fixes it. Below is what sellers actually want in that email, a template you can use this Friday, and the Claude workflow agents in my classes use to build it in about 10 minutes from inputs they already have.

What should a seller weekly update email include?

A seller weekly update should answer five questions in the same order every week: who came, what they said, what happened online, what changed in the market, and what's next. Sellers can skim it in a minute and know exactly where things stand.

Two rules hold it together. Lead with the most important thing, good or bad. And use only numbers you can point to a source for.

That second rule matters most in the online section. If you don't have view counts from a site, don't estimate them. "We had 3 inquiries through my website" is better than a made-up total across portals.

What do you need before you write the update?

You need four inputs, and you probably already have all of them: the showing feedback emails, your notes from the week, online numbers from your own tools, and a fresh market export from your MLS.

1. Showing feedback. Forward or copy the feedback emails and texts from buyer agents. Include the ones that just say "no feedback," because the count matters.
2. Your notes. Calls with buyer agents, what you heard at the open house, anything you did this week (new photos, a price check, a social post).
3. Online activity. Whatever your listing site, social posts, or portal dashboards show you for this listing. Screenshot or copy the numbers.
4. Market snapshot. Export the active, pending, and recently sold listings around the subject from your MLS as a CSV or PDF. Claude can't see your MLS, so this export is how it knows what changed. Use the same search every week so the comparison is fair.

When I teach this in class, the first thing agents ask is how big the market export should be. Small. The same tight search you used for the CMA, refreshed. If you built your pricing with the workflow in how to do a CMA with AI, reuse that search and just re-export it each Friday.

How to build a seller weekly update with Claude in 10 minutes

Set up a Claude Project for seller updates once, then each week paste in your inputs, run one prompt, and check the numbers. The setup takes 15 minutes. Each update after that takes about 10.

Step 1: Create a Seller Updates project

A Project is a workspace with its own instructions and files that every chat in it uses (Anthropic's Projects guide). Upload the template below, two past updates you wrote that you liked, and these instructions:

You help me write weekly update emails to the sellers I represent. I review and send every one.

Always:
- Use the template I uploaded, in the same section order.
- Use only the numbers and facts I give you in the chat or files. Never estimate, round up, or fill in a number. If something is missing, write [CHECK: what's missing].
- Lead the email with the single most important thing from this week, good or bad, in the first two sentences.
- Group showing feedback into themes. Say how many showings each theme came up in. Don't quote harsh comments word for word; describe them fairly.
- Compare the market export to last week's if I give you both, and only report changes you can see in the data.
- Describe the home and competing homes, never the people who live nearby or who should buy.
- Match the tone of my two sample updates. Under 300 words unless I ask for more.
- No legal, tax, or inspection advice. If the seller would need that, suggest they talk to the right professional.

Step 2: Paste the week's inputs

Start a new chat in the Project each week. Paste the feedback, your notes, and the online numbers, and upload the market export.

Step 3: Run the weekly update prompt

This is a fuller version of the short seller update prompt in my Claude prompts list, built to work with the Project above.

Write this week's update for my seller(s), [FIRST NAMES], at [ADDRESS].
Week: [DATES]. Days on market: [NUMBER]. List price: [PRICE].

Showings this week: [NUMBER]. Open house: [YES/NO, VISITOR COUNT]. Second showings: [NUMBER].
Showing feedback (pasted below, including "no feedback" replies):
[PASTE FEEDBACK]

My notes from the week:
[PASTE NOTES: calls with agents, open house conversations, what I did]

Online activity from my own tools:
[PASTE: tool name and the numbers it shows, e.g., "listing website: X visits," "Instagram post: X views." Leave out anything I don't have.]

Market snapshot: I uploaded this week's export [and last week's]. Tell me what's new: new actives, price changes, new pendings, new solds, and anything that went off market. Compare each to the subject home on price, size, and condition where the export has the data.

Next week's plan: [ACTIONS]
Anything I need from the seller: [e.g., "keep the dog out during showings," "decide on paint touch-up"]

This seller is [ANXIOUS / ANALYTICAL / BUSY / HANDS-OFF]. Adjust the length and tone for that.
After the email, list every number you used and where it came from, so I can check it.

Step 4: Check every number

The source list at the end is your checklist. Match each number to the feedback, your tools, or the export. AI can make mistakes, and a wrong showing count is the fastest way to lose a seller's trust.

Step 5: Send it

Send it yourself, or connect Gmail (the + menu, then Connectors) and ask Claude to save it as a draft in your Gmail. By default, Claude asks for your approval before sending anything through Gmail, per Anthropic's Google Workspace connectors article.

Seller weekly update email template

Upload this to your Project as a file, or keep it in a note and paste it when you need it. The brackets are for Claude (or you) to fill.

Subject: [ADDRESS]: week [NUMBER] update

Hi [FIRST NAMES],

[ONE OR TWO SENTENCES: the most important thing this week, good or bad.]

SHOWINGS
- [NUMBER] showings this week ([NUMBER] total since we listed)
- Open house: [VISITOR COUNT or "none this week"]
- Second showings or follow-up interest: [DETAILS or "none yet"]

WHAT BUYERS ARE SAYING
- [THEME 1] (came up in [NUMBER] of [NUMBER] showings)
- [THEME 2] (came up in [NUMBER] of [NUMBER] showings)
- Worth noting: [USEFUL ONE-OFF COMMENT]

ONLINE ACTIVITY
- [TOOL]: [NUMBER] [views / saves / inquiries]
- [TOOL]: [NUMBER] [views / saves / inquiries]

WHAT CHANGED NEARBY
- New competition: [ADDRESS OR DESCRIPTION, PRICE, HOW IT COMPARES]
- Price changes: [DETAILS or "none"]
- Went pending or sold: [DETAILS or "none"]

NEXT WEEK
- [WHAT I'M DOING]
- [WHAT I NEED FROM YOU, if anything]

[ONE-LINE CLOSE, e.g., "Happy to talk through any of this. Call me anytime this weekend."]

[YOUR NAME]

Keep the sections even in a quiet week. "No new competition this week" is useful information, and a consistent format tells the seller you're watching.

How do you tell a seller the feedback says price?

Lead with what buyers are saying and doing, show the market data behind it, and invite a conversation instead of announcing a decision. The email recaps the facts. The conversation about what to do happens on the phone.

This is the week most agents put off. The feedback says "overpriced for the condition" for the third week in a row, and nobody wants to write that email. Waiting doesn't help. Sellers usually sense it before you say it.

A few rules I teach for this week:

• Call first, then email. Price news in an email with no warning feels cold. Send the update right after the call as the written recap.
• Let the data talk. "Four of six showings mentioned price compared to the home on the next street" is easier to hear than "I think we're too high."
• No blame. Not the seller's, not the photos', not the market's. Just what's happening.
• Offer choices. Price, condition, terms, or wait another week with a clear reason. Your recommendation can come on the call.

This week's feedback points to price. Help me write the update and prep the call.

Listing: [ADDRESS], [PRICE], [DAYS ON MARKET] days, [TOTAL SHOWINGS] showings, [OFFERS: none / details]
Feedback themes over the last [NUMBER] weeks: [PASTE OR SUMMARIZE, with counts]
Market export uploaded: actives, pendings, and solds near the subject.
Seller: [MOTIVATION, TIMELINE, HOW THEY TOOK THE LAST UPDATE]

Give me:
1. A 3-sentence opening for the phone call that leads with what buyers are saying, no blame, no recommendation yet.
2. The 3 strongest facts from the export that support the feedback, with the addresses and numbers from the file.
3. The weekly update email, using my template, written as a recap of the call. Calm, plain, kind. Mention the options we discussed: [OPTIONS].
4. Two honest answers to "Shouldn't we just wait for the right buyer?"
Use only my data. Show any math. If the export doesn't support a point, say so.

If the data doesn't back the feedback, that's worth knowing too. Sometimes "overpriced" really means "the kitchen photo is bad." The free Claude 101 kit includes a Price Reduction Conversation tool if you want a ready-made version for this exact moment.

What belongs in a listing activity report for sellers?

A listing activity report is the numbers part of your weekly update, sometimes sent as its own one-page summary: showings, feedback counts, online activity from your tools, and changes in nearby competition over a set period. Some sellers want the whole picture since day one, not just this week.

Ask Claude to build a running version from your past updates:

I'm uploading my last [NUMBER] weekly updates for [ADDRESS] and the latest market export.
Build a one-page listing activity report since we listed on [DATE]:
- A week-by-week table: showings, open house visitors, feedback themes, online numbers I reported.
- Totals to date.
- How the competition has changed since week 1, based only on the export and my past updates.
- The two feedback themes that have come up most since we listed.
Plain language, no jargon. Don't add any number that isn't in my updates or the export. Flag weeks where data is missing.

This is useful before a price conversation, at the 30-day mark, or for the seller who's analytical and wants to see the trend.

How do you schedule the update as a Friday draft?

Set up a weekly scheduled task that reads the week's files and drafts the update every Friday, so it's waiting for your review instead of waiting for you to start. You still check it and send it.

Scheduled tasks run on a cadence you pick (hourly, daily, weekly, weekdays, or manual). You describe the task in a conversation, review the name, schedule, and instructions, and click Schedule. They run in the cloud, so your computer can be closed, and they're on paid plans (Pro, Max, Team, Enterprise). Anthropic's scheduled tasks article has the steps.

The trick is giving the task one place to look. Make a Google Drive folder per listing, and drop the week's feedback, notes, and MLS export in it as they come in. Then:

Every Friday at 10 AM: For each folder in my Google Drive folder "Active Listings," read the files added this week (showing feedback, my notes, online numbers, and the MLS export). Write that listing's weekly seller update using my template and rules. Save each update as a Gmail draft to the seller emails listed in the folder's "seller info" file. Don't send anything. Then give me a short summary: one line per listing with the most important point and any [CHECK] items I need to fill in.

If the drafts come back off, fix the instructions once rather than editing every draft. Once the process is steady, you can also save it as a skill so Claude follows it the same way every time, covered in Claude skills for real estate agents.

What should you do about seller updates this week?

Start with the listing whose seller you've heard from least:

1. Today: copy the template into a Claude Project with two of your past updates and the instructions above.
2. Before Friday: save this week's feedback emails, your notes, and a fresh MLS export for that listing in one place.
3. Friday: run the weekly update prompt, check every number against the source list, and send it before your seller has to ask.