Spotify Automate

Spotify Automate synchronizes your Spotify playlist with a YouTube playlist, ensuring that every hour it checks for updates, adds new tracks, and removes deleted videos. It intelligently matches Spotify tracks with YouTube videos based on title, artist, and duration, enhancing your listening experience. With persistent storage in Supabase, it keeps track of all music data and notifies you of any changes, making playlist management seamless and efficient.

7/8/2025
54 nodes
Complex
schedulecomplexspotifysupabasecomparedatasetsnoopschedule triggerwaityoutubesplitinbatchesdiscordaggregateremoveduplicatessticky noteautomationadvancedlogicconditionalcroncommunicationbot
Categories:
Communication & MessagingSchedule TriggeredComplex WorkflowCreative Content & Video Automation
Integrations:
SpotifySupabaseCompareDatasetsNoOpSchedule TriggerWaitYouTubeSplitInBatchesDiscordAggregateRemoveDuplicatesSticky Note

Target Audience

This workflow is ideal for:
- Music Curators: Individuals who manage playlists across different platforms and want to ensure synchronization between Spotify and YouTube.
- Data Enthusiasts: Users who are interested in data management and integration, particularly in music databases.
- Developers: Those looking to automate tasks related to music playlists and database management using APIs.
- Content Creators: YouTube creators who want to keep their playlists updated with the latest music from Spotify.
- Social Media Managers: Professionals managing music-related social media accounts that require regular updates on playlists.

Problem Solved

This workflow addresses the challenge of keeping a YouTube playlist in sync with a Spotify playlist. It automates the process of:
- Identifying new tracks added to the Spotify playlist and adding them to the YouTube playlist.
- Removing tracks from the YouTube playlist that have been deleted from Spotify.
- Matching tracks based on title, artist, and duration, ensuring that only relevant videos are added.
- Updating a database with video IDs, allowing for easy tracking and management of music content.

Workflow Steps

  • Schedule Triggers: The workflow is triggered daily at noon and 1 minute past noon, as well as every hour, ensuring regular synchronization.
    2. Get Spotify Playlist Snapshot: The current state of the Spotify playlist is retrieved to check for changes.
    3. Compare Snapshots: The new snapshot is compared with the previous one to identify any differences.
    4. Fetch Music Data: If changes are detected, the workflow fetches all music data from the Supabase database.
    5. Add New Tracks: New tracks are added to the Supabase database if they are not already present.
    6. YouTube Video Search: For each track, a search is performed on YouTube to find a matching video based on title and artist.
    7. Duration Matching: The workflow checks if the video duration is within ±10% of the Spotify track duration before adding it to the YouTube playlist.
    8. Update Database: The YouTube video ID is saved in the Supabase database, and notifications are sent via Discord for successful matches or unmatched tracks.
    9. Delete Removed Tracks: The workflow checks for any deleted videos from YouTube and removes them from the playlist, updating the database accordingly.

    • Customization Guide

    Users can customize this workflow by:
    - Adjusting Schedule: Modify the schedule triggers to run the workflow at different times or intervals based on their needs.
    - Changing Playlist IDs: Update the Spotify and YouTube playlist IDs in the 'variables' nodes to sync different playlists.
    - Modifying Database Structure: Alter the Supabase database schema if additional fields are needed for tracking or if the existing structure changes.
    - Custom Notifications: Adjust the Discord notification messages to include more personalized content or use different communication channels.
    - Error Handling: Implement additional error handling for API requests to manage potential failures more effectively.