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.

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 grouped by stage gives you a working pipeline.

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

Asking what happens to the record after the deal closes 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 the sales tool and wherever delivery happens is usually where details from the sale get lost.

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 the way an Airtable base and a Google Sheet do.

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

A CRM is built for the business where most of the effort happens before someone says yes: long nurture cycles, lots of email, several people touching the same prospect. Nearly every service business we work with carries the heavier load after the yes, and for them, splitting the record across two systems usually costs more than the CRM features were worth.

How to use Airtable as a CRM?

Most Airtable CRMs that hold up use the same tables, with one Interface on top.

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. It is also what turns a list of deals into something you can review each week.

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 the fields you will not use early on, because unused fields are what make an Airtable CRM 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.

Teams usually respond in one of these ways.

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 answer depends on whether your effort goes into selling or into delivery.

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, what usually lasts 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.

We keep the sales features thin on purpose. In these businesses the pipeline holds a handful of live opportunities while the operational side holds hundreds of active records, so the build goes where the records are.

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.

Airtable makes a good CRM for businesses where the sale is the beginning of the relationship, and a poor one where the sale is most of it.

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.