Archive monthly Spotify tracks with AI-powered playlist categorization
Workflow Description
Monthly automation that retrieves your Spotify library additions, intelligently categorizes them by genre, mood, and context using Claude AI, and stores organized results in Google Sheets for easy archiving and analysis of your listening patterns.
How it works
- 1.Fetch all tracks added to your Spotify account during the current month
- 2.Extract and structure track metadata and audio characteristics
- 3.Categorize each track automatically via Claude based on genre, mood, and usage context
- 4.Store categorized results in a Google Sheets spreadsheet for permanent archive
Use cases
- Maintain an organized historical record of your monthly music discoveries and listening patterns
- Build categorized playlists automatically for different moods, activities, or genres
- Analyze how your musical taste evolves and identify listening trends over time
Requirements
- Active Spotify account with full API access permissions configured
- Google account with access to create and modify spreadsheets
- Anthropic API key with Claude model access enabled
- Pre-configured Google Sheets document ready to receive archived track data
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
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 (37)
Retrieve relevant info
Set
Batch preparation
Code
Get Track details
HTTP Request
Split Out
Split Out
Anthropic Chat Model
Lm Chat Anthropic
Get Playlist
If
Get Tracks
If
Structured Output Parser
Output Parser Structured
Playlists informations
Set
Filter my playlist
Filter
Split Out1
Split Out
Batch preparation1
Code
Merge
Merge
Simplify Tracks informations
Set
Limit
Limit
Get logged tracks
Google Sheets
Excluding logged tracks
Merge
Filter
Filter
Split Out2
Split Out
Manual Verification
Merge
Spotify
If
Aggregate by 200 tracks
Code
Sticky Note
Sticky Note
Monthly Trigger
Schedule Trigger
Sticky Note1
Sticky Note
Get logged playlists
Google Sheets
Log new tracks
Google Sheets
Log new playlists
Google Sheets
Excluding logged playlists
Merge
Sticky Note2
Sticky Note
Limit2
Limit
Classify new tracks
No Op
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Basic LLM Chain - AI Classification
LLM Chain