Airtable is a flexible spreadsheet‑database hybrid that lets coaches organize clients, schedule sessions, track progress, and automate admin work. This guide walks you through the core concepts, step‑by‑step setup, everyday workflows, advanced patterns, and the most common mistakes coaches make with Airtable.
Airtable stores data in bases. Each base contains tables (like sheets) and each table has fields (columns). Fields can be plain text, numbers, dates, single‑select lists, or linked records that connect tables together. Think of a base as a mini‑CRM for your coaching practice.
Follow these five steps to get a functional coaching base up and running in under 30 minutes.
Visit airtable.com and sign up with your email. Choose the free plan – it gives you 1,200 records per base and 2 GB of attachment space.
In the Airtable Marketplace, search “Coaching Dashboard”. Click “Use template”. This creates a base with three tables: Clients, Sessions, and Invoices. All fields are pre‑named, so you can start entering data right away.
Open the Clients table and add two fields:
Starter, Growth, Elite.In the Sessions table, click “Add view” → Calendar. Choose the Session Date field. Now you see every upcoming meeting on a calendar that you can embed on your website.
Go to “Automations” → “Create a custom automation”. Choose trigger “When a record is created” in Sessions. Add action “Send email” using your Gmail integration. Use the following template:
Subject: Your upcoming session
Hi {Client Name},
Your next session is on {Session Date} at {Session Time}. Here is the Zoom link: {Zoom Link}.
See you soon,
{Your Name}
Turn the automation on. Now every new session automatically emails the client.
These workflows turn the raw data in your base into daily actions.
Clients, an automation assigns a “Welcome” task to your assistant.Use the Zapier recipe “New Airtable Record → Create Zoom Meeting”. Map the Session Date and Client Email. The Zap returns a Zoom Link that you store back in the same record. The email automation from Section 2.5 picks up the link automatically.
Create a Progress Log table with fields:
Clients)Link each log entry to the client. In the Clients table, add a rollup field that shows the most recent Status using the formula ARRAYJOIN(values, ", "). This gives you a one‑line health check for every client.
When a session is marked “Completed”, trigger an automation that creates a draft invoice in Invoices. Use the formula field:
IF({Status}="Completed", {Hourly Rate}*{Duration}, "")
Then, connect Stripe via the “Airtable + Stripe” integration to send a payment link automatically.
Beyond the basics, these patterns save you hours each week.
Add a formula field Alert in Clients:
IF(
AND(
{Goal Date},
IS_BEFORE({Goal Date}, TODAY())
),
"⚠️ Goal passed",
""
)
The field shows a warning icon when a client’s goal date is overdue. Use the “Grid view” filter “Alert is not empty” to see at‑risk clients instantly.
Build an automation that runs every Monday at 8 am:
Sessions where Session Date is within the next 7 days.Client Name – Session Date – Topic.Use Airtable’s native “Google Calendar” sync. In Sessions, enable “Sync to Google Calendar”, map Session Date to the event start, and set the calendar to your coach’s personal calendar. Edits in either system stay in sync.
If you have assistant coaches, give them “Read‑only” access to Clients but “Editor” rights on Progress Log. This protects sensitive contact details while letting assistants add notes.
Open the “Scripting” block and paste this JavaScript snippet to bulk‑update all “Starter” package clients to a new price:
let table = base.getTable("Clients");
let query = await table.selectRecordsAsync();
for (let record of query.records) {
if (record.getCellValue("Coaching Package")?.name === "Starter") {
await table.updateRecordAsync(record.id, {
"Hourly Rate": 75
});
}
}
Run it once a quarter to keep pricing consistent.
Even experienced coaches slip up. Below are the top errors and quick remedies.
Problem: Storing clients, sessions, invoices, and notes in one table makes filtering painful.
Fix: Split each logical entity into its own table and use linked records. This keeps each table under the 1,200‑record free limit longer.
Problem: Deleting a row permanently erases progress data.
Fix: Turn on “Record history” in base settings. It keeps a 30‑day revision log you can restore from.
Problem: Uploading large video files quickly eats the 2 GB free attachment quota.
Fix: Store heavy media on Google Drive or Dropbox, then paste a shareable link into an attachment field.
Problem: Team members can’t find the “Upcoming Sessions” view.
Fix: Prefix view names with emojis or tags, e.g., “📅 Upcoming Sessions”. Use consistent naming conventions.
Problem: An automation sends a blank email because a field name changed.
Fix: After any schema change, open the automation, click “Run test” and verify the output before re‑enabling.
Choose the plan that matches your coaching business size. The table shows key limits and price per user.
| Plan | Monthly Price (per user) | Records per Base | Attachment Storage | Automation Runs |
|---|---|---|---|---|
| Free | $0 | 1,200 | 2 GB | 100 runs |
| Plus | $12 | 5,000 | 5 GB | 5,000 runs |
| Pro | $24 | 50,000 | 20 GB | 50,000 runs |
| Enterprise | Custom | Unlimited | Unlimited | Unlimited |
Most solo coaches stay on the Free or Plus plan. If you run a team of five coaches and need >5,000 records, the Pro plan at $24 each is the sweet spot.
You can start with the free tier. It supports up to 1,200 records per base and 2 GB attachment space, which is enough for a solo coach with a few dozen clients.
Yes. Use Airtable's native Zapier or Make (Integromat) connectors. A typical Zap creates a Zoom meeting when a new row with a session date is added.
Create a “Progress Log” table linked to the “Clients” table. Use a single‑select field for status (On Track, Needs Help, Completed) and a formula field that calculates days since the last entry.
Airtable Marketplace offers a “Coaching Dashboard” template and a “Client Onboarding” template. Both are free and can be duplicated with one click.
Turn on “Record history” in the base settings. It keeps a 30‑day revision log. Also, give team members only “Commenter” or “Read‑only” permissions unless they need edit rights.
Airtable gives coaches a single place to store client data, schedule sessions, track progress, and automate admin tasks. By following the setup steps, using the core workflows, and applying the advanced patterns, you can run a lean, data‑driven coaching practice. Avoid the common pitfalls listed above and choose a pricing tier that matches your growth. Start with the free template today and watch your coaching business become more organized and profitable.