Airtable as a CRM: When It Works, and the Point Where It Stops

Search for Airtable as a CRM and the results split cleanly in two. Airtable’s own site, its community, its academy and its blog all explain how to build a CRM in it. One consultancy on the same page says plainly that they advise companies against it.

Both are describing real experience. They are just describing different companies.

We build operations systems on Airtable for service businesses, so we have set up sales pipelines in it and we have also told people to buy a CRM instead. This is how we decide which one, and what the Airtable version gets right and wrong.

Is Airtable good as a CRM?

For a small team whose sales process is short and whose work continues after the sale, yes. Airtable handles contacts, companies, deals, stages and linked records natively, and a kanban view gives you a pipeline in about an hour.

Where it is genuinely weak is communication history. There is no shared inbox, no email thread attached to a contact, and no call logging unless you build it.

What Airtable does after the deal closes

This is the test we use, and it usually settles the question faster than a feature comparison does.

In HubSpot, Salesforce and Pipedrive the deal is the end of the story. It moves to closed won, a report counts it, and the actual work happens somewhere else entirely: a project tool, a spreadsheet, an operations system, somebody’s inbox. The handoff between those two worlds is where things get dropped.

In Airtable there is no handoff, because the client record you sold to is the same record that carries the project, the documents, the invoices and the compliance dates. Nothing is re-entered and nothing has to stay in sync between two systems.

So the question is which half of your business is heavier.

If most of the effort happens before someone says yes, with long nurture cycles, lots of email, several people touching the same prospect, then a CRM is built for that and Airtable is not. If most of the effort happens after they say yes, which is true of nearly every service business we work with, then splitting the record across two systems costs you more than the CRM features were worth.

How to use Airtable as a CRM?

The Airtable structure that holds up is four tables and one interface.

Contacts. People. Name, email, phone, and a link to their company.

Companies. Organisations, linked to contacts. Skip this if you sell to individuals.

Deals. One record per opportunity, linked to a company and a contact. A single select field for the stage, an owner, a value and a next action date.

Activities. One record per meaningful touch, linked to a deal. This is the table people leave out, and it is what turns a list of deals into something you can actually review.

Then build an Interface rather than sending your team into the grid. A pipeline view grouped by stage, a record page for one deal, and a list of what is overdue. The grid stays as the back end for whoever maintains the system.

Airtable ships its own Sales CRM template that gets you most of this structure. It is a reasonable starting point as long as you delete what you do not need in the first week, because unused fields are how these systems get confusing.

Email and calls are where Airtable stops

HubSpot or Pipedrive records that Maria emailed the client on Tuesday and that Daniel called them on Thursday, and everyone can see both. Airtable does not do this by itself. Your team’s emails stay in individual inboxes, so two people can email the same prospect the same week without knowing, and when someone leaves the company their side of every conversation leaves with them.

There are three honest responses to that.

Build the logging. Automations can write emails and call notes into the Activities table, through Make, Zapier or Airtable’s own automations. This works and we have built it. It is a real project, and it captures what you configure it to capture rather than everything.

Accept the gap. For a two or three person team who talk to each other constantly, shared email history is a nice-to-have. Plenty of businesses run for years without it.

Buy a CRM for the top of the funnel. Keep it for prospecting and email, and hand the record to Airtable when the deal closes. This costs you an integration and it is often the right answer for a team where selling is a full-time job.

What are the downsides of using Airtable?

Scoped to using it as a CRM, the list is short and specific.

No shared communication history, as above. This is the big one.

No packaged lead scoring or prioritisation. You can build a formula that scores records, and it will be your formula rather than a tested model with reporting attached.

No built-in sales reporting. Pipeline value by stage, conversion rates, cycle length. All of it is buildable in Airtable and none of it is waiting for you.

You are building a CRM rather than using one. Somebody on your team owns the design, and when they leave, that knowledge leaves unless it was written down.

External access costs extra. If clients or partners need to see their own records, Airtable’s Portals add-on is priced per guest on top of your seats. We covered the arithmetic in the pricing breakdown.

Which is better, HubSpot or Airtable?

They are built for different jobs, so the honest answer depends on where your work sits.

HubSpot is a CRM. Email tracking, sequences, meeting links, forms, lead scoring and sales reporting all come with it, and they work on the day you sign up. If your growth depends on running a sales process well, that is what you are paying for.

Airtable is a database. It gives you structure, and anything resembling a sales feature is something you build. What you get in return is that the same record carries the entire relationship, from first enquiry through delivery to renewal, without an integration in the middle.

Teams that sell a lot and deliver a little are better off in HubSpot. Teams that sell a little and deliver a lot are usually better off in Airtable. The awkward middle is where the two-system setup earns its keep.

The Airtable CRM setup we build most often

For service businesses, the version that tends to survive is a single Airtable base where the client record runs the whole lifecycle, with a light pipeline at the front of it.

Deals, stages and next actions live in the same base as projects, documents, staff assignments and invoices. Automations move records forward and send notifications. Where clients need visibility, we put a portal in front of the base rather than giving them seats.

The sales features are deliberately thin, because for these businesses the pipeline holds a handful of live opportunities and the operational side holds hundreds of active records. Spending the build on the small half would be the wrong trade.

Frequently asked questions

What are the top 3 CRM systems?

Salesforce, HubSpot and Pipedrive are the three that come up most often in the small and mid-sized market, with Zoho and Microsoft Dynamics close behind. Which is right depends far more on how you sell than on any feature list.

Does Airtable have a CRM template?

Yes. Airtable publishes its own Sales CRM template with contacts, deals and stages already set up, and you can start from it directly. Treat it as a starting point and remove the fields you will not use.

Can Airtable send emails to clients?

Airtable automations can send email, and they are best suited to notifications and templated messages. What Airtable does not do is act as an inbox, so replies land in the recipient’s usual email client rather than against the record.

How many contacts can Airtable hold?

Record limits are per base: 1,000 on Free, 50,000 on Team and 125,000 on Business. Contacts, companies, deals and activities all count towards the same base total, so an active pipeline consumes more than people expect.

Should I move off Airtable once we grow?

Sometimes, and the trigger is usually the sales side rather than the size of the database. When several people are selling full time and email history becomes something you argue about, that is the point where a dedicated CRM starts paying for itself.

The short version: Airtable makes a good CRM for businesses where the sale is the beginning of the relationship, and a poor one where the sale is the whole relationship. Everything else about the decision follows from that.

If you are still deciding what Airtable is for in general, the plain explanation is here. If the cost is what you are weighing, what Airtable actually costs by team shape has the numbers, including client access. For a pipeline built properly on the base you already have, Airtable consulting explains how we approach it.