🧠 AI Learning Hub

Hub › Lessons › Client onboarding, lesson 3

Lesson 3 · AI for client onboardingAbout 20 minutes

Track every client in Notion and see what is due next

Once you have sent a welcome message and intake questions, the next risk is losing track: whose turn is it, and what is due this week? This lesson sets up a small Notion database with four properties and two views. One shows everything overdue or due in the next 7 days. The other shows every open client with no date, because those are the ones that quietly slip. A tested prompt turns your rough client notes into rows you can import.

What you will be able to do: keep every client in one Notion database and see, in one view, the next action for each client that is overdue or due in the next 7 days.

Step 1: Build the client tracker (5 minutes)

In Notion, create a new page, add a table database and name it "Clients". Rename the first column and add three more properties:

The four properties of the client tracker
PropertyTypeWhat goes in it
ClientTitle (the first column)The client or business name
StageSelectEnquiry, Onboarding, In progress, Waiting on client or Done
DueDateWhen the next action is due
Next actionTextThe one next thing you must do, starting with a verb, such as "Send proposal for 3-page site"

Step 2: Add the two views (5 minutes)

View 1: "Due in the next 7 days". Click + next to the view name and choose Table. Then:

  1. Choose Filter, pick Due, set it to is on or before and choose the relative date One week from now.
  2. Add a second filter: Stage is not Done.
  3. Choose Sort, pick Due, Ascending, so overdue items come first.

Use "on or before", not a "this week" filter. A this-week filter hides anything you missed last week, and missed actions are the ones you most need to see.

View 2: "Needs a date". Add another table view with two filters: Due is empty, and Stage is not Done. A client with no date never appears in view 1, so this view is where you catch them. Aim to keep it empty.

If you share the database, choose Save for everyone after changing a filter, as Notion's filter help describes.

Step 3: The prompt that turns notes into rows

Fill in the first line, change the stages if yours differ, and paste your notes under the third line, one line per note with its date. Then paste the whole prompt into your AI tool. Say how you write dates: in Singapore 10/11 usually means 10 November, but to Notion's CSV import it means 11 October.

Prompt: client notes to tracker rows
Turn my client notes into rows for my Notion client tracker. Use only what the notes say.

How I write dates (for example day/month/year):
My stages (use these names exactly): Enquiry, Onboarding, In progress, Waiting on client, Done
Client notes (one line per note; contact details removed if you can):

Do this:
1. Make one row per client. If a client has more than one note, use the latest one for Stage and Next action. If an earlier note has an action that is still open, list it under Also open.
2. Client: the client or business name as I wrote it.
3. Stage: the one stage from my list that fits best.
4. Due: the date the next action is due, only if the notes give one. Read it the way I said I write dates, then write it as MM/DD/YYYY. Leave it empty if there is no date, if the note only says something like "next Tuesday", or if I did not say how I write dates and the date could be read two ways, such as 10/11.
5. Next action: the one next thing I must do for this client, starting with a verb, in under 12 words. If I am waiting on the client, write what I need to chase, starting with "Chase". If the client is Done and nothing is left, write None.
Output:
- A CSV block with exactly this header: Client,Stage,Due,Next action
- Put every value in double quotes. Show the CSV only once.
Then, after the CSV:
- Needs a date: every client that is not Done and has an empty Due, and why.
- Also open: earlier actions that are still open, with their dates.
- Check: clients in my notes, rows in the CSV. They must be equal.

Rules:
- Never copy phone numbers, emails, addresses, NRIC or bank details into any column.
- Do not make up actions, dates or stages.
- If no notes are given, ask me for them and stop.

Step 4: Add the rows to Notion

For three or four clients, type the rows in by hand from the AI's table. For more, import the CSV:

  1. Copy the CSV block into a plain text file and save it as clients.csv.
  2. Open the Clients database as a full page, click the ••• menu at the top and choose Merge with CSV.
  3. Match each CSV column to the property with the same name, then import.

Notion's import help says the header names should match your property names exactly, that dates import in MM/DD/YYYY format, and that a merge adds rows and does not update existing ones. So use the import to start the tracker, then update each client's row by hand as things move. We followed these steps from Notion's help but did not run the import ourselves; see how we checked this lesson below.

Step 5: Check the rows in 5 minutes

Worked example

This continues the made-up freelance web designer from lesson 2. On Monday 9 November she copied her latest notes on six clients, including two notes about the same client and a phone number she forgot to remove. The business, clients, dates and phone number are illustrative.

Input (illustrative)

Sample input
How I write dates (for example day/month/year): day month year, for example 7 Nov 2026
My stages (use these names exactly): Enquiry, Onboarding, In progress, Waiting on client, Done
Client notes (one line per note; contact details removed if you can):
- 30 Oct 2026, Bloom Florist: Site launched. Final invoice paid 4 Nov 2026. Nothing left to do.
- 2 Nov 2026, Tan & Co Accounting: Sent homepage design. Waiting on their feedback, no date agreed.
- 3 Nov 2026, Haji Lane Barbers: Call done, they want a 3-page site. I need to send the proposal.
- 5 Nov 2026, Lim Physio: Welcome message sent. Waiting for their intake form, reply-by Fri 13 Nov 2026.
- 6 Nov 2026, Studio Ana: Enquiry from Instagram, wants a quote for a 4-page site. I said I would reply by next Tuesday. Her number is 9999 0000.
- 7 Nov 2026, Kopi Corner: Intake form came back. I need to send the sitemap draft by Thu 12 Nov 2026.
- 8 Nov 2026, Kopi Corner: Asked to add a menu page. I need to reply with the change cost by Wed 11 Nov 2026.

Output (as returned)

The CSV is shown word for word from our test with Claude. The notes after it are summarised.

CSV returned
Client,Stage,Due,Next action
"Bloom Florist","Done","","None"
"Tan & Co Accounting","Waiting on client","","Chase Tan & Co Accounting for homepage design feedback"
"Haji Lane Barbers","Enquiry","","Send proposal for 3-page site"
"Lim Physio","Waiting on client","11/13/2026","Chase Lim Physio for intake form"
"Studio Ana","Enquiry","","Reply with quote for 4-page site"
"Kopi Corner","In progress","11/11/2026","Reply with change cost for menu page"

Needs a date: Tan & Co Accounting (no date agreed), Haji Lane Barbers (no date for the proposal) and Studio Ana ("next Tuesday" is not a date).

Also open: Kopi Corner's sitemap draft, due Thu 12 Nov 2026, from the 7 Nov note.

Check: 6 clients in the notes, 6 rows in the CSV. The phone number was left out.

What it looked like in Notion

We added these six rows to a test database with the four properties above, plus three extra made-up rows to test the filters: one overdue (due 6 Nov), one due later (20 Nov) and one Done row with a date (10 Nov). We created both views and queried them on Monday 9 November:

Rows in the "Due in the next 7 days" test view, 9 Nov 2026
ClientStageDueNext action
Extra test row (overdue)Waiting on client6 NovChase signed agreement
Kopi CornerIn progress11 NovReply with change cost for menu page
Lim PhysioWaiting on client13 NovChase Lim Physio for intake form

What we changed after testing

The prompt above is the third version. We ran all three on the same inputs:

Watch out for

Next step

How we checked this lesson