HumationHuman + Automation
Back to Catalog

Repurpose YouTube videos to multiple content types with OpenRouter AI and Airtable

Alexandra SpalatoAlexandra Spalato
876 views
2/3/2026
MarkdownHTMLConverterText TransformationAPI Integration
Official Page

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](Scrape Creator 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:

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

OpenAI Setup:

  1. Create an OpenRouter account and generate an API key

Workflow Configuration

  1. Import the workflow JSON into your n8n instance
  2. Update all credential references with your API keys
  3. Configure the Airtable nodes with your base and table IDs
  4. 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

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

This n8n workflow automates the process of transforming YouTube video transcripts into various content formats using OpenRouter AI and managing the content in Airtable. It's designed to help content creators efficiently repurpose their video content into blog posts, social media updates, and more.

What it does

This workflow streamlines your content repurposing efforts through the following steps:

  1. Triggers on Airtable Record Creation: It listens for new records created in a specified Airtable base and table. Each record is expected to contain a YouTube video URL and a desired content type for repurposing.
  2. Extracts YouTube Transcript: It uses a custom Code node to fetch the transcript of the provided YouTube video URL.
  3. Filters for Transcript Availability: It checks if a transcript was successfully retrieved. If no transcript is found, the item is filtered out.
  4. Generates Content with OpenRouter AI: For records with a valid transcript, it sends the transcript and the desired content type to OpenRouter AI (via a LangChain Basic LLM Chain and OpenRouter Chat Model) to generate the repurposed content.
  5. Parses AI Output: It uses a Structured Output Parser to extract the generated content from the AI's response.
  6. Updates Airtable: Finally, it updates the original Airtable record with the newly generated content.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • Airtable Account: An Airtable account with a base and table configured to store YouTube video URLs and content types. You'll need an API key for Airtable.
  • OpenRouter AI Account: An OpenRouter AI account with an API key for accessing their language models.
  • YouTube Video URLs: The Airtable records should contain valid YouTube video URLs.

Setup/Usage

  1. Import the workflow: Import the provided JSON into your n8n instance.
  2. Configure Airtable Trigger:
    • Select your Airtable credential or create a new one.
    • Specify the "Base ID" and "Table Name" where your YouTube video information will be stored.
    • Ensure the trigger is active.
  3. Configure OpenRouter AI:
    • In the "OpenRouter Chat Model" node, select your OpenRouter AI credential or create a new one. This typically involves providing your OpenRouter API Key.
    • Review the prompt in the "Basic LLM Chain" node to ensure it aligns with your content generation needs. Adjust the content_type and youtube_transcript variables as needed to match your Airtable column names.
  4. Configure Airtable Update:
    • In the final "Airtable" node, select the same Airtable credential.
    • Specify the "Base ID" and "Table Name".
    • Map the Record ID from the trigger to the "Record ID" field in the update node.
    • Map the output from the "Structured Output Parser" (e.g., {{ $json.text }}) to the appropriate field in your Airtable table where you want to store the generated content.
  5. Activate the workflow: Once configured, activate the workflow.

Now, whenever a new record is added to your specified Airtable table with a YouTube URL and a content type, the workflow will automatically fetch the transcript, generate the desired content using OpenRouter AI, and update the Airtable record.

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

Daily cash flow reports with Google Sheets, Slack & Email for finance teams

Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. 💸📧 Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
619

Automate loan document analysis with Mistral OCR and GPT for underwriting decisions

LOB Underwriting with AI This template ingests borrower documents from OneDrive, extracts text with OCR, classifies each file (ID, paystub, bank statement, utilities, tax forms, etc.), aggregates everything per borrower, and asks an LLM to produce a clear underwriting summary and decision (plus next steps). Good to know AI and OCR usage consume credits (OpenAI + your OCR provider). Folder lookups by name can be ambiguous—use a fixed folderId in production. Scanned image quality drives OCR accuracy; bad scans yield weak text. This flow handles PII—mask sensitive data in logs and control access. Start small: batch size and pagination keep costs/memory sane. How it works Import & locate docs: Manual trigger kicks off a OneDrive folder search (e.g., “LOBs”) and lists files inside. Per-file loop: Download each file → run OCR → classify the document type using filename + extracted text. Aggregate: Combine per-file results into a borrower payload (make BorrowerName dynamic). LLM analysis: Feed the payload to an AI Agent (OpenAI model) to extract underwriting-relevant facts and produce a decision + next steps. Output: Return a human-readable summary (and optionally structured JSON for systems). How to use Start with the Manual Trigger to validate end-to-end on a tiny test folder. Once stable, swap in a Schedule/Cron or Webhook trigger. Review the generated underwriting summary; handle only flagged exceptions (unknown/unreadable docs, low confidence). Setup steps Connect accounts Add credentials for OneDrive, OCR, and OpenAI. Configure inputs In Search a folder, point to your borrower docs (prefer folderId; otherwise tighten the name query). In Get items in a folder, enable pagination if the folder is large. In Split in Batches, set a conservative batch size to control costs. Wire the file path Download a file must receive the current file’s id from the folder listing. Make sure the OCR node receives binary input (PDFs/images). Classification Update keyword rules to match your region/lenders/utilities/tax forms. Keep a fallback Unknown class and log it for review. Combine Replace the hard-coded BorrowerName with: a Set node field, a form input, or parsing from folder/file naming conventions. AI Agent Set your OpenAI model/credentials. Ask the model to output JSON first (structured fields) and Markdown second (readable summary). Keep temperature low for consistent, audit-friendly results. Optional outputs Persist JSON/Markdown to Notion/Docs/DB or write to storage. Customize if needed Doc types: add/remove categories and keywords without touching core logic. Error handling: add IF paths for empty folders, failed downloads, empty OCR, or Unknown class; retry transient API errors. Privacy: redact IDs/account numbers in logs; restrict execution visibility. Scale: add MIME/size filters, duplicate detection, and multi-borrower folder patterns (parent → subfolders).

Vinay GangidiBy Vinay Gangidi
471