Home / Playbooks / Airtable Personal CRM
An Airtable personal CRM: template, fields and routine
An Airtable personal CRM is a base with a People table (Name, Company, Tier, Email, Source, Last contacted, Cadence, Next check-in, Notes) and an Interactions table that logs each conversation. A formula calculates who is due, and a filtered view shows them each week. Build it in under an hour, set a cadence per tier, and spend 20 minutes weekly working the list.
Create a base with two tables. People: Name (primary field), Company, Tier (single select), Email, Phone, Source (single select), Cadence (number, days), Notes (long text), and Interactions (link to the second table). Interactions: Date, Type (call, email, coffee, text), and Summary. On People, make Last contacted a rollup of Interactions Date with MAX(values), and Next check-in a formula: DATEADD({Last contacted}, {Cadence}, 'days').
Add a grid view called Due this week (Next check-in on or before a week from today), a kanban grouped by Tier, and a form view for adding someone from your phone. Be clear about the limit: Airtable won't see that you emailed someone, won't remind you unless you build an automation, and won't write the message. The base keeps the list; you keep the habit.
On this page
Who to contact and how often
| Tier | Who | How often | Channel | What to send |
|---|---|---|---|---|
| Inner circle | Mentors, close collaborators, and your most important clients or champions. Tier = Inner circle, Cadence = 30. | Every 2 to 4 weeks. | Phone, text, coffee. | Real updates, questions you'd value their view on, and help when they mention a need. Log each conversation as an Interactions record with a one-line Summary so the next touch builds on the last. |
| Key professional | Clients, partners, peers, and hiring managers who matter this year. Tier = Key professional, Cadence = 60, and Company filled in (or linked to a Companies table if you track several people per organization). | Every 6 to 8 weeks. | Email, LinkedIn, an occasional call. | An article tied to their current project, an introduction, congratulations on wins, and a catch-up call once or twice a year. |
| Wider network | Former colleagues, alumni, event contacts, and friends of friends. Tier = Wider network, Cadence = 90 or 120, with a multiple select field for industry or city. | Every 3 to 4 months. | LinkedIn message, short email. | Congratulations on new roles, a quick note when you see their work, and replies to what they post. |
| New contacts | Anyone met in the last 90 days, added through your form view with Source filled in (event, introduction, inbound) and a note on what you discussed. | A follow-up within 48 hours, a second touch within a month, then move them to a lasting tier. | Email or LinkedIn. | A thank-you that mentions something specific from your conversation, plus anything you promised. |
| Reconnect | People with Last contacted more than 365 days ago. A Days since contact formula, DATETIME_DIFF(TODAY(), {Last contacted}, 'days'), makes this view easy to filter. | One warm message, then a new tier and cadence. | Whatever channel you last used with them. | A no-ask hello that references a shared memory or something they're doing now. |
The 12-month plan
| When | Focus | Actions |
|---|---|---|
| Q1 (January to March) | Build and load the base | Create the People and Interactions tables, formulas, and views. Import contacts by CSV, then delete anyone you wouldn't actually message. Set Tier and Cadence for everyone left and log one Interactions record with your best guess at the last contact date. |
| Q2 (April to June) | Run the routine | Work the Due this week view every week. Add a Birthday field for your inner circle. Clean up Source options and merge duplicates. Reconnect with five people from the Reconnect view. |
| Q3 (July to September) | Midyear review and optional automation | Sort by Next check-in to find everyone overdue and lower cadences you can't keep. Move spring's new contacts into lasting tiers. If you want a nudge, build one automation that emails you the Due this week list each Monday. |
| Q4 (October to December) | Gratitude and reset | Send year-end thank-you notes to people who helped you. Archive contacts you no longer need. Group People by Source to see where your best relationships came from and plan next year's events. |
Messages to send
One message is easy. Hundreds of people, all year, is the hard part. Capstone Outreach puts everyone you know on a rhythm you pick, from weekly to every three months. When someone is due, a message like these is already written in your voice from your history with them. You approve it, and it goes from your own email or phone. See how it works.
Start 14 days free, then $25/mo
Everyone on a rhythm. Who is due, and when. Recorded in the app on a demo account.
1. Follow-up after meeting someone new (email)
Subject: Great to meet you at [Event]
Why it works: Delivering what you promised within two days makes the first impression stick.
2. Check-in with a key professional contact (email)
Subject: How did [project] land?
Why it works: Picking up the thread from your last Summary shows you listened.
3. Congratulations on a new role (LinkedIn message)
Why it works: A job change is a natural reason to contact a weaker tie, and Rajkumar and colleagues (2022, Science) found moderately weak ties the most useful for job mobility.
4. Reconnecting after a long silence (text)
Why it works: Levin, Walter, and Murnighan (2011, Organization Science) found reconnected dormant ties still offered real value, so a simple hello is worth sending.
5. Sharing something useful (email)
Subject: Thought of you: [topic]
Why it works: A specific note with no ask keeps you in mind without creating work for them.
6. Thank-you after an introduction (email)
Subject: Thank you for connecting me with [Person]
Why it works: Closing the loop makes people glad they helped and open to helping again.
Write yours in 20 seconds
Free, no signup. The example is filled in: press the button, then replace it with your own situation. In Capstone, a message like it is written for each person you know when their check-in is due.
The weekly routine
- Open the Due this week view (about 2 minutes).
- Send a message to everyone due, inner circle and key professional tiers first.
- Add an Interactions record for each touch with the Date, Type, and a one-line Summary, which updates Last contacted.
- Add new contacts through the form view with Tier, Cadence, and Source filled in.
- Pick one person from the Reconnect view and send a hello.
- Glance at the kanban by Tier and move anyone whose relationship has changed.
Mistakes to avoid
- Building five linked tables and a dashboard before sending a single message.
- Typing Last contacted by hand on some records and using the rollup on others, so the dates stop matching.
- Importing every contact you've ever had instead of the people you'd actually reach out to.
- Assuming the base will remind you, when it only does if you build and maintain an automation.
- Leaving the Summary field blank, so months later you can't remember what you discussed.
- Letting weeks slip, which piles up overdue records until the base feels like a chore.
What to track
- Last contacted and Next check-in for every person.
- Tier and Cadence, reviewed once a quarter.
- Source, so you can see which events and introductions lead to lasting relationships.
- An Interactions record for each conversation, with promises noted in the Summary.
- The count of records in Due this week that are already overdue.
- People moved from Reconnect back into an active tier.
Tired of filling in the Airtable by hand? Capstone builds the timeline for you. Emails, texts, calls and meetings show up on each person's page. It also shows who you have not talked to in a while.
Start 14 days free, then $25/mo
A study of 20 million LinkedIn members found that acquaintances, more than close friends, led to new jobs (Science, 2022). Capstone keeps those people warm. You approve every message, and it goes from your own email or phone.
Frequently asked questions
Can Airtable be used as a CRM?
Yes. Airtable works as a CRM if you build the tables, fields, and views yourself, and many people use it for a personal CRM. It handles contact lists, linked interaction logs, formulas, and filtered views well. What it doesn't do on its own is notice your emails, remind you without an automation, or draft messages, so it depends on your weekly habit.
Is Airtable a CRM?
No, Airtable is a flexible database tool, not a CRM out of the box. You can turn it into one with a People table, an Interactions table, a few formulas, and views for who is due. Airtable also offers CRM-style templates you can start from, but you'll still adjust the fields to fit relationships rather than a sales pipeline.
How do I use Airtable as a personal CRM?
Create a People table with Name, Company, Tier, Email, Source, Cadence, and Notes, and an Interactions table with Date, Type, and Summary. Link them, make Last contacted a rollup of the latest interaction date, and add a Next check-in formula. Then work a Due this week view for 20 minutes every week and log each touch.
Is there a free Airtable personal CRM template?
Yes, Airtable's own template gallery and many creators share CRM bases, and some are free. A personal CRM is also simple to build from scratch in under an hour using the fields on this page. Building it yourself means you'll understand every formula and rollup when you want to change a cadence or add a field.
Can Airtable remind me to follow up with someone?
Only if you build it. Airtable automations can send you an email or notification when a record matches a condition, such as Next check-in being today. You'll need to set it up, test it, and check what your plan allows. Many people skip automations and simply open the Due this week view on the same day each week.
When does an Airtable personal CRM stop working well?
It usually strains when logging becomes the bottleneck. If you talk to many people each week, adding Interactions records by hand gets skipped, Last contacted drifts, and the Due view stops being trustworthy. It's also slow on a phone right after meeting someone. If your list is small and your habit is steady, it can work for years.