01
Problem
A site for a club that isn't open yet lives or dies on lead capture, and the club's small team needed to act on that data without learning a custom admin panel.
02
Approach
Make the spreadsheet the club already uses the system of record, and put the engineering effort into the capture flows and automation around it.
03
Design decisions
- Two clear calls to action, join the interest list or reserve a clinic spot, everywhere on the site
- A focused registration modal per clinic, with date, time and location shown up front
- No separate admin panel: dashboards are generated inside Google Sheets
04
Technical build
- Service-account integration that appends rows and auto-creates a formatted dashboard tab per clinic
- First-party analytics: visits, page views and conversions logged to a dedicated sheet
- Templated transactional email through Resend
- Vercel CI/CD on every push
05
Outcome
Live at pbathletic.org, capturing interest-list sign-ups and clinic registrations into a self-updating operations hub ahead of the club's launch.