AI Agents

Connect Spotify with Google Sheets

37 nodes 201 136 Scheduled trigger
Download

Workflow Description

An intelligent automation template that retrieves Spotify listening data, analyzes it using Anthropic's language model, and automatically logs insights into Google Sheets on a scheduled basis for continuous music preference tracking.

How it works

  1. 1.Activate scheduled triggers to run the automation at regular intervals
  2. 2.Fetch current and recent listening data from your Spotify account
  3. 3.Send the data to Anthropic's language model for pattern and preference analysis
  4. 4.Filter and structure results using the output parser to ensure consistency
  5. 5.Merge processed data and write the final insights to your Google Sheets for persistent storage

Use cases

  • Track listening habits and automatically analyze music preference patterns over time
  • Generate periodic reports on Spotify activity and listening statistics
  • Create a historical record of music taste evolution in an organized spreadsheet format

Requirements

  • Active Spotify account with proper access permissions for playback data
  • Pre-configured Google Sheets with appropriate columns for incoming data
  • Valid Anthropic API key to access the language model for analysis

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 201
Downloads 136

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