{"product_id":"n8n-youtube-weekly-digest-apify-openai-gmail-email","title":"n8n YouTube Weekly Digest: Apify + OpenAI + Gmail Email","description":"\u003ch3\u003eTurn your YouTube watchlist into an AI-powered weekly digest—automatically\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003en8n YouTube Weekly Digest: Apify + OpenAI + Gmail Email\u003c\/strong\u003e workflow runs every Monday to pull new videos from your Google Sheets list, fetch available transcripts via \u003cstrong\u003eApify\u003c\/strong\u003e, generate structured summaries with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, log everything to Google Sheets, and email you a single HTML digest through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules a weekly run\u003c\/strong\u003e every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your YouTube sources\u003c\/strong\u003e (channel, playlist, or video URLs) from the \u003cem\u003eGoogle Sheets\u003c\/em\u003e tab named \u003cstrong\u003eChannels\u003c\/strong\u003e (using a \u003cstrong\u003eSource\u003c\/strong\u003e column).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Apify\u003c\/strong\u003e to expand sources, collect recent videos, and fetch transcripts—then \u003cem\u003epolls until the Apify run succeeds or fails\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters intelligently\u003c\/strong\u003e: skips videos without transcripts and removes videos already summarized in previous workflow runs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSummarizes with OpenAI\u003c\/strong\u003e to produce structured output per new video, including key takeaways, topic tags, and a “worth-watching” verdict.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs results to Google Sheets\u003c\/strong\u003e by appending video metadata and AI output to the \u003cstrong\u003eVideos\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends one combined HTML email\u003c\/strong\u003e to your recipient using Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContent monitoring\u003c\/strong\u003e: keep up with YouTube channels or playlists for your niche without manually checking transcripts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS and product research\u003c\/strong\u003e: weekly summaries of creator updates, features, or release discussions you track.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTeam knowledge sharing\u003c\/strong\u003e: email a digest of “new + worth-watching” videos with tags and key takeaways.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth-connected spreadsheet with \u003cstrong\u003eChannels\u003c\/strong\u003e and \u003cstrong\u003eVideos\u003c\/strong\u003e tabs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e: HTTP requests using \u003ccode\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/code\u003e to run an actor, then poll for completion.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: generates structured summaries (configurable via \u003ccode\u003esummaryModel\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: sends a single HTML digest email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e used include: if, set, code, no op, wait, gmail.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45876834468019,"sku":"N8N-18529","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/VvhAF0THMg2QXqafkcFy8_mZPkiij6.png?v=1787303058","url":"https:\/\/buyflowscripts.com\/products\/n8n-youtube-weekly-digest-apify-openai-gmail-email","provider":"N8N Commerce","version":"1.0","type":"link"}