{"product_id":"export-spotify-podcast-analytics-to-google-sheets-n8n","title":"Export Spotify Podcast Analytics to Google Sheets (n8n)","description":"\u003ch3\u003eExport Spotify Podcast Analytics to Google Sheets—one row per episode\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls your podcast’s episode list and performance metrics from \u003cstrong\u003eSpotify for Creators (Anchor API)\u003c\/strong\u003e, then automatically appends a complete analytics row for \u003cstrong\u003eeach episode\u003c\/strong\u003e into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRuns when you manually trigger the workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003eUses the Spotify for Creators (Anchor API) to look up your podcast’s \u003cstrong\u003eSpotify show URI\u003c\/strong\u003e and extracts the \u003cstrong\u003eshow ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFetches the podcast’s full episode list, then splits the response so each episode is processed individually.\u003c\/li\u003e\n  \u003cli\u003eFor every episode, requests performance metrics from the Spotify for Creators (Anchor API) and combines them with episode metadata such as \u003cstrong\u003etitle\u003c\/strong\u003e, \u003cstrong\u003epublish date\u003c\/strong\u003e, and \u003cstrong\u003eduration\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIncludes a short wait between episodes to reduce the chance of rate-limiting.\u003c\/li\u003e\n  \u003cli\u003eAppends one row per episode to your selected Google Sheets worksheet, including metrics such as \u003cstrong\u003eplays\u003c\/strong\u003e, \u003cstrong\u003estreams\/downloads\u003c\/strong\u003e, \u003cstrong\u003eunique listeners\u003c\/strong\u003e, \u003cstrong\u003econsumption hours\u003c\/strong\u003e, \u003cstrong\u003emedian consumption\u003c\/strong\u003e, \u003cstrong\u003eaudience retention\u003c\/strong\u003e, and the \u003cstrong\u003eepisode ID\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePodcast operators who want episode-level performance tracking without exporting from Spotify manually.\u003c\/li\u003e\n  \u003cli\u003eSaaS and analytics teams building internal dashboards using Google Sheets as a lightweight reporting layer.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who need repeatable n8n data collection from Spotify for Creators for ongoing monitoring.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n trigger:\u003c\/strong\u003e Manual start\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI integration:\u003c\/strong\u003e Spotify for Creators (Anchor API) via \u003cstrong\u003eHTTP Request\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData handling:\u003c\/strong\u003e \u003cem\u003eSet\u003c\/em\u003e, \u003cem\u003eSplit Out\u003c\/em\u003e, and \u003cem\u003eWait\u003c\/em\u003e (rate-limit mitigation)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStorage:\u003c\/strong\u003e \u003cem\u003eGoogle Sheets\u003c\/em\u003e (append one analytics row per episode)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup inputs:\u003c\/strong\u003e Google Sheets credentials, spreadsheet ID, sheet name (e.g., “Episode Analytics”), Spotify for Creators podcast ID, and the Authorization bearer token\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional verification:\u003c\/strong\u003e Ensure the Spotify for Creators (Anchor) API base URL matches your account before running\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eBring your Spotify podcast analytics into Google Sheets with an n8n automation workflow built specifically for \u003cstrong\u003eepisode-by-episode reporting\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962130391219,"sku":"N8N-19192","price":43.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WFrhJ0UvFRb0imQOMCj4s_ZfVegYki.png?v=1788599985","url":"https:\/\/buyflowscripts.com\/products\/export-spotify-podcast-analytics-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}