Just finished building a custom tool that turns Google Sheets into a programming workspace for CrossFit coaches. No more clicking through the Wodify admin UI one workout at a time.
What it does:
- Bulk uploads an entire week of programmed workouts from a single sheet
- Pulls historical workouts back into the sheet for review, editing, or analytics
- Handles three program streams in parallel: Main, Masters, and Kids
- Configurable per location and date range
How it's built:
- Google Apps Script (JavaScript runtime)
- Wodify REST API integration with secure key storage
- Custom menu UI built into the Sheets toolbar
- Multi-tab architecture: Input · Results · Config · Pulled Workouts · Log
- Date-range and "last N days" query logic for flexible pulls
Why this matters: coaches were spending hours each week on manual data entry. This collapses that into a single click. The same architecture works for any SaaS platform with a REST API — gym software, CRMs, fitness apps, scheduling tools.
Tech stack: Google Apps Script, JavaScript, REST APIs, OAuth/API key auth, Google Sheets as a lightweight frontend.
Open to building similar automation tools for fitness businesses or any SaaS workflow that's eating up admin time.
GoogleAppsScript #API #Automation #Wodify #FitnessTech #FullStack #JavaScript