Airtable CRM for Coaches: A Step-by-Step Build Guide

Yes, you can build a working Airtable CRM for a coaching practice in an afternoon. Five linked tables (Leads, Clients, Packages, Sessions and Check-ins), a handful of rollup and formula fields, three or four views and one intake form give you a client list that knows who is due for a session, who has gone quiet and who owes you money. This guide gives you the exact structure, field by field, a filled example for a 12-client practice, and an honest map of where the setup stops working.

That map matters because an Airtable CRM tracks clients; it does not run the work with them. Booking, payments, signed agreements, reminders and the between-session check-ins all live in other tools that you connect by hand. When stitching those together starts costing more time than the coaching itself, a purpose-built platform such as Coachful, which puts the whole client journey behind one login for you and one branded app for your clients, is usually the better home. We make Coachful, so weigh that recommendation accordingly; the build below works whether or not you ever switch.

Most of the readers who search for this are freelancers, consultants and small service businesses, not only coaches. The structure holds for all of them, but every example here is framed through a coaching practice, because coaching asks more of a CRM than a one-off project does: clients stay for months, progress happens between sessions, and the relationship is the product.

Can you really run a coaching practice from an Airtable CRM?

For a solo coach with up to about a dozen clients and a single offer, yes, and it can be a good first system. Airtable is a relational database with a spreadsheet face, so it handles the core of a customer relationship management system well: records, relationships between them, filtered views and simple automations.

What it does not do is anything that touches money, calendars or the client's own experience without a second tool. You will still need a scheduler, a payment processor, an e-signature tool, an email sender and somewhere for clients to log progress. Airtable becomes the hub those tools report into, and you become the person who keeps them in sync.

A useful test before you start: list every tool you would connect to the base. If the list is two or three items, build it. If it is five or six, read the limits section first, and compare the total monthly cost against an all-in-one option. Our roundup of the best CRM for coaches covers the dedicated options in more depth.

What jobs does a coaching CRM have to do?

A coaching CRM has to carry a person from first enquiry to finished program and, ideally, to a renewal or referral. The table below lists each job, whether Airtable can do it on its own, and the usual workaround when it cannot.

Read the "No" rows as the true cost of the build. Each one is another subscription, another login for the client, and another place where data can fall out of sync.

How do you build an Airtable CRM step by step?

Create one base called "Coaching Practice" with five tables, link them, then add formulas and views. Build in this order so that every link field has a table to point at.

Step 1: Create the base and the five tables

1. Start a new base from scratch (templates tend to carry sales-pipeline fields you will delete anyway).
2. Rename the default table to Clients.
3. Add four more tables: Leads, Packages, Sessions and Check-ins.
4. Optional sixth table: Payments, if you take instalments or retainers. A one-payment-per-package practice can keep payment fields on the Clients table instead.

Keep everything in one base. Airtable's record limits apply per base, and linked records only work inside a base, so splitting leads and clients into separate bases breaks the relationships you need.

Step 2: Add the fields, with types

Here is the full schema. The first field in each table is the primary field, which Airtable uses as the record's name in links.

TABLE: Leads
  Name                    Single line text   (primary)
  Email                   Email
  Phone                   Phone number
  Source                  Single select: Website form, Instagram, Referral, Podcast, Event, Other
  Stage                   Single select: New, Call booked, Call done, Proposal sent, Won, Lost
  Enquiry date            Created time
  Discovery call          Date (include time)
  Main goal               Long text
  Lost reason             Single select: Price, Timing, Not a fit, No reply, Chose another coach
  Converted client        Link to Clients
  Follow-up due           Formula (see Step 3)

TABLE: Clients
  Name                    Single line text   (primary)
  Email                   Email
  Phone                   Phone number
  Status                  Single select: Onboarding, Active, Paused, Completed, Alumni
  Package                 Link to Packages
  Start date              Date
  Goals                   Long text
  Agreement signed        Checkbox
  Agreement file          Attachment
  Sessions                Link to Sessions
  Check-ins               Link to Check-ins
  Sessions used           Rollup (see Step 3)
  Sessions included       Lookup: Package → Sessions included
  Sessions left           Formula
  Last session            Rollup: Sessions → Date, MAX(values)
  Last check-in           Rollup: Check-ins → Submitted, MAX(values)
  Days since check-in     Formula
  End date                Formula
  Package price           Lookup: Package → Price
  Paid to date            Currency (or Rollup from Payments)
  Balance due             Formula
  Health                  Formula
  Referral source         Link to Leads

