Connect Spotify with Google Sheets
Workflow Description
An automation template that uses artificial intelligence to fetch your Spotify playlist data, analyze it, and automatically log it in Google Sheets periodically. This simplifies tracking and organizing your listening habits with structured, actionable data.
How it works
- 1.Activate the scheduler trigger to run the automation at regular intervals
- 2.Retrieve playlist and track data from Spotify using API authentication
- 3.Process and analyze the data using Anthropic Claude language model
- 4.Filter and format results according to defined criteria and preferences
- 5.Upload the processed data to Google Sheets automatically
Use cases
- Track listened songs and create a chronological listening history in a spreadsheet
- Analyze listening patterns and extract statistics about music preferences
- Build a comprehensive archive of your playlists and how they evolve over time
- Document music recommendations generated by the AI system
Requirements
- Active Spotify account with playlist access permissions
- A Google Sheets document configured to receive the data
- Anthropic API key to run Claude models for analysis
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