YouTube and Google Sheets integration

//ASMR AI Workflow Who is this for? Content Creators, YouTube Automation Enthusiasts, and AI Hobbyists looking to autonomously generate and publish unique, satisfying ASMR-style YouTube Shorts without manual effort. What problem does this solve? This workflow solves the creative bottleneck and time-consuming nature of daily content creation. It fully automates the entire production pipeline, from brainstorming trendy ideas to publishing a finished video, turning your n8n instance into a 24/7 content factory. What this workflow does Two-Stage AI Ideation & Planning: Uses an initial AI agent to brainstorm a short, viral ASMR concept based on current trends. A second "Planning" AI agent then takes this concept and expands it into a detailed, structured production plan, complete with a viral-optimized caption, hashtags, and descriptions for the environment and sound. Multi-Modal Asset Generation: Video:* Feeds detailed scene prompts to the ByteDance Seedance* text-to-video model (via Wavespeed AI) to generate high-quality video clips. Audio:* Simultaneously calls the Fal AI* text-to-audio model to create custom, soothing ASMR sound effects that match the video's theme. Assembly:** Automatically sequences the video clips and sound into a single, cohesive final video file using an FFMPEG API call. Closed-Loop Publishing & Logging: Logging:** Initially logs the new idea to a Google Sheet with a status of "In Progress". Publishing:** Automatically uploads the final, assembled video directly to your YouTube channel, setting the title and description from the AI's plan. Updating:** Finds the original row in the Google Sheet and updates its status to "Done", adding a direct link to the newly published YouTube video. Notifications:** Sends real-time alerts to Telegram and/or Gmail with the video title and link, confirming the successful publication. Setup Credentials: You will need to create credentials in your n8n instance for the following services: OpenAI API Wavespeed AI API (for Seedance) Fal AI API Google OAuth Credential (enable YouTube Data API v3 and Google Sheets API in your Google Cloud Project) Telegram Bot Credential (Optional) Gmail OAuth Credential Configuration: This is an advanced workflow. The initial setup should take approximately 15-20 minutes. Google Sheet:* Create a Google Sheet with these columns: idea, caption, production_status, youtube_url. Add the Sheet ID* to the Google Sheets nodes in the workflow. Node Configuration:** In the Telegram Notification node, enter your own Chat ID. In the Gmail Notification node, update the recipient email address. Activate:** Once configured, save and set the workflow to "Active" to let it run on its schedule. How to customize Creative Direction:* To change the style or theme of the videos (e.g., from kinetic sand to soap cutting), simply edit the systemMessage in the "2. Enrich Idea into Plan" and "Prompts AI Agent"* nodes. Initial Ideas:* To influence the AI's starting concepts, modify the prompt in the "1. Generate Trendy Idea"* node. Video & Sound:* To change the video duration or sound style, adjust the parameters in the "Create Clips" and "Create Sounds"* nodes. Notifications:* Add or remove notification channels (like Slack or Discord) after the "Upload to YouTube"* node.

Who’s it for? This workflow is built for: AI storytellers, **content creators, YouTubers, and short-form video marketers Anyone looking to transform text prompts into cinematic AI-generated videos fully automatically Educators, **trainers, or agencies creating story-based visual content at scale What It Does This n8n workflow allows you to automatically turn a simple text prompt into a multi-scene cinematic video, using the powerful Fal.AI Seedance V1.0 model (developed by ByteDance — the creators of TikTok). It combines the creativity of GPT-4o, the motion synthesis of Seedance, and the automation power of n8n to generate AI videos with ambient sound and publish-ready format. How It Works Accepts a prompt from Google Sheets (configurable fields like duration, aspect ratio, resolution, scene count) Uses OpenAI GPT-4o to write a vivid cinematic narrative Splits the story into n separate scenes For each scene: GPT generates a structured cinematic description (characters, camera, movement, sound) The Seedance V1.0 model (via Fal.AI API) renders a 5s animated video Optional: Adds ambient audio via Fal’s MM-Audio model Finally: Merges all scene videos using Fal’s FFmpeg API Optionally uploads to YouTube automatically Why This Is Special Fal.AI Seedance V1.0** is a highly advanced motion video model developed by ByteDance, capable of generating expressive, stylized 5–6 second cinematic clips from text. This workflow supports full looping, scene count validation, and wait-polling for long render jobs. The entire story, breakdown, and scene design are AI-generated — no manual effort needed. Output is export-ready: MP4 with sound, ideal for YouTube Shorts, Reels, or TikTok. Requirements n8n (Self-hosted recommended) API Keys: Fal.AI (https://fal.ai) OpenAI (GPT-4o or 3.5) Google Sheets Example Google Sheet How to Set It Up Clone the template into your n8n instance Configure credentials: Fal.AI Header Token OpenAI API Key Google Sheets OAuth2 (Optional) YouTube API OAuth Prepare a Google Sheet with these columns: story (short prompt) number_of_scene duration (per clip) aspect_ratio, resolution, model Run manually or trigger on Sheet update. How to Customize Modify the storytelling tone in GPT prompts (e.g., switch to fantasy, horror, sci-fi) Change Seedance model params like style or seed Add subtitles or branding overlays to final video Integrate LINE, Notion, or Telegram for auto-sharing Example Output Prompt: “A rabbit flies to the moon on a dragonfly and eats watermelon together” → Result: 3 scenes, each 5s, cinematic camera pans, soft ambient audio, auto-uploaded to YouTube Result

Transform YouTube comments into actionable insights with automated AI analysis and professional email reports. This intelligent workflow monitors your Google Sheets for YouTube video IDs, fetches comments using YouTube API, performs comprehensive AI sentiment analysis, and delivers formatted email reports with viewer insights - helping content creators understand their audience and improve engagement. 🚀 What It Does Smart Video Monitoring: Watches Google Sheets for new YouTube video IDs marked as "Pending" and triggers automated analysis Complete Comment Collection: Fetches up to 100 top comments per video using YouTube API with relevance-based ordering AI-Powered Analysis: Uses GPT-4 to analyze comments for sentiment, themes, questions, feedback, and actionable insights Professional Email Reports: Generates detailed HTML reports with statistics, sentiment breakdown, and improvement recommendations Automated Status Tracking: Updates spreadsheet status to prevent duplicate processing and maintain organized workflow 🎯 Key Benefits ✅ Deep Audience Insights: Understand what viewers really think about your content ✅ Save Hours of Manual Work: Automated comment analysis vs reading hundreds of comments ✅ Improve Content Strategy: Get actionable feedback for better video performance ✅ Track Sentiment Trends: Monitor positive/negative feedback patterns ✅ Professional Reporting: Receive formatted analysis reports via email ✅ Scalable Analysis: Process multiple videos automatically 🏢 Perfect For Content Creators & YouTubers Individual creators tracking audience engagement Educational channels analyzing learning feedback Entertainment creators understanding viewer preferences Business channels monitoring brand sentiment Marketing & Business Applications Brand Monitoring**: Track sentiment on branded content and partnerships Audience Research**: Understand viewer demographics and preferences Content Optimization**: Identify what resonates with your audience Competitor Analysis**: Analyze comments on competitor videos (where allowed) ⚙️ What's Included Complete Analytics Workflow: Ready-to-deploy YouTube comment analysis system Google Sheets Integration: Simple spreadsheet-based video management YouTube API Integration: Automated comment fetching with proper authentication AI Analysis Engine: GPT-4 powered sentiment and insight generation Email Reporting System: Professional HTML-formatted reports Status Management: Automatic processing tracking and duplicate prevention 🔧 Setup Requirements n8n Platform**: Cloud or self-hosted instance YouTube API Credentials**: Google Cloud Console API access OpenAI API**: GPT-4 access for comment analysis Google Sheets**: Video ID management and status tracking Gmail Account**: For receiving analysis reports 📊 Required Google Sheets Structure | ID | Video Title | YouTube Video ID | Status | |----|-------------|------------------|---------| | 1 | My Tutorial | dQw4w9WgXcQ | Pending | | 2 | Product Demo| abc123def456 | Mail Sent | | 3 | Weekly Vlog | xyz789uvw012 | Draft | Status Options: Draft → Pending → Mail Sent 📧 Sample Analysis Report 📺 YouTube Comments Analysis Report Video: "How to Build Your First Website" 📊 Quick Statistics: • Total Comments Analyzed: 87 • Average Likes per Comment: 3.2 • Total Replies: 156 • Sentiment Summary: Positive: 65%, Negative: 10%, Neutral: 25% ❓ Common Questions: • "What hosting service do you recommend?" • "Can I do this without coding experience?" • "How much does domain registration cost?" 💡 Key Feedback Points: • Tutorial pace is perfect for beginners • More examples of finished websites requested • Viewers want follow-up video on advanced features 🎯 Actionable Insights: • Create hosting comparison video • Add timestamps for different skill levels • Consider beginner-friendly series expansion 🎨 Customization Options Analysis Depth: Adjust AI prompts for different analysis focuses (engagement, education, entertainment) Comment Limits: Modify maximum comments processed (default: 100, AI analysis: 50) Report Recipients: Send reports to multiple team members or clients Custom Metrics: Add specific analysis criteria for your content niche Multi-Channel: Process videos from multiple YouTube channels Scheduling: Set up regular analysis of your latest videos 🏷️ Tags & Categories #youtube-analytics #comment-analysis #content-creator-tools #ai-sentiment-analysis #video-insights #audience-research #youtube-api #content-optimization #social-media-analytics #creator-economy #video-marketing #engagement-analysis #content-strategy #ai-reporting #youtube-automation 💡 Use Case Examples Educational Channel: Analyze tutorial comments to identify confusing concepts and improve teaching methods Product Reviews: Monitor sentiment on review videos to understand customer satisfaction trends Entertainment Creator: Track audience reactions to different content formats and optimize future videos

Translating your YouTube video titles and descriptions into multiple languages is one of the simplest ways to expand your channel's global reach. But doing it manually is super tedious and time-consuming. This n8n workflow automates the entire process: from detecting your latest video, translating its metadata into multiple languages using AI, to publishing the translated versions directly to YouTube - all managed and tracked through a connected Google Sheet only. What Problem Is This Workflow Solving? Manually translating YouTube metadata—titles, descriptions, and tags—is both time-consuming and costly, especially as your video library grows. For example, let's say you want to translate the metadata of 50 videos into 5 languages, and if you spend 10 minutes on each video, it could take over 40 hours of manual work. This workflow automates the localization of your YouTube metadata, making it fast and efficient to translate large volumes of content. Instead of spending days on translations, you can handle bulk updates in minutes: Save Time and Resources**: Instantly translate metadata for dozens or hundreds of videos, freeing you from repetitive, manual tasks. Expand Your Global Reach**: Enable your videos to appear in search results across multiple languages, reaching new audiences worldwide. Boost Engagement and SEO**: Localized metadata helps your videos get discovered and increases viewer engagement, leading to higher watch times and better performance. Make Content More Accessible**: Welcome viewers from different linguistic backgrounds, making your channel inclusive and inviting. Who Is This For? Use cases are many: This workflow is perfect for YouTubers who want to automate multilingual metadata updates and eliminate repetitive manual tasks. It’s especially useful for creators whose content is visually driven and easy to follow, such as: DIY and How-to Channels Travel and Nature Channels Fitness and Workout Channels Cooking Channels Art and Craft Channels How It Works Phase 1: Prepare Values & Auto Crawl Mode Set up a Schedule Trigger: In the **Schedule Trigger node in n8n, define your preferred interval to automatically run the workflow on a recurring schedule; no manual execution needed. Set Required Parameters: In the **Prepare Values node in n8n, you must enter the following: spreadsheet_id: to link the workflow to your connected Google Sheet channel_name: to specify which tab of the Google Sheet contains the video URLs to process channel_id: to define the YouTube channel the workflow will act upon Set Target Languages: In the **Languages tab of your connected Google Sheet, list all languages you'd like to generate translated titles and descriptions for. These will be used later during the translation phase. Choose Crawling Mode: In the **Auto tab of your Google Sheet, configure the Auto Crawl setting in Column B based on your preferred method: Select No (Turn off Auto Crawl): You must manually input the video URL(s) in the channel_name tab and set the status to Ready for 1 video only. Select Yes (Turn on Auto Crawl): The workflow will automatically fetch one of the latest videos from your connected YouTube channel (based on channel_id) into the channel_name tab in your Google Sheet. Phase 2: Trigger The Process Once everything is properly set up, the workflow in n8n can be activated - either manually or automatically via the Schedule Trigger, which runs based on the interval you’ve configured earlier. The tool then checks the Auto Crawl status in Column B in the Auto tab of your connected Google Sheet to determine the route: If Auto Crawl = No: The workflow skips auto-fetching and proceeds directly to the next phase, expecting that the video URL is already entered manually and marked as Ready in its status. If Auto Crawl = Yes: The tool connects to your YouTube channel using the predefined channel_id. It fetches one of the latest videos and checks whether that video’s ID already exists in the list of processed videos. If the video has not been processed yet, its URL will be inserted into the channel_name tab, and its status in Column A will automatically be set to Ready, ensuring it proceeds to the next step. If it already exists, the video is skipped to avoid reprocessing. ⚠️ Important: When Auto Crawl = Yes, do not manually add another URL and set its status to Ready in the channel_name tab in the Google Sheet. Doing so may trigger the same video twice, causing data conflicts and redundant processing. Phase 3: Collect Video Information Once a new video URL appears in your connected Google Sheet and its status is set Ready in Column A (under the specified channel_name tab), the workflow picks it up automatically. Then, it extracts the Video ID from the URL and sends a GET request to the YouTube API to retrieve that video’s title and description in your channel’s default language for the next steps. Phase 4: Generate Translated Metadata In Preset Languages The tool reads your target languages from the Languages tab in your connected Google Sheet. A loop runs through each language code one at a time. For each language, the tool sends your original title and description to Google Gemini’s Chat Model. Then, the AI returns the content translated into the target language. The output is returned in JSON data, then restructured to ensure each language’s data is clearly separated and ready for the next step. Phase 5: Update Translated Metadata On YouTube & Log Status All translated titles and descriptions from previous steps are combined into one structured format. The tool sends a PUT request to the YouTube API to update the video’s metadata directly with the new multilingual-translated content. If the update is successful, the video's status in Column A in the channel_name tab in the connected Google Sheet is marked as Success. If the update fails, the video’s status is marked as Error for later review or retry. How To Set Up Download the working package. Import the package into your n8n interface. Duplicate the Youtube - Update Video Metadata in Multi-Languages Google Sheet template into your Google Sheets account. For the channel_name tab in the template, you can rename it with your actual YouTube channel's name for easier tracking. Set up necessary credentials in Google Cloud Console for tools access and usability: For Google Sheets access, please ensure connection in the following nodes: Node Get Auto Crawl Status → connected to the Auto tab Node Check Latest Video ID → connected to the channel_name tab Node Insert Video Info → connected to the channel_name tab Node Get Video URL → connected to the channel_name tab Node Get Language List → connected to the Languages tab Node Update Status - Success → connected to the channel_name tab Node Update Status - Error → connected to the channel_name tab For YouTube access, ensure connection to YouTube API in the following nodes: Node YouTube - Get Latest Video Node Get Video Info Node Update Video Metadata with Selected Languages For Google Gemini access, ensure connection to Google Gemini API in the following node: Node Google Gemini’s Chat Model Set a Schedule Trigger in n8n to run the workflow automatically at your preferred interval. Define necessary parameters in Node Prepare Values in your n8n workflow: spreadsheet_id: your connected Google Sheet ID channel_name: the tab in your connected Google Sheet contains the video URLs and receives process updates (should be renamed with your actual YouTube channel’s name for easy tracking) channel_id: your YouTube channel ID Check the status of the Auto Crawl function in the Auto tab in your connected Google Sheet: By default, its status is No: You’ll manually insert a video URL and mark its row as Ready. In case you want to turn it on, please change it to Yes: The tool will automatically fetch the latest video(s) from your channel. Activate the workflow in n8n. To manually update a video: Set Auto Crawl to No Insert the video URL into the channel_name tab Set the status to Ready To automate with Auto Crawl: Set Auto Crawl to Yes The tool will auto-fetch one of the new videos and set its status to Ready Track results of the original row in the channel_name tab of your Google Sheet and YouTube: If the row’s status is Success, the metadata is updated on YouTube with all the set languages and you can check things out on the platform directly. If the row’s status is Error, you can do manual review or retry. Requirements Basic setup in Google Cloud Console with OAuth2 credentials in the following configurations: Google Sheets API enabled, with edit permissions on the connected spreadsheet YouTube API enabled, with an account that has Owner or Editor role on the target channel API access to Google Gemini for generating multilingual translated content via AI. How To Customize Adjust the trigger interval: Change the schedule in the **Schedule Trigger node to fit your needs (e.g. every 10 minutes, hourly, etc.). Add or remove target languages: Simply update the **Languages tab in your connected Google Sheet. No changes in n8n are required. Customize the translation style: You can edit the prompt inside the **AI node to change the tone, format, or style of the translations. However, do not modify the output structure format - doing so will break the workflow. Add alerts or notifications when finished**: Feel free to integrate additional nodes (like Telegram or Email) to notify you and your team when updates succeed or fail. FAQs: Can I use this workflow for more than one YouTube channel? Not directly. This workflow is currently designed to connect to a single YouTube channel ID at a time. However, if you’d like to manage multiple YouTube channels within one Google Sheet and a unified n8n interface, we can customize the setup for you. Feel free to reach out to Agent Circle for a tailored setup and guidance. What happens if I manually enter a video URL while Auto Crawl is ON? Avoid this. Manually adding a URL with status Ready in the channel_name tab while Auto Crawl = Yes may cause duplicate processing, API conflicts, or data overwrites. How many languages can I translate into at once? There's no strict limit. You can list as many languages as needed in the Languages tab in your connected Google Sheet. Refer to the All Languages tab in the Google Sheet template for valid languages and language codes (e.g., en, fr, es, de). Do I need to change anything in n8n when I add more languages? No - simply update the Languages tab in your connected Google Sheet. No work in n8n is needed for this. Can I change the AI model from Google Gemini to something else? Yes. You can replace the Google Gemini Chat Model node with another chat model, such as OpenAI GPT-4, or any compatible LLM provider. What happens if the metadata update to YouTube fails? The video's status in Column A of the channel_name tab in your connected Google Sheet will be marked Error. You can then review, fix, and re-run the process. Can I edit the translation prompt in the AI node for my own brand tone? Absolutely. You can customize the translation prompt in the AI node to adjust tone, format, or even brand voice. Just make sure the structure of the returned JSON remains intact. Is the workflow GDPR or YouTube policy-compliant? Yes - as long as you're the owner or have editor access to the YouTube channel and use the official YouTube API with proper OAuth2 authentication. Can I schedule this workflow to run every day? Yes. In the Schedule Trigger node in n8n, set your preferred interval - e.g., daily, every 12 hours, etc. Does this work with unlisted or private videos? No - YouTube API typically returns data only for public videos. For private/unlisted videos, additional permissions and scopes are required. If you need support for this case, feel free to contact Agent Circle for personalized consultation and setup assistance. Need Help? If you need a step-by-step guide to set up this workflow or want it customized for your specific business needs, feel free to reach out to Agent Circle. We’re always here to support and help you to bring automation ideas to life. Join our community on different platforms for assistance, inspiration and tips from others. Website: https://www.agentcircle.ai/ Etsy: https://www.etsy.com/shop/AgentCircle Gumroad: http://agentcircle.gumroad.com/ Discord Global: https://discord.gg/d8SkCzKwnP FB Page Global: https://www.facebook.com/agentcircle/ FB Group Global: https://www.facebook.com/groups/aiagentcircle/ X: https://x.com/agent_circle YouTube: https://www.youtube.com/@agentcircle LinkedIn: https://www.linkedin.com/company/agentcircle

Auto-Post Veo3 Videos on YouTube An automated workflow for creating Veo3 videos and posting them to YouTube. YT Tutorial: https://youtu.be/DXM1VA-vDX4 Workflow Overview The workflow is divided into three main phases: Create Veo3 Video Wait for Video Processing Post on YouTube Create Veo3 Video This phase handles the initial video creation based on user input. Type Prompt:** A form trigger allows the user to input details for the video, including: Prompt: A simple scenario for the video. Video Style: (e.g., Dialogue, Monologue, Advertisement, Documentary) Aspect Ratio: (e.g., 16:9, 9:16, 1:1) Video Category: A YouTube category for the video. Get Specific Prompt:** Based on the selected "Video Style," the workflow fetches specific prompt data from a Google Sheet. Videography (AI Refinement):** An AI agent (using OpenRouter's Google Gemini 2.5 Flash model) refines the user's prompt into a detailed "script-to-screen" format suitable for video generation. Make FAL.AI Request:** The refined prompt is sent to the Fal.ai Veo 3 model via an HTTP request to generate the video. The video duration is fixed at 8 seconds. Store Data:** Details of the video request, including the date requested, the refined prompt, and the request URL, are stored in a Google Sheet. Wait for Video Processing Wait 5 mins:** The workflow pauses for 5 minutes. This waiting period is necessary as it typically takes 3-5 minutes for the video to be ready after the generation request. Post on YouTube This phase focuses on generating YouTube SEO details and uploading the video. YT Video SEO (AI Generation):** An AI agent (using OpenRouter's OpenAI GPT-4.1 Mini model) acts as a YouTube SEO specialist and viral content strategist. It generates the following details for the YouTube video: Video Title: A compelling title (less than 6 words). Video Description: A detailed description. Video Tags: Relevant tags to maximize discoverability. YouTube Category: The appropriate YouTube category code based on the user's input. The AI agent is configured to follow guidelines for virality and YouTube's tag limits. Structured Output:** Parses the structured JSON output from the AI agent. Get Keywords:** Extracts and formats the video tags into a comma-separated list suitable for YouTube. Fetch Video Credentials:** Fetches the video URL and other credentials from Fal.ai. Download Video:** Downloads the generated video file. Post on YouTube:** The video is uploaded to YouTube using the generated title, description, tags, and category. Setup To run this workflow, you need to set up credentials in n8n for: OpenRouter:** Generate API key from your OpenRouter account. Google Sheets:** Uses OAuth 2.0. Connect by authenticating your Google account. YouTube Data API:** Configure credentials to allow posting videos to YouTube. If you do not have an n8n account, follow the tutorial at https://youtu.be/E2yQelHPUdU?feature=shared to get started.

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).