Skool + Airtable: Track Members, Leads and Programs
To track Skool members, leads and programs in Airtable, build three linked tables, one for people, one for programs and one for enrollments, so a single person can be a lead, a free member and a paying client in two programs without duplicate rows. Airtable is worth it over a spreadsheet when you sell more than one thing and need to see who is in what.
Why linked tables matter
A flat member list breaks as soon as you have a second program. Do you add a column per program? A row per enrollment? Both get messy fast. Airtable's linked records solve this: each person exists once, each program exists once, and enrollments connect them.
Step 1: The People table
One row per human, whether they've joined Skool yet or not:
• Name
• Email
• Skool profile link
• Source: lead magnet, referral, YouTube, ad
• Stage: lead, free member, paid member, client, alumni
• Goal, from their membership answer
• Notes
Step 2: The Programs table
One row per thing you sell or run:
• Program name, for example "Paid community," "8-week cohort," "1:1 coaching"
• Type: membership, cohort, coaching
• Start and end dates, for cohorts
• Price
Step 3: The Enrollments table
This is the link between the two:
• Person (linked to People)
• Program (linked to Programs)
• Status: invited, active, finished, dropped
• Start date
• Course progress or completion, if you track it
Now one person can have three enrollments over a year and you'll see the whole path on their record.
Step 4: Views that answer real questions
• Leads who joined the free community this month
• Free members with a goal that matches your paid offer
• Active cohort members who haven't finished week 2
• Alumni from last year's cohort, for a reunion or upsell
Each view should answer one question you'd otherwise answer by scrolling.
Step 5: Getting data in
Skool has no public API. Your options:
• Leads from forms or a landing page go straight into People through the form tool's Airtable connection
• Skool member events can come in through an automation platform like n8n or Make, fed by a Skool-native tool that sends webhooks
• Skool's Zapier integration may cover some events; check what it offers on your plan
• For low volume, add rows by hand in a weekly review
Match people by email so a lead who later joins Skool updates their existing row instead of creating a new one. n8n Skool Automation: What Is Possible and What Is Not explains where the limits are on the Skool side.
Mistakes to avoid
• One giant table with 40 columns
• Matching by name instead of email, which creates duplicates
• Tracking engagement in Airtable by hand. It goes stale in a week. Keep Airtable for stage and program data.
• No owner. Someone has to look at the views weekly.
A worked example
Say you run a free Skool community, a $49/month paid community and a quarterly 8-week cohort. A lead downloads your guide and lands in People as a lead. Two weeks later they join the free community and their stage changes. In March they join the cohort, which adds an enrollment. When the next cohort opens, you filter alumni who finished, and you have a warm list of people who already know how you teach.
Which program would you track first if you set this up this week?
0
0 comments
Sasha Zotov
2
Skool + Airtable: Track Members, Leads and Programs
Skool Automation
skool.com/skool-automation
Skool automation for DMs, member follow-ups, posts, AI moderation, engagement, retention, and community workflows powered by stickyhive.ai
Powered by