Export Spotify Podcast Analytics to Google Sheets (n8n)

Export Spotify Podcast Analytics to Google Sheets—one row per episode

This n8n workflow pulls your podcast’s episode list and performance metrics from Spotify for Creators (Anchor API), then automatically appends a complete analytics row for each episode into Google Sheets.

What this workflow does

• Runs when you manually trigger the workflow in n8n.
• Uses the Spotify for Creators (Anchor API) to look up your podcast’s Spotify show URI and extracts the show ID.
• Fetches the podcast’s full episode list, then splits the response so each episode is processed individually.
• For every episode, requests performance metrics from the Spotify for Creators (Anchor API) and combines them with episode metadata such as title, publish date, and duration.
• Includes a short wait between episodes to reduce the chance of rate-limiting.
• Appends one row per episode to your selected Google Sheets worksheet, including metrics such as plays, streams/downloads, unique listeners, consumption hours, median consumption, audience retention, and the episode ID.

Use cases

• Podcast operators who want episode-level performance tracking without exporting from Spotify manually.
• SaaS and analytics teams building internal dashboards using Google Sheets as a lightweight reporting layer.
• Automation engineers who need repeatable n8n data collection from Spotify for Creators for ongoing monitoring.

Technical details

• n8n trigger: Manual start
• API integration: Spotify for Creators (Anchor API) via HTTP Request
• Data handling: Set, Split Out, and Wait (rate-limit mitigation)
• Storage: Google Sheets (append one analytics row per episode)
• Setup inputs: Google Sheets credentials, spreadsheet ID, sheet name (e.g., “Episode Analytics”), Spotify for Creators podcast ID, and the Authorization bearer token
• Optional verification: Ensure the Spotify for Creators (Anchor) API base URL matches your account before running

Bring your Spotify podcast analytics into Google Sheets with an n8n automation workflow built specifically for episode-by-episode reporting.