How to Build a Solopreneur CRM in Airtable (2026)

Quick Answer

To build a solopreneur CRM in Airtable: create a new base with a Contacts table, a Deals (or Pipeline) table, and an Interactions log. Link the tables using linked record fields, set up views for each pipeline stage, and add automations for follow-up reminders. The free Airtable plan handles everything you need if you’re managing under 1,000 records.

Most CRM tools are built for sales teams — pipeline dashboards, seat-based pricing, activity quotas, manager reports. None of that maps to how a solopreneur actually works. You’re not managing a pipeline of hundreds of deals. You’re nurturing a handful of key relationships, following up on proposals, and making sure nobody falls through the cracks.

Airtable is the right tool for this job. It’s flexible enough to become exactly the CRM you need, without the complexity you don’t. And unlike rigid SaaS CRMs, you own the structure — if your workflow changes, the system changes with it. This guide walks you through building it from scratch, step by step, in under two hours.

Why Airtable Works as a Solopreneur CRM

Dedicated CRM tools like HubSpot, Pipedrive, and Salesforce are optimized for teams. Their free tiers are lead magnets, not functional tools. Their paid tiers assume multiple users, deal volumes that justify the cost, and reporting needs you almost certainly don’t have.

Airtable sits in a different category. It’s a relational database with a spreadsheet interface — which is exactly what a CRM is, conceptually. Contacts link to deals. Deals link to interactions. Interactions trigger follow-up tasks. You get all of that in Airtable without paying $49/month per seat for features you’ll never touch.

The Airtable free plan supports up to 1,000 records per base and unlimited bases — more than enough for most solopreneurs. The Team plan ($20/month) unlocks automations beyond the free tier’s limit and adds Gantt/timeline views if you want them. Most users start on free and upgrade only when they outgrow it.

If you’re already using Airtable for project management or business workflow automation, adding a CRM to the same workspace keeps everything in one place — no context switching, no additional subscriptions.

Step 1: Create Your Base and Tables

Open Airtable and create a new blank base. Name it something like Client CRM or Business Development. Your base will contain three tables that talk to each other:

Contacts — every person you interact with (leads, clients, referral partners, prospects)
Deals — every active proposal, project opportunity, or sales conversation
Interactions — a log of emails, calls, meetings, and touchpoints

Start by renaming the default “Table 1” to Contacts. Then add two more tables: Deals and Interactions. You’ll wire them together in the next step.

Pro Tip

Start simple. You can always add tables later, but complexity up front kills adoption — even when it’s just you. Build the minimum viable CRM first and expand once you’ve used it for two weeks.

Step 2: Build the Contacts Table

The Contacts table is your master list of people. Add the following fields — Airtable will default to single-line text for most, but adjust types as noted:

Name (Single line text) — primary field, used as the display label
Company (Single line text)
Email (Email field type)
Phone (Phone number field type)
Status (Single select: Lead / Prospect / Active Client / Past Client / Cold)
Source (Single select: Referral / LinkedIn / Inbound / Outreach / Conference / Other)
Last Contacted (Date field)
Notes (Long text)
Deals (Linked record → Deals table) — you’ll add this after creating the Deals table
Interactions (Linked record → Interactions table) — same

The Status field is your most important field. It lets you filter your view to show only active clients, only leads, or only prospects — without manually digging through everyone. Keep the options lean. Five status values is enough.

Step 3: Build the Deals Table

The Deals table tracks proposals, pitches, and project opportunities — not contacts themselves. One contact can have multiple deals over time. Add these fields:

Deal Name (Single line text) — e.g., “Website Redesign — Acme Co.”
Contact (Linked record → Contacts table)
Stage (Single select: Discovery / Proposal Sent / Negotiating / Won / Lost / On Hold)
Value (Currency field)
Close Date (Date field — when you expect a decision)
Proposal Sent (Checkbox)
Follow-Up Date (Date field)
Notes (Long text)

The Stage field is your pipeline. Every deal lives in exactly one stage at a time. Combined with Airtable’s Kanban view (available on free), you get a visual pipeline board identical to what you’d pay $30/month for in a dedicated CRM.

Step 4: Build the Interactions Log

This table is your activity history — a running log of every meaningful touchpoint with a contact. Keeping this separate from the Contacts table lets you log multiple interactions per person without cluttering the main record.

Summary (Single line text) — e.g., “Discovery call — confirmed budget”
Contact (Linked record → Contacts table)
Deal (Linked record → Deals table)
Type (Single select: Call / Email / Meeting / Message / Proposal / Other)
Date (Date field)
Next Action (Single line text)
Next Action Date (Date field)

After a call or meeting, you log one row here. The linked Contact and Deal fields pull in the related records automatically — so when you look at any contact’s record, you see the full history of every interaction in a linked records panel on the right.

Watch Out

Don’t log interactions in the Notes field of your Contacts table. That turns into an unstructured blob that’s impossible to query or filter. Keeping interactions in their own table lets you ask questions like “show me everyone I haven’t contacted in 30 days” — which is where the real CRM value lives.

Step 5: Set Up Your Views

Views are how Airtable becomes a CRM interface rather than a spreadsheet. Set up the following views across your tables:

In the Contacts table

All Contacts — default grid view, no filters
Active Clients — filter: Status = Active Client
Hot Leads — filter: Status = Lead or Prospect; sort by Last Contacted ascending
Follow Up Today — filter: Last Contacted is before 14 days ago AND Status is not Past Client or Cold

In the Deals table

Pipeline (Kanban) — group by Stage; shows your visual pipeline board
Open Deals — filter: Stage is not Won or Lost
Follow Ups Due — filter: Follow-Up Date is today or earlier AND Stage is not Won or Lost

