Spotify to Youtube Playlist Sync

Spotify to YouTube Playlist Sync Overview This comprehensive workflow automates the process of synchronizing a Spotify playlist with a YouTube playlist. It acts as a one-way sync, where the Spotify playlist is the source of truth. The system is designed to be reliable, handling not just additions and deletions but also recovering from errors like deleted YouTube videos. It uses a Supabase database as a persistent state manager to keep track of synced tracks and their corresponding YouTube video IDs. The automation is divided into three core processes: 1. Playlist Change Detection & Sync: Monitors the Spotify playlist for modifications. When changes are detected, it updates a Supabase database to reflect the current state, adding new songs and marking removed songs for deletion. 2. Smart Video Matching: For new songs added to the database, it intelligently searches YouTube for a matching music video. The matching logic is sophisticated, considering not just the title and artist but also comparing the track's duration to find the most accurate video and avoid covers or remixes. 3. Maintenance & Recovery: Periodically cleans up the YouTube playlist by removing videos for songs that are no longer on the Spotify playlist. It also automatically detects if a synced video gets deleted from YouTube and flags it to be re-matched. Finally, it periodically retries matching songs that it previously couldn't find a video for. Technologies Used - Spotify API: To read the source playlist and its tracks. - YouTube Data API v3: To search for videos and manage the destination playlist. - Supabase: A PostgreSQL database used as a backend to store the state of the synchronization, mapping Spotify track IDs to YouTube video IDs. - Discord: For sending real-time notifications about successful syncs and failures. Automation Value This workflow provides immense value by completely automating a tedious and ongoing task. Instead of manually searching for each song from a Spotify playlist on YouTube and adding it to a playlist, this system does it automatically.