How to Build a CRM and Sales Pipeline With Airtable

A CRM should make it easy to answer a few basic questions: Who are we talking to? What do they need? What is the next step? And which opportunities are most likely to close?

Airtable is a flexible place to store this information. You can connect companies, contacts, opportunities, notes, tasks, files, and quotes without forcing your sales process into a rigid, off-the-shelf CRM.

The challenge is giving each person the right way to interact with that data. A prospect needs a simple form. A salesperson needs a focused pipeline. A manager needs visibility across the team. A customer may need a secure place to review information, upload a document, or approve a proposal.

With miniExtensions, you can keep Airtable as the source of truth and add the forms, interfaces, portals, documents, signatures, and automations needed to turn the base into a complete CRM workflow.

What can an Airtable CRM manage?

A CRM built on Airtable can be as simple as a list of leads or as complete as a connected sales and account-management system. A typical setup can handle:

• Lead capture from your website or a shared form
• Companies and their associated contacts
• Deals moving through a defined sales pipeline
• Calls, emails, meetings, notes, and follow-up tasks
• Ownership by salesperson or account manager
• Quotes, proposals, contracts, and signatures
• Appointment or demo requests
• Customer-facing account and onboarding information
• Email follow-ups and status notifications
• Reporting by stage, owner, source, value, and expected close date

You do not need to implement everything at once. Start with the tables and steps your team already uses, then add more extensions as the workflow becomes clearer.

Example Airtable CRM structure

The most useful CRM bases separate companies, people, and opportunities. This prevents information from being duplicated and makes it easier to understand every relationship.

Table	What it stores	Important links
Companies	Organizations or accounts	Contacts, Deals
Contacts	Individual people and their details	Company, Deals, Activities
Deals	Sales opportunities and pipeline data	Company, Contacts, Owner, Activities
Activities	Calls, emails, meetings, notes, and tasks	Deal, Contact, Owner
Sales Reps	Users who own or manage CRM records	Deals, Activities
Quotes	Pricing, proposals, and approval status	Deal, Company, Line Items

Companies

Use the Companies table for information that belongs to the account rather than one person. Useful fields include company name, website, industry, size, region, account status, owner, estimated value, and internal notes.

Contacts

Use the Contacts table for names, job titles, email addresses, phone numbers, contact preferences, lead sources, and consent information. Link each contact to a company. A company can have many contacts, while a contact will usually belong to one company.

Deals

Use one record for each opportunity. This is the table that powers the sales pipeline. Common fields include:

• Deal name
• Company and primary contact
• Sales stage
• Deal owner
• Estimated value
• Probability
• Expected close date
• Next step and next-step date
• Lead source
• Loss reason

Activities

Do not put every note into one long field on the deal. An Activities table creates a usable history. Each record can represent a call, email, meeting, note, or task and link back to the relevant deal and contact.

Before you build: decide how records should move

Write down the stages your team actually uses. A simple B2B pipeline might be:

• New Lead
• Contacted
• Qualified
• Demo or Discovery
• Proposal Sent
• Negotiation
• Won
• Lost

Keep the first version simple. If two stages do not lead to meaningfully different actions, they probably do not need to be separate. You can always add detail later.

Also decide which fields are required before a deal can move forward. For example, a deal should not move to Proposal Sent without a value, expected close date, primary contact, and next step.

How to set up the CRM with miniExtensions

1. Prepare your Airtable base

Create the Companies, Contacts, Deals, Activities, and Sales Reps tables. Add Quotes if your team produces proposals from CRM data.

Then create linked-record fields between the tables. At minimum:

• Contacts should link to Companies.
• Deals should link to Companies, Contacts, and Sales Reps.
• Activities should link to Deals, Contacts, and Sales Reps.
• Quotes should link to Deals and Companies.

Create Airtable views for the groups of records people need to work with, such as My Open Deals, New Leads, Follow-ups Due, Proposals Outstanding, Won This Month, and Stale Deals.

2. Create a lead capture form

In the miniExtensions dashboard, select your workspace and Airtable base, click Create Extension, and choose Form (or simply click here to create a form directly). Select the Contacts or Deals table, depending on how you want new inquiries stored.

A lead form might ask for:

• Name
• Work email
• Company
• Phone number
• What the prospect needs
• Budget range
• Preferred meeting time
• How they heard about you

Use default or hidden values for internal fields such as Stage = New Lead and Lead Source = Website. If your form creates a contact first, you can create or link the deal through your Airtable workflow.

