Most small businesses don't need Salesforce. They need a CRM that tracks contacts, manages a pipeline, and reminds them to follow up — without a five-figure implementation budget or a dedicated admin.
That's exactly what you can build in Airtable. In this guide, you'll create a complete CRM from scratch: a Contacts table, a Companies table, a Deals pipeline with Kanban view, activity logging, automated follow-up reminders, and a sales dashboard — all connected through linked records.
What you'll need:
- An Airtable account (free plan works for testing; Team plan at $20/user/month recommended for production)
- 2–3 hours to build the complete system
- Optional: Make or Zapier account for advanced automations
What you'll build:
- 4 core linked tables (Contacts, Companies, Deals, Activities)
- A visual Kanban pipeline for deal tracking
- Filtered views for lead management and follow-ups
- Automations for follow-up reminders and status notifications
- A sales dashboard with Interface Designer
Step 1: Create Your Base and Core Tables
Start by creating a new base in Airtable. Name it something clear like "Sales CRM."
Your CRM needs four core tables. Each stores one type of data, and they'll connect to each other through linked records — this is what makes Airtable a relational database rather than a spreadsheet.
Create these four tables:
- Contacts — the people you're selling to or working with
- Companies — the organizations those people belong to
- Deals — your sales opportunities and pipeline
- Activities — every call, email, meeting, and note
Pro Tip: Resist the urge to put everything in one table. Separating entities into linked tables is what gives your CRM its power. A single "master spreadsheet" is exactly what you're replacing.
Step 2: Configure the Companies Table
Start with Companies because Contacts and Deals will link to it.
Fields to create:
| Field Name | Field Type | Purpose |
|---|---|---|
| Company Name | Primary field (text) | The organization's name |
| Industry | Single select | Segment companies (SaaS, Agency, E-commerce, etc.) |
| Website | URL | Quick access to the company's site |
| Size | Single select | Employee count range (1-10, 11-50, 51-200, 200+) |
| Contacts | Linked record → Contacts | Auto-populated when you link contacts |
| Deals | Linked record → Deals | Auto-populated when you link deals |
| Total Deal Value | Rollup (sum of Deal Value from Deals) | Calculates total pipeline value per company |
| Notes | Long text | General notes about the relationship |
The Total Deal Value rollup is your first taste of Airtable's relational power. It automatically sums every deal linked to that company — no formulas to maintain, no VLOOKUP to break.
Step 3: Configure the Contacts Table
Your Contacts table stores the people you interact with.
Fields to create:
| Field Name | Field Type | Purpose |
|---|---|---|
| Full Name | Primary field (text) | Contact's name |
| Clickable email link | ||
| Phone | Phone number | Clickable phone link on mobile |
| Company | Linked record → Companies | Which organization they belong to |
| Role/Title | Single line text | Their job title |
| Lead Status | Single select | New Lead, Contacted, Qualified, Customer, Churned |
| Lead Source | Single select | How they found you (Referral, Website, LinkedIn, Event, Cold Outreach) |
| Deals | Linked record → Deals | Auto-populated when you link deals |
| Activities | Linked record → Activities | Auto-populated when you log activities |
| Last Contacted | Rollup (MAX of Date from Activities) | Automatically shows when you last spoke |
| Owner | Collaborator | Which team member owns this relationship |
| Created | Created time | When the record was added |
The Last Contacted rollup is critical. It pulls the most recent activity date from the linked Activities table, so you always know which contacts are going cold — without manual updates.
Step 4: Configure the Deals Table
This is your sales pipeline — every opportunity you're working.
Fields to create:
| Field Name | Field Type | Purpose |
|---|---|---|
| Deal Name | Primary field (text) | Descriptive name (e.g., "Acme Corp — Website Redesign") |
| Contact | Linked record → Contacts | Primary person on this deal |
| Company | Linked record → Companies | The organization |
| Deal Value | Currency | Expected revenue |
| Stage | Single select | Your pipeline stages (see below) |
| Expected Close Date | Date | When you expect this deal to close |
| Probability | Percent | Likelihood of closing (tied to stage) |
| Weighted Value | Formula | {Deal Value} * {Probability} |
| Owner | Collaborator | Sales rep responsible |
| Activities | Linked record → Activities | Auto-populated |
| Days in Stage | Formula | DATETIME_DIFF(NOW(), LAST_MODIFIED_TIME({Stage}), 'days') |
| Notes | Long text | Deal-specific context |
Pipeline stages to configure (customize these to match your actual sales process):
- New Lead (10% probability)
- Discovery Call (20%)
- Proposal Sent (40%)
- Negotiation (60%)
- Verbal Commit (80%)
- Closed Won (100%)
- Closed Lost (0%)
The Weighted Value formula multiplies deal value by probability, giving you a realistic pipeline forecast. The Days in Stage formula flags deals that are stalling — if a deal has been in "Proposal Sent" for 30 days, something is wrong.
Step 5: Configure the Activities Table
This table logs every interaction — calls, emails, meetings, and notes.
Fields to create:
| Field Name | Field Type | Purpose |
|---|---|---|
| Activity Title | Primary field (text) | Brief description (e.g., "Discovery call with Sarah") |
| Contact | Linked record → Contacts | Who you interacted with |
| Deal | Linked record → Deals | Which deal this relates to (optional) |
| Type | Single select | Call, Email, Meeting, Note, LinkedIn Message |
| Date | Date (with time) | When it happened |
| Summary | Long text | What was discussed, next steps |
| Follow-Up Date | Date | When to follow up next |
| Completed | Checkbox | Has the follow-up been done? |
Pro Tip: Make it a habit to log every meaningful interaction. A CRM is only as good as the data in it. If your team won't log activities manually, use Make or Zapier to auto-capture emails from Gmail or Outlook.
Step 6: Build Your Views
Views are what turn your database into a usable CRM. Each view shows the same data filtered and formatted for a specific purpose.
Deals: Kanban Pipeline View
This is the heart of your CRM — a visual sales pipeline.
- In your Deals table, click + Create a view and select Kanban
- Stack by the Stage field
- Cards will display as draggable tiles in columns: New Lead → Discovery Call → Proposal Sent → Negotiation → Verbal Commit → Closed Won / Closed Lost
- Configure the card to show Company, Deal Value, Owner, and Expected Close Date
- Hide "Closed Won" and "Closed Lost" columns if they clutter the view (create a separate "Closed Deals" grid view for those)
Your sales team drags deals between columns as they progress. Each drag automatically updates the Stage field.
Contacts: Leads to Follow Up
Create a filtered grid view that shows only contacts needing attention:
- Filter: Lead Status is "New Lead" or "Contacted"
- Sort: Last Contacted ascending (oldest first — coldest leads at the top)
- Group by: Owner (so each rep sees their own leads)
This view answers the daily question: "Who should I reach out to today?"
Contacts: My Active Clients
A personal view filtered to the current user:
- Filter: Owner is "Me" AND Lead Status is "Customer"
- Sort: Last Contacted ascending
Activities: Upcoming Follow-Ups\
- Filter: Follow-Up Date is within the next 7 days AND Completed is unchecked
- Sort: Follow-Up Date ascending
- Group by: Contact
This is your daily to-do list for sales outreach.
Deals: Calendar View
Create a Calendar view on the Deals table using Expected Close Date as the date field. This shows your team when deals are expected to land — useful for revenue forecasting and resource planning.
Step 7: Set Up Automations
Airtable's built-in automations handle the repetitive work that salespeople forget.
Automation 1: Follow-Up Reminder
Trigger: When a record in Activities matches conditions: Follow-Up Date is today AND Completed is unchecked
Action: Send an email (or Slack notification) to the Owner with the contact name, activity summary, and a link to the record.
This ensures no follow-up falls through the cracks.
Automation 2: New Lead Notification
Trigger: When a record is created in the Contacts table where Lead Status is "New Lead"
Action: Send a Slack message (or email) to the sales team channel with the contact's name, company, lead source, and a link to the record.
New leads get immediate attention instead of sitting unnoticed.
Automation 3: Deal Stage Change Alert
Trigger: When a record in Deals is updated and the Stage field changes
Action: Send a notification to the deal Owner and their manager with the deal name, new stage, and deal value.
This keeps leadership informed without requiring status meetings.
Automation 4: Stale Deal Warning
Trigger: At a scheduled time (every Monday morning)
Conditions: Find records in Deals where Stage is NOT "Closed Won" or "Closed Lost" AND Days in Stage is greater than 14
Action: Send a summary email to the sales team listing stale deals that need attention.
Going Further with Make
For automations that go beyond Airtable's native capabilities, Make opens up powerful workflows:
- Auto-log emails: Connect Gmail or Outlook to Make so every email sent to a contact automatically creates an Activity record in Airtable
- Auto-enrich contacts: When a new contact is added, Make can pull LinkedIn data, company size, and industry from enrichment APIs
- Generate invoices: When a deal moves to "Closed Won," Make can auto-generate an invoice in QuickBooks or Xero
- Sync with marketing tools: Push new customers from Airtable to Mailchimp, ConvertKit, or HubSpot for onboarding email sequences
Step 8: Build a Sales Dashboard with Interfaces
Airtable's Interface Designer turns your CRM data into a visual command center.
Create a new Interface and add these elements:
- Number block: Total pipeline value (sum of Deal Value where Stage is not Closed Lost)
- Number block: Deals closed this month (count of Deals where Stage is "Closed Won" and close date is this month)
- Number block: Weighted forecast (sum of Weighted Value for all open deals)
- Chart: Pipeline by stage (bar chart showing deal count and value per stage)
- Chart: Revenue by month (line chart tracking closed deals over time)
- Grid: Upcoming follow-ups (filtered Activities table showing this week's tasks)
- Grid: Recent activities (last 10 logged interactions)
This dashboard replaces the Monday morning pipeline review spreadsheet. Leadership sees real-time metrics without asking anyone to pull a report.
Common Mistakes to Avoid
Putting everything in one table
The biggest mistake is building a flat spreadsheet with 30 columns instead of using linked tables. Separate your data into entities (Contacts, Companies, Deals, Activities) and connect them. This is the single most important architectural decision.
Skipping data hygiene
Duplicate contacts, outdated statuses, and empty fields make your CRM untrustworthy. Set up a weekly 15-minute review: merge duplicates, update stale statuses, and archive dead leads. Use Airtable's "Group by" feature to spot inconsistencies.
Over-engineering from day one
Start with the four core tables described above. Don't add a Products table, a Partners table, a Referrals table, and a Campaigns table on day one. Build what you need now, then expand when you have real usage patterns to inform the design.
Not logging activities
A CRM with no activity data is just a contact list. If your team won't log activities manually, automate it — connect Gmail via Make to auto-capture emails, or create a simple form view in the Activities table that takes 30 seconds to fill out after each call.
What You've Built
By following this guide, you now have:
- 4 linked tables forming a relational CRM — Contacts, Companies, Deals, Activities
- A Kanban pipeline for visual deal tracking with drag-and-drop stage management
- Filtered views for lead follow-ups, active clients, and upcoming tasks
- 4 automations for follow-up reminders, new lead alerts, stage change notifications, and stale deal warnings
- A sales dashboard with real-time pipeline metrics and forecasts
This Airtable CRM costs $20/user/month — a fraction of Salesforce ($100+/user/month) or HubSpot Sales Hub ($100+/seat/month on Professional) — and it's built exactly the way your team works. As your needs grow, you can add a client portal with Softr, connect advanced automations with Make, or eventually migrate to a dedicated CRM when your scale demands it.
The best CRM isn't the most expensive one. It's the one your team actually uses.
