Extract and store Spotify streaming data in database
Workflow Description
Scheduled automation retrieves playlist and track data from Spotify at regular intervals, processes information in batches with conditional logic, and stores cleaned data in Noco Db for tracking and historical analysis.
How it works
- 1.Trigger scheduled execution and authenticate with Spotify account
- 2.Fetch playlist and track metadata from Spotify API
- 3.Split data into batches and apply conditional filters
- 4.Merge processed results and validate data integrity
- 5.Save verified data to Noco Db tables
Use cases
- Monitor streaming patterns and track performance metrics regularly
- Maintain historical records of playlists and listening activity
Requirements
- Active Spotify account with API access configured
- Noco Db project with pre-defined database tables
- Scheduling interval configured according to business needs
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (30)
Get current date
Code
Sticky Note3
Sticky Note
Get last 10 liked tracks
If
Check if track is saved
Noco Db
Is not saved
If
Create song entry
Noco Db
Get all user playlist
If
Sticky Note4
Sticky Note
Get monthly playlist
Filter
Get playlist in DB
Noco Db
Monthly playlist exist in Spotify ?
If
Playlist exist in DB ?
If
Create playlist in Spotify
If
Create playlist in DB1
Noco Db
Create playlist in DB
Noco Db
Merge
Merge
Clean op
No Op
Clean op2
No Op
Get this month playlist in DB
Noco Db
Get this month tracks in DB
Noco Db
Add song to the playlist
If
For each tracks in liked song
Split In Batches
For each monthly tracks in DB
Split In Batches
Get this month tracks in Spotify
If
Filter1
Filter
Song is not present in the playlist ?
If
Clean op1
No Op
Sticky Note5
Sticky Note
Schedule Trigger
Schedule Trigger
End
No Op