The “Follow Ups Due” view in Deals is the most valuable one you’ll build. Open it every morning. It tells you exactly who to contact that day.

This approach pairs well with how many solopreneurs already use Notion for client management — Airtable handles the relational data layer, while Notion can host client portals and documentation if you use both.

Step 6: Add Automations for Follow-Up Reminders

Airtable’s built-in automations handle the most important CRM function: making sure you never forget to follow up. The free plan includes 100 automation runs per month. The Team plan bumps that to 25,000.

Set up two core automations:

Automation 1: Follow-Up Reminder Email

Trigger: When a record in Deals matches a condition
Condition: Follow-Up Date = today
Action: Send an email to yourself with the deal name, contact name, and your notes

Automation 2: Update Last Contacted on New Interaction

Trigger: When a new record is created in Interactions
Action: Update the linked Contact’s “Last Contacted” field to today’s date

This second automation is the one most people skip — and then wonder why their Last Contacted field is always stale. Automating it means logging one interaction row keeps your entire Contacts table accurate without any extra work.

If you want more powerful automation across tools — for example, creating a new Interaction row automatically when a Calendly booking is confirmed — Zapier connects Airtable to virtually any external app. A Zapier workflow that logs new Calendly meetings as Interactions in your CRM takes about 10 minutes to set up and runs silently in the background forever.

Airtable CRM vs. Dedicated CRM Tools

Feature	Airtable CRM	HubSpot Free	Pipedrive Starter
Monthly Cost	$0–$20	$0 (limited)	$14/month
Custom Fields	Unlimited	Limited on free	30 fields
Visual Pipeline	Yes (Kanban)	Yes	Yes
Email Integration	Via Zapier/Make	Native	Native
Customization	Very high	Moderate	Moderate
Learning Curve	Medium (setup required)	Low	Low
Scales Beyond Solo	Yes	Yes	Yes

The honest trade-off: dedicated CRM tools have native email sync, which means every email thread automatically appears in the contact record. Airtable doesn’t do that natively — you either log interactions manually or use Zapier to automate it. If email logging automation matters to you and you’d rather pay $14/month than configure Zapier, Pipedrive is worth considering. But for most solopreneurs tracking fewer than 100 active relationships, the Airtable setup above covers everything.

Extending Your CRM: Optional Add-Ons Worth Considering

Once you’ve used your base setup for a few weeks, you may want to extend it. A few additions that work well:

Proposal Tracker

Add a Proposals table linked to Deals. Store proposal value, version number, sent date, and expiry date. Use a rollup field in Deals to show the latest proposal value automatically.

Revenue Dashboard

Add a formula field in Deals that marks a record as “Won This Month” using a date formula. Then create a summary view grouped by month to see revenue trends without any separate reporting tool. You can also combine this with ClickUp automations if you use ClickUp for project execution — link a won deal to a new project automatically.

Calendly → Airtable Automation

If you use Calendly for discovery calls, a Zapier workflow can create a new Contact record and an Interactions log entry the moment someone books a call — including their name, email, and any pre-call form responses. You show up to every discovery call with the contact already in your CRM, no manual entry needed.

Pro Tip

Set a recurring weekly task to open your “Follow Ups Due” view in Deals and your “Hot Leads” view in Contacts. Ten minutes every Monday morning keeps your pipeline healthy without turning relationship management into a part-time job.

Key Takeaways

Three tables — Contacts, Deals, Interactions — give you a fully relational CRM without overengineering
Linked record fields are the backbone: they let you navigate from any contact to their full deal and interaction history in one click
Views do the heavy lifting: the “Follow Ups Due” Deals view and “Hot Leads” Contacts view replace every CRM dashboard you’d pay for
Airtable automations handle follow-up reminders and Last Contacted updates — set them once, forget about them
Zapier extends the system into your email, calendar, and booking tools without building anything custom
The free Airtable plan handles this entire setup — upgrade only when you hit 1,000 records or need more automation runs

Frequently Asked Questions

Can I use Airtable as a CRM for free?

Yes. The Airtable free plan supports up to 1,000 records per base and includes Kanban views, basic automations (100 runs/month), and unlimited collaborators (with limited permissions). The three-table CRM in this guide runs entirely on the free plan for most solopreneurs.

How is Airtable different from a spreadsheet CRM in Google Sheets?

The key difference is linked records. In Google Sheets, you’d manually type a contact’s name in a Deals tab and hope it stays consistent. In Airtable, the Deals table links directly to the Contacts table — click the linked field and you open the full contact record. That relational layer is what makes Airtable a real CRM rather than a glorified spreadsheet.

What if I outgrow this setup?

You have two paths: upgrade to Airtable Team ($20/month) for more automation runs, timeline views, and interface designer — or migrate to a dedicated CRM like Pipedrive when you’re managing enough deals to justify the cost. The advantage of Airtable is that you can export everything to CSV cleanly if you ever switch, so you’re never locked in.

Should I use Airtable Interface Designer to build a dashboard?

Interface Designer (available on Team plan) lets you build a custom app-like view of your CRM data without seeing the underlying table grid. If you want a cleaner UI for daily use, it’s worth exploring — but it’s optional. The grid and Kanban views in this guide are sufficient for most users.

Can multiple people use this CRM?

Yes, with limitations. The free plan allows collaborators with commenter or read-only access. If you have a VA or business partner who needs to log interactions, you’ll need the Team plan for editor access. For a true multi-user setup with role-based permissions, consider whether a dedicated CRM like HubSpot or a lightweight project tool with CRM features serves you better at that point.