Build a CRM in Airtable with Email Integration

Airtable is probably the closest thing to a real CRM you can build without paying for one. Linked records connect emails to contacts. Automations can update deal stages when status changes. Kanban view gives you a pipeline board without any configuration. And the Interfaces feature lets you build a clean dashboard for your team that hides all the underlying complexity.

The missing piece is getting client emails into your Airtable records without copy-pasting. Here's how to set it up with Quicktion.

Why Build a CRM in Airtable?

• Linked records — connect a Contacts table to an Emails table so every contact has a full communication history
• Kanban view — drag deals through pipeline stages on a visual board
• Automations — trigger Slack notifications or follow-up reminders when a record changes status
• Interfaces — build a polished CRM dashboard for your team without any code
• Form view — create a lead intake form that feeds directly into your CRM table

Setting Up Your Base

Create two linked tables: one for contacts, one for email records.

Contacts table:

Emails table:

Connecting Your Email (via Quicktion)

Method 1: Email Forwarding

For high-volume client communication, set up forwarding rules:

1. Create a Quicktion destination pointing to your Emails table
2. Create a Gmail filter for a specific client's email domain (e.g., from:*@clientcompany.com)
3. Forward to your Quicktion address
4. All emails from that domain automatically appear as records in Airtable

After records land, link them to the relevant contact using the linked record field.

Method 2: Gmail Add-on

The Gmail add-on is ideal for CRM because you choose which emails to save. Open an important client email, click the Quicktion icon, select your Emails destination, and save. You can review and edit fields before saving, which is useful for tagging emails or cleaning up subject lines.

CRM Workflows

Kanban Pipeline

Create a kanban view on your Contacts table grouped by Stage:

• Lead -- New inquiries
• Contacted -- You've responded
• Negotiation -- Active discussions
• Won -- Closed deals
• Lost -- Didn't convert

Drag contacts between columns as deals progress. Color-code by Priority to spot high-value leads at a glance.

Follow-Up Tracking

Create a grid view filtered to contacts where Last Contact is more than 7 days ago and Stage is not "Won" or "Lost." This surfaces contacts who need a follow-up. Sort by Priority to work the most important leads first.

Automations

Set up Airtable automations to keep your team in sync:

• When a record's Stage changes to "Lead," send a Slack notification to the sales channel
• When Last Contact is more than 14 days old, send an email reminder to the assigned team member
• When a form view submission creates a new contact, set Stage to "Lead" and Source to "Website"

Use a form view on your Contacts table to collect leads from your website. Share the form link or embed it in a landing page — submissions create records directly in your CRM.

Tips

Save selectively. Don't log every email — focus on important communications you'll need to reference.

Use linked records. Linking emails to contacts gives you a full communication history on every contact record. That's what makes this a CRM and not just a table of emails.

Review weekly. Scan your kanban view to update stages and follow up on stale leads.

Build an interface. Airtable Interfaces let you create a clean CRM dashboard that hides the complexity of the underlying tables — useful if your team finds raw Airtable overwhelming.

Add context when saving. When saving via the add-on, add a quick note about next steps or key points in the Notes field.

Get Started

Sign up for Quicktion and set up a destination for your CRM Emails table. Use the Gmail add-on for selective saving or forwarding for automatic capture — or use both together.

Also building a CRM on other platforms? See our guides for Notion and Google Sheets.