TABLE: Packages
  Package name            Single line text   (primary)
  Price                   Currency
  Sessions included       Number (integer)
  Length (weeks)          Number (integer)
  Billing                 Single select: Paid in full, Monthly, Instalments
  Active                  Checkbox
  Clients                 Link to Clients

TABLE: Sessions
  Session                 Formula (primary): {Client name} & " · " & DATETIME_FORMAT({Date}, 'D MMM')
  Client                  Link to Clients
  Client name             Lookup: Client → Name
  Date                    Date (include time)
  Type                    Single select: Discovery, 1:1, Group, Review
  Status                  Single select: Scheduled, Completed, No-show, Cancelled, Rescheduled
  Coach notes             Long text
  Client actions          Long text
  Recording link          URL

TABLE: Check-ins
  Check-in                Autonumber (primary)
  Client                  Link to Clients
  Submitted               Created time
  Energy (1 to 5)         Rating
  Win this week           Long text
  Biggest obstacle        Long text
  Actions completed       Single select: All, Most, Some, None
  Wants a call            Checkbox

Two choices in that schema save trouble later. First, status values are single selects, not free text, so filters and formulas never break on a typo. Second, the Sessions table stores one record per session rather than a "sessions used" number you type by hand; the count then updates itself.

Step 3: Add the rollups and formulas

Formula and rollup fields turn the base from a list into something that tells you what to do next. Paste these into the matching fields.

Clients → Sessions used
  Rollup of Sessions → Status
  Condition: only include linked records where Status is "Completed" or "No-show"
  Aggregation: COUNTALL(values)

Clients → Sessions left
  {Sessions included} - {Sessions used}

Clients → Days since check-in
  IF({Last check-in}, DATETIME_DIFF(TODAY(), {Last check-in}, 'days'), "")

Clients → End date
  DATEADD({Start date}, {Length (weeks)}, 'weeks')
  (add a Lookup of Package → Length (weeks) first)

Clients → Balance due
  {Package price} - {Paid to date}

Clients → Health
  IF({Status} != "Active", "",
    IF({Days since check-in} = "", "No check-ins yet",
      IF({Days since check-in} > 14, "At risk",
        IF({Days since check-in} > 7, "Quiet", "On track"))))

Leads → Follow-up due
  IF(AND({Stage} = "Call done", DATETIME_DIFF(TODAY(), {Discovery call}, 'days') >= 2),
    "Send proposal", "")

Counting no-shows as used sessions is a policy choice; leave them out of the condition if your agreement says otherwise. Whatever you choose, write it into your coaching agreement so the number in the base matches the promise on paper.

Step 4: Create the views you will open every day

• Leads → Pipeline (kanban, stacked by Stage). Drag cards as people move. Hide Lost and Won to keep it short.
• Leads → Follow up today (grid). Filter: Follow-up due is not empty.
• Clients → Active roster (grid). Filter: Status is Active. Sort: Sessions left ascending. Group by Package.
• Clients → Needs attention (grid). Filter: Health is "At risk" or "Quiet", or Balance due is greater than 0, or Agreement signed is unchecked.
• Clients → Renewals (grid). Filter: End date is within the next 21 days. This is your renewal conversation list.
• Sessions → Calendar (calendar view on Date). Useful for a glance, though it is not a booking calendar.
• Sessions → Notes due (grid). Filter: Status is Completed and Coach notes is empty.

Step 5: Build the two forms

1. Enquiry form on the Leads table: Name, Email, Phone, Source, Main goal. Put the link on your website's contact page and in your bio.
2. Weekly check-in form on the Check-ins table: Client (linked), Energy, Win this week, Biggest obstacle, Actions completed, Wants a call.

The check-in form has a known weak spot: if the Client field is a linked-record picker, the person filling it in can see the names of other clients in the dropdown. Either restrict which records the link field can show, or replace the picker with an Email field and match check-ins to clients afterwards. That trade-off between convenience and privacy comes up again in the limits section.

Step 6: Add three automations

• New lead alert: trigger "When a record is created" in Leads; action "Send email" to yourself with the lead's goal.
• Check-in reminder: trigger "When a record matches conditions" in Clients where Health becomes "Quiet"; action "Send email" to the client asking for this week's check-in, with the form link.
• Won lead to client: trigger "When a record matches conditions" in Leads where Stage is Won; action "Create record" in Clients, copying name, email and phone, then "Update record" to fill Converted client.

