{"product_id":"save-youtube-captions-to-google-sheets-with-apify-n8n","title":"Save YouTube Captions to Google Sheets with Apify (n8n)","description":"\u003ch3\u003eSave YouTube captions directly to Google Sheets with Apify (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow fetches an existing YouTube video (or Shorts) caption track using Apify and appends one clean row per successful video to your Google Sheets—complete with the full caption text and useful metadata. If captions can’t be retrieved, the workflow routes failures to a separate branch so you don’t end up with blank transcript rows.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eManual start:\u003c\/strong\u003e You manually execute the workflow.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eReads inputs:\u003c\/strong\u003e It takes the \u003cem\u003eYouTube video URL\u003c\/em\u003e, your \u003cem\u003eGoogle Sheets spreadsheet URL\u003c\/em\u003e, and the \u003cem\u003eworksheet name\u003c\/em\u003e.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eFetch captions via Apify:\u003c\/strong\u003e The workflow runs Apify’s \u003cstrong\u003eYouTube Transcript Scraper\u003c\/strong\u003e in a “retrieve existing captions” mode (not audio transcription) and waits for the Apify run to finish.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eValidates results:\u003c\/strong\u003e It reads the same run’s Dataset (including saved status records from failed actor runs) to confirm whether a transcript was retrieved successfully.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eAppends one row per success:\u003c\/strong\u003e For each successful video, it writes the video ID, title, URL, channel, caption language, automatic-caption flag, full fetched text, and extraction time to Google Sheets.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eHandles missing\/blocked captions:\u003c\/strong\u003e Missing captions, unavailable languages, and blocked requests are sent to a separate status node instead of adding empty transcript entries.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cp\u003eBuild a searchable transcript library in Google Sheets for YouTube content you manage.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003eMaintain datasets for analytics (language, channel, captions availability, extraction time) using n8n + Apify.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003eAutomate caption harvesting workflows while keeping failures cleanly separated for later review.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eApify integration:\u003c\/strong\u003e Uses the verified n8n node \u003cstrong\u003e(@apify\/n8n-nodes-apify)\u003c\/strong\u003e to run the \u003cstrong\u003eYouTube Transcript Scraper\u003c\/strong\u003e.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Writes rows to the destination spreadsheet (requires permission to edit).\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e Uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and \u003cstrong\u003eno op\u003c\/strong\u003e, plus helper\/status handling.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eWorksheet requirement:\u003c\/strong\u003e Create a worksheet named \u003cstrong\u003eTranscripts\u003c\/strong\u003e with headers including: Video ID, Video title, Video U… (as specified in the setup).\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232401838259,"sku":"N8N-21059","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fOj8ioMcS-oLcoRMHEssj_sxGi5Dq4.png?v=1792141780","url":"https:\/\/buyflowscripts.com\/products\/save-youtube-captions-to-google-sheets-with-apify-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}