Sleeper Dynasty Roster Sync
Summary
Managing rosters across a 12-team dynasty fantasy football league meant constantly cross-referencing player statuses manually. There was no easy way to get a clean, structured snapshot of every team’s full roster – starters, bench, taxi squad, and IR – in one place.
What I did
- Identified the Sleeper API as a no-auth data source and mapped the relevant endpoints (rosters, users, players) to understand what data was available
- Built a Google Apps Script function that fetches live league and player data, then writes a structured tab in Google Sheets for each of the 12 teams
- Categorized every player by roster designation (Starter, Bench, Taxi, IR) so the output is immediately usable, not just a raw data dump
- Generalized and open-sourced the script so any Sleeper dynasty manager can use it with their own league ID
Outcome
Reduced roster review from a manual, multi-tab process to a single script run. The project is publicly available on GitHub and documented for reuse by the broader fantasy football community.