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](https://wayin.ai/api/) 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)