How anxt-it/spotifywrapped-weekly works
The product is a Spotify listening-history collector and weekly email report. The main workflow fetches recent plays, normalizes them, stores them in SQLite, then queries the history and emails a formatted summary. The README also describes a v2 redesign with a normalized schema, audio features, and a dashboard; the v2 source excerpts are empty, so those capabilities are shown as planned rather than connected runtime stages.
Main entry points: collector.py Collection pipeline · reporter.py Report generation · spotify_client.py Spotify client · recent_tracks.py Track parser
Components 15
Listening collection
- Collection pipeline
collector.py - Spotify client
spotify_client.py - Track parser
recent_tracks.py - Listening history
Weekly reporting
- Report generation
reporter.py - Weekly SQL queries
wrapped_queries.sql
V2 roadmap
- Normalized schema
v2/database_manager.py - Audio features
v2/reccobeats_client.py - V2 transformation
v2/transformer.py - V2 collection
v2/collector_v2.py - React dashboard
Other components
- Cron scheduler
- Spotify API
- SMTP service
- Email recipient
Connections 10
- Cron scheduler → Collection pipeline: schedules hourly
README.md - Cron scheduler → Report generation: schedules weekly
README.md - Collection pipeline → Spotify client: fetches plays
collector.py - Spotify client → Spotify API: requests plays
spotify_client.py - Collection pipeline → Track parser: normalizes results
collector.py - Collection pipeline → Listening history: writes plays
collector.py - Report generation → Weekly SQL queries: loads queries
README.md - Report generation → Listening history: reads history
reporter.py - Report generation → SMTP service: sends report
reporter.py - SMTP service → Email recipient: delivers email