AI Agents

Analyze and log your Spotify songs to Google Sheets automatically

37 nodes 350 145 Scheduled trigger
Download

Workflow Description

Intelligent automation that extracts your favorite songs from Spotify, analyzes them using artificial intelligence, and automatically records results in Google Sheets on a scheduled basis. Perfect for tracking listening patterns and building music insights over time.

How it works

  1. 1.Fetch your recent songs and playlists from Spotify account
  2. 2.Process music data through Anthropic AI for intelligent analysis
  3. 3.Filter and structure the analyzed information according to predefined rules
  4. 4.Insert processed records into your Google Sheets spreadsheet
  5. 5.Execute the entire workflow on your scheduled interval

Use cases

  • Track your musical taste evolution and listening patterns over weeks and months
  • Build an organized music library with AI-generated insights about artists and genres
  • Generate automated weekly or monthly reports of your listening habits

Requirements

  • Active Spotify account with API access permissions
  • Pre-configured Google Sheets document ready to receive data
  • Valid Anthropic API key for AI analysis functionality

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Anthropic If Output Parser Google Sheets LLM Chain

Details

Trigger Scheduled trigger
Nodes 37
Apps 5
Views 350
Downloads 145

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (37)

/

Retrieve relevant info

Set

#1

Batch preparation

Code

#2

Get Track details

HTTP Request

#3

Split Out

Split Out

#4

Anthropic Chat Model

Lm Chat Anthropic

#5

Get Playlist

If

#6

Get Tracks

If

#7

Structured Output Parser

Output Parser Structured

#8

Playlists informations

Set

#9

Filter my playlist

Filter

#10

Split Out1

Split Out

#11

Batch preparation1

Code

#12

Merge

Merge

#13

Simplify Tracks informations

Set

#14

Limit

Limit

#15

Get logged tracks

Google Sheets

#16

Excluding logged tracks

Merge

#17

Filter

Filter

#18

Split Out2

Split Out

#19

Manual Verification

Merge

#20

Spotify

If

#21

Aggregate by 200 tracks

Code

#22

Sticky Note

Sticky Note

#23

Monthly Trigger

Schedule Trigger

#24

Sticky Note1

Sticky Note

#25

Get logged playlists

Google Sheets

#26

Log new tracks

Google Sheets

#27

Log new playlists

Google Sheets

#28

Excluding logged playlists

Merge

#29

Sticky Note2

Sticky Note

#30

Limit2

Limit

#31

Classify new tracks

No Op

#32

Sticky Note3

Sticky Note

#33

Sticky Note4

Sticky Note

#34

Sticky Note5

Sticky Note

#35

Sticky Note6

Sticky Note

#36

Basic LLM Chain - AI Classification

LLM Chain

#37