Dubsado and Airtable: Making Business Operations Smoother

Updated October 2026: rewritten around how Dubsado and Airtable actually connect, which Dubsado events reach Airtable, what to track, and where the integration stops.

Dubsado is very good at everything your client sees: the inquiry form, the proposal, the contract, the invoices and the reminders. What it doesn’t do well is tell you how your business is doing. How many leads came from Instagram this year? Which service brings in the most money for the hours it takes? How full is March already? Most owners end up rebuilding those answers by hand in a spreadsheet, usually the night before they do their taxes.

That’s the job I give Airtable. Dubsado keeps running the client experience, Airtable becomes the place you look at your numbers, and you never type anything twice.

How Dubsado and Airtable connect

There’s no native Dubsado Airtable integration. The two connect through Zapier, and Zapier is only included on Dubsado’s Premier plan (the plans are broken down in my Dubsado pricing guide). Dubsado can send Zapier five events:

• New Project as Lead: a project is created with a lead status, by hand or through a lead capture form or public proposal.
• New Project as Job: a project is created with a job status.
• Contract Signed: a client signs any contract.
• New Payment Received: a payment comes in through Dubsado Payments, Square or PayPal. Payments you log by hand do NOT count.
• Project Status Updated: a project’s status changes, including changes your workflows make.

In Airtable, each of those becomes a new record or an update to one you already have. A new lead creates a client record. A signed contract marks that client as booked. A payment adds a row to a payments table linked to the client, so every dollar is tied to a person and a service.

Where the integration stops

Going the other direction, Dubsado has exactly one Zapier action: Create Project. Airtable can start a brand new Dubsado project, but it can’t change a project that already exists. It can’t move a status, add a note or update a date. Every project a Zap creates also gets the same status, source and workflow, so different kinds of projects need separate Zaps or filters.

So plan Airtable as your reporting and back-office side, and keep managing clients in Dubsado. If you catch yourself wanting to edit client details in Airtable and have them show up in Dubsado, the split between the two tools is in the wrong place, and it’s worth fixing before you build anything else.

What to track in Airtable

• Lead sources. If your lead capture form asks how someone found you, Airtable can count leads by source every month and show which ones turn into booked work.
• Revenue by service. Payments linked to the service they paid for, so you see what actually earns instead of what feels busy.
• Capacity. Booked projects by start date, so you know how full a month is before you say yes to one more.
• Everything Dubsado has no place for. Inventory, rental items, team hours and reviews can all go in Airtable too.

Once those tables exist, an Airtable dashboard puts the numbers on one screen you can check in a minute.

What it looks like in a real business

For Live Wilder Studio, 10 Zaps feed Airtable from Dubsado, ClickUp and Google Reviews, so only 2 things get entered by hand each month. The Party Bar splits the work the same way: Dubsado runs 12 client workflows, and Airtable tracks 226 rental variations by date.

Before you build a single Zap

Decide what you want to see every month, THEN build the Zaps that feed it. Zaps built first turn into a pile of Airtable records you never look at, and every Zap run uses up Zapier tasks whether you look at the data or not. Automation makes messy things messy faster, so the mapping comes first here too.

The webinar (interruptions included)

I walked through all of this in a webinar, and two minutes in, the owner of the rental I was staying in started banging on the front door and would NOT stop. I’d been there for weeks and nobody had knocked once, and then it was an emergency porch situation the moment I was live. The content held up anyway, and you can watch the whole thing here.

The free template I keep mentioning in the webinar is here. For every other tool Dubsado connects to, natively or through Zapier, see my Dubsado integrations guide.

Want it built for you?

Connecting Dubsado and Airtable in your own business is part of my custom systems work. Want your whole Dubsado account built start to finish? See my Dubsado setup services. Want Airtable tracking your numbers? See my Airtable setup services. Run a nonprofit instead? The same Airtable thinking runs donor, grant and volunteer tracking in my nonprofit systems.