Turn YouTube videos into weekly email newsletters with WayinVideo and GPT-4o-mini

Description Add your YouTube video URLs to a Google Sheet once and every Monday at 7AM the workflow automatically converts each pending video into a complete newsletter draft. WayinVideo summarizes each video and extracts numbered highlights and tags, then GPT-4o-mini reads the summary and writes a full newsletter issue — subject line, preview text, hook intro, three H2 content sections, a featured quote, CTA button text, and hashtags — all assembled into a Markdown-formatted newsletter body with a week-number issue label. The draft is saved to a Newsletter Drafts tab and the video row is marked Processed in the Video Queue. Built for content creators, media brands, newsletter writers, and marketing teams who publish YouTube videos and want a ready-to-send newsletter draft waiting for them every Monday morning without writing anything manually. --- What This Workflow Does - Runs every Monday at 7AM and stops cleanly if the queue is empty — An early check detects whether any videos are pending and exits gracefully if there are none — no errors on empty weeks - Summarizes each video automatically — WayinVideo extracts a structured summary, numbered highlights, and tags from each YouTube video so GPT has real content to base the newsletter on - Assigns a week-number issue label to every draft — The issue number is calculated from the current week of the year (e.g. Issue 18 — 2025) so your newsletter archive stays organized automatically - Writes a 12-section newsletter in one GPT call — Subject line, preview text, intro hook, three H2 sections with bodies, featured quote, CTA text, and hashtags are all produced together in a single request - Assembles a complete Markdown newsletter body — All sections are combined into one formatted body with H2 headings and a blockquote for the featured quote — ready to paste into any email platform - Saves 14 fields to the Newsletter Drafts tab — Subject line, preview text, full newsletter body, featured quote, CTA text and link, hashtags, word count, and generation timestamp are all saved per draft - Marks each video as Processed in the Video Queue — After saving the draft, the sheet row is updated so the same video is never processed again on a future Monday run --- Setup Requirements Tools Needed - n8n instance (self-hosted or cloud) - WayinVideo account with API access - OpenAI account with GPT-4o-mini API access - Google Sheets (one spreadsheet with two tabs: Video Queue and Newsletter Drafts) Credentials Required - WayinVideo API key (pasted into 4. WayinVideo — Submit Summarization and 6. WayinVideo — Get Summary Results) - OpenAI API key - Google Sheets OAuth2 (used in 2. Google Sheets — Read Pending Videos, 13. Google Sheets — Save Newsletter Draft, and 14. Google Sheets — Mark Video Processed) > ⚠️ WayinVideo API key appears in 2 steps — replace YOURWAYINVIDEOAPIKEY in both 4. WayinVideo — Submit Summarization and 6. WayinVideo — Get Summary Results. Missing either one will cause the workflow to fail. > ⚠️ Two separate Google Sheet IDs are used — replace YOURVIDEOQUEUESHEETID in 2. Google Sheets — Read Pending Videos and 14. Google Sheets — Mark Video Processed, and replace YOURNEWSLETTERSHEETID in 13. Google Sheets — Save Newsletter Draft. These can be the same spreadsheet or different ones — just make sure each uses the correct Sheet ID. Estimated Setup Time: 20–25 minutes --- Step-by-Step Setup 1. Import the workflow — Open n8n → Workflows → Import from JSON → paste the workflow JSON → click Import 2. Get your WayinVideo API key — Log in to your WayinVideo account → go to Account Settings → copy your API key 3. Add your WayinVideo API key to node 4 — Open node 4. WayinVideo — Submit Summarization → find the Authorization header value Bearer YOURWAYINVIDEOAPIKEY → replace YOURWAYINVIDEOAPIKEY with your actual key 4. Add your WayinVideo API key to node 6 — Open node 6. WayinVideo — Get Summary Results → find the same Authorization header → replace YOURWAYINVIDEOAPIKEY with the