Airtable and YouTube integration

Auto-Generate Long Videos with AI, ElevenLabs,PIAPI,Shotstack/Creatomate & Post to Youtube Overview This n8n automation workflow automates the creation, scripting, production, and posting of YouTube videos. It leverages AI (OpenAI), image generation (PIAPI), video rendering (Shotstack), and platform integrations (Airtable, Google Sheets, YouTube) to streamline the process. Target Audience Content creators, video producers, and YouTubers** seeking to automate video content creation. Digital marketing teams** managing video campaigns for travel or history niches. Users familiar with n8n, Airtable, Google Sheets, YouTube, and API integrations**. Problem Solved Manually managing YouTube video production, from ideation to posting, is time-consuming and prone to errors. This workflow addresses: Content Sourcing**: Generates video ideas using AI based on "domain of choice". Content Formatting**: Automatically creates detailed scripts and scene structures. Visual Production**: Produces high-quality images and renders videos with minimal manual input. Multi-Platform Integration**: Publishes to YouTube with status tracking in Airtable and Google Sheets. Status Tracking**: Monitors progress (Generated, Scripted, Produced, Published) across platforms. Prerequisites Before setting up, ensure you have: An n8n instance (self-hosted or cloud) API credentials for: OpenAI (for idea generation) PIAPI.ai (for image and video generation) ElevenLabs (for audio generation) Shotstack (for video rendering) Creatomate (for video rendering) Airtable & Google Sheets and Drive (for storage and tracking) Gmail (for notifications) YouTube API (for posting to YouTube) How the Automation Works (Step by Step) Trigger (Schedule Trigger) Initiates the workflow daily Connects to "Generate Idea" Generate Idea Uses OpenAI to create a unique 4-minute video idea with a title, description, keywords, scene structure, and intrigue note Checks Airtable "Ideas" table via searchAirtable to avoid duplicates Connects to "Parse Ideas" Parse Ideas Extracts title, description, and notes from the OpenAI output using JavaScript Connects to "Add Ideas" Add Ideas Stores the initial idea in Google Sheets "Ideas" sheet with fields like "Idea", "Description", and "Progress" (set to "Generated") Connects to "Store in Airtable" Store in Airtable Saves the idea to Airtable "Ideas" table with mapped fields and typecast enabled Connects to "Generate Script" Generate Script Creates a 500-600 word script with 8-10 scenes using OpenAI, based on the latest "Generated" idea Uses Structured Output Parser to format output Connects to "Parse Script Output" Parse Script Output Formats the script into readable text and JSON, extracting scenes and closing question Connects to "Store Script" Store Script Saves the script to Google Sheets "Production" sheet with "Script", "Scenes", and "Status" (set to "Scripted") Connects to "Store Script in Airtable" Store Script in Airtable Saves the script to Airtable "Production" table with mapped fields and typecast enabled Connects to "Updated Idea to Scripted" Updated Idea to Scripted Updates the idea status to "Scripted" in Google Sheets "Ideas" sheet Connects to "Update Status Ideas Table" Update Status Ideas Table Updates the idea status to "Scripted" in Airtable "Ideas" table, matching by "Idea ID" Connects to "Extract Scenes" Extract Scenes Parses scene data from Airtable "Production" table for image generation Connects to "Text-to-Image" Text-to-Image Generates images for each scene using PIAPI Connects to "Wait for 4 Min" Wait for 4 Min Waits 3 minutes to allow image generation to complete Connects to "Get Images" Trigger (Schedule Trigger1) Initiates the posting process daily Connects to "Search for Latest Ready Video" Search for Latest Ready Video Searches Airtable "Production" table for the latest video with "Status" = "Ready" Connects to "If Ready?" If Ready? Checks if a video is ready (condition: Status contains Ready) If true, connects to "Download Video" and "Update Production Table" Download Video Downloads the video file using the VideoURL from Airtable Connects to "Post YouTube" Post YouTube Uploads the video to YouTube with title and description, using YouTube OAuth2 Update Production Table Updates the "Production" sheet in Google Sheets, setting "Status" to "Published" and matching by "Production ID" Additional Nodes and Processes OpenAI Chat Model**: Powers "Generate Idea" and "Generate Script" with GPT Structured Output Parser**: Ensures proper JSON output for scripts Get Images**: Retrieves generated images Extract Narration**: Prepares narration for voice generation Voice Generation**: Generates voiceovers Generate Music Prompt**: Creates music prompts using OpenAI Text-to-Music**: Generates music Build Shotstack Timeline**: Constructs video timeline ShotStack Render Video**: Renders the final video Poll Rendered Videos**: Checks video rendering status Final Video**: Updates Airtable "Production" with final video details Final Video Update**: Updates Google Sheets "Production" with video URL Music Urls**: Adds music URLs to the process Setup Requirements Before starting, ensure you have the following 1 n8n Instance A self-hosted or cloud-based n8n instance to run the workflow 2 API Credentials OpenAI: API key Airtable: Personal Access Token (e.g, "Airtable Personal Access Token Google Sheets: OAuth2 credentials PIAPI: HTTP Header Auth key YouTube: OAuth2 credentials 3 Airtable Configuration Base: "Youtube Videos" Tables: "Ideas" "Production" Share with the Airtable token 4 Google Sheets Configuration Document: "Youtube Videos" Sheets: "Ideas" "Production" Share with the Google Sheets credential email Shotstack Configuration (Assumed) API key and endpoint for video rendering (not specified in JSON) Setup Instructions Import the Workflow Import the provided JSON file into your n8n instance Configure Credentials Add OpenAI, Airtable, Google Sheets, PIAPI, and YouTube credentials in n8n’s credential manager Set Up Airtable Create or update the "Ideas" and "Production" tables with the specified fields Ensure proper permissions with the Airtable token Configure Google Sheets Create or update the "Ideas" and "Production" sheets with the specified columns Share the document with the Google Sheets credential email Schedule Triggers Set "Schedule Trigger" to trigger Test the Workflow Run manually to verify each node’s functionality Check Airtable, Google Sheets, and YouTube for updates Ensure PIAPI image generation completes (wait 4 minutes) Monitor and Adjust Monitor API rate limits (e.g, PIAPI, YouTube) Adjust wait times if image or video generation delays occur Verify connections for unlinked nodes Benefits Efficiency**: Automates the entire process from idea to posting Scalability**: Handles daily video production Quality**: Ensures cinematic scripts and visuals Tracking**: Provides detailed progress monitoring Notes Rate Limits**: Be aware of PIAPI (150,000 units per task) and YouTube API limits Timing**: Adjust wait nodes (e.g, "Wait for 4 Min") based on API response times Conclusion and Suggestions to Improve the Automation Conclusion This workflow streamlines YouTube video production, making it ideal for busy content creators, video producers, and marketing teams. Customize it by adding more platforms, adjusting wait delays for image/video generation, or enhancing notifications for status updates. Share your feedback in the n8n community to help others benefit from this automation. Suggestions to Improve Customization**: Adjust prompts, timings, and API parameters based on your needs Expand "Text-to-Music**" with multiple music styles or integrate a royalty-free music API for variety. Improve Video Rendering**: Optimize "Build Shotstack Timeline" and "ShotStack Render Video" with predefined templates to reduce rendering time. Add Analytics Tracking**: Include a node to fetch YouTube Analytics post-upload for performance monitoring. Error Handling**: Add error-catching nodes (e.g., "If" nodes) to retry failed image or video generations. Notification System**: Incorporate email or Slack notifications for key milestones (e.g., script completion, video upload).

This n8n template from Intuz provides a complete end-to-end content factory to automate the entire lifecycle of creating and publishing AI-driven videos. It transforms a single text prompt into a fully scripted, visually rich video with AI-generated images and voiceovers, then distributes it across multiple social media platforms. Who's this workflow for? Content Creators & YouTubers Social Media Managers & Agencies Digital Marketers & Entrepreneurs Brands looking to scale video content production Objective Generate viral video scripts with Gemini AI (via LangChain). Break scripts into structured scenes(hooks, retention, CTA). Create image prompts and high-quality background visuals automatically. Store all scenes, prompts, images, and metadata into Airtable. Handle file formatting, uploads, and naming automatically. Add error handling and retry logic for smooth execution. Uploading into Social Media platforms. How it works AI Script Generation: The workflow starts with a single command. A powerful Google Gemini AI model, acting as a "Content Brain," generates a complete, viral video script with a title, description, and multiple scenes. Content Management in Airtable: The entire script is broken down and saved systematically into an Airtable base, which acts as the central Content Management System (CMS) for the video production pipeline. AI Image Generation: The workflow loops through each scene in Airtable. It uses an AI agent to enhance the image prompts and sends them to an image generation API (like Pollinations.ai) to create a unique, high-quality image for each scene. These images are then automatically uploaded back into Airtable. Automated Video Rendering: Once all images are ready, the workflow gathers the script text and the corresponding image URLs from Airtable and sends them to Creatomate. Creatomate uses a pre-defined template to assemble the final video, complete with AI-generated voiceovers for each scene. Multi-Platform Publishing: After a brief wait for the video to render, the workflow retrieves the final video file and automatically publishes it across your connected social media channels, including YouTube and Instagram. Key Requirements to Use This Template Before you start, please ensure you have the following accounts and assets ready: n8n Instance & Required Nodes: An active n8n account (Cloud or self-hosted). This workflow relies on the official n8n LangChain integration (@n8n/n8n-nodes-langchain). If you are using a self-hosted version of n8n, please ensure this package is installed on your instance. AI & Video Accounts: Google Gemini AI Account: A Google Cloud account with the Vertex AI API enabled and an API Key. Creatomate Account: It's platform to generate videos. An account with Creatomate for video rendering, and your API key and a pre-designed video template ID. Content & Social Media Accounts: Airtable Account: An Airtable base set up to manage the video content. Using the complementary Airtable template is highly recommended. YouTube Account: A YouTube channel with API access enabled via Google Cloud Console. Upload-Post.com Account: An account for posting to other platforms like Instagram. Workflow Steps 1.▶️ Trigger (Manual/Auto) Start workflow manually or via schedule. 2.🧠 Content Brain (Gemini + LangChain) Role-trained viral strategist prompt. Generates 6 scene scripts with: Hook → Retention → Value → CTA. Follows viral content rules (engagement triggers, curiosity gaps, shareable moments). 3.📑 Structured Output Parser Enforces JSON schema: video_id video_title description scenes[] → scene_number, text, image_prompt 4.📄 Airtable – Store Scenes Each scene stored with: Video ID, Title, Description Scene Number & Text Image Prompt & Generated Image link 5.🤖 AI Agent – Image Prompt Creator Transforms scene text →optimized image prompts using structured rules. 6.🎨 Pollination AI – Image Generation Generates vertical 9:16 visuals with parameters: Model: flux Resolution: 1080x1920 Steps: 12 Guidance Scale: 3.5 Safety Checker: Enabled Options: seed=42, nologo=true 7.📂 File Handling & Conversion Assigns filenames automatically (e.g., images_001.png). Converts binary image → base64 for Airtable storage. 8.📤 Airtable Upload – Store Images Attaches generated visuals directly into Generated Image field. 9.⚡ Switch & Error Handling Branches for: ✅ Success → continue ❌ Failed → stop with error message ⏳ Processing → wait/retry 10.Social Media Upload In YouTube via YouTube API from official documentation In Instagram Via Upload Post API Setup Instructions AI Configuration: In the Google Gemini Chat Model nodes, connect your Google Gemini API account. In the Content Brain node, you can customize the core prompt to change the video's niche, style, or topic. Airtable Setup (Crucial): Connect your Airtable account in the Airtable nodes. Set up your Airtable base using the provided template or ensure your base has identical table and field names. Update the Base ID and Table IDs in the Airtable nodes. Airtable Schema: Video Rendering Setup (Creatomate): In the Video Rendering - Creatomate node, add your Creatomate API key to the header authorization. In the Template for Creatomate node, replace the template_id with the ID of your own video template from your Creatomate account. Social Media Connections: In the Upload on YouTube node, connect your YouTube account via OAuth2. In the Upload on Instagram node, replace the API key in the header authorization with your key from Upload-Post.com. Execute the Workflow: Click "Execute workflow" to kick off your automated video content factory. Connect with us Website: https://www.intuz.com/n8n-workflow-automation-templates Email: [email protected] LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started

What It Does This workflow automates the creation of a daily AI and automation content digest by aggregating trending content from four sources: YouTube (n8n-related videos with AI-generated transcript summaries), Reddit (rising posts from r/n8n), X/Twitter (tweets about n8n, AI automation, AI agents, and Claude via Apify scraping), and Perplexity AI (top 3 trending AI news stories). The collected data is analyzed using OpenAI models to extract key insights, stored in Airtable for archival, and then compiled into a beautifully formatted HTML email report that includes TL;DR highlights, content summaries, trending topics, and AI-generated content ideas—delivered straight to your inbox via Gmail. --- Setup Guide Prerequisites You will need accounts and API credentials for the following services: ┌──────────────────┬───────────────────────────────────────────────┐ │ Service │ Purpose │ ├──────────────────┼───────────────────────────────────────────────┤ │ YouTube Data API │ Fetch video metadata and search results │ ├──────────────────┼───────────────────────────────────────────────┤ │ Apify │ Scrape YouTube transcripts and X/Twitter data │ ├──────────────────┼───────────────────────────────────────────────┤ │ Reddit API │ Pull trending posts from subreddits │ ├──────────────────┼───────────────────────────────────────────────┤ │ Perplexity AI │ Get real-time AI news summaries │ ├──────────────────┼───────────────────────────────────────────────┤ │ OpenAI │ Content analysis and summarization │ ├──────────────────┼───────────────────────────────────────────────┤ │ OpenRouter │ Report generation (GPT-4.1) │ ├──────────────────┼───────────────────────────────────────────────┤ │ Airtable │ Store collected content │ ├──────────────────┼───────────────────────────────────────────────┤ │ Gmail │ Send the daily report │ └──────────────────┴───────────────────────────────────────────────┘ Step-by-Step Setup Import the workflow into your n8n instance Configure YouTube credentials: Set up YouTube OAuth2 credentials Replace YOURAPIKEY in the "Get Video Data" HTTP Request node with your YouTube Data API key Configure Apify credentials: In the "Get Transcripts" and "Scrape X" HTTP Request nodes, replace YOURAPIKEY in the Authorization header with your Apify API token Configure Reddit credentials: Set up Reddit OAuth2 credentials (see note below) Configure AI service credentials: Add your Perplexity API credentials Add your OpenAI API credentials Add your OpenRouter API credentials Configure Airtable: Create a base called "AI Content Hub" with three tables: YouTube Videos, Reddit Posts, and Tweets Update the Airtable nodes with your base and table IDs Configure Gmail: Set up Gmail OAuth2 credentials Replace YOUREMAIL in the Gmail node with your recipient email address Customize search terms (optional): Modify the YouTube search query in "Get Videos" node Adjust the subreddit in "n8n Trending" node Update Twitter search terms in "Scrape X" node Important Note: Reddit API Access The Reddit node requires OAuth2 authentication. If you do not already have a Reddit developer account, you will need to submit a request for API access: Go to https://www.reddit.com/prefs/apps Click "create another app..." at the bottom Select "script" as the application type Fill in the required fields (name, redirect URI as http://localhost) Important: Reddit now requires additional approval for API access. Visit https://www.reddit.com/wiki/api to review their API terms and submit an access request if prompted Once approved, use your client ID and client secret to configure the Reddit OAuth2 credentials in n8n API approval can take 1-3 business days depending on your use case. --- Recommended Schedule Set up a Schedule Trigger to run this workflow daily (e.g., 7:00 AM) for a fresh content digest each morning.

This n8n template demonstrates how to automate YouTube content repurposing using AI. Upload a video to Google Drive and automatically generate transcriptions, A/B testable titles, AI thumbnails, short-form clips with captions, and YouTube descriptions with chapter timestamps. Use cases include: Content creators who publish 1-2 long-form videos per week and need to extract 5-10 short-form clips, YouTube agencies managing multiple channels, or automation consultants building content systems for clients. Good to know Processing time is approximately 10-15 minutes per video depending on length Cost per video is roughly $1.00 (transcription $0.65, AI generation $0.35) YouTube captions take 10-60 minutes to generate after upload - the workflow includes automatic polling to check when captions are ready Manual steps still required: video clipping (using provided timestamps), social media posting, and YouTube A/B test setup How it works When a video is uploaded to Google Drive, the workflow automatically triggers and creates an Airtable record The video URL is sent to AssemblyAI (via Apify) for transcription with H:MM:SS.mmm timestamps GPT-4o-mini analyzes the transcript and generates 3 title variations optimized for A/B testing When you click "Generate thumbnail" in Airtable, your prompt is optimized and sent to Kie.ai's Nano Banana Pro model with 2 reference images for consistent branding After uploading to YouTube, the workflow polls YouTube's API every 5 minutes to check if auto-generated captions are ready Once captions are available, click "Generate clips" and Grok 4.1 Fast analyzes the transcript to identify 3-8 elite clips (45+ seconds each) with proper start/end boundaries and action-oriented captions GPT-4o-mini generates a YouTube description with chapter timestamps based on the transcript All outputs are saved to Airtable: titles, thumbnail, clip timestamps with captions, and description How to use Duplicate the provided Airtable base template and connect it to your n8n instance Create a Google Drive folder for uploading edited videos After activating the workflow, copy webhook URLs and paste them into Airtable button formulas and automations Upload your edited video to the designated Google Drive folder to trigger the system The workflow automatically generates titles and begins transcription Add your thumbnail prompt and 2 reference images to Airtable, then click "Generate thumbnail" Upload the video to YouTube as unlisted, paste the video ID into Airtable, and check the box to trigger clip generation Use the provided timestamps to manually clip videos in your editor Copy titles, thumbnail, clips, and description from Airtable to publish across platforms Requirements Airtable account (Pro plan recommended for automations) Google Drive for video upload monitoring Apify account for video transcription via AssemblyAI actor OpenAI API key for title and description generation (GPT-4o-mini) OpenRouter API key for clip identification (Grok 4.1 Fast) Kie.ai account for AI thumbnail generation (Nano Banana Pro model) YouTube Data API credentials for caption polling Customising this workflow Tailor the system prompts to your content niche by asking Claude to adjust them without changing the core structure Modify the clip identification criteria (length, caption style, number of clips) in the Grok prompt Adjust thumbnail generation style by updating the image prompt optimizer Add custom fields to Airtable for tracking performance metrics or additional metadata Integrate with additional platforms like TikTok or Instagram APIs for automated posting

This n8n template acts as your automated social media data analyst. Instead of manually checking your analytics across different dashboards every week, this workflow scrapes your latest stats, calculates your week-over-week growth, and uses AI to write a strategic performance report delivered straight to your inbox. Use cases are many: Perfect for content creators tracking growth, agencies managing client reporting, or community managers monitoring Skool engagement alongside social channels. Good to know First Run Setup:* Since this workflow calculates *growth (Current vs. Last Week), it needs a baseline to start. You will need to manually add one row to the linked Airtable template with your current stats before the first scheduled run. Cost:** This uses the Apify API for scraping TikTok and OpenRouter for the LLM analysis. Costs are generally very low (pennies per run), but you will need active accounts for both. How it works Data Collection: Every Sunday, the workflow triggers and pulls your live follower counts from YouTube, TikTok, and Skool. It also grabs the transcripts and stats for every video you posted in the last 7 days. Growth Calculation: It searches your Airtable database for the previous week's record and compares it against the live numbers to calculate exactly how many subscribers and followers you gained. AI Analysis: The data and video transcripts are fed into an LLM (via OpenRouter). The AI analyzes why certain videos performed well based on the content, identifying trends and engagement patterns. Reporting: The LLM generates a clean, formatted HTML report. Delivery & Archiving: The workflow emails the report to you and saves the new raw data into Airtable to serve as the baseline for next week. How to use The workflow is set to run weekly (Sundays), but you can change the Schedule Trigger to whatever day you prefer to receive reports. You will need to configure the CONFIG node at the start with your specific profile URLs and Channel IDs so the scrapers know where to look. Link to the required Airtable template is included in the workflow sticky notes. Requirements n8n** (Self-hosted recommended) Apify** account (for TikTok and Skool scraping) Google Cloud** project (for YouTube Data API) OpenRouter** or OpenAI API key Airtable** account Gmail** account Customising this workflow You can easily swap out the LLM model in the OpenRouter node if you prefer a specific model (like Claude 3.5 Sonnet or GPT-4o) for the analysis. You could also add more platforms like LinkedIn or Instagram if you have the appropriate Apify actors or API credentials.

YouTube Chapter Auto-Description with AI This n8n template automatically adds structured timestamp chapters to your latest YouTube video’s description using your RSS feed, SupaData for transcript extraction, and an AI tool for chapter generation. Ideal for creators who want every video to include chapter markers without doing it manually. Good to Know SupaData extracts full transcripts from YouTube videos via URL. The AI chapter generator converts long transcripts into formatted timestamps with short titles. This workflow edits the existing video description and appends the chapters to the bottom. How It Works The RSS Feed Trigger detects new uploads from your YouTube channel. The workflow checks Airtable to prevent duplicate processing. Transcript is fetched using SupaData API. The total video duration is extracted from the transcript. AI is prompted to generate well-formatted chapter timestamps. The existing description is fetched from YouTube. The chapters are appended and pushed back via the YouTube API. How to Use Start with the Manual Trigger to test the setup. Replace it with the RSS Trigger once you're ready for automation. Chapters are added only if the video hasn't been processed before. Requirements YouTube OAuth2** credentials in n8n SupaData API Key** Airtable account** (for optional deduplication logic) Customizing This Workflow Change the chapter format, or instruct the AI to use emojis, bold titles, or include sections like "sponsor" or "Q&A". Replace the RSS Trigger with a webhook if using a different publishing process.