AutomationMart
Home/Browse/Create YouTube videos daily from Google Sheets using MagicHour + Gemini
n8n

Create YouTube videos daily from Google Sheets using MagicHour + Gemini

n8nn8n26 modulesv1.0
agentchatTriggercodegoogleSheetsgoogleSheetsTriggerhttpRequestiflimitlmChatGoogleGeminimediaFXmergeoutputParserStructuredsetwaityouTube

Prompt To Video (MagicHour API) with Music & YouTube Automate AI video creation, background music, YouTube uploads, and result logging — all from a single text prompt. ⚡ Overview This n8n template turns a text prompt into a complete AI-generated video using the MagicHour API, adds background music, generates YouTube metadata, uploads to YouTube, and logs results in Google Sheets — all in one flow. Perfect for creators, marketers, and startups producing YouTube content at scale — from daily AI Sh

At a glance

Create YouTube videos daily from Google Sheets using MagicHour + Gemini is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects agent, chatTrigger, code, googleSheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
agent, chatTrigger, code, googleSheets, googleSheetsTrigger, httpRequest
Modules
26
Price
Free
Version
v1.0
Create YouTube videos daily from Google Sheets using MagicHour + Gemini workflow diagram

About this workflow

Prompt To Video (MagicHour API) with Music & YouTube Automate AI video creation, background music, YouTube uploads, and result logging — all from a single text prompt. ⚡ Overview This n8n template turns a text prompt into a complete AI-generated video using the MagicHour API, adds background music, generates YouTube metadata, uploads to YouTube, and logs results in Google Sheets — all in one flow. Perfect for creators, marketers, and startups producing YouTube content at scale — from daily AI Shorts to explainers or marketing clips. 🧩 Use Cases 🎥 Daily AI-generated Shorts 🧠 Product explainers 🚀 Marketing & brand automation 🔁 Repurpose blog posts into videos 💡 AI storytelling or creative projects ⚙️ How It Works Trigger when a new row is added to Google Sheets or via Chat input. Gemini parses and normalizes the text prompt. MagicHour API generates the AI video. Poll until the render completes. (Optional) Mix background audio using MediaFX. Gemini generates YouTube title, description, and tags. Upload the video to YouTube with metadata. Log YouTube URL, metadata, and download link back to Google Sheets. 🧰 Requirements Service Purpose MagicHour API Key Text-to-video generation Gemini API Key Prompt parsing & metadata YouTube OAuth2 Video uploads Google Sheets OAuth2 Trigger & logging (Optional) MediaFX Node Audio mixing 🗂️ Google Sheets Setup Column Description Prompt Text prompt for video Background Music URL (Optional) Royalty-free track Status Tracks flow progress YouTube URL Auto-filled after upload Metadata Title, tags, and description JSON Date Generated (Optional) Auto-filled with video creation date 📅 100 Daily Prompts Automation You can scale this workflow to generate one video per day from a batch of 100 prompts in Google Sheets. Setup Steps Add 100 prompts to your Google Sheet — one per row. Set the Status column for each to Pending. Use a Cron Trigger in n8n to run the workflow once daily (e.g., at 9 AM). Each run picks one Pending prompt, generates a video, uploads to YouTube, then marks it as Done. Continues daily until all 100 prompts are processed. Example Cron Expression 0 9 → Runs the automation every day at 9:00 AM. Node Sequence [Schedule Trigger (Daily)] → [Get Pending Prompt from Sheets] → [Gemini Prompt Parser] → [MagicHour Video Generation] → [Optional: MediaFX Audio Mix] → [Gemini Metadata Generator] → [YouTube Upload] → [Update Row in Sheets] 💡 Optional Enhancements: Add a notification node (Slack, Discord, or Email) after each upload. Add a counter check to stop after 100 videos. Add a “Paused” column to skip specific rows. 🧠 Gemini Integration Gemini handles: JSON parsing for MagicHour requests Metadata generation (title, description, tags) Optional creative rewriting of prompts 🎧 Audio Mixing (Optional) Install MediaFX Community Node → Settings → Community Nodes → n8n-nodes-mediafx Use it to blend background music automatically into videos. 🪶 Error Handling Avoid “Continue on Fail” in key nodes Use IF branches for MagicHour API errors Add retry/timeout logic for polling steps 🧱 Node Naming Tips Rename generic nodes for clarity: Merge → Merge Video & Audio If → Check Video Completion HTTP Request → MagicHour API Request 🚀 How to Use Add MagicHour, Gemini, YouTube, and Sheets credentials Replace background music with your own track Use Google Sheets trigger or daily cron for automation Videos are created, uploaded, and logged — hands-free ⚠️ Disclaimer This template uses community nodes (MediaFX). Install and enable them manually. MagicHour API usage may incur costs based on video duration and quality. 🌐 SEO Keywords MagicHour API, n8n workflow, AI video generator, automated YouTube upload, Gemini metadata, AI Shorts, MediaFX, Google Sheets automation, AI marketing, content automation.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Automated AI cold calling system with VAPI.ai, Airtable, and smart follow-ups

Automate your cold calling process with AI-powered conversation handling, smart scheduling, and comprehensive call tracking How it works This comprehensive cold calling system automates your entire outbound calling workflow in 4 high-level steps: 1. Automated Dialing - System automatically calls prospects from your Airtable database at scheduled intervals 2. AI Conversation Handling - Advanced AI assistant conducts natural conversations, handles objections, and books appointmen

Free

Enrich Company Data from LinkedIn via Bright Data & Google Sheets

This n8n workflow automates the enrichment of a company list by discovering and extracting each company’s official LinkedIn URL using Bright Data’s search capabilities and Google Gemini AI for HTML parsing and result interpretation. Who is this template for? This workflow is ideal for sales, business development, and data research professionals who need to collect official LinkedIn company profiles for multiple organizations, starting from a list of company names in Google Sheets. It’s especiall

Free

Automate social media headlines with Bright Data & n8n

Description This workflow automatically finds trending headlines and content from various sources and posts them to your social media accounts. It helps maintain an active social media presence without the daily manual effort of content curation. Overview This workflow automatically scrapes trending headlines and content from various sources and posts them to your social media accounts. It uses Bright Data to access content and n8n to schedule and post to platforms like Twitter, LinkedIn, or Fac

Free

Extract & classify invoices & receipts with Gmail, OpenAI and Google Drive

Who is it for? Anyone who wants to automatically aggregate their invoices or receipts. Main beneficiaries: small business owners and freelancers. How it works 1. Creates a folder in Google Drive for uploading invoices and receipts. Responds (Webhook response) with URL to the created folder. 2. Gets all emails with attachments from a Gmail mailbox. 3. (Optional) Filters emails, e.g. exclude emails sent to specific address. 4. Filters only PDF attachments. 5. Classifies all PDF attach

Free

📚 Auto-generate documentation for n8n workflows with GPT and Docsify

This workflow creates a documentation system for n8n instances using Docsify.js. It serves a dynamic documentation website that allows users to: - View an overview of all workflows in a tabular format - Filter workflows by tags - Access automatically generated documentation for each workflow - Edit documentation with a live Markdown preview - Visualize workflow structures using Mermaid.js diagrams > 📺 Check out the short 2-min demonstration on LinkedIn. Don't forget to connect! 🔧 Key Componen

Free

Auto-generate product comparison pages with OpenAI & Google Sheets

Auto-generate product comparison pages that help users buy faster This workflow creates detailed "X vs Y" product comparison pages designed to help readers make faster, more confident purchase decisions — all with zero manual writing. --- How it works - Triggered manually or via Google Sheets row - Takes two product names as input (e.g. “Notion vs Evernote”) - Uses AI to generate: - ✅ A compelling title and meta description - 📝 Clear feature-by-feature comparison - 🤝 Use-case-ba

Free

Get Google search results (SERPs) for SEO research

Use Case Research search engine rankings for SEO analysis: - You need to track keyword rankings for your website - You want to analyze competitor positions in search results - You need data for SEO competition analysis - You want to monitor SERP changes over time What this Workflow Does The workflow uses ScrapingRobot API to fetch Google search results: - Retrieves SERP data for your target keywords - Captures URL rankings and page titles - Processes up to 5000 searches with free account - Organ

Free

Report spam and phishing URLs from IMAP mailboxes to Spamhaus

This workflow automates URL reporting to Spamhaus based on incoming spam/phishing sample emails. It watches one or more IMAP folders, extracts URLs from each email body, removes duplicates and common noise, and submits the remaining URLs to the Spamhaus submission API with the appropriate threat context. What it does - Monitors one or more IMAP mailboxes/folders containing abuse samples (spam/phish). - Processes each email individually in a loop. - Extracts and normalizes URLs from the email tex

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free