Airtable · Solution guide
Airtable CRM Setup: Structure, Plan Limits, Template vs Custom and Real Cost
Quick answer
How to set up a CRM in Airtable: the tables to create, how linked records, views, automations and interfaces fit together, which plan limits you will hit first, whether to start from Airtable's Sales CRM template or build your own, and what a build costs if you hire it. Plan figures checked on Airtable's own pages on Oct 25, 2026.
Part of the guide: Airtable consultant guide
Key takeaways
- Build a CRM in Airtable as four linked tables first: Contacts, Companies, Deals and Activities. Every table draws on one record cap per base, 50,000 on Team and 125,000 on Business (Airtable pricing page, as recorded Oct 17, 2026).
- Automation runs are counted per trigger, including failed ones, and reset on the first of each month. Team allows 25,000 runs and 100 unique automations per base, Business 100,000 and 150 (Airtable support, checked Oct 25, 2026).
- Airtable publishes a free Sales CRM template with accounts, contacts, interactions and opportunities, plus a separate Sales Pipeline template. Start there for one pipeline, and build custom when your records span several linked tables or teams (airtable.com/templates, checked Oct 25, 2026).
- Team has no two-way sync and allows 10 synced tables per base. Business allows 20 synced tables and two-way sync. Integrated sync sources top out at 10,000 records (Airtable sync article, checked Oct 25, 2026).
- The seat price is the small part. Ten seats on Team cost $2,400 a year. Published market bands for a hired build are $1.5k to $8k small and $8k to $25k mid, from one agency page (checked Oct 15, 2026).
If you searched “airtable crm setup”, “airtable crm template” or “airtable crm cost”, you are deciding whether to build a CRM yourself. This page covers the build: the tables, links, views, automations and interfaces, the plan limits that bite first, whether to copy Airtable’s template or start blank, and what the work costs. If you would rather hand the build to someone, the other page, Airtable consultant: what to hire, verify and pay, covers who to hire and how to check them. Both lean on the plan sheet in Airtable pricing and limits 2026.
How should I structure a CRM in Airtable?
Use four linked tables: Contacts, Companies, Deals and Activities. Each fact lives in one table, and a linked record field points to it from everywhere else, so changing a company name once changes it on every deal.
| Table | One record is | Links to | Typical fields |
|---|---|---|---|
| Companies | One organisation | Contacts, Deals | Name, industry, size, owner |
| Contacts | One person | Company, Deals, Activities | Name, email, phone, role, lead source, status |
| Deals | One opportunity | Company, Contacts, Activities | Stage (single select), value, close date, next step, owner |
| Activities | One call, email or meeting | Contact, Deal | Type, date, note, who logged it |
Source: aibrevo build pattern for Airtable CRMs, Oct 25, 2026. The same four-table shape is described on an agency page, Business Automated (published Mar 21, 2026, checked Oct 25, 2026). The point of the split is that a flat table with everything in it becomes a spreadsheet in a different place. A Company rollup of open deal value, a Contact lookup of last activity date and a Deal lookup of the company name are what make it behave like a CRM.
Five rules save most rework:
- One owner per fact. Email lives on the Contact, not copied to Deals.
- Stages are a single select, not free text. If you rename an option, automations that test the old name stop firing, so change stage names rarely and test automations after.
- Lookups and rollups over copies. Avoid lookups of lookups, especially for attachments. Airtable’s sync article warns that a single cell resolving to more than about 1,000 attachments, often from chained lookups, can break table sync.
- Filter views, do not duplicate data. One view per owner, per stage and per follow-up list.
- Write the base map before you build. Table, owner, what links where.
Which Airtable plan limits matter for a CRM?
Records per base arrive first, then automation runs, then sync limits. All three are in the plan sheets, and the API ceiling is in the developer docs.
| Limit | Free | Team | Business | Enterprise Scale |
|---|---|---|---|---|
| Price per seat, billed yearly | $0 | $20 | $45 | Contact sales |
| Records per base | 1,000 | 50,000 | 125,000 | 500,000 |
| Automation runs a month, per workspace | 100 | 25,000 | 100,000 | 500,000 |
| Unique automations per base | 75 | 100 | 150 | 200 |
| Attachments per base | 1 GB | 20 GB | 100 GB | 1,000 GB |
| Synced tables per base | Not offered | 10 | 20 | 20 |
| Two-way sync | No | No | Yes | Yes |
Source: Airtable pricing page via our limits page (Oct 17, 2026); Airtable’s automations and sync support articles (Oct 25, 2026). The per-base automation caps were raised on Oct 2, 2026 according to our late-October updates page; older guides still say 50.
Three details change how you design:
- A run is a trigger, not an action. Airtable counts a run each time a trigger fires, whether or not the actions work. One automation that fires on every new lead uses one run per lead, no matter how many actions it has.
- Disabled automations still count. Turning an automation off does not free a per-base slot. Deleting it does.
- Sync has its own caps. Integrated sync sources are limited to 10,000 records each, which does not apply to base-to-base syncs. The Airtable sync FAQ covers sync intervals by source.
On the API, Airtable’s developer documentation allows 5 requests per second per base. Anything that writes a lot of records, such as a nightly sync from another tool, is built around that number. The API rate limits comparison shows how long 50,000 one-record updates take on four CRMs.
How do I size a plan? An illustrative example
Count records across all four tables, add headroom, then match the total to the plan. The numbers below are illustrative, not a benchmark, and the caps in the last column are Airtable’s.
| Illustrative stage | Contacts | Companies | Deals | Activities | Total records | Plan that fits |
|---|---|---|---|---|---|---|
| Launch, 3 reps | 2,000 | 500 | 300 | 1,500 | 4,300 | Team |
| 18 months in, 8 reps | 12,000 | 3,000 | 2,500 | 25,000 | 42,500 | Team, about 85% of the cap |
| 3 years in, 8 reps | 30,000 | 7,000 | 7,000 | 80,000 | 124,000 | Business, 99% of the cap |
Activities grow fastest because every call and email adds a row. Each row counts, so a team that logs every email can reach Team’s 50,000 cap before contacts do. Three options when you near it: archive old activities into a separate base, summarise them (one weekly note per contact instead of every email), or move to Business.
Illustrative automation budget. Suppose 1,500 new leads a month, with one assignment automation (1 run per lead), one follow-up task automation (1 run per lead) and one stage-change automation firing on about 400 stage changes. That is 1,500 + 1,500 + 400 = 3,400 runs a month, about 14% of Team’s 25,000. Add a daily stale-deal check firing 30 times and an inbound webhook automation firing 5 times a lead and the total moves to about 11,000, a little over 40% of the cap. Estimate runs before you build, since a failed run still counts.
Illustrative licence arithmetic. At the pricing-page rates, 8 seats billed yearly cost 8 × $20 × 12 = $1,920 on Team or 8 × $45 × 12 = $4,320 on Business. Billed monthly at $24 and $54, the same 8 seats cost $2,304 and $5,184. Portals for outside guests are a separate add-on, from $120 a month for 15 guests on Team.
Should I use Airtable’s CRM template or build my own?
Start from the template if you have one pipeline and under about five users. Build your own when your records need more than the template’s tables or when more than one team will use the base. Airtable’s Sales CRM template (checked Oct 25, 2026) describes pages for accounts, contacts, interactions and opportunities, grid, Kanban and calendar views, built-in dashboards and email integration to log conversations. A separate Sales Pipeline template is listed on Airtable’s sales solutions page.
| Your situation | Likely best path | Why |
|---|---|---|
| One pipeline, a few reps, no migration | Copy the Sales CRM template and edit the stages | Tables, views and a dashboard already exist; easy to redo |
| Pipeline plus onboarding or delivery tracking in the same base | Custom on the four-table pattern | The template’s tables will not carry project or delivery data without restructuring |
| Moving from HubSpot, Pipedrive or a spreadsheet | Custom, or a scoped migration only | Relationships and formulas do not import cleanly |
| Reps live in email and want sequences and a dialer | Reconsider the tool | Airtable’s plan sheet lists no email sync, dialing or forecasting |
| Existing CRM stays, Airtable adds back-office tracking | Template plus an integration | Airtable’s sales page says most customers use it alongside an existing CRM |
Source: aibrevo, Oct 25, 2026, and Airtable’s template and sales pages (checked Oct 25, 2026). Whichever you pick, read every field and automation in a copied template before you load real data. If the question is whether to leave Airtable altogether, read monday CRM vs Airtable first, then how to move Airtable to monday.com.
How do I build views, automations and interfaces?
Build views first, interfaces second and automations last, because views tell you what the team actually looks at.
Views. A Kanban view of Deals grouped by stage is the pipeline. A grid view of Contacts filtered to “no activity in 14 days” is the follow-up list. Add one view per owner, so reps see only theirs. Filtering a view keeps the data in one place.
Interfaces. Interface Designer is on every plan, including Free, per Airtable’s plan sheet. Build a rep page (my open deals, my follow-ups) and a manager dashboard (pipeline by stage, closed this month). Most reps then never touch the raw base, which protects the structure.
Automations. Start with three. Assign a new lead to an owner. Create a task when a deal moves stage. Flag a deal with no activity in a set number of days. Airtable’s Oct 19, 2026 update added a trigger for a field changing from one specific value to another, which removes the helper field you used to need for stage-change logic. The post does not say which plans include it, so test it in your own workspace (see the late-October updates page).
Integrations. Airtable offers sync integrations on paid plans. Standard integrations are on Team, premium ones on Business. To connect to HubSpot, read how to connect Airtable to HubSpot; if the other side is monday.com, see does monday.com integrate with Airtable. Decide which system owns each field before you connect anything, or two systems will overwrite each other.
What does an Airtable CRM cost to set up?
Doing it yourself costs the licence plus your time. Hiring it costs the licence plus a build fee that the one source I could open puts at $1.5k to $8k for a small build and $8k to $25k mid.
| Route | One-time cost | Running cost | Source |
|---|---|---|---|
| DIY from the template | Your time | $1,920 to $4,320 a year for 8 seats (illustrative) | Airtable pricing page |
| Hired, small build | $1.5k to $8k | Licence, plus any retainer | aibrevo CRM implementation cost benchmark, single source |
| Hired, mid build with automations and integrations | $8k to $25k | Licence, retainer, integration tool fees | Same |
| Hired, enterprise | $25k to $40k+ | Enterprise Scale quoted by Airtable | Same |
Source: CRM implementation cost benchmark 2026, where Airtable rests on a single agency page published Mar 21, 2026 and there is no median. The ranges exclude licences. Use our CRM implementation cost calculator for a rough scope check, and the Airtable CRM implementation cost guide for what drives the number. aibrevo quotes Airtable builds per project after a 30 minute call; we do not publish an Airtable price list.
Hidden costs to budget: extra seats as sales, onboarding and delivery all want to edit; Portals if clients need access; an upgrade from Team to Business when you reach the record cap; and integration tools such as Zapier or Make.
When should I hire an Airtable consultant?
Hire when a mistake would cost more than the fee. That means a migration, automations that email customers, more than one team editing, or a base that will hold more than a few tens of thousands of records. The mistakes that are costly to unwind are a flat data model, free-text stages and automations that create duplicates instead of updating one record.
The hiring side, with how to check Airtable’s partner directory and Academy certifications, a cost band, and questions to ask, is on Airtable consultant: what to hire, verify and pay. If you only want a second opinion on a base you built, book a free 30 minute call.
Want a second pair of eyes on your Airtable CRM? See the Airtable implementation service, book a 30 minute call or send a message with your table list and record counts. We quote Airtable builds per project after the call and will tell you if a smaller fix or a different tool fits better.
Sources
All pages opened on Oct 25, 2026 unless noted.
- Airtable, Sales CRM template and Sales solutions page: tables, views, Sales Pipeline template, use alongside existing CRMs.
- Airtable support, Getting started with Airtable automations: runs, unique automations, run history by plan.
- Airtable support, Getting started with Airtable sync: synced tables, two-way sync, 10,000 record integrated source cap, attachment lookup warning.
- Airtable, developer rate limits and pricing page, as recorded on Airtable pricing and limits 2026, Oct 17, 2026.
- Business Automated, How much does an Airtable consultant cost?, published Mar 21, 2026: four-table CRM pattern and the single-source cost bands. An agency marketing page.
- aibrevo, CRM implementation cost benchmark 2026, Oct 15, 2026, and monday, Pipedrive and Airtable late October 2026 updates.