How to Build a Client Onboarding System in Airtable (Without Losing Your Mind)

Let's be honest — client onboarding is one of those things that sounds simple until you're actually doing it. Suddenly you're digging through your inbox for a signed contract, realizing you forgot to send the intake form, and trying to remember if you already scheduled the kickoff call. It's chaos, and it doesn't have to be.

I've onboarded dozens of clients across freelance and consulting work, and the single biggest upgrade I made to my business was building a proper onboarding system in Airtable. Not a complicated one — a clean, practical one that makes sure nothing slips and every new client feels like they're working with someone who has their act together.

Here's exactly how I built it, and how you can too.

Why Airtable for Onboarding?

You might be wondering — why not just use a project management tool like Asana or ClickUp? Those are great for ongoing project work, but onboarding has a specific shape: it's a repeatable process with stages, documents, deadlines, and communications that need to happen in a specific order for every single client.

Airtable sits in a sweet spot between a spreadsheet and a database. It lets you track each client as a record, attach files, link to related tables (like your project table or invoice table), and automate follow-up actions. Once it's built, spinning up a new client takes less than five minutes.

The 5 Stages of a Good Onboarding Flow

Before you build anything, it helps to map out the stages your onboarding actually goes through. Mine has five:

1. Lead confirmed — Proposal accepted, ready to kick off
2. Paperwork sent — Contract and invoice out the door
3. Intake completed — Client has filled out your intake form
4. Kickoff scheduled — Call is on the calendar
5. Active — Onboarding complete, project underway

Your stages might look slightly different depending on your service, but the idea is the same: every client moves through the same checkpoints, and you always know exactly where they are.

Building the Base: Step by Step

Step 1: Create Your Clients Table

Start a new Airtable base and create your first table: Clients. Each row is a client. The fields I include:

• Client Name (Single line text)
• Contact Email (Email field)
• Service Type (Single select — useful if you offer multiple services)
• Onboarding Stage (Single select — your five stages from above)
• Start Date (Date field)
• Contract Sent (Checkbox)
• Invoice Sent (Checkbox)
• Intake Form Received (Checkbox)
• Kickoff Call Date (Date field)
• Notes (Long text)
• Attachments (Attachment field — for contracts, briefs, etc.)

Keep it focused. You don't need 30 fields — you need the fields that actually tell you what's done and what isn't.

Step 2: Set Up a Kanban View

Once your fields are in, switch to a Kanban view grouped by Onboarding Stage. Now instead of a table, you have a visual board where you can see every client and exactly where they are in the process at a glance. Drag cards between columns as they move through stages.

This is genuinely one of my favorite views in Airtable — it makes the whole onboarding pipeline feel manageable instead of overwhelming.

Step 3: Create an Onboarding Checklist Table

Create a second table called Onboarding Tasks. This is your master checklist of everything that needs to happen for every client. Link it to your Clients table so each task is tied to a specific client record.

Fields to include:

• Task Name (e.g., "Send welcome email," "Share intake form link")
• Linked Client (Link to Clients table)
• Due Date
• Status (To Do / In Progress / Done)
• Notes

When you bring on a new client, you duplicate your template tasks and link them to the new client record. Takes about two minutes.

Step 4: Add Automations

This is where things get really good. Airtable has built-in automations — no Make.com required (though you can use it for more advanced flows). Here are the three I set up for every client:

Automation 1 — Welcome email trigger. When a new record is created in the Clients table, automatically send a welcome email template to the client's email field. You write the email once, Airtable sends it every time.

Automation 2 — Stage change notification. When the Onboarding Stage field changes to "Active," send yourself a Slack message (or email) saying the client is fully onboarded. Small thing, but it feels great every time.

Automation 3 — Overdue task alert. If a task in your Onboarding Tasks table has a due date that's passed and the status isn't "Done," send a reminder notification. This catches things before they become a problem.

Step 5: Create a Form for Client Intake

Airtable has a built-in form builder. Create a form that maps to your Clients table and captures all the info you need from a new client — project goals, brand details, access credentials, whatever applies to your work.

Send clients the form link as part of your onboarding email. When they fill it out, a new record is automatically created in your Clients table with all their info pre-filled. No more copying and pasting from emails.

The Result: What This Actually Changes

Once this system is set up, your onboarding goes from something you're figuring out as you go to something that practically runs itself. You know exactly where every client is. You never forget to send a contract or schedule a kickoff call. And your clients? They notice. A smooth onboarding experience sets the tone for the entire engagement.

I've had clients specifically comment on how organized and professional my onboarding process feels — and it's because I invested two hours once to build a system that does the work for me every single time after that.

Common Mistakes to Avoid

Over-engineering it. Don't add 15 fields because you might need them someday. Start lean, add fields as you identify real gaps.

Not using views. Airtable's power is in its views. Set up at least a Kanban and a filtered view showing only active onboardings. These save you mental energy every time you open the base.

Skipping the automation step. Manual systems only work when you remember to use them. Even one or two automations — like the welcome email — make the whole thing sticky.

Ready to Build Yours?

If you want to set this up yourself, everything I've described here is something you can do on Airtable's free plan. It'll take you a couple of hours the first time, but once it's done you have a system that scales with your business.

If you'd rather skip straight to a working system, my pre-built Airtable Onboarding Base has all of this configured and ready to duplicate — fields, views, task templates, and automation blueprints included. You just add your clients and go.

Either way, your future clients (and your future self) will thank you.