Keep the first form short. Information such as qualification notes, probability, and deal value belongs to the internal sales process, not the public lead form.

Share the form directly or embed it on your website. Because every submission is written to Airtable, new leads enter the same system your team uses to manage the rest of the sales process.

3. Build an internal sales pipeline interface

Your sales team needs a faster way to review and update opportunities than opening the complete Airtable base. Create a miniExtensions Interface for the Deals table and choose the layout that matches the task.

• Use a Grid Interface for a familiar spreadsheet-style pipeline with inline editing.
• Use a List Interface for a clean, scan-friendly list of deals and next steps.
• Use a Gallery Interface when visual cards are more useful.
• Use a Calendar Interface for expected close dates, demos, or follow-up schedules.

For day-to-day sales work, a grid is often the best starting point. Show only the fields reps need, such as Deal, Company, Stage, Value, Next Step, Next-Step Date, Expected Close Date, and Owner.

Enable inline editing for the fields that should be updated quickly. Keep calculated fields, sensitive notes, and administrative fields read-only or hidden.

You can create multiple views for the same interface, such as All Open Deals, My Deals, Closing This Month, and Needs Follow-up. Filtering and sorting keep the interface focused without changing the underlying Airtable data. You can also mix and match interface layouts within the same interface, e.g. a grid and a calendar to look at data in different ways.

4. Give each salesperson access to the right records

If every salesperson already works directly in Airtable, you can use Airtable views and miniExtensions Interfaces as needed. If you want a simpler experience—or do not want to provide access to the full base—create a Portal.

Choose Portal from Create Extension (or simply click here to create one directly). Use Sales Reps as the users table and Deals as the first data table. Select the linked-record field that connects each deal to its owner.

Configure email or another unique field as the login field. When a rep logs in, the portal can show the deals connected to that rep rather than every record in the CRM.

In the portal, you can:

• Choose the Airtable views, records, and fields that appear.
• Allow reps to open and update selected deal fields.
• Enable inline editing in grid views.
• Show a logged-in profile that reps can view or update.
• Add multiple tables, such as Deals, Activities, Contacts, and Quotes.
• Use conditional tables or views for different roles, regions, or teams.

Use access rules as part of the design, not as an afterthought. Test the portal with at least two sales-rep records and confirm that each account sees only the records intended for it.

5. Let reps log calls, meetings, and follow-ups

Add the Activities table to the Portal and configure it as a linked table under Deals. Allow users to create new linked records from within a deal.

An activity form can include:

• Activity type
• Date and time
• Contact
• Summary
• Outcome
• Next step
• Follow-up date
• Attachments

A new activity created from a deal can be linked automatically to that deal and the logged-in rep. This removes manual relationship work and keeps the activity history complete.

For a faster workflow, keep the activity form short. The most important outcome is a reliable record of what happened and what should happen next.

6. Let prospects or customers update their own information

Not every external user needs a full CRM portal. Sometimes a prospect only needs to correct contact information, complete qualification questions, or upload a document.

Use a Form with Login when a user should identify themselves and update an existing record. Each person sees only the record that matches the configured login fields.

You can also send a unique direct record URL when the recipient should open one specific form without searching. Choose the access method based on the sensitivity of the information and the experience you want to provide.

For ongoing access to multiple records—such as projects, quotes, invoices, support requests, and account details—use a customer portal. See Airtable Customer Portal Without Extra Airtable Seats for a detailed example.

7. Generate quotes and proposal PDFs

Once a deal is qualified, CRM data can be reused instead of copied into a separate document manually.

Create a Quotes table linked to Deals. Store the quote number, client details, validity date, pricing, terms, line items, status, and output attachment field.

Then choose the PDF automation that fits the document:

• PDF Generator is useful for proposals, contracts, certificates, and other documents based on a fillable PDF template.
• Invoice Generator is designed for invoices or receipts with linked line items.
• Generate PDFs from Formulas works for simple text-based documents.
• Convert HTML Code to PDF provides more control for conditional or complex layouts.

Map Airtable fields to the document template and save the generated PDF to an attachment field. That attachment can then appear in the deal, be shared in a portal, or be included in an email.

8. Collect an approval or signature

If a prospect needs to approve a quote or sign a document, add a signature step to the workflow.

A miniExtensions form attachment field can be configured in Signature mode. Depending on your settings, the signer can type a name, upload a signature image, or draw a signature by hand. The resulting signature is stored in the Airtable attachment field you selected.

You can also use the Signature Collection automation as a follow-up step in an existing form workflow. Keep the signed file, signature, signing status, and date connected to the deal so the complete history remains in Airtable.

9. Send follow-ups from Airtable data

Use the Send Emails for Records automation to send messages to contacts using fields in Airtable.

For example, create formula fields for the email subject and body, then use filtered Airtable views to identify records that should receive a message:

• A new-lead acknowledgement
• A reminder before a scheduled demo
• A follow-up after a meeting
• A proposal-ready notification
• A reminder before a quote expires
• A welcome email when a deal moves to Won

The automation can attach files, such as a generated proposal PDF. It can also record that an email was sent and, when tracking is configured, update delivery, open, or click status during subsequent automation runs.

Use filters and sent-status fields to avoid sending the same message repeatedly. Test the workflow with internal addresses before processing live contacts.

10. Add appointment or demo requests

If meetings are part of the sales process, add an appointment form for discovery calls, demos, consultations, or follow-ups. You can offer available time slots and link the request back to the relevant contact or deal. The guide How to Build an Airtable Appointment Booking Form covers this workflow in more detail.

11. Import existing CRM data

If you are moving from a spreadsheet or another CRM, clean the data before importing it. Give each company, contact, and deal a stable unique ID, separate combined fields, and decide how duplicates will be handled.

miniExtensions CSV automations can import new and updated records into Airtable. A unique ID allows the automation to match rows to existing records. Test a small sample first, verify linked records and field types, then run the full migration.

Keep the original export until the migration has been checked and approved.

A practical CRM rollout plan

A CRM succeeds when people trust it and keep it current. Roll it out in stages rather than trying to build every possible workflow at once.

Phase	Build	Success check
1. Foundation	Companies, Contacts, Deals, stages, owners	Every open opportunity is represented once
2. Intake	Public lead form and source tracking	New inquiries arrive with the right defaults
3. Daily work	Sales interface or rep portal	Reps can update stage and next step quickly
4. History	Activities and follow-up dates	Every active deal has a recent activity and next action
5. Documents	Quotes, PDFs, signatures, email	Proposal workflow can run without copying data
6. External access	Forms with login or customer portal	External users see only their own information

CRM design tips

Make the next action obvious

A pipeline stage describes where a deal is. A next step describes what somebody must do. Give every active deal a next step, a due date, and an owner.

Keep internal and external fields separate

Prospects and customers should not see internal notes, probability estimates, loss analysis, account risk, private pricing calculations, or other fields intended only for your team. Configure each form, interface, and portal around its audience.

Use views as workflow queues

Views such as Unassigned Leads, Follow-ups Due Today, Stale Deals, Proposals Expiring, and Won Without Onboarding turn CRM data into actionable work queues.

Avoid duplicate sources of truth

If a value already exists in Airtable, reuse it in the form, portal, PDF, or email workflow. Do not maintain separate copies of company names, addresses, prices, or statuses unless there is a clear reason.

Test access with real scenarios

Before sharing a portal, create test users for different roles. Confirm what each user can view, edit, create, and download. Repeat this check after changing linked fields, Airtable views, or portal conditions.

When should you build a CRM with Airtable?

An Airtable CRM is a good fit when your sales process needs more flexibility than a standard CRM provides, your operational data already lives in Airtable, or the workflow must connect closely to delivery, onboarding, documents, events, inventory, or customer portals.

It is especially useful for agencies, consultancies, associations, property businesses, education programs, nonprofits, and operations-heavy teams whose sales process does not end at a generic Closed Won stage.

A specialized enterprise CRM may be a better fit when you need a very large sales organization, complex territory management, advanced forecasting, or an extensive ecosystem of CRM-specific integrations. The goal is not to rebuild every possible CRM feature. It is to create the system your team will actually use.

Build the CRM around your real workflow

Airtable gives you the relational structure for companies, contacts, deals, activities, and quotes. miniExtensions gives each person a focused way to work with that data.

Prospects can submit a lead form. Sales reps can manage a filtered pipeline. Managers can review the full process. Customers can update records or access selected account information. Quotes, signatures, emails, and files can remain connected to the same Airtable records from the first inquiry through the completed sale.

Start with the smallest useful version: your core CRM tables, a lead form, and a sales pipeline interface. Then add portals and automations where they remove repetitive work. Create your free miniExtensions account and turn your Airtable base into a CRM built around the way your team sells.