Automate Spotify Track Archiving to Google Sheets

• Automatically log Spotify liked tracks into Google Sheets for easy access and organization.
• Utilize AI to classify tracks into personalized playlists based on user preferences.
• Maintain a historical record of music listening habits for analysis and reflection.

Fetch current playlists from Spotify and filter them by owner. Retrieve details of liked tracks, including track ID and popularity. Get audio features for each track using Spotify's API. Merge track information with audio features for comprehensive data. Filter out already logged tracks in Google Sheets to avoid duplicates. Log new tracks into Google Sheets for future reference. Use AI to classify tracks into suitable playlists based on characteristics.

1. 1
   Import the workflow template into n8n.
2. 2
   Set up valid Spotify OAuth2 and Google Sheets credentials.
3. 3
   Configure the trigger for manual or scheduled execution.
4. 4
   Prepare a Google Sheet with the necessary structure for logging track details.
5. 5
   Adjust playlist conditions and AI classification criteria as needed.