I rebuilt a coaching & professional development platform's fully manual assessment workflow into one connected Airtable + Zapier pipeline — automating 80% of the process across 50–60 personalized career assessments per cycle, with 8 email variants sent without a single manual send, while keeping humans firmly in the loop.
Workflow automated
80%
Of the end-to-end workflow, from intake and scoring to coach follow-up.
Assessments per cycle
50–60
Personalized, high-value career assessments processed consistently.
Personalized email variants
8
Across score type × membership tier — with zero manual sends.
A coaching & professional development platform was running 50–60 personalized, high-value career assessments per cycle — a growing product hitting a manual ceiling. Because the product was highly monetized, quality and consistency were critical, yet every part of the process depended on people doing repetitive work by hand:
I rebuilt the end-to-end workflow into a single connected pipeline on Airtable, Zapier, SendGrid, and Google Drive — one pipeline, fully connected, with a deliberate human-oversight layer at its center. Here is how it works:
The rebuilt pipeline automated 80% of the end-to-end career assessment workflow for the coaching platform. It processes 50–60 personalized assessments per cycle, consistently. All 8 personalized email variants are delivered with zero manual sends, and monthly member delivery now runs with zero manual steps end-to-end.
The team went from managing every touchpoint to monitoring a queue, and coaches went from chasing forms to delivering insight — the personal, coaching-driven experience the product is built on was never lost.
The system handles scoring, report generation, delivery, and follow-up automatically, while a human review queue sits at its center: Airtable interfaces show sent and pending reports with reasons and tags, and staff can review, override, and resend at any point. The automation was deliberately built around that oversight layer — humans supervise a queue instead of executing every step, so oversight never becomes a bottleneck.
Score logic inside Airtable determines each member's report type — one of 4 variants — and assembles dynamic content automatically. A PDF is generated and stored in Google Drive, linked back to Airtable, and a personalized HTML email is sent via SendGrid, drawn from 8 variants across the combination of score type and membership tier, with zero manual sends.
Airtable serves as the main database, admin interface, and automation infrastructure; Zapier is the data pipeline and cross-system connective tissue; SendGrid handles personalized email delivery; Google Drive stores the generated PDF reports, linked back to Airtable; and custom JavaScript and API integrations support the pipeline throughout.
The pipeline processes 50–60 personalized, high-value career assessments per cycle, consistently. For monthly members, delivery runs with zero manual steps end-to-end; annual members additionally flow through an automated coach loop with assignment, notification, a 7-day follow-up questionnaire, and feedback video distribution.