Every Monday, a List of Which Clients Need a Check-In From You

Most coaches track client check-ins from memory: a feeling that you haven't heard from someone in a while, a glance at the calendar, a scroll through messages. It works until a busy month, and then the quiet clients are the ones you miss, because they're quiet. The usual advice is a tracker with a "days since contact" column, or an automation that emails every client a form. We'd do it differently. One sheet, filled in from your calendar, with one formula that writes why each client needs a check-in this week. Every Monday you open a filtered view, and AI drafts a short, specific message for each person on it. You read every one and you send it yourself. The list doesn't need AI. The drafts do.

Time check: about 45 to 75 minutes to set up once: 20 to 30 minutes to build the sheet, 20 to 30 to fill it in from your calendar and inbox, and 10 to save the message templates. After that, about 15 to 20 minutes every Monday for 8 to 15 clients: 5 to update dates, 1 to open the list, 10 to draft, read, and send. If you now do this by scrolling your calendar and messages and trying to remember, or you mostly don't do it, that's roughly 15 to 30 minutes back a week. The bigger difference is harder to count: you notice a drifting client while there's still time to talk. This is an estimate, not a measured result.

Who it's for

Coaches and solopreneurs with recurring 1:1 clients, roughly 5 to 30 of them, on weekly, every-other-week, or monthly sessions, or in packages that end. If you have fewer than five clients, a recurring calendar note may be enough. If you run a group program, use this for your 1:1 clients first.

What you need

• Google Sheets (free): Or Excel; the formula works in both with small changes. Settings used: View > Freeze > 1 row, Data > Data validation (a dropdown for Status), Format > Number > Date for the date columns, Format > Conditional formatting, and Data > Create filter view.
• Your calendar: Google Calendar, Calendly, Acuity, or whatever books your sessions. You only read dates from it. No integration needed.
• Any AI chat tool: ChatGPT, Claude, Gemini, or Grok. Free tiers are fine: you paste a few short rows, not session notes.
• A recurring 15-minute slot: A Google Calendar event every Monday morning, "Check-in list", with the sheet's link in the description.
• Privacy settings checked: First names only, and one line of context per client with nothing about health, money, or relationships. In ChatGPT: Settings > Data controls > turn off "Improve the model for everyone", or use a Temporary Chat. In Claude: Settings > Privacy > turn off "Help improve Claude". More in AI session notes without breaking client confidentiality.

It pairs well with Weekly Client Check-In Form + AI Summary Before Each Session and Coaching Call Transcript to Client Recap + Action Items. New here? Get the free guide: 3 complete workflows for weekly posts, client recaps, and call prep. Not sure where to start? See every workflow by job or count your admin hours.

The steps

1. Decide what earns a check-in (10 minutes)

   "Check in more" isn't a rule, so it never happens on a busy week. Write down the reasons that should put a client on your Monday list. These four cover most coaching practices:

   • No session booked. They're active and nothing is on the calendar. This is the earliest sign of drift, and the easiest to fix: one message with your booking link.
   • Quiet for longer than their rhythm. A weekly client you haven't heard from in 10 days is a different story from a monthly client you haven't heard from in 10 days. So each client gets their own number: the usual days between sessions.
   • A commitment is due. They said they'd do something by a date. A short "how did it go?" on that day often does more than the next session.
   • The package is ending. Two sessions or fewer left, or it ends within three weeks. This is a care message, not a sales message (step 5 explains).

   And two reasons to stay off the list: you already checked in during the last 7 days, or the client paused by agreement. A client who asked for space until January gets one message in January, on the date you both agreed. Put that date in your calendar now.

   Done when: you've picked your reasons (start with the four above), and you know each client's usual rhythm: 7, 14, or 30 days.

2. Build the sheet once, with a formula that writes the reason (20 to 30 minutes)

   Make a new Google Sheet called Client check-ins. One row per client, these thirteen columns in this order (column M is a formula):

   CopyA First name B Status (dropdown: Active, Wrapping up, Paused) C Rhythm (days) (7, 14, or 30) D Last session (date) E Next session (date, or blank if nothing is booked) F Last heard from them (date of their last reply, message, or session) G Open commitment (their words, one line) H Commitment due (date, or blank) I Sessions left (number, or blank if not a package) J Package ends (date, or blank) K Context (one line, nothing private: "starting new job Nov 3") L I last checked in (date) M This week's reasons (the formula below)

   Paste this into M2, then drag it down to the last row:

   Copy=IF(OR(B2="",B2="Paused",AND(L2<>"",TODAY()-L2<7)),"",TEXTJOIN(", ",TRUE,IF(OR(E2="",E2<TODAY()),"no session booked",""),IF(AND(F2<>"",TODAY()-F2>C2),"quiet "&(TODAY()-F2)&" days",""),IF(AND(H2<>"",H2<=TODAY()+7),"commitment due "&TEXT(H2,"mmm d"),""),IF(AND(I2<>"",I2<=2),"sessions left: "&I2,""),IF(AND(J2<>"",J2<=TODAY()+21),"package ends "&TEXT(J2,"mmm d"),"")))

   What it does: it stays blank for paused clients and for anyone you checked in with in the last 7 days. For everyone else it lists every reason that applies, like no session booked, commitment due Oct 30. Change the numbers to fit you: 7 is the cool-down, 2 is "sessions left", 21 is the days before a package ends.

   Then four settings:

   1. Status dropdown: select B2:B, Data > Data validation > Add rule > Dropdown, with Active, Wrapping up, Paused.
   2. Dates as dates: select D, E, F, H, J, and L, then Format > Number > Date. If a date is typed as text, the formula quietly skips it.
   3. Highlight the list: select A2:M, Format > Conditional formatting > Format cells if > Custom formula is, enter =$M2<>"", and pick a light yellow fill.
   4. Your Monday view: Data > Create filter view, name it Monday list, filter column M by condition Is not empty. Also View > Freeze > 1 row.

   In Excel, the formula works as written in Excel 2019 or Microsoft 365 (TEXTJOIN). Use the Filter button for the view.

   Done when: the sheet has all 13 columns, the formula is in every row of M, and a test row with a past commitment date shows "commitment due" in M.

3. Fill it in from your calendar and inbox (20 to 30 minutes, once)

   Open your calendar for the last six weeks and the next six. For each client, fill in the last session, the next session (or leave it blank), and their rhythm. Then search your inbox and messages for their name to get "last heard from them". Copy the open commitment from your last session notes, in their words.

   If you'd rather not type it all, AI can turn a pasted list into rows. In Google Calendar, search the client's name (or your session event name) and copy the results list. Paste it into this prompt with first names only:

   Copy this prompt

   Prompt: Turn my calendar list into sheet rows

   CopyBelow is a list of my coaching sessions copied from my calendar, with first names only. Today's date is [date]. [paste the session list] For each client, give me one row I can paste into Google Sheets, tab-separated, in this order: First name, Last session (the most recent date before today), Next session (the first date after today, or blank), Rhythm (the usual number of days between their sessions, rounded to 7, 14, or 30). Rules: - Use only dates in the list. Don't guess any date. - If a client has only one session in the list, write CHECK in the Rhythm column. - Don't add any column I didn't ask for. - After the rows, list any names that look like the same person written two ways.

   Done when: every active client has a row, the dates are real dates, and column M shows reasons for some clients but not all of them. If every row shows a reason, the dates are probably stale: check column F first.

*Time saved is an estimate based on typical manual effort for this task, not a measured result. Your mileage will vary. Always review AI output before sending or publishing.

Next: Turn One Voice Memo Into a Week of Social Posts →