Automated VS Video Creator from Google Sheets
detail.loadingPreview
This n8n workflow automatically generates 'VS' style videos by pulling character data from Google Sheets and using AI to create scene prompts and image prompts for Creatomate. It solves the problem of manually creating engaging comparison videos at scale.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow automates the creation of 'VS' style comparison videos. It starts by fetching data, specifically a 'Main Character' and a list of 'Opponents', from a Google Sheet. An AI agent (Scene Creator) then generates eight distinct opponents from the provided category, ensuring variety. These opponents, along with the main character, are then used by another AI agent (Image Prompt Generator) to create detailed text-to-image prompts for each character, focusing on a fierce, close-up, and roaring depiction. Finally, these prompts are sent to the Creatomate API to render a video, dynamically populating image and text fields based on the AI-generated content and the structured Google Sheet data. This workflow is ideal for content creators looking to quickly produce engaging comparison videos for social media or other platforms.
Key Features
- Dynamically generates comparison videos using AI.
- Integrates with Google Sheets to pull character data.
- Leverages AI agents for scene generation and image prompt creation.
- Utilizes Creatomate API for video rendering.
- Customizable via template IDs and API keys.
How To Use
- Configure Google Sheets Node: Connect your Google account and specify the Google Sheet containing your 'Main Character' and 'Opponents' data. Ensure the 'Status' column is set to 'To Do' for rows you want to process.
- Set Up AI Nodes: Configure the 'Scene Creator' and 'Image Prompt Generator' nodes with appropriate AI models (e.g., GPT-4.1-mini via OpenRouter) and ensure your system prompts are correctly defined.
- Set Up Creatomate Node: Obtain your Creatomate API key and template ID. Update the 'Render Video' node with these credentials and the correct template, ensuring the JSON body matches your Creatomate template's structure.
- Map Data: Ensure the 'Set' nodes correctly map the output from the Google Sheets node to the AI nodes and that the 'Split Out' and 'Merge' nodes correctly handle the opponent data.
- Test and Execute: Run the workflow to generate a video. Monitor the execution to troubleshoot any API or data mapping issues.
Apps Used
Workflow JSON
{
"id": "c36bc7d9-8a07-4a17-a9df-bcdc555c8070",
"name": "Automated VS Video Creator from Google Sheets",
"nodes": 0,
"category": "Content Creation Automation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: c36bc7d9-8a07...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Google Sheets + Telegram(118 workflows)
- Execute Workflow Trigger + Google Sheets(101 workflows)
Related Workflows
Discover more workflows you might like
Easy WordPress Content Creation from PDF Document + Human In The Loop with Gmail Approval
Transform PDF documents into WordPress blog posts with an automated workflow that includes human review via Gmail.
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Automate Meta Ad Uploads: Google Drive to Ads Manager Workflow
This n8n workflow automates the entire process of uploading video and image ad creatives from Google Drive to Meta Ads Manager, with ad details managed via Google Sheets, significantly streamlining your ad campaign deployment.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.
Google Calendar to Sheets Sync: Real-time Event Tracking
This n8n workflow automates the real-time synchronization of your Google Calendar events directly into a Google Sheet. It intelligently checks for new and updated events, ensuring your spreadsheet always has the most current and accurate information without manual data entry.
Intelligent AI Assistant for Airtable Data Management
Leverage the power of AI with this n8n workflow to create an intelligent assistant that interacts with your Airtable data. Seamlessly query, retrieve, and process information using natural language commands.