Formula-driven triggers such as the Health one depend on the formula re-evaluating as dates pass, so test them with a dummy client before you rely on them. Automation run counts and emails to people outside your workspace are capped per plan; check your plan's limits before you send client-facing emails from the base.

Step 7: Set sharing deliberately

• Do not invite clients as collaborators on the base. A collaborator with read access can open every table, including other clients' notes.
• Shared view links show every record in that view to anyone with the link. If you share a view with a client, filter it to that one client and treat the link like a password.
• Anyone you give edit access counts as a paid seat on Airtable's Team and Business plans, according to its pricing FAQ; read-only collaborators, form submissions and share links are not charged.
• Keep sensitive session notes in a field that never appears in a shared view or form.

What does a filled-in Airtable CRM look like for 12 clients?

Here is an illustrative example, not a real practice. Jordan is a fictional career coach with two offers and 12 current clients. All names, prices and numbers below are examples to show how the fields fill in, not suggested rates. Career coaches comparing dedicated tools can also read our CRM guide for career coaches.

Example Packages table: "Career Pivot, 12 weeks" priced at $1,800 for 10 sessions, paid in full or in three instalments; and "Job Search Retainer" at $350 per month for 2 sessions, billed monthly.

On a Monday morning, Jordan opens Needs attention and sees six names: Ben and Jonas are at risk, Elena and Hiro are quiet, Chloe has not checked in since onboarding, and Grace has an instalment outstanding. Felix has one session left on a 12-week package, so Felix also appears in Renewals. That five-minute scan is the real value of the build.

The record count is where the example gets interesting. Over a year, 12 clients on weekly check-ins create about 624 check-in records (12 × 52). Add roughly 300 sessions, 40 to 60 leads, a couple of dozen package and payment records, and the base passes 1,000 records before the year is out. On Airtable's Free plan, which allows 1,000 records per base as listed in November 2026, Jordan would hit the cap in the second half of the year and need either a paid plan or an archive base, which breaks the links to old history.

What does the client see on their phone?

Very little, and that is the honest weak point of any Airtable CRM. The base is built for you, not for the people you coach. A client experiences your system as a handful of links:

• A form link for the weekly check-in, which opens in the phone's browser and works well.
• A booking link from whichever scheduler you connect, with its own branding and confirmation emails.
• A payment link or invoice from your processor.
• An e-signature email for the agreement.
• Possibly a shared view or document with their action items, which they have to find again each week.

Nothing ties those together for the client. There is no history of their check-ins to scroll back through, no streak, no progress bar on their goal, no single place that says "your next session is Thursday, and here is what to finish before it". The Airtable mobile app exists, but it is for people with access to the base, which is exactly where clients should not be.

Airtable now also markets Portals for guest users outside your organisation, which can give a client a login to a filtered interface. If you go that way, confirm the plan, the per-guest cost and how records are scoped on its pricing page before you design around it.

Compare that with a client app built for coaching, where the client opens one app and finds their next session, their program for the week, forms to complete and their own progress:

Where does an Airtable CRM hit its limits?

The limits that bite a coaching practice are rarely the database ones. They are privacy, money, calendars and the client's experience. Here are Airtable's own plan limits first, as listed on its pricing page in November 2026, then the practical ones.

Airtable's FAQ also says that if you reach a record or attachment limit, your data stays but you cannot add records until you upgrade, and automations and API calls are capped at your plan's limit. For a solo coach, the Team plan is the realistic floor once the practice has a year of history.

Privacy and sharing risk

Coaching notes are personal data, and in many countries the law treats them that way. Under the EU's General Data Protection Regulation, for example, you are responsible for who can see a client's information. In a DIY base, one mis-shared view link or a linked-record picker on a public form can expose other clients' names or notes. Audit every shared link each quarter. Health-related coaching adds another layer: coaching is not medical treatment, and clinical records belong in a clinical system, whichever tool you use.

Payments

Airtable does not process payments. You connect a processor, then either type payments in or pay for an integration that writes them in. Instalments are where errors creep in: a failed card on the processor side does not change the Balance due field unless something tells it to.

Booking and reminders

The calendar view shows sessions you have already recorded; it does not offer availability, prevent double bookings or send reminder texts. A separate scheduler does that, and its bookings must reach the Sessions table by sync or by hand. If they do not, Sessions used drifts and the renewal list lies.

Check-ins and programs

