Prompt
How do I build a shared CRM in Airtable or something like it?
Latest observation
You can build a shared CRM in Airtable pretty quickly if you treat it like a lightweight database + workflow system. The key is to design it around people, companies, interactions, ownership, and pipeline stages.
Here’s a practical way to do it.
1) Decide what the CRM needs to do
Before building anything, define:
- Who will use it?
- What counts as a lead/contact?
- What stages does a deal go through?
- What activities should be tracked?
- What reports do you need?
A simple shared CRM usually needs:
- Contacts
- Companies
- Deals / opportunities
- Tasks / follow-ups
- Notes / interaction history
- Ownership / assignment
- Pipeline status
2) Build the core tables
In Airtable, create these tables:
A. Contacts
Fields:
- First name
- Last name
- Phone
- Job title
- Company link
- Owner
- Lead source
- Status
- Last contacted
- Next follow-up
- Notes
B. Companies
Fields:
- Company name
- Website
- Industry
- Size
- Owner
- Status
- Related contacts
- Related deals
C. Deals
Fields:
- Deal name
- Company link
- Primary contact link
- Owner
- Stage
- Value
- Close date
- Probability
- Next step
- Activity history
D. Activities / Interactions
This is your audit trail. Fields:
- Date
- Type: call/email/meeting/note
- Related contact
- Related company
- Related deal
- Owner
- Summary
- Next action
- Due date
E. Tasks
If you want a separate action system. Fields:
- Task name
- Assigned to
- Due date
- Status
- Related contact/deal/company
- Priority
3) Set up relationships properly
This is the difference between a useful CRM and a messy spreadsheet.
Use linked records:
- Contacts ↔ Companies
- Deals ↔ Companies
- Deals ↔ Contacts
- Activities ↔ Contacts/Companies/Deals
- Tasks ↔ Contacts/Deals
Use lookup/rollup fields for things like:
- Last activity date
- Number of open tasks
- Total deal value by company
- Contact count per company
4) Add statuses and stages
Keep these consistent.
Contact status examples
- New
- Working
- Qualified
- Nurture
- Unresponsive
- Customer
- Disqualified
Deal stages examples
- Prospecting
- Discovery
- Proposal
- Negotiation
- Won
- Lost
Task status examples
- To do
- In progress
- Done
- Blocked
Use single-select fields so everyone uses the same labels.
5) Make it shared without becoming chaos
Airtable works well for team CRMs if you set rules.
Best practices:
- Create an Owner field on every important record
- Use views filtered by owner or team
- Lock down who can edit what
- Use forms for data entry if needed
- Add required fields where possible
- Standardize naming conventions
Example views:
- My Leads
- My Open Deals
- Today’s Follow-ups
- Unassigned Records
- Stale Deals
- Closed Won This Month
6) Automate the boring parts
Airtable automations can help a lot.
Useful automations:
- When a new lead is added, assign owner based on territory or round-robin
- When deal stage changes, notify the owner
- When follow-up date is today, send reminder
- When no activity has happened in 14 days, flag the deal
- When a form is submitted, create contact + task automatically
You can also connect:
- Gmail / Outlook
- Slack
- Calendars
- Zapier / Make
- HubSpot / Pipedrive if you need more automation
7) Create forms for intake
Use Airtable forms for:
- Lead capture
- Referral submissions
- Event signups
- Internal requests
- New customer onboarding
Forms prevent people from editing the wrong stuff and keep data clean.
8) Build a useful interface
Airtable Interfaces are great for making a CRM feel less like a database.
Create dashboards for:
- Sales rep home page
- Manager pipeline overview
- Contact profile page
- Task queue
- Company account view
This helps users avoid the base itself if they don’t need to touch it.
9) Add reporting
At minimum, track:
- Number of new leads
- Conversion rate by stage
- Deal value by owner
- Revenue closed this month
- Average time in stage
- Follow-up completion rate
- Activity volume
You can do this with Airtable views, summary fields, or interface charts.
10) Decide if Airtable is enough
Airtable is great if you want:
- Flexibility
- Simple shared workflows
- Custom fields and views
- Lightweight CRM needs
You may want something else if you need:
- Strong sales pipeline features
- Email tracking
- Built-in calling
- Advanced permissions
- Sophisticated reporting
- Very large data volume
Alternatives worth considering:
- Notion: good for simple shared tracking, weaker relational CRM
- HubSpot: best if you want a real CRM with sales features
- Coda: similar flexibility to Airtable, more document-like
- Monday.com: good for team workflows
- Smartsheet: spreadsheet-like, less CRM-native
- Attio: modern CRM designed for flexibility
- Pipedrive: sales pipeline focused
- Airtable + Softr/Stacker: if you want a nicer front-end
Recommended starter setup
If you want the simplest useful version, start with just 4 tables:
- Contacts
- Companies
- Deals
- Activities
Then add Tasks later if needed.
A simple build order
- Create tables
- Add linked records
- Add status/stage fields
- Create views
- Add forms
- Add automations
- Build interface dashboards
- Test with a small team
- Refine after 2 weeks of real use
If you want, I can also give you:
- a ready-to-build Airtable CRM schema
- a step-by-step Airtable setup
- or a better alternative depending on your team size and use case.