Build a CRM in Airtable with Email Integration

Airtable makes a surprisingly good CRM for small teams. It's flexible, visual, and gives you linked records, automations, and views that dedicated CRM tools charge hundreds for. The missing piece? Getting client emails into your CRM 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

1. Save selectively -- Don't save every email. Focus on important communications that you'll need to reference.
2. Use linked records -- Linking emails to contacts gives you a full communication history on every contact record.
3. Review weekly -- Scan your kanban view weekly to update stages and follow up on stale leads.
4. Build an interface -- Use Airtable Interfaces to create a clean CRM dashboard that hides the complexity of the underlying tables.
5. Add context -- 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.