How to Build a Simple Client CRM in Airtable
Right now your client info is probably split across a spreadsheet, a notes app, and a few sticky notes you'll lose by Friday. This mission walks you through building one Airtable base that holds your clients and your meetings with them, connected so nothing falls through the cracks. You'll set up a follow-up date that calculates itself and an automation that sends the email for you, two weeks after every meeting, without you lifting a finger. By the end you'll have a live client tracker that reminds you to follow up instead of the other way around.
Who this is for: Anyone tracking clients in a spreadsheet or notes app who keeps forgetting to follow up after a meeting.
By the end, you'll have:
- A Clients table linked to a Meetings table so every meeting ties back to the right person
- A formula field that calculates a follow-up date two weeks after each meeting on its own
- A working automation that sends a follow-up email on that date without you touching it
- A clean dashboard view you can check each morning to see who needs attention
What you'll learn:
- How linked records connect two tables so the same data shows up in both places
- How to write a simple formula to calculate a date
- How to build an automation with a trigger and an action
- How to turn a table into an interface you'd actually want to open
The journey
3 objectives. One real outcome.
Objective 1
Build your client and meeting tables
Set up a Clients table and a Meetings table, then link them so every meeting points back to a person.
Objective 2
Set up automatic follow-up emails
Add a formula field that calculates a follow-up date, then build an automation that emails the client on that date.
Objective 3
Build a dashboard you'll actually open
Turn your data into a clean interface showing each client, their info, and their latest meeting.
Frequently asked questions
Do I need to know how to code?
No. Everything here is point and click, including the formula.
Will this work on Airtable's free plan?
Yes, everything in this mission fits on the free plan.
I already track clients in a spreadsheet. Do I have to start over?
Start this base fresh, then move your client list in once it works.
Can I change the follow-up email later?
Yes, you can edit the subject and message anytime from the automation.
What if I don't use Gmail?
You can send from Airtable's own address instead, no extra account needed.