A form collects a check-in. It does not show the client their own trend, nudge them at the right time of day, or deliver week three of a program. Many coaches end up adding a course tool or a shared folder, which is one more login for the client.

Mobile

Fine for you, thin for clients. Forms work on a phone; everything else is a link they have to keep.

A team

The day you add an associate coach, they need editor access to log sessions, which makes them a paid seat and gives them sight of every client unless you build interfaces with careful permissions. Splitting availability, assigning clients and paying associates are all outside the base.

How does an Airtable CRM compare with Coachful and dedicated coaching CRMs?

Judged on what a coaching practice needs (one login for the whole client journey, delivery between sessions, total stack cost, and setup effort), the comparison looks like this. Vendor prices are as listed in October 2026; Airtable's are as listed in November 2026.

The Airtable row looks cheapest until you add the scheduler, the processor, the e-signature tool and a course or portal tool to it. Price that stack honestly and compare it with a single subscription (current Coachful plans: Lite: $29/month for up to 5 clients; Solo: $49/month for up to 20 clients; Pro: $99/month with unlimited clients; Studio: $199/month with unlimited clients). For a 12-client practice like Jordan's, the relevant line is Solo: $49/month for up to 20 clients. For a fuller look at how general databases compare for coaches, read Airtable vs Notion for coaches.

What is Coachful, and who is it for?

Coachful is a coaching platform: one subscription covers booking, payments, coaching agreements, program delivery with habits and check-ins, courses, a community, a website with funnels and email, and an AI assistant, with one login for the coach and one branded app for the client. It suits coaches who deliver programs rather than single sessions, solo coaches growing into a small team, and anyone currently paying for four to six tools. The company is based in Tallinn, Estonia.

The pieces you would bolt onto an Airtable base are already inside it. The client record holds goals, check-ins, habits, notes, intake answers, tags, payments and sessions, and gives each client a status of thriving, active, quiet or at risk, which is the Health formula from Step 3 without the formula. Booking pages handle availability rules, buffers, minimum notice and time zones, with two-way Google, Apple and Outlook calendar sync and email reminders, plus SMS and WhatsApp reminders once messaging is enabled. Payments run through your own Stripe Connect or Razorpay account, with one-time payments, subscriptions, payment plans and invoices, and a 0% Coachful platform fee. Coaching agreements are signed before the first call and stored on the client record.

Between sessions, clients follow multi-week programs with weekly goals, daily tasks, habits and morning and evening check-ins, all inside the coach's branded home and app. Michelle, the built-in AI assistant, works from your live practice data and can brief you before a session.

What it does not do matters too. Coachful is not HIPAA-certified and is not for clinical records or insurance billing. There is no PayPal and no permanent free plan. The client app ships under the Coachful listing with your branding, not under your own App Store account. It has no multi-stage sales deal board for large teams and no Salesforce or HubSpot integration, so a sales organisation that lives in a heavy pipeline tool is not the target.

Why Coachful stands out: a free white-glove service. From Create > We'll build it for you · FREE, you describe what you want built (a website, a funnel, a program, a course outline, an intake form, an email sequence) and attach up to 8 reference links and up to 10 files. The Coachful team builds it inside your own account, usually within about 24 hours, without inventing credentials, testimonials or prices. A leadership coach with a Squarespace renewal days away, for example, got one clean homepage with a repeated "talk with me" button. Read more about the free white-glove service.

To start: open a free trial, request the white-glove build for the part you least want to do yourself, and let the onboarding team import your clients.

How do you move from an Airtable CRM into Coachful?

Export your Clients and Leads tables as CSV, hand them over during onboarding, and rebuild the parts that were never really data (your program, your check-in questions, your agreement) as Coachful content. Clients, programs and content are imported for you during onboarding, so the heavy lifting is not a weekend of copy and paste.

What to export from Airtable

1. From each table, open the view with all records and no filters, then download it as CSV. Do Clients, Leads, Sessions and Check-ins.
2. Download attachments (signed agreements) separately; CSV exports contain links to files, not the files themselves.
3. Keep the base read-only for a month after the move as a reference, then archive it.

What to rebuild rather than import

• Packages become offers and programs, with prices set on payment links through your own Stripe or Razorpay account.
• The check-in form becomes a weekly check-in or morning and evening check-ins, which clients complete in their app and can look back on.
• The enquiry form becomes a booking, application or lead-magnet funnel; leads land on the Prospects page with their source and stage.
• Your formulas mostly disappear. Client status, session counts and payment state are tracked by the platform.
• The agreement becomes a coaching agreement with e-signature sent before the first call.

What clients notice

Clients notice fewer links. Instead of a form link, a booking link and an invoice email, they get one invitation to your branded app, where their next session, program, forms and progress live together. Tell them in a short note before the switch, and move clients at a natural break (a renewal or a new month) rather than mid-package if you can.

This walkthrough shows how the client list works once everyone is moved in:

If onboarding is the part of the workflow that hurts most right now, our guide to managing client onboarding without Airtable walks through that stage in detail.

What mistakes do coaches make with an Airtable CRM?

• Starting from a sales template. Deal value, company size and close probability fields make sense for B2B sales and clutter a coaching base. Start from scratch with the schema above.
• Typing counts by hand. A "sessions used" number field goes wrong the first time you forget to update it. Log sessions as records and let a rollup count them.
• Using free text for statuses. "active", "Active " and "ACTIVE" are three different values to a filter.
• Splitting data across bases. It feels tidy and breaks every link and rollup between leads, clients and sessions.
• Inviting clients into the base. Even read-only access shows them more than their own record.
• Forgetting the record cap. Weekly check-ins fill a Free base fast. Plan for a paid plan or a lighter check-in rhythm.
• Treating the base as the client experience. The base helps you stay organised. Clients judge the practice by what they see, and in a DIY stack that is a set of unrelated links.
• Never pricing the stack. Add up every tool connected to the base once a quarter. The total is the number to compare with a coaching platform.

If you coach in a specific niche, the CRM guides for life coaches and health coaches cover what changes for those practices, and the comparison hub lines up the main platforms side by side.

Frequently asked questions

Is Airtable a good CRM for a small coaching business?

It is a good database for tracking leads and clients, and many solo coaches start there. It does not book sessions, take payments, collect signatures or give clients an app, so you will connect several other tools. Once you are maintaining four or more of those connections, a coaching platform usually costs less time and often less money.

How many clients can an Airtable CRM handle?

The database can hold far more than any solo coach needs on a paid plan: 50,000 records per base on Team, as listed in November 2026. The Free plan's 1,000 records per base is the cap to watch, because sessions and weekly check-ins add records quickly. In the 12-client example above, the base passes 1,000 records within a year.

Is there a ready-made Airtable CRM template for coaches?

Airtable offers general CRM and sales templates, but they are built around deals rather than ongoing coaching relationships. The schema in this guide is designed for coaching: packages, sessions, check-ins and a health flag. Copying it field by field takes about an hour.

Can clients log in to see their own records in Airtable?

Not safely as base collaborators, because collaborators can see every table. You can share a filtered view per client or use Airtable's guest portals where your plan allows them. Check the plan and per-guest pricing on Airtable's pricing page before you design around portals.

Can Airtable take payments or book sessions?

No. You need a payment processor and a scheduling tool, and their data has to reach your base through an integration or by hand. That sync is the most common source of errors in DIY coaching CRMs.

Is Airtable safe for confidential coaching notes?

The risk is less the platform and more the sharing settings you choose: an over-shared view link or a public form with a linked-record picker can expose other clients. Keep notes in fields that never appear in shared views, and review links regularly. If your coaching touches health, remember that coaching is not medical care and clinical records belong in a clinical system.

What does Coachful do that an Airtable CRM cannot?

Coachful combines the CRM with booking, payments through your own Stripe or Razorpay account, signed agreements, programs, habits, check-ins, courses and a community, all inside one branded client app. Client status (thriving, active, quiet or at risk) is tracked without formulas. Coachful is not HIPAA-certified and has no PayPal.

What is Coachful's free white-glove service?

Every Coachful plan includes a free white-glove build: you describe what you need, such as a website, a funnel, a program or an email sequence, and attach references. The Coachful team builds it inside your own account, usually within about 24 hours. It does not include recording videos, logo design, ad management or ongoing marketing.

Will I lose my Airtable history if I move to Coachful?

No, if you export first. Download every table as CSV and save attachments separately; clients, programs and content are imported for you during onboarding. Keep the old base read-only for a month as a reference.

Should freelancers who are not coaches use this Airtable CRM setup?

Yes, with small changes. Rename Packages to Projects or Retainers, swap Check-ins for a weekly status update, and keep the Leads pipeline as is. The limits on payments, booking and client experience apply the same way.