Hub › Lessons › Client onboarding, lesson 3
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:
| Property | Type | What goes in it |
|---|---|---|
| Client | Title (the first column) | The client or business name |
| Stage | Select | Enquiry, Onboarding, In progress, Waiting on client or Done |
| Due | Date | When the next action is due |
| Next action | Text | The one next thing you must do, starting with a verb, such as "Send proposal for 3-page site" |
- One next action per client. The tracker answers "what do I do next for this client?", not "everything I ever have to do". If you need a full task list, keep it inside the client's page.
- "Waiting on client" still has an action. Your action is to chase, so write "Chase intake form" and give it the date you will chase.
- Keep contact details out. You only need the name to know who it is. Phone numbers, addresses and bank details belong in your email or invoicing tool, not in a list you might share.
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:
- Choose Filter, pick Due, set it to is on or before and choose the relative date One week from now.
- Add a second filter: Stage is not Done.
- 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.
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:
- Copy the CSV block into a plain text file and save it as
clients.csv. - Open the Clients database as a full page, click the ••• menu at the top and choose Merge with CSV.
- 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
- The numbers add up. Under Check, the clients in your notes should equal the rows in the CSV.
- Every date is one you wrote. Compare each Due date with your notes. "Next Tuesday" should come back empty, not as a guessed date.
- Read Needs a date and Also open. Give each client under Needs a date a real date, or it will sit in view 2. Anything under Also open is a second action the row does not show; add it to the client's page or decide it is done.
- Every stage is one of yours. A stage name that is not in your Select options will not match.
- No contact details. Search the CSV for phone numbers, emails and account numbers before you import it.
- One CSV block. In a few of our tests the AI showed a CSV, then a corrected copy. If you get two, use the last one and check it.
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)
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.
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:
| Client | Stage | Due | Next action |
|---|---|---|---|
| Extra test row (overdue) | Waiting on client | 6 Nov | Chase signed agreement |
| Kopi Corner | In progress | 11 Nov | Reply with change cost for menu page |
| Lim Physio | Waiting on client | 13 Nov | Chase Lim Physio for intake form |
- The overdue row came first, because of the "on or before" filter and the sort by Due. A this-week filter would have hidden it.
- The 20 Nov row and the Done row were left out, as the filters should do.
- "Needs a date" showed exactly the three clients the AI listed: Studio Ana, Tan & Co Accounting and Haji Lane Barbers. Bloom Florist (Done, no date) did not appear.
What we changed after testing
The prompt above is the third version. We ran all three on the same inputs:
- Version 2 lists earlier actions that are still open. With one row per client, Kopi Corner's sitemap draft (due 12 Nov) dropped out of the row when a newer note arrived. Version 1 mentioned it in only 2 of 3 runs; versions 2 and 3 listed it under Also open every time.
- Version 2 leaves a date empty when it could be read two ways. We tested a made-up bookkeeper's notes with dates like 10/11/2026 and the date line left blank. Version 1 read them as day/month in both runs and said so afterwards. That happens to be right for Singapore, but it was a guess. Versions 2 and 3 left the dates that could be read two ways empty and explained why, and kept 11/11/2026, which reads the same either way.
- Version 3 moves Due before Next action and writes None for finished clients. In versions 1 and 2, lines ending in an empty value often came back with a stray comma, space or bracket after it, and the AI then printed a corrected second copy. With Due moved and no empty value at the end of a line, that stopped.
- What did not change: in all runs, "next Tuesday" was left empty rather than guessed, the phone number and the bank account number never reached the CSV, and with no notes the AI asked for them and stopped.
Watch out for
- A tracker only helps if you update it. When you finish a next action, write the new one and its date straight away. A row with an old action is worse than no row.
- Import once, then edit. A CSV merge adds rows and never updates them, so importing the same clients twice gives you duplicates.
- Relative dates need a real date. "Next Tuesday" or "end of the month" cannot be filtered. Turn them into a date when you write the note.
- The stage is a judgment call. The AI picks the closest stage from your list; change it if you see the client differently.
Next step
Fill the tracker from your intake replies
When a client sends back your intake questions, move them to Onboarding or In progress and write the next action with its date.
Go to lesson 2Next: a one-page scope from your call notes
Lesson 4 shows you how to turn your call notes into a one-page project scope: what is included, what is not, the dates and what to confirm.
Go to lesson 4How we checked this lesson
- On 9 Nov 2026 (about 4 am Singapore time) we ran the prompt with Claude Code 2.1.319 in print mode on four illustrative inputs: the web designer's notes on six clients, a bookkeeper's notes on four clients with dates written as day/month/year, the same bookkeeper notes with the date line left blank, and an empty note list. We ran version 1 nine times, version 2 ten times and version 3 fourteen times. The CSV above is from the first web designer run of version 3.
- A separate script checked every output: one CSV block with the exact header and every value quoted; one row per client; each stage on the list and the expected one; each Due date matching the notes or empty where it should be; "Chase" for clients we wait on; Needs a date naming every open client without a date; the Kopi Corner sitemap action mentioned; and no phone or bank account number anywhere. Version 3 passed in 12 of 14 runs; the other 2 put quote marks around the header row, which is still a valid CSV header, and their rows were correct. We also read every output.
- We created a Notion test database with these four properties through Notion's API, added the six rows plus three extra test rows, and created both views with the filters in step 2. Querying the views on 9 Nov 2026 returned the rows shown above. We did not build it in the Notion app itself, and we did not run Merge with CSV; those steps and menu names come from Notion's help pages.
- Notion help pages checked on 9 Nov 2026: Import data into Notion (Merge with CSV, matching headers, MM/DD/YYYY dates, merges add rows) and Views, filters and sorts (Filter, filter groups, Save for everyone, Sort). That page does not list the relative date options, so the "One week from now" label is from Notion's API; if your menu shows a different name, pick the closest option.
- We tested one assistant on made-up notes. AI output varies by tool, model and input, so run the step 5 check each time.
- Last reviewed: 9 November 2026.