n8n Workflow: Turn YouTube Captions into Notion Drafts

Turn YouTube Captions into Notion-Ready Marketing Drafts—Automatically

This n8n workflow pulls your latest YouTube video, downloads the official captions, and uses OpenAI to generate a Facebook post, email campaign draft, Skool announcement, and Udemy announcement—saving everything directly into a Notion database for review.

What this workflow does

• Runs on a schedule or on demand—configured to run Tuesdays and Fridays at 15:00 via cron, or manually.
• Finds your most recent YouTube video using the YouTube Data API with your authenticated channel credentials.
• Checks for caption tracks and stops if no captions are available.
• Downloads the first available caption track as an SRT file and converts it into clean plain text.
• Generates platform-specific drafts with OpenAI by sending the cleaned transcript and the video link to the OpenAI step.
• Saves results to Notion by creating a new page in your Notion database, storing the video title plus the four generated content drafts in dedicated properties: Video Name, Facebook Post, Email Campaign, Skool Announcement, and Udemy Announcement.

Use cases

• Convert every new YouTube upload into consistent social and course marketing drafts without starting from scratch.
• Maintain a content review pipeline in Notion: capture drafts, approve them, then publish wherever you sell or engage.
• SaaS operators and automation engineers: automate transcript-to-marketing workflows for recurring campaigns.

Technical details

• YouTube Data API via HTTP requests (Google OAuth2 credential with captions access).
• OpenAI for marketing copy generation (replace [YOUR NAME] in prompts to match your signature/voice).
• Notion integration to create database pages (update the Notion database ID and required property names).
• Workflow uses n8n nodes including if, code, no op, http request, notion, and sticky note.