Zum Inhalt springen
Social MediaPro — €97

Spotify & YouTube Music Discovery to Discord & Supabase

100/100
46 Nodes

Beschreibung

Findet neue Musik auf Spotify und YouTube, speichert sie in Supabase und teilt Updates auf Discord.

Setup-Anleitung

# Spotify to YouTube Playlist Synchronization
## A workflow that maintains a YouTube playlist in sync with a Spotify playlist, featuring smart video matching and persistent synchronization.

## Key Features
- **One-way Sync**: Spotify playlist → YouTube playlist (additions and deletions
- **Continuous Monitoring**: Automatic synchronization (every hour by default, but you can put any time you want)
- **Smart Video Matching**: Considers video length and content relevance
- **Auto-Recovery**: Automatically handles deleted YouTube videos
- **Database Backup**: Persistent storage using Supabase

## Prerequisites

1. Supabase project with the following table structure:
```sql
CREATE TABLE IF NOT EXISTS musics (
    id TEXT PRIMARY KEY,
    title TEXT NOT NULL,
    artist TEXT NOT NULL,
    duration INT8 NOT NULL,
    youtube_video_id TEXT,
    to_delete BOOLEAN DEFAULT FALSE
);
```
2. Empty YouTube playlist (recommended as duplicates are not handled)
3. Configured credentials for YouTube, Spotify, and Supabase APIs
4. Properly set variables in all "variables" nodes (variables, variables1, variables2, variables3, variables4 (all the same))
5. Activate the workflow !

## Workflow Components

### Workflow 1: Main Sync Process
1. **Change Detection**
   - Monitors Spotify playlist for changes
   - Compares database state with current playlist

2. **Video Matching**
   - Searches YouTube based on title, artist, and duration
   - Evaluates top 5 results for best match
   - Marks unmatched tracks with "NOTFOUND"
   - Notifies user of successful matches and failures

### Workflow 2: YouTube Maintenance
- Monitors YouTube playlist for removed videos
- Flags removed videos for re-search
- Handles deletion of marked videos

### Workflow 3: Recovery Process
- Clears "NOTFOUND" flags periodically to re-search previously unmatched tracks

## Implementation Notes
- Workflows can be separated into different files for better monitoring
- Recovery process ensures long-term playlist maintenance

Benötigte Integrationen (11)

Aggregate

Aggregate

Compare Datasets

CompareDatasets

Discord

Discord

API Key

Remove Duplicates

RemoveDuplicates

Schedule

Schedule

Split In Batches

SplitInBatches

Spotify

Spotify

Stop And Error

StopAndError

Supabase

Supabase

API Key

Wait

Wait

You Tube

YouTube

Workflow freischalten

Kaufe das Pro Bundle für €97 — erhalte sofortigen Zugang zu diesem und allen weiteren Starter + Pro Workflows als ZIP-Datei zum Import in n8n.

Sichere Zahlung via Stripe. 7-Tage Geld-zurück-Garantie.
← Zurück zum Marketplace