{"product_id":"extract-youtube-transcripts-in-bulk-with-apify-google-sheets","title":"Extract YouTube Transcripts in Bulk with Apify \u0026 Google Sheets","description":"\u003ch3\u003eExtract YouTube Transcripts in Bulk and Log Them to Google Sheets (Apify + n8n)\u003c\/h3\u003e\n\u003cp\u003eStop copy-pasting transcripts one video at a time. This n8n workflow pulls YouTube video transcripts in bulk using the \u003cstrong\u003eApify YouTube Transcript Scraper\u003c\/strong\u003e, filters out videos without captions, and appends one clean row per video into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including metadata, transcript text, and run totals.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e when you trigger it in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your inputs\u003c\/strong\u003e: a comma-separated list of YouTube URLs plus caption preferences (language and whether to use \u003cem\u003ehuman\u003c\/em\u003e vs \u003cem\u003eauto-generated\u003c\/em\u003e captions).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests transcript results from Apify\u003c\/strong\u003e by using your \u003cstrong\u003eApify personal API token\u003c\/strong\u003e (HTTP Bearer Auth).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters out videos\u003c\/strong\u003e that don’t have an available transcript.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats each result into a consistent row\u003c\/strong\u003e with video metadata and the \u003cstrong\u003efull transcript text\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends rows to a selected Google Sheets tab\u003c\/strong\u003e and generates run totals such as \u003cstrong\u003etotal word count\u003c\/strong\u003e and \u003cstrong\u003eaverage duration\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a spreadsheet of transcripts for a content library, podcast repurposing, or SEO research.\u003c\/li\u003e\n  \u003cli\u003eStandardize caption language across many videos and quickly compare human vs auto-generated transcripts.\u003c\/li\u003e\n  \u003cli\u003eReview transcript quality and analyze volume metrics (e.g., word count and duration) across runs.\u003c\/li\u003e\n  \u003cli\u003eGive SaaS teams and automation engineers an easy “transcripts to data” pipeline without custom scraping code.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e: Apify YouTube Transcript Scraper via \u003cstrong\u003eHTTP Request\u003c\/strong\u003e with \u003cstrong\u003eBearer Auth\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth connection; writes to a chosen spreadsheet + sheet tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: set, filter, summarize, sticky note, http request, google sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Ensure your Google Sheet headers match the output fields (Title, Channel, Video URL, Duration (min), Views, Language, Auto-Generated, Word Count, Tags, Description, Transcript) and update the CONFIG values (video URLs and language) before running.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45872832905395,"sku":"N8N-18458","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/pBjO5YwnuskGtGGdLZWHt_nNl8hczj.png?v=1787217462","url":"https:\/\/buyflowscripts.com\/products\/extract-youtube-transcripts-in-bulk-with-apify-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}