{"product_id":"apify-youtube-transcript-timestamps-in-google-sheets-n8n","title":"Apify YouTube Transcript Timestamps in Google Sheets (n8n)","description":"\u003ch3\u003eTurn YouTube transcripts into timestamped, searchable Google Sheets\u003c\/h3\u003e\n\u003cp\u003eStop manually scrubbing videos for key moments. This n8n workflow uses Apify to pull YouTube transcripts, finds the exact lines matching your search terms, and appends one row per mention to Google Sheets—each with a link that jumps straight to the relevant second.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule:\u003c\/strong\u003e It’s triggered every Monday morning using a scheduled trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls transcript data from Apify:\u003c\/strong\u003e You define YouTube video URLs, search terms, and transcript language. The workflow uses the \u003cstrong\u003eApify YouTubeTranscripts actor (johnvc~YoutubeTranscripts)\u003c\/strong\u003e to fetch timestamped transcripts and video metadata for all provided URLs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrops videos without transcripts:\u003c\/strong\u003e Any video where a transcript isn’t available is excluded.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches your keywords:\u003c\/strong\u003e The transcript is split into individual timestamped lines. Each line is checked for \u003cem\u003ecase-insensitive\u003c\/em\u003e matches against your search terms.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates “jump to moment” links:\u003c\/strong\u003e For each matching line, the workflow generates a YouTube link pointing to that line’s start time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSorts and appends results:\u003c\/strong\u003e Matches are kept only when at least one term matches, sorted by video and timestamp, and appended to your selected Google Sheets worksheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack when competitors, product names, or keywords are mentioned across weekly YouTube uploads.\u003c\/li\u003e\n  \u003cli\u003eMonitor podcast-style channels for specific topics and log the exact timestamps for quick review.\u003c\/li\u003e\n  \u003cli\u003eCreate an ongoing “mentions tracker” in Google Sheets for SaaS operators and content teams.\u003c\/li\u003e\n  \u003cli\u003eOptional: forward each mention via \u003cstrong\u003eSlack\u003c\/strong\u003e by wiring in a Slack step and posting to a chosen channel.\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 Requires an Apify account and your Apify API token in n8n; runs the \u003cstrong\u003ejohnvc~YoutubeTranscripts\u003c\/strong\u003e actor.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Uses your provided credentials to append rows to a target spreadsheet and worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esort\u003c\/strong\u003e, \u003cstrong\u003elimit\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, and optional \u003cstrong\u003eslack\u003c\/strong\u003e integration.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830424494259,"sku":"N8N-18220","price":27.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fsZEuLweEOpfoxvHglT9R_uh18Lwox.png?v=1786698800","url":"https:\/\/buyflowscripts.com\/products\/apify-youtube-transcript-timestamps-in-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}