Tuesdays are 3 AI updates, one hot take, one action. Weekends are 1 practical real estate agent workflow.

On Tuesday I said Claude is swallowing the apps in your other browser tabs. This weekend, put that to work on the most useful question you can ask before January: where did my 2026 business come from? Most of us have that answer sitting in our inbox and calendar and never ask for it. This will take you ten minutes and you'll end with a Claude summary of your year.

What you need. A paid Claude plan with Gmail, Google Calendar and Google Drive connected (Settings, then Connectors), plus your 2026 closings exported from your CRM or MLS if you can get them. Sheets and Whiteboards are in beta on paid plans. Because you'll be working with deal data, turn off the setting that lets Anthropic train on your chats first (Settings, then Privacy).

example output from the below actions (data not real)

1. Build your year as a Sheet (5 min)

Paste this into a new chat:

❝

Look through my Gmail, Google Calendar and Google Drive for every transaction I closed in 2026. Build a Claude Sheet with one row per deal and columns for closing date, address, price, buyer or seller side, lead source and date of first contact. Mark anything you're guessing with a check mark.

Upload and add your CRM export for an even more effective answer.

2. Fix the guesses (5 min)

Lead source is the column Claude gets wrong most, because it's rarely written down anywhere. Fill in every CHECK yourself, and add first-contact dates where you remember them. Claude shows you each cell it changes, so nothing moves without you seeing it.

3. Ask where the business came from (5 min)

❝

Using this sheet, add a tab that shows, for each lead source, the number of deals, closed volume, average price and average days from first contact to closing. Then list any past clients who sent me more than one deal, and tell me what this data can't show.

This is the tab I'd screenshot and keep. Pay the most attention to the days column, because a source that closes in six weeks is worth more than one that took a year.

4. Put 2027 on a whiteboard (5 min)

❝

Based on that tab, put my 2027 plan on a whiteboard by quarter. Give more of my time to the lead sources that produced the most closed volume, and list what I should do in January.

Read it against your own memory of the year. If a source looks great on paper but those clients wore you out, move it yourself.

5. Let it update itself (5 min)

Schedule a task for the first Monday of every month:

❝

Add any new closings from my Gmail and calendar to my deals sheet, and tell me which lead source moved since last month.

That turns a one-time look back into a scoreboard you check once a month, and next November this takes you five minutes.

Where this breaks

Claude will guess at lead sources it can't see, which is why step 2 comes before step 3. Sheets has simple spreadsheet functions for now, so keep the math to totals and averages and leave commission splits in your real spreadsheet. And the data can't tell you which clients you'd happily work with again, so I'd weigh its answer against your own sense of the year.

AI FOR RE AGENTS DECEMBER COURSE IS OPEN

Matt Spangler coaching an agent at her laptop. The AI System for Top Real Estate Agents, live online December 6 to 12, rated 4.8 on Maven. Save your seat.

My December course runs December 6 to 13 in four live online sessions, so you can join from anywhere. Enroll at maven.com/matt-spangler/ai-for-real-estate. Everything else lives at agent-intelligence.co. Here are some reviews from my most recent course:

“Finally a course that was interactive and not just someone talking at me... I was actually able to set up my Google calendar, gmail, Canva and more.” - Kelli J., agent

“I use Chat GPT often and have been reluctant to dive into Claude, as I really did not know where to start. This was a well spent Saturday afternoon.” - Lisa V., agent

“100% worth it. I highly recommend taking this; it’s definitely elevating my skills.” - Shawn W., agent

-Matt