Analyze Spotify playlists and automatically organize them in Google Sheets
Workflow Description
Automated workflow that fetches your Spotify playlists and tracks, analyzes them using Anthropic's AI to extract musical insights, and records structured results to Google Sheets on a scheduled basis. Enables intelligent music data organization without manual effort.
How it works
- 1.Retrieve playlist and track data from Spotify on a recurring schedule
- 2.Process the music data through Anthropic AI to analyze content and extract musical attributes
- 3.Format, filter, and upload the analyzed results to Google Sheets automatically
Use cases
- Monitor your listening habits, favorite artists, and musical patterns with AI-powered categorization
- Build an organized music library in Google Sheets with automatic genre, mood, and context classifications
Requirements
- Active Spotify account with access permissions to read playlists and track metadata
- Google Sheets account with write permissions for storing and updating automation results
- Valid Anthropic API key configured for AI analysis capabilities
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