Track Spotify podcast performance in Google Sheets with weekly AI email insights

Description

Quick overview
This workflow manually pulls episode lists and performance metrics from Spotify for Creators (Anchor API) and appends one analytics row per episode to a Google Sheets worksheet.

How it works
Starts when you run the workflow manually.
Calls the Spotify for Creators (Anchor) API to look up your podcast’s Spotify show URI and extracts the show ID.
Fetches the full episode list for the podcast and splits the response so each episode is processed individually.
For each episode, requests performance metrics from the Spotify for Creators (Anchor) API and combines them with episode metadata (title, publish date, duration).
Waits briefly between episodes to reduce the chance of rate-limiting.
Appends a row to Google Sheets for each episode with plays, streams/downloads, unique listeners, consumption hours, median consumption, audience retention, and episode ID.

Setup
Create a Google Sheets credential in n8n and set the target spreadsheet ID and sheet name (for example, a tab named "Episode Analytics").
In Spotify for Creators, capture your podcast ID and the Authorization bearer token from your browser session and paste them into the workflow’s configuration values.
Verify the Spotify for Creators (Anchor) API base URL is correct for your account and update it if needed before running the workflow.