OpenAI and YouTube integration

👥 Who Is This For? Content creators, marketing teams, and channel managers who need to streamline video publishing with optimized metadata and scheduled releases across multiple videos. 🛠 What Problem Does This Solve? Manual YouTube video publishing is time-consuming and often results in inconsistent descriptions, tags, and scheduling. This workflow fully automates: Extracting video transcripts via Apify for metadata generation Creating SEO-optimized descriptions and tags for each video Setting videos to private during initial upload (critical for scheduling) Implementing scheduled publishing at strategic times Maintaining consistent branding and formatting across all content 🔄 Node-by-Node Breakdown | Step | Node Purpose | |------|--------------| | 1 | Every Day (Scheduler) | Trigger workflow on a regular schedule | | 2 | Get Videos to Harmonize | Retrieve videos requiring metadata enhancement | | 3 | Get Video IDs (Unpublished) | Filter for videos that need publishing | | 4 | Loop over Video IDs | Process each video individually | | 5 | Get Video Data | Retrieve metadata for the current video | | 6 | Loop over Videos with Parameter IS | Set parameters for processing | | 7 | Set Videos to Private | Ensure videos are private (required for scheduling) | | 8 | Apify: Get Transcript | Extract video transcript via Apify | | 9 | Fetch Latest Videos | Get most recent channel content | | 10 | Loop Over Items | Process each video item | | 11 | Generate Description, Tags, etc. | Create optimized metadata from transcript | | 12 | AP Clean ID | Format identifiers | | 13 | Retrieve Generated Data | Collect the enhanced metadata | | 14 | Adjust Transcript Format | Format transcript for better processing | | 15 | Update Video's Metadata | Apply generated description and tags to video | ⚙️ Pre-conditions / Requirements n8n with YouTube API credentials configured Apify account with API access for transcript extraction YouTube channel with upload permissions Master templates for description formatting Videos must be initially set to private for scheduling to work ⚙️ Setup Instructions Import this workflow into your n8n instance. Configure YouTube API credentials with proper channel access. Set up Apify integration with appropriate actor for transcript extraction. Define scheduling parameters in the Every Day node. Configure description templates with placeholders for dynamic content. Set default tags and customize tag generation rules. Test with a single video before batch processing. 🎨 How to Customize Adjust prompt templates for description generation to match your brand voice. Modify tag selection algorithms based on your channel's SEO strategy. Create multiple publishing schedules for different content categories. Integrate with analytics tools to optimize publishing times. Add notification nodes to alert when videos are successfully scheduled. ⚠️ Important Notes Videos MUST be uploaded as private initially - the Publish At logic only works for private videos that haven't been published before. Publishing schedules require videos to remain private until their scheduled time. Transcript quality affects metadata generation results. Consider YouTube API quotas when scheduling large batches of videos. 🔐 Security and Privacy API credentials are stored securely within n8n. Transcripts are processed temporarily and not stored permanently. Webhook URLs should be protected to prevent unauthorized triggering. Access to the workflow should be limited to authorized team members only.

👥 Who Is This For? Content creators, marketing teams, and channel managers who want a simple, hands‑off solution to upload videos and automatically generate optimized metadata from video transcripts. 🛠 What Problem Does This Solve? Manual video uploads with proper metadata creation is time‑consuming and repetitive. This workflow fully automates: Monitoring a specific Google Drive folder for new video uploads Seamless YouTube upload processing Transcript extraction for context understanding AI‑powered generation of titles, descriptions, and tags Metadata application to uploaded videos without manual intervention 🔄 Node‑by‑Node Breakdown | Step | Node Purpose | |------|---------------------------------------------------------------------| | 1 | New Video? (Trigger) – Monitors specified Google Drive folder | | 2 | Download New Video – Retrieves the video file from Google Drive | | 3 | Upload to YouTube – Uploads the video to YouTube with initial settings | | 4 | Get Transcript – Extracts transcript from the uploaded video | | 5 | Adjust Transcript Format – Formats raw transcript for processing | | 6 | Create Description – Generates SEO‑optimized description | | 7 | YT Tags (Message Model) – Creates relevant tags based on content | | 8 | YT Title (Message Model) – Generates compelling title | | 9 | Define File Path Upload Format (Optional) – Structures data paths | | 10 | Update Video’s Metadata – Applies generated title, description, tags| ⚙️ Pre‑conditions / Requirements n8n with Google Drive and YouTube API credentials configured (stored as n8n credentials/variables; no hard‑coded IDs) Dedicated Google Drive folder for video uploads YouTube channel with proper upload permissions AI service access for transcript processing and metadata generation Sufficient storage for temporary video handling ⚙️ Setup Instructions Import this workflow into your n8n instance. Configure Google Drive credentials; reference folder ID via n8n variable (do not hard‑code). Set up YouTube API credentials with upload and edit permissions. Specify the target Google Drive folder ID in the New Video? trigger node (via variable). Configure AI service credentials for transcript and metadata generation. Adjust message templates for title, description, and tag creation. Test with a small video file before production use. 🎨 How to Customize Modify AI prompts to match your channel’s tone and style. Add conditional logic based on video categories or naming conventions. Implement notification systems to alert when uploads complete. Create custom metadata templates for different content types. Include timestamps or chapter markers based on transcript analysis. Add social media sharing nodes to announce new uploads. ⚠️ Important Notes Video quality is preserved through the upload process. Consider YouTube API quotas when handling multiple uploads. Transcript quality affects metadata generation results. Videos are initially uploaded without visibility adjustments. Processing time depends on video length and transcript complexity. 🔐 Security and Privacy Store API credentials and folder IDs as n8n Credentials/Variables—remove any hard‑coded tokens or IDs. Video files are processed temporarily and not stored permanently. Limit Google Drive folder access to authorized users only. Manage YouTube upload permissions carefully (use OAuth/service accounts). Ensure compliance with organizational data‑handling policies.

