Build an AI-Powered Sales Machine in Airtable (Part 2: Pipeline, Payments & Commissions)

Part 1 covered how to capture and analyze leads. Part 2 is about turning that foundation into a complete sales operation: a structured pipeline, payment tracking, and a commission system that calculates automatically as deals close.

The Five Questions Behind Every CRM Build

Before building anything in Airtable, this video starts with five structural questions that shape every solid CRM.

What are your lifecycle stages? — Defining the distinct states a deal moves through is the foundation of pipeline clarity. Without this, your pipeline is just a list of names.

What tables and fields do you need? — Once you know your stages, you can map which datasets belong together and which fields each table requires. Good structure here makes everything downstream easier.

What core assets does your team track? — Proposals, contracts, call recordings, payment records — identifying what your team actually needs to reference prevents you from building a CRM they won't use.

Which automations move work forward? — Not every step needs automation, but the right ones — follow-up reminders, stage transitions, payment notifications — are what turn a database into a system.

How will this scale? — Building with growth in mind means avoiding shortcuts that create rework later. The video covers the most common scaling mistakes and how to architect around them.

Pipeline, Payments, and Commissions

The second half of the video builds out three interconnected systems: the pipeline view that shows deal progress and forecast value, the payment tracking that records what's been invoiced and collected, and the commission calculation that determines rep payouts as deals close.

All three pull from the same underlying data structure — meaning there's no manual data entry between systems and no reconciliation required at the end of the month.