Spotify Playlist Sync to Supabase

Name: Spotify Playlist Sync to Supabase
Rating: 5.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

45 views

0 downloads

Data Managementautomationdatabaseplaylistspotifysupabasesync

Synchronizes a Spotify playlist with a Supabase table, updating or adding new tracks.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of keeping a Supabase database table in sync with a specified Spotify playlist. It periodically checks for changes in the Spotify playlist, compares it with the existing data in Supabase, and updates or adds new tracks accordingly. It also marks tracks for deletion in Supabase if they are no longer present in the Spotify playlist.

Key Features

Periodically checks a Spotify playlist for updates.
Compares Spotify playlist tracks with existing data in a Supabase table.
Adds new tracks from Spotify to Supabase.
Updates existing tracks in Supabase based on Spotify data.
Marks tracks for deletion in Supabase if removed from the Spotify playlist.
Optionally searches for YouTube videos associated with tracks.

How To Use

Import the workflow: Load this JSON into your n8n instance.
Configure Credentials: Ensure you have valid Spotify API credentials and Supabase credentials set up in n8n.
Set Spotify Playlist ID: In the variables node, update spotify_playlist_id with the ID of the Spotify playlist you want to sync.
Set Supabase Table Name: In the variables node, update supabase_table_name with the name of your Supabase table.
Configure Supabase Node Filters: In the Supabase nodes (Get all musics, Update to_delete to true, Add music), adjust the filters to match your Supabase table's primary key and the fields you want to use for matching (e.g., id for track ID).
Adjust Wait Times: Modify the Wait 1 hour node if you need a different synchronization frequency.
Enable the workflow: Activate the workflow to start the synchronization process.

Apps Used

automation

database

playlist

spotify

supabase

sync

Workflow JSON

{
  "id": "7ebd8b15-a945-45e0-9722-13c1de01b28d",
  "name": "Spotify Playlist Sync to Supabase",
  "nodes": 0,
  "category": "Data Management",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.