📊 Description Automate your YouTube research workflow by extracting audio from any video, transcribing it with Whisper AI, and generating structured GEO (Goal–Execution–Outcome) summaries using GPT-4o-mini. 🎥🤖 This template transforms unstructured video content into actionable, searchable insights that are automatically stored in Notion with rich metadata. It’s ideal for creators, educators, analysts, and knowledge workers who want to convert long videos into concise, high-quality summaries without manual effort. Perfect for content indexing, research automation, and knowledge-base enrichment. 📚✨ 🔁 What This Template Does • Triggers on a schedule to continuously process new YouTube videos. ⏰ • Fetches video metadata (title, description, thumbnails, published date) via the YouTube API. 🎥 • Downloads audio using RapidAPI and prepares it for transcription. 🎧 • Transcribes audio into text using OpenAI Whisper. 📝 • Skips invalid entries when no transcript is generated. 🚫 • Merges the transcript with metadata for richer AI context. 🔗 • Uses GPT-4o-mini to generate Goal, Execution, Outcome, and Keywords via structured JSON. 🤖📊 • Parses the AI-generated JSON into Notion-friendly formats. 🔍 • Creates a Notion page with GEO sections, keywords, and video metadata. 📄🏷️ • Produces a fully searchable knowledge record for every processed video. 📚✨ ⭐ Key Benefits ✅ Converts long YouTube videos into concise, structured knowledge ✅ AI-powered GEO summaries improve comprehension and recall ✅ Zero manual transcription or note-taking — 100% automated ✅ Seamless Notion integration creates a powerful video knowledge base ✅ Works on autopilot with scheduled triggers ✅ Saves hours for educators, researchers, analysts, and content teams 🧩 Features YouTube API integration for metadata retrieval RapidAPI audio downloader OpenAI Whisper transcription GPT-4o-mini structured analysis through LangChain Memory buffer + structured JSON parser for consistent results Automatic Notion page creation Fail-safe transcript validation (IF node) Metadata + transcript merging for richer AI context GEO (Goal–Execution–Outcome) summarization workflow 🔐 Requirements YouTube OAuth2 credentials OpenAI API key (Whisper + GPT-4o-mini) Notion API integration token + database ID RapidAPI key for YouTube audio downloading n8n with LangChain nodes enabled 🎯 Target Audience YouTubers and content creators archiving their content Researchers and educators summarizing long videos Knowledge managers building searchable Notion databases Automation teams creating video intelligence workflows 🛠️ Step-by-Step Setup Instructions Add YouTube OAuth2, OpenAI, Notion, and RapidAPI credentials. 🔑 Replace the placeholder RapidAPI key in the “Get YouTube Audio” node. ⚙️ Update the Notion database ID where summaries should be stored. 📄 Configure the Schedule Trigger interval based on your needs. ⏰ Replace the hardcoded video ID (if present) with dynamic input or playlist logic. 🔗 Test with a sample video to verify transcription + AI + Notion output. ▶️ Enable the workflow to run automatically. 🚀

