Repurpose YouTube Videos to Multiple Content Types with OpenRouter AI and Airtable

Description

YouTube Content Repurposing Automation

Who's it for

This workflow is for content creators, marketers, agencies, coaches, and businesses who want to maximize their YouTube content ROI by automatically generating multiple content assets from single videos. It's especially useful for professionals who want to:

Repurpose YouTube videos into blogs, social posts, newsletters, and tutorials without manual effort
Scale their content production across multiple channels and platforms
Create consistent, high-quality content derivatives while saving time and resources
Build automated content systems that generate multiple revenue streams
Maintain active presence across social media, email, and blog platforms simultaneously

What problem is this workflow solving

Content creators face significant challenges when trying to maximize their video content:

Time-intensive manual repurposing: Converting one YouTube video into multiple content formats traditionally requires hours of manual writing, editing, and formatting across different platforms.

Inconsistent content quality: Manual repurposing often leads to varying quality levels and missed opportunities to optimize content for specific platforms.

High costs for content services: Hiring ghostwriters or content agencies to repurpose videos can cost thousands of dollars monthly.

Scaling bottlenecks: Manual processes prevent creators from efficiently scaling their content across multiple channels and formats.

This workflow solves these problems by automatically extracting YouTube video transcripts, using AI to generate multiple high-quality content formats (tutorials, blog posts, social media content, newsletters), and organizing everything in Airtable for easy management and distribution.

How it works

Automated Video Processing
Starts with a manual trigger and retrieves YouTube URLs from your Airtable configuration, processing only videos marked as "selected" while filtering out those marked for deletion.

Intelligent Transcript Extraction
Uses Scrape Creator API to extract video transcripts, automatically cleaning and formatting the text for optimal AI processing and content generation.

Multi-Format Content Generation
Leverages OpenRouter models, o you can easily test different AI models and choose the one that delivers the best results for your needs:
Step-by-step tutorials with code snippets and technical details
YouTube scripts with hooks, titles, and conclusions
Blog posts optimized for lead generation
Structured summaries with key takeaways
LinkedIn posts with engagement triggers
Newsletter content for email marketing
Twitter/X posts for social media

Smart Content Filtering
Processes only the content types you've selected in Airtable, ensuring efficient resource usage and faster execution times.

Automated Content Organization
Matches and combines all generated content pieces by URL, then updates your Airtable with complete, ready-to-use content assets organized by type and source video.

How to set up

Required credentials

OpenRouter API key**
Airtable Personal Access Token**
Scrape Creators API Key** - For YouTube transcript extraction and processing

Airtable base setup

Create an Airtable base with one main table:

Videos Table:
title** (Single line text): Video title for reference
url** (URL): YouTube video URL to process
Status** (Single select): Options: "selected", "delete", "processed"
output** (Multiple select): Content types to generate
summary
tutorial
blog-post
linkedin
newsletter
tweeter
youtube
summary** (Long text): Generated video summary
tutorial** (Long text): Generated step-by-step tutorial
key_take_aways** (Long text): Extracted key insights
blog_post** (Long text): Generated blog post content
linkedin** (Long text): LinkedIn post content
newsletter** (Long text): Email newsletter content
tweeter** (Long text): Twitter/X post content
youtube_titles** (Long text): YouTube video title suggestions
youtube_hook** (Long text): Video opening hooks
youtube_steps** (Long text): Video step breakdowns
youtube_conclusion** (Long text): Video ending/CTAs

API Configuration

Scrape Creator Setup:
Sign up for Scrape Creator API
Obtain your API key from the dashboard
Configure the HTTP Request node with your credentials
Set the endpoint to: https://api.scrapecreators.com/v1/youtube/video/transcript

OpenAI Setup:
Create an OpenRouter account and generate an API key

Workflow Configuration

Import the workflow JSON into your n8n instance
Update all credential references with your API keys
Configure the Airtable nodes with your base and table IDs
Test the workflow with a single video URL first

Requirements

n8n instance** (self-hosted or cloud)
Active API subscriptions** for OpenRouter (or the LLM or your choice), Airtable, and Scrape Creator
YouTube video URLs** - Must be publicly accessible videos with available transcripts
Airtable account** - Free tier sufficient for most use cases

How to customize the workflow

Modify content generation prompts

Edit the LLM Chain nodes to customize content style and format:
Tutorial node**: Adjust technical depth and formatting preferences
Blog post node**: Modify tone, length, and CTA strategies
LinkedIn node**: Customize engagement hooks and professional tone
Newsletter node**: Tailor subject lines and email marketing approach

Adjust AI model selection

Update the OpenRouter Chat Model to use different models

Add new content formats

Create additional LLM Chain nodes for new content types:
Instagram captions
TikTok scripts
Podcast descriptions
Course outlines