Monthly Spotify Track Archiving and Playlist Classification

This n8n workflow allows you to automatically archive your monthly Spotify liked tracks in a Google Sheet, along with playlist details and descriptions. Based on this data, Claude 3.5 is used to classify each track into multiple playlists and add them in bulk.

Who is this template for?

This workflow template is perfect for Spotify users who want to systematically archive their listening history and organize their tracks into custom playlists.

What problem does this workflow solve?

It automates the monthly process of tracking, storing, and categorizing Spotify tracks into relevant playlists, helping users maintain well-organized music collections and keep a historical record of their listening habits.

Workflow Overview

• Trigger Options: Can be initiated manually or on a set schedule.
• Spotify Playlists Retrieval: Fetches the current playlists and filters them by owner.
• Track Details Collection: Retrieves information such as track ID and popularity from the user’s library.
• Audio Features Fetching: Uses Spotify's API to get audio features for each track.
• Data Merging: Combines track information with their audio features.
• Duplicate Checking: Filters out tracks that have already been logged in Google Sheets.
• Data Logging: Archives new tracks into a Google Sheet.
• AI Classification: Uses an AI model to classify tracks into suitable playlists.
• Playlist Updates: Adds classified tracks to the corresponding playlists.

Setup Instructions

1. Credentials Setup:
   Make sure you have valid Spotify OAuth2 and Google Sheets access credentials.
2. Trigger Configuration:
   Choose between manual or scheduled triggers to start the workflow.
3. Google Sheets Preparation:
   Set up a Google Sheet with the necessary structure for logging track details.
4. Spotify Playlists Setup:
   Have a diverse range of playlists and exhaustive description (see example) ready to accommodate different music genres and moods.

Customization Options

• Adjust Playlist Conditions:
  Modify the AI model’s classification criteria to align with your personal music preferences.
• Enhance Track Analysis:
  Incorporate additional audio features or external data sources for more refined track categorization.
• Personalize Data Logging:
  Customize which track attributes to log in Google Sheets based on your archival preferences.
• Configure Scheduling:
  Set a preferred schedule for periodic track archiving, e.g., monthly or weekly.

Cost Estimate

For 300 tracks, the token usage amounts to approximately 60,000 tokens (58,000 for input and 2,000 for completion), costing around 20 cents with Claude 3.5 Sonnet (as of October 2024).

Playlists' Description Examples