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 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.
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.
AI-Powered Stack Overflow Lead Generation
Unleash the power of AI to automatically scrape valuable lead data from Stack Overflow user profiles. This workflow intelligently identifies and extracts key information like names, locations, skills, and reputation, then seamlessly organizes it into your Google Sheet for effortless lead management.
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.
Automate EU Legislation Monitoring for Sustainability Insights
This n8n workflow automates the tracking of European Parliament legislative procedures, using AI to identify sustainability-related debates. It efficiently organizes these key insights by saving them to a Google Sheet and creating actionable study tasks in Google Tasks, perfect for policy analysts and advocacy groups.