🎬 Repurpose YouTube videos into social posts and thumbnails with OpenAI

⚑ 17 views · 🎬 Content Creation & Video

πŸ’‘ Pro Tip β€” YouTube’s API quotas can be a bottleneck when you’re pulling data at scale. ScraperNode is a community node with dedicated scrapers for channels, videos, and comments β€” no quota limits, just structured data.

View All Scrapers

Description

Quick overview

This workflow accepts a YouTube URL via webhook, pulls video details and a transcript, uses OpenAI to generate repurposed text content and a thumbnail image, uploads the thumbnail to Google Drive, and stores everything (including the public thumbnail link) in a Notion database.

How it works

  1. Receives a POST webhook request containing a YouTube video URL.
  2. Extracts the video ID, then uses the YouTube API to fetch the video’s metadata and Apify to retrieve the video transcript.
  3. Cleans and normalizes the transcript text (for example, removing HTML entities and extra whitespace).
  4. Sends the cleaned transcript to OpenAI to generate a LinkedIn post, Twitter/X thread, blog draft, and YouTube description in a JSON format.
  5. Uses OpenAI to create a thumbnail image prompt from the video title and transcript, then generates a 1024Γ—1024 thumbnail image.
  6. Uploads the generated thumbnail to Google Drive, shares it publicly, and prepares the public URL.
  7. Saves the video title, video URL, transcript excerpt, AI-generated content, timestamp, and thumbnail URL as a new page in a Notion database.

Setup

  1. Create and connect credentials for YouTube, Apify, OpenAI, Google Drive, and Notion.
  2. Create a Notion database with properties matching the workflow fields (Video Title, Video URL, Transcript, LinkedIn Post, Twitter Thread, Blog, YouTube description, Thumbnail, Timestamp) and select its database ID in the Notion step.
  3. Choose the Google Drive folder to upload thumbnails to and ensure link sharing is allowed for your Drive.
  4. Activate the workflow and send a POST request to the webhook URL with a JSON body containing url set to the YouTube link.

Additional info

How To Customize Nodes

Customize AI Content Style

Modify OpenAI prompts to generate:

Customize Thumbnail Design

Update thumbnail prompt instructions:

Customize Notion Storage

You can add additional fields:

Customize Google Drive Storage

You may:

Add-Ons (Optional Enhancements)

You can extend this workflow to:

Use Case Examples

1. Content Repurposing

Convert one YouTube video into multiple content formats automatically.

2. Social Media Automation

Generate ready-to-post social content using AI.

3. AI Thumbnail Generation

Automatically create engaging thumbnail images.

4. Content Database Management

Store all AI-generated content inside Notion.

5. Marketing Workflow Automation

Reduce manual content creation workload.

Troubleshooting Guide

IssuePossible CauseSolution
Transcript not foundVideo has no subtitlesUse videos with captions enabled
OpenAI generation failedInvalid API keyReconnect OpenAI credentials
Thumbnail not uploadingGoogle Drive issueReconnect Drive account
Notion data not savingWrong database fieldsMatch field names correctly
Webhook not workingWorkflow inactiveActivate workflow
Empty AI responseTranscript too shortTest with longer videos

Need Help?

If you need help customizing or extending this workflow by adding auto-posting, advanced AI prompts, SEO automation, multi-platform publishing, analytics dashboards or production-level scaling, then our n8n team at WeblineIndia can help with building advanced workflow automation solutions.

πŸ”— Nodes Used

Webhook, Google Drive, YouTube, Notion, OpenAI

πŸ“₯ Import

Download workflow.json and import into n8n: Workflow menu β†’ Import from File

πŸ“– Importing guide Β· πŸ”‘ Credential setup