WATCH THE n8n STARTER GUIDE 👇 This template is featured in the n8n Starter Guide series. The template is free, but comes with two additional PDFs and a Quick Start video if you grab the full download pack on gumroad. How it works This template is a visual map of many useful n8n nodes. It groups nodes like Triggers, AI tools, and App connectors onto the canvas. Explore the sections to learn about different nodes and easily copy them for your own workflows. It acts as a handy visual reference guide. Set up steps • Setup takes about 5 minutes. • Import the template into your n8n instance. • Explore the node categories visually on the canvas. • A Quick Start video is included in the download pack, along with a prompts PDF and PDF with links to other awesome n8n templates here on the n8n template gallery.

Hacker News to Video Content Overview This workflow converts trending articles from Hacker News into engaging video content. It integrates AI-based tools to analyze, summarize, and generate multimedia content, making it ideal for content creators, educators, and marketers. Features Article Retrieval: Pulls trending articles from Hacker News. Limits the number of articles to process (configurable). Content Analysis: Uses OpenAI's GPT model to: Summarize articles. Assess their relevance to specific topics like automation or AI. Extract key image URLs. Image and Video Generation: Leonardo.ai: Creates stunning AI-generated images based on extracted prompts. RunwayML: Converts images into high-quality videos. Structured Content Creation: Parses content into structured formats for easy reuse. Generates newsletter-friendly blurbs and social media-ready captions. Cloud Integration: Uploads generated assets to: Dropbox Google Drive Microsoft OneDrive MinIO Social Media Posting (Optional): Supports posting to YouTube, X (Twitter), LinkedIn, and Instagram. Workflow Steps Trigger Initiated manually via the "Test Workflow" button. Fetch Articles Retrieves articles from Hacker News. Limits the results to avoid processing overload. Content Filtering Evaluates if articles are related to AI/Automation using OpenAI's language model. Image and Video Generation Generates: AI-driven image prompts via Leonardo.ai. Videos using RunwayML. Asset Management Saves the output to cloud storage services or uploads directly to social media platforms. Prerequisites API Keys**: Hacker News OpenAI Leonardo.ai RunwayML Creatomate n8n Installation**: Ensure n8n is installed and configured locally or on a server. Credentials**: Set up credentials in n8n for all external services used in the workflow. Customization Replace Hacker News with any other data source node if needed. Configure the "Article Analysis" node for different topics. Adjust the cloud storage services or add custom storage options. Usage Import this workflow into your n8n instance. Configure your API credentials. Trigger the workflow manually or schedule it as needed. Check the outputs in your preferred cloud storage or social media platform. Notes Extend this workflow further by automating social media posting or newsletter integration. For any questions, refer to the official documentation or reach out to the creator. About the Creator This workflow was built by AlexK1919, an AI-native workflow automation architect. Check out the overview video for a quick demo. Tools Used Leonardo.ai** RunwayML** Creatomate** Hacker News API** OpenAI GPT** Feel free to adapt and extend this workflow to meet your specific needs! 🎉

POV Video Creator: Automating TikTok-Style Instagram Video Automation, Approval, and Multi-Platform Posting Using AI, ElevenLabs, Google Sheets, and Social Media APIs Description What Problem Does This Solve? 🎥 This workflow automates the creation, rendering, approval, and posting of TikTok-style POV (Point of View) videos to Instagram, with cross-posting to Facebook and YouTube. It eliminates manual video production, approval delays, and inconsistent posting schedules. It ensures high-quality content creation and distribution for social media managers and content creators Target audience: Social media managers, content creators, small to medium-sized businesses, and n8n users familiar with AI tools, Google Sheets, and social media APIs What Does It Do? 🌟 Generates daily POV video ideas using OpenAI Creates images, videos, and audio with PIAPI.ai and ElevenLabs Renders final videos with Creatomate Manages approvals via email and Google Sheets Posts approved videos to Instagram, Facebook, and YouTube Tracks progress in a Google Sheet for transparency Key Features AI-driven idea generation and script creation Automated media production with image, video, and audio synthesis Email-based approval system for quality control Cross-platform posting to Instagram, Facebook, and YouTube Real-time tracking in Google Sheets and Google Drive Error handling for rendering and posting failures Setup Instructions Prerequisites n8n Instance**: Self-hosted or cloud n8n instance API Credentials**: OpenAI API: API key for idea generation, stored in n8n credentials PIAPI.ai API: API key for image and video generation, stored in n8n credentials ElevenLabs API: API key for audio generation, stored in n8n credentials Creatomate API: API key for video rendering, stored in n8n credentials Google Sheets/Drive API: OAuth2 credentials from Google Cloud Console with Sheets and Drive scopes Gmail API: OAuth2 credentials from Google Cloud Console with Gmail scope Instagram Graph API: User Access Token with instagram_content_publish permission from a Facebook App Facebook Graph API: Access Token from the same Facebook App YouTube API: OAuth2 credentials for YouTube uploads Google Sheet**: A sheet named "POV Videos" with a tab "Instagram" and columns: Timestamp, ID, Subject, Topic, Caption, POV_Status, Prompt, Publish_Status, Link, Final Video, Approval, row_number Creatomate Template**: A pre-configured template with video, audio, and text elements Installation Steps Import the Workflow: Copy the workflow JSON from the “Template Code” section (to be provided) Import it into n8n via “Import from File” or “Import from URL” Configure Credentials: Add API credentials in n8n’s Credentials section for OpenAI, PIAPI.ai, ElevenLabs, Creatomate, Google Sheets/Drive, Gmail, Instagram Graph, Facebook Graph, and YouTube Assign credentials to respective nodes. For example: In "Text-to-Image", use PIAPI.ai credentials: {{ $credentials.PIAPI }} In "Render with Creatomate", use Creatomate credentials: {{ $credentials.Creatomate }} In "Send Approval Request", use Gmail credentials Set Up Nodes: Schedule Trigger: Configure to run daily Approval Email (Send Approval Request): Customize the HTML email template with approval/rejection links Post to Social Media Nodes (Instagram Container, Facebook Posts, Post YouTube): Configure with your Instagram Business Account ID, Facebook Page ID, and YouTube channel details Configure Google Sheet and Drive: Create "POV Videos" Google Sheet with "Instagram" tab and specified columns Share the sheet with your Google Sheets credential email Create "Audio" and "Video" folders in Google Drive, noting their IDs Test the Workflow: Run manually to verify idea generation, media creation, and posting Check email notifications, Google Sheet updates, and social media posts Schedule the Workflow: Enable "Schedule Trigger" and "Schedule Trigger1" for daily runs Enable "Get Latest Approved Video" to poll at 7 PM daily How It Works High-Level Steps Generate Video Ideas: Creates daily POV video concepts with OpenAI Create Media: Produces images, videos, and audio using AI tools Render Video: Combines media into a final video with Creatomate Manage Approvals: Sends approval emails and processes decisions Post to Platforms: Publishes approved videos to Instagram, Facebook, and YouTube Detailed Descriptions Detailed node descriptions are available in the sticky notes within the workflow (to be provided). Below is a summary of key actions Node Names and Actions Video Idea Generation and Script Creation Schedule Trigger**: Initiates daily workflow Get Title**: Fetches pending video ideas from Google Sheet Generate Topics**: Uses OpenAI to create a new video idea Format Row**: Structures the idea into a Google Sheet row Insert new Prompt, Caption and Title/Topic**: Adds the idea to Google Sheet Generate Ideas**: Produces 3 POV sequences Generate Script**: Expands a sequence into a detailed script Set Topics**: Stores the script for media creation Media Creation Text-to-Image**: Generates an image with PIAPI.ai Get Image**: Retrieves the generated image Generate Video Prompt**: Creates a video prompt from the image Generate Video**: Produces a 5-second video with PIAPI.ai Access Videos**: Retrieves the video URL Store Video**: Updates Google Sheet with video URL Generate Sound Prompt**: Creates an audio prompt Text-to-Sound**: Generates a 20-second audio clip with ElevenLabs Store Sound**: Uploads audio to Google Drive Allow Access**: Sets audio file permissions Video Rendering Merge**: Combines script, video, and audio data List Elements**: Formats data for Creatomate Render with Creatomate**: Renders the final video Check Video Status**: Routes based on render success/failure Storage and Notification Google Drive**: Uploads the rendered video New Render Video Alert**: Sends success email Failed Render**: Sends failure email Render Video Link**: Updates Google Sheet with final video URL Approval Process Approval Email**: Sends approval request email Handle Approval/Rejection1**: Processes approval/rejection via webhook Video Update1**: Updates Google Sheet with approval status Social Media Posting Get Latest Approved Video**: Polls for approved videos Check Approval**: Routes based on approval status Instagram Container**: Creates Instagram media container Post to Instagram**: Publishes to Instagram Facebook Posts**: Posts to Facebook Download Video**: Downloads video for YouTube Post YouTube**: Uploads to YouTube Mark Rejected**: Updates status for rejected videos Update Google Sheet**: Updates publish status Customization Tips Expand Platforms**: Add nodes to post to other platforms Modify Approval Email**: Update the Send Approval Request node to customize the HTML template Alternative Notifications**: Add nodes for Slack or Telegram alerts Adjust Video Duration**: Modify Generate Video node to change duration (default: 5 seconds)