All articles

    CRM guide

    Airtable as a CRM: setup, limits, and migration

    Check your contact and deal base, calendar sync, running costs, and export before deciding whether to move.

    Tiago Ferreira
    Tiago F.
    Writer · Updated 21 September 2026

    Can you use Airtable as a CRM?

    Yes. Use linked tables for companies, contacts, and deals, with clear owners and next actions. Airtable has automations and a Google Calendar sync integration. Test the connections, plan limits, and reports your team needs before choosing between that setup and a dedicated CRM.

    Define the records and daily views

    Start with three tables: Companies, Contacts, and Deals. Link them so a deal can point to its company and the people involved. Keep field definitions and naming rules in one place.

    Example deal
Company: Example Studio
Contact: Alex Chen
Stage: Proposal sent
Owner: Sam
Next action: Confirm the review meeting
Due date: 25 September 2026

    • Keep the board actionable

      Show the owner, next action, and due date alongside the stage. Create a view for overdue actions and review records with no owner.

    • Test access with a teammate

      Check what each person can read, edit, and share. Try the same task through the views or interfaces they will use each day.

    Check what each connection actually does

    Airtable can sync Google Calendar events into a table on paid plans, with plan limits. That integration is one way: changes in the Airtable table do not sync back to Google Calendar.

    • Check calendar scope

      Choose the calendar, date range, fields, and deletion behavior deliberately. Test a changed event before relying on the table for a client meeting.

    • Test email history separately

      Airtable automations can send email, with recipient limits by plan. Check whether your chosen setup also brings in replies, matches people, and handles shared mailboxes. An outgoing email action alone does not prove those workflows work.

    • Give automation an owner

      Review run history and monthly usage. Assign someone to receive failure notifications and fix broken rules or connections.

    Price the setup you will use

    Airtable has a Free plan. On Team and Business, edit access can create a paid seat; read-only collaborators are not charged. Check the current terms for each role and billing period.

    • Count more than deals

      Record usage spans the tables in a base. Include contacts, companies, activities, and any synced records in your estimate. Check attachment storage, automation runs, and API limits too.

    • Compare running costs

      Add the plan, external connections, and time spent maintaining rules and reports. Keep Airtable if it meets those needs. Test a CRM when a required workflow costs too much to maintain.

    Export each table and preserve its links

    Airtable exports a grid view as CSV. Use an unfiltered view with all required fields visible. Export each table separately. Record comments are not included in a CSV export.

    • Map related records

      Keep stable identifiers for companies, contacts, and deals. Inspect how linked fields appear in a sample export, then define how the destination will rebuild those links. Check duplicate names before importing.

    • Save the attachment files

      CSV attachment fields contain filenames and download URLs. Those URLs expire after a few hours. Download the files while the links work and preserve the record-to-file mapping.

    • Run a small trial import

      Include a company, two contacts, a deal, a file, and an empty field. Check counts, links, owners, dates, and files in the destination. Confirm how to carry over any required comments and automation. Keep the source export before the final move.

    Common questions

    Yes. Its Google Calendar sync brings events into Airtable on paid plans with limits. The documented integration is one way, so edits in Airtable do not update Google Calendar.

    A view export follows its filters and visible fields. Use an unfiltered view with the required fields visible. Export each table separately and plan separately for record comments.

    Airtable CSV download URLs expire after a few hours. Copy the files while the URLs work, map them to their records, and check the imported files in the destination.

    Sources

    Sources checked 21 September 2026. Lumenbase is independent of Airtable. Features and plan terms can change.

    Next steps

    Try the full workspace free for 30 days. No credit card required.