Overview
Airtable makes a surprisingly powerful CRM when combined with its built-in automations. This guide shows you how to build a kanban-style sales pipeline in Airtable, then automate the critical actions: stage-change notifications, follow-up reminders when deals go cold, and weekly pipeline digest emails. It's a lean CRM that a team of 1-5 can actually maintain.
Before you start
- Airtable account (Pro plan for automations)
- Deals and contacts data ready
- Slack workspace (optional)
- Zapier account for advanced automations
Step-by-step guide (5 steps)
Set up your pipeline base and views
Create an Airtable base with a 'Deals' table. Add fields: Company name, Contact name, Email, Phone, Deal value, Stage (single select: Lead, Qualified, Proposal, Negotiation, Won, Lost), Close date, Owner, and Notes. Create a Kanban view grouped by Stage.
Create a stage-change notification automation
In Airtable Automations, create a new automation triggered by 'When record matches condition: Stage changed to Proposal.' Action: Send an email to the deal owner with the company name, deal value, and a link to the record. This keeps reps on top of active deals.
Set up a stale deal reminder
Create a second automation: 'When record matches condition: Last Modified is more than 7 days ago AND Stage is not Won or Lost.' Action: Send the deal owner an email reminder to follow up. This prevents deals from dying in the pipeline silently.
Add a 'Last Contacted' date field and use that instead of 'Last Modified' — it's more accurate since updates to notes shouldn't reset the follow-up clock.
Create a Won deal celebration + sync
Trigger: Stage changed to Won. Actions: Post a Slack message to #wins channel with deal name and value. Create a new record in your Clients table. Send a welcome email to the new client via Gmail.
Build the weekly pipeline digest
Use Zapier or Make with a Schedule trigger. Every Monday at 8am, query your Airtable pipeline, then format and email a summary: total pipeline value, deals closing this week, stale deals.
What you'll get
Visual pipeline the whole team can update
No deals fall through the cracks with stale alerts
Won deals automatically trigger onboarding actions
No expensive CRM subscription for small teams
Common mistakes to avoid
Building too many fields upfront — start with 8-10 essential fields
Not creating a 'Last Contacted' field (Last Modified is inaccurate)
Skipping the won/lost automation (data becomes useless without it)
Frequently asked questions
Do I need coding experience to set up this Airtable automation?
No coding is required. This guide walks you through everything using Airtable's built-in features and Zapier's visual interface. If you can follow a recipe, you can follow this guide.
How long does this automation take to set up?
Most users complete this setup in 30–60 minutes on their first try. Once set up, it runs completely automatically with zero ongoing effort.
What happens if the automation fails?
Zapier and Make both have error notifications and task history, so you'll know immediately if something goes wrong. We cover troubleshooting steps in the guide above.
Can I customize this automation for my specific business?
Absolutely. The guide includes notes on common customizations. Most automations have multiple variation points — timing, conditions, notification recipients, and more.