Role Growth Specialist Timeline 4 months Platform Airtable

Scaling Partner Operations with Airtable

I redesigned a broken, drive-only system into a full operations platform — managing 50+ partners across multiple states with zero missed follow-ups.

☰21 automationsstate-driven, not time-based
◉Org-first architecturepartners, not transactions
✓Human-in-the-loop Outboxsystem prepares, human sends
✶Trigger-based logicstatus changes fire downstream actions

This dashboard is interactive

Click any stage above to see the full cascade of automations it triggers across all three layers.

Operations Intelligence — Cascade Visualizer LIVE SYSTEM
Click any stage to see what fires
Lead
Outreach
Priority
Onboard
Scheduled
Active
Pickup
Complete
When status changes to: Lead
Three-Layer Operations Model
Layer 1: Partner Operations
Relationship lifecycle, communication, Outbox
Outreach Onboarding Outbox Follow-Up Comm Log
↓ triggers ↓
Layer 2: Logistics Control
Bins, routes, pickup scheduling, driver coordination
Status Gate Bin Routing ADLM Assign Pickup Pounds
↓ data flows ↓
Layer 3: Enablement & Scale
Dashboards, reporting, partner toolkits, renewal
Dashboard Exception Board Partner Toolkit Renewal Pipeline
The Problem

A database of transactions, not relationships

When I inherited this system, there was no concept of a "partner." There was a flat table of drives — 247 rows, no relationships, no history. First Baptist Church appeared 3 times and you'd never know it was the same organization.

That meant no one could answer basic questions: Who's our contact? Do they have a W-9? How many pounds have they raised lifetime? When did we last talk to them?

Toggle between the before and after to see what changed.

Before
After
Drives247 records
Drive Name
Charity
Start
End
Status
Lbs
Spring Drive 2024
First Baptist Church
Mar 4
Mar 18
Complete
1,240
Earth Day Collection
Northstar LLC
Apr 15
Apr 29
Active
—
Fall Drive 2023
First Baptist Church
Oct 2
Oct 16
Complete
980
Holiday Give-Back
Lincoln Elementary
Dec 1
Dec 15
Complete
670
Back to School 2023
First Baptist Church
Aug 7
Aug 21
Complete
1,100
Community Clean-Up
Meridian Co.
May 6
May 20
Scheduled
—
Spring Drive 2024
Hope Church
Mar 11
Mar 25
Active
—
?Who's the contact at First Baptist? Check email threads...
?Do they have a W-9 on file? No idea — no field for it
?How many total lbs has First Baptist raised? Add it up manually across 3 rows
?When did we last talk to Lincoln Elementary? Not tracked anywhere
FB
First Baptist Church
Church Nashville, TN Partner since Aug 2023
3
Drives
3,320
Lifetime Lbs
$265
Total Payout
Contact
Pastor David Kim
david.kim@firstbaptist.org
(615) 555-0142
Status
Repeat Partner
Comm: Active Conversation
W-9 on file
ADLM: Mike R. (Southeast)
Outbox
Intro sent — Aug 7, 2023
Welcome kit — Aug 10
3x results emails sent
Early-bird renewal — ready to send
Drive History
Spring 20241,240 lbsComplete
Fall 2023980 lbsComplete
Back to School 20231,100 lbsComplete
Communication Log
EmailResults sent — Spring 2024 payout $99Mar 22
CallDrive planning call — confirmed Mar 4 startFeb 15
EmailThank you — Fall drive completeOct 20
CallInitial onboarding — program overviewAug 8
Tasks
Onboarding complete (10/10)
Send early-bird renewal offer
Next drive target: Sep 2024
Date Confirm
Welcome Kit
W-9 Request
Pickup Reminder
Thank You
Results
Welcome Kit
Welcome to Bags for Bucks, [Partner Name]! We're excited to have [Organization] on board.

Here's what's coming up:

• Your promo toolkit — flyers, social templates, and talking points
• Bin placement — your ADLM ([ADLM name]) will coordinate logistics
• Drive dates — [start] through [end]
• W-9 — needed before payout, we'll send a reminder

Questions? Just reply here — we're with you every step.
▶ Send via Outbox
The Outbox

System prepares. Human decides.

Every email in the system is pre-written, personalized with partner data, and staged for one-click sending. But nothing sends automatically — because partners are people, not funnel entries.

The Outbox gives you the right email at the right time based on where the partner is in their lifecycle. Highlighted fields show exactly what needs personalization before you hit send.

→20+ email templates from welcome kit through results & renewal
✎Personalized fields partner name, org, dates, payout auto-filled
✓Stage-locked you can only see emails relevant to the current status
⏱Auto-logged every send creates a comm log entry with timestamp
Trigger-Based Automations

21 automations that respond to reality

Every automation fires based on what's actually happening — a status change, a missing document, a completed pickup — not a scheduled cron job or calendar reminder.

One status change can trigger a cascade across all three layers: partner ops, logistics, and enablement. Click any row to see the full chain.

⚡State-driven automations respond to status changes, not schedules
☰Cross-layer one trigger fires ops, logistics, and enablement actions
⚠Exception-aware missing W-9s, stalled onboarding, no-reply streaks flagged
Status → "Priority"
→
Onboarding checklist auto-generated + Outbox activated
The system clones the Master Partner Checklist into the partner record, sets due dates based on drive start, and enables all Outbox email buttons for the current lifecycle stage.
Drive confirmed
→
Welcome Kit staged + W-9 request queued + ADLM notified
Three systems respond to one status change: the Outbox stages the Welcome Kit for review, a W-9 request is queued if missing, and the assigned ADLM receives notification for bin logistics planning.
Status → "Scheduled"
→
Automation fires — drive enters logistics system
Trigger-based automation: when status reaches "Scheduled," downstream workflows fire automatically — bin routing, ADLM assignment, pickup prep. No manual handoff needed.
W-9 still missing
→
Exception flag raised on the Uh-Oh Board with countdown
If a W-9 is missing within 14 days of drive start, the partner appears on exception dashboards. One of the few time-aware triggers — because payment deadlines are real.
Pickup logged
→
Drive locked + thank-you staged + renewal target set (6 months)
The drive record locks to prevent accidental edits. Thank you is staged in the Outbox. The system auto-sets a renewal target 6 months out and creates an outreach task 30 days before.
Pounds entered
→
Results email generates with impact data and payout amount
When pound totals are entered, the system generates the results email with calculated payout. Sent through the Outbox for final review.
Any status change
→
Available actions update — only relevant buttons for current stage
The interface adapts to where the partner is. You can’t accidentally send a pickup reminder to a partner still in scheduling.
Priority Base — Active PartnersLIVE
Partner
Status
Tasks
Days
Flag
Northstar LLC
Nonprofit
Onboarding
12d
W-9 missing
Partner Info
Contact: Sarah Chen
Phone: (555) 234-5678
Drive dates: Apr 12 – Apr 26
ADLM: Assigned (Mike R.)
Outbox Ready
Intro sent
Welcome kit sent
W-9 request — needs follow-up
4/10 onboarding tasks complete
Elevate Growth Co.
Business
Active Drive
34d
Partner Info
Contact: David Park
Drive: Mar 5 – Mar 19 (active)
Bins: 2x standard, placed
ADLM: Jen T. (Southeast)
Status
All onboarding complete
W-9 on file
Weekly check-in sent
Pickup scheduled Mar 20
Lincoln Elementary
School
Scheduling
8d
No reply 5d
Partner Info
Contact: Principal Morrison
Type: School (different W-9 flow)
Last contact: 5 days ago
Action Needed
No reply after follow-up
Follow-up #2 staged in Outbox
Rule: 2 follow-ups = flag as cold
Meridian Co.
Business
Needs ADLM
21d
Drive in 9d
Hope Church
Church
Active Drive
45d
Summit Academy
School
Onboarding
5d
Parkview Baptist
Church
Scheduling
15d
No reply 3d
Partner Info
Contact: James Wright
Drive: Mar 29 – Apr 12
Location: Nashville, TN
Exception
Drive confirmed but no ADLM assigned
Nashville coverage: needs routing
Cannot enter logistics until assigned
The Daily View

Open it, work the list, go home

Priority Base is the daily execution view — every morning, open it, see who needs attention, and work through the list. No digging through tabs, no wondering who fell through the cracks.

Each row shows status, task progress, days in system, and exception flags. Click any partner to expand their full detail panel with contact info, outbox status, and next actions.

⚠Exception flags W-9 missing, no reply, drive approaching without ADLM
◉Task progress visual bar shows onboarding completion percentage
⏱Days tracked how long each partner has been in the system

Partner Lifecycle

Every partner moves through a structured timeline

–4 weeks → drive → +4 weeks. Nothing is ad-hoc.

WEEK -4
Welcome
Welcome packet
W-9 collection
Program overview
WEEK -3
Promote
Promo toolkit
Social templates
Flyers & talking pts
WEEK -2
Prep
Countdown graphics
Bin placement
Logistics confirmed
WEEK -1
Final Check
Pickup instructions
Contact verify
Prerequisites check
ACTIVE
Live Drive
Support check-ins
Progress graphics
Overflow protocol
WEEK +1
Closeout
Thank you email
Processing update
Drive locked
WEEK +2
Results
Impact report
Payout issued
Tax receipt
WEEK +3-4
Renewal
Feedback survey
Early-bird offer
6-month pipeline
Impact

The numbers behind the system

Real results from a real program managing real partnerships across multiple states.

0
Flat Drive Rows
→
0
Org Profiles
0
Drives Linked
0
Automations
0
Missed Follow-ups
$0.5K
Funds Distributed
0K+
Families Served
0K lbs
Landfill Diversion

Design Philosophy

How I think about systems

State > Time
Automations respond to what's happening, not what the calendar says
Human > Auto
System prepares. Human decides. One click executes.
Context > Speed
Every email reviewed — partners are people, not funnel entries
Focus > Volume
Show what needs attention now. Hide noise, surface exceptions.
Workflow Analysis Database Design Automation Logic Interface Design Process Mapping Airtable Partner Operations Data Governance