by Oneclick AI Squad
This n8n workflow monitors blood stock levels daily and sends alerts when availability is low. It fetches data from a Google Sheet, checks stock status, and notifies via WhatsApp. Key Features Daily Monitoring**: Checks blood stock every day. Automated Alerts**: Sends notifications when stock is low. Real-Time Updates**: Uses live data from Google Sheets. Efficient Delivery**: Alerts sent instantly via WhatsApp. Continuous Check**: Loops to ensure ongoing monitoring. Workflow Process Daily Check Blood Stock: Triggers the workflow daily. Fetch Blood Stock: Reads data from a Google Sheet. Get All Stock: Collects all available blood stock details. Check Stock Availability: Analyzes stock levels for low thresholds. Send Alert Message: Sends WhatsApp alerts if stock is low. Sheet Columns Blood Type**: Type of blood (e.g., A+, O-). Quantity**: Current stock amount. Threshold**: Minimum acceptable stock level. Last Updated**: Date and time of last update. Status**: Current status (e.g., Low, Sufficient). Setup Instructions Import Workflow**: Add the workflow to n8n via the import option. Configure Sheet**: Set up a Google Sheet with blood stock data. Set Up WhatsApp**: Configure WhatsApp API credentials in n8n. Activate**: Save and enable the workflow. Test**: Simulate low stock to verify alerts. Requirements n8n Instance**: Hosted or cloud-based n8n setup. Google Sheets**: Access with stock data. WhatsApp API**: Integration for sending alerts. Admin Access**: For monitoring and updates. Customization Options Adjust Threshold**: Change low stock limits. Add Channels**: Include email or SMS alerts. Update Frequency**: Modify daily trigger time.
by Calvin Cunningham
AI-Assisted Lead Follow-Up With Human Approval This workflow automates your lead response process from end to end. When someone submits your n8n Form, the workflow generates an AI-written follow-up email, sends that draft to your sales team for approval, and then sends the approved email to the lead or marks it as needing revision. All lead details, drafts, approval decisions, and timestamps are stored in Airtable. Ideal For Teams that want AI to draft emails while keeping a human approval step Businesses receiving inbound inquiries that need fast, consistent responses Users building a simple form โ email โ CRM workflow Teams that want a record of all drafts and approval outcomes What This Template Provides AI-generated follow-up email drafts Human approval flow, using Approve and Reject links Automatic Airtable logging of leads, drafts, and statuses Fully automated pipeline triggered by a simple form submission Setup Steps (5โ10 minutes) Connect Your Credentials Gmail Airtable OpenAI Create Your Airtable Table Use the following fields: Name Email Phone Company Name Message Status Email Draft Created On Add Your Airtable Base ID and Table ID Insert them into the Workflow Configuration node. Enter Your Company Details Add your: Name Title Company name Email Phone number Website Etc. These values will appear in the final approved email sent to the lead. Set the Sales Approval Email Specify the email address where draft approval requests should be sent. Deploy the Approval Webhook Switch the Webhook node to the Production URL, and confirm that the Approve and Reject links point to it. Publish Your n8n Form Submit a test lead to verify: AI draft generation Approval email delivery Airtable logging Final email sending Why Use This Template? This workflow creates a reliable, semi-automated follow-up process that blends AI speed with human judgment. It ensures consistent communication, maintains accurate CRM records, and reduces manual work without requiring a full CRM platform.
by Davide
๐คน๐ค This workflow (AI Document Generator with Anthropic Agent Skills and Uploading to Google Drive) automates the process of generating, downloading, and storing professionally formatted files (PDF, DOCX, PPTX, XLSX) using the Anthropic Claude API and Google Drive. This workflow connects user prompts with the Anthropic API to generate professional documents in multiple formats, automatically retrieves and uploads them to Google Drive โ providing a complete AI-powered document automation system. Key Advantages โ Full Automation** From user input to file delivery, the entire pipeline โ creation, extraction, download, and upload โ runs without manual intervention. โ Multi-Format Support** Handles four major business document types: PPTX (Presentations) PDF (Reports) DOCX (Documents) XLSX (Spreadsheets) โ Professional Output** Each format includes tailored Claude system prompts with detailed formatting and design principles: Layout structure Typography Visual hierarchy Consistency and readability This ensures that every file produced follows professional standards. โ Easy Customization** You can modify the prompt templates or add new Skills using the โGet All Skillsโ node. The form and switch logic make it simple to extend with additional file types or workflows. โ Seamless Cloud Integration** Generated files are automatically uploaded to a Google Drive folder, enabling: Centralized storage Easy sharing and access Automatic organization โ Reusable and Scalable** This workflow can be used as a foundation for: Automated report generation Client deliverables Internal documentation systems AI-driven content creation pipelines How it Works This n8n workflow enables users to create professional documents using Anthropic's Claude AI and automatically save them to Google Drive. The process works as follows: Form Trigger: The workflow starts with a web form where users submit a prompt and select their desired file type (PPTX, PDF, DOCX, or XLSX). Document Type Routing: A switch node routes the request based on the selected file type to the appropriate document creation node. AI Document Generation: Each document type has a dedicated HTTP Request node that calls Anthropic's Messages API with: Specific system prompts tailored for each document type (PowerPoint, PDF, Word, or Excel) The user's input prompt Appropriate Anthropic skills (pptx, pdf, docx, xlsx) for specialized document creation Code execution capabilities for complex formatting File ID Extraction: Custom JavaScript code nodes extract the generated file ID from Anthropic's response using recursive search algorithms to handle nested response structures. File Download: HTTP Request nodes download the actual file content from Anthropic's Files API using the extracted file ID. Cloud Storage: Finally, the downloaded files are automatically uploaded to a specified Google Drive folder, organized and ready for use. Set Up Steps API Configuration: Set up HTTP Header authentication with Anthropic API Add x-api-key header with your Anthropic API key Configure required headers: anthropic-version and anthropic-beta Google Drive Integration: Connect Google Drive OAuth2 credentials Specify the target folder ID where documents will be uploaded Ensure proper permissions for file upload operations Custom Skills (Optional): Use the "Get All Skills" node to retrieve available custom skills Update skill_id fields in JSON bodies if using custom Anthropic skills Modify the form dropdown to include custom skill options if needed Form Configuration: The form is pre-configured with prompt field and file type selection No additional setup required for basic functionality Execution: Activate the workflow Access the form trigger URL Submit prompts and select desired output formats Generated files will automatically appear in the specified Google Drive folder The workflow handles the entire process from AI-powered document creation to cloud storage, providing a seamless automated solution for professional document generation. Need help customizing? Contact me for consulting and support or add me on Linkedin.
by Gilbert Onyebuchi
Capture leads from Tally forms to Google Sheets CRM This workflow automates lead intake by capturing form submissions, enriching them with smart tags and scores, storing them in a Google Sheets CRM, and sending personalized welcome emails. Who's it for This template is perfect for solopreneurs, small agencies, and marketing consultants who need a simple yet powerful CRM system without paying for expensive tools like HubSpot or Salesforce. If you're collecting leads through forms and manually copying data to spreadsheets, this automation will save you hours every week. What it does When someone submits your Tally lead capture form, this workflow automatically: Generates a unique lead ID and timestamps the entry Analyzes their responses to assign relevant service tags (Podcast Lead, Social Content Lead, Video Editing Lead, etc.) Calculates an initial lead score based on interest level Determines the next follow-up date automatically Appends all data to your Google Sheets CRM with proper formatting Logs the activity in a separate tracker sheet Sends a personalized welcome email tailored to their interests Updates the lead status to "Nurturing" Requirements Apps & Services: Google Sheets (for your CRM database) Tally.so or Google Forms (for lead capture) SendGrid account (free tier works) for email sending n8n instance (cloud or self-hosted) Setup needed: Create the Google Sheets CRM structure (4 sheets: Leads, Email Sequence Tracker, Activity Log, Dashboard Data) Set up your Tally form with fields: Name, Email, Business Type, Interest Level, Services Needed Configure SendGrid API credentials in n8n Connect your Google Sheets account to n8n How to set up Copy the Google Sheets template with all four sheets (Leads, Email Sequence Tracker, Activity Log, Dashboard Data) and set up column headers as specified Create your Tally form at tally.so with the required fields, then grab the webhook URL from n8n Import this workflow into your n8n instance Configure credentials for Google Sheets and SendGrid Update the webhook URL in your Tally form settings Customize the welcome email in the "Generate Welcome Email" node with your branding Test with a sample submission to verify everything flows correctly Activate the workflow and start capturing leads How to customize Modify service tags: Edit the serviceTagMap object in the "Auto-Tag Lead" node to match your specific services. Adjust lead scoring: Change the scoring logic in "Calculate Initial Dates & Score" to prioritize different interest levels or sources. Personalize emails: Update the email templates in "Generate Welcome Email" to match your brand voice and add specific resources or links. Add more integrations: Extend the workflow with Slack notifications, SMS alerts via Twilio, or sync to other tools like Notion or Airtable. Change follow-up timing: Modify the daysToAdd calculation to adjust when leads receive their next touchpoint. Add conditional paths: Use IF nodes to route different lead types to different email sequences or team members.
by Davide
This workflow automates the process of estimating a personโs fashion size from an uploaded image using an AI model. This workflow is an automated pipeline that uses an AI model to estimate a person's body measurements and clothing size from an image URL. Key Features ๐ Full Automation** โ From image submission to result display, the process requires no manual steps. โ๏ธ Easy Integration** โ Uses n8nโs native nodes and simple HTTP requests to connect with Fal.aiโs API. ๐ Real-Time Processing** โ Automatically waits and checks for the AI result, ensuring the user receives the output as soon as itโs ready. ๐งฉ Modular Design** โ Each step (submit โ process โ check โ result) is clearly separated, making it easy to modify or extend (e.g., adding notifications or storing results in a database). ๐ก User-Friendly Interface** โ The initial form and final result form make it accessible even for non-technical users. ๐ Secure** โ Authentication to the Fal.ai API is handled through HTTP header authorization, keeping API keys protected. How it works Form Trigger: The workflow starts with a public form where a user submits a URL of an image. AI Processing Request: The submitted image URL is sent to the fal.run AI service (specifically, the "fashion-size-estimator" model) via a POST request. This initial request places the job in a queue and returns a unique request_id. Polling for Completion: The AI processing is asynchronous and takes some time. The workflow enters a loop where it: Waits: Pauses for 10 seconds to give the AI model time to process the request. Checks Status: Uses the request_id to check the status of the job. Conditional Check: An IF node checks if the status is "COMPLETED". If NO (not completed), the loop repeats (wait, then check again). If YES, the workflow exits the loop. Fetching and Displaying Results: Once processing is complete, the workflow retrieves the final result (containing the size, height, bust, waist, and hip measurements) and automatically displays it to the user on a "thank you" page. Set up steps To make this workflow operational, you need to configure the API authentication. Obtain an API Key: Create an account at fal.ai Navigate to your account settings to generate an API key. Configure Credentials in n8n: In your n8n instance, create a new HTTP Header Auth credential (you can name it "Fal.run API"). Set the Name field to Authorization. Set the Value field to Key YOURAPIKEY, replacing "YOURAPIKEY" with the actual key you obtained from fal.ai. Ensure this credential is correctly selected in the three HTTP Request nodes: "Send image to estimator", "Get status", and "Get result". Need help customizing? Contact me for consulting and support or add me on Linkedin.
by Eddy Medina
What does this workflow do? This workflow exports the names of all Dialogflow intents from your agent, together with their priority levels, directly into a Google Sheets spreadsheet. It is triggered via Telegram and includes visual indicators (emojis) for priority levels. ๐ Overview ๐ Activation**: Triggered when a validated user sends the keyword (e.g. "backup") via Telegram. ๐ฅ Data Retrieval**: Fetches all intents of the specified Dialogflow agent using the Dialogflow API. โ๏ธ Processing**: Transforms each intent into an n8n-compatible item. Extracts the displayName and priority of each intent. Assigns an emoji and descriptive label based on priority tier: ๐ด Highest, ๐ High, ๐ต Normal, ๐ข Low, ๐ซ Ignore. ๐ Storage**: Appends each intent (name, priority number, emoji, and description), along with current date and time, to a Google Sheets document. ๐ฉ Notification**: Sends a single confirmation message to the Telegram user once insertion is complete (using Execute Once). ๐ ๏ธ How to install and configure Import the workflow: Upload the .json into your n8n instance. Connect Telegram: Add your Telegram bot credentials and configure the node Validaciรณn de usuario por ID with your Telegram ID. Configure Dialogflow: Authenticate using a Google Service Account API Credential. Then, in the Obtiene datos de los intents node, replace the example project ID (TU_PROJECT_ID) with your actual Dialogflow agent's project ID. Connect Google Sheets: Authorize Google Sheets via OAuth2 and select your destination document/sheet in the node Aรฑadir fila en la hoja. Customize trigger keyword: Adjust the command text (default "backup") if needed. Activate workflow: Ensure the webhook is correctly set up in Telegram before enabling the workflow. ๐ฅ Who is this for? ๐ค Bot administrators who need quick backups of Dialogflow intent names. ๐ Teams managing multilingual or multi-intent agents wanting priority oversight. ๐ป Development teams needing an automated way to audit or version intent configurations regularly. ๐ก Use Cases โ๏ธ Backup intents periodically to monitor changes over time. ๐ Visualize priority assignment in a spreadsheet for analysis or team discussion. ๐ Document conversational structure for onboarding or knowledge transfer.
by Intuz
This n8n template from Intuz provides a complete solution to automate your accounting by instantly creating QuickBooks sales receipts for every new Stripe payment. This workflow automates the process of recording successful payments from Stripe into QuickBooks by creating corresponding Sales Receipts. It ensures payment data is captured accurately, checks whether the customer exists in QuickBooks, and creates a new customer if necessary before generating the receipt. This integration streamlines bookkeeping by eliminating manual data entry and ensuring all payment records are synchronized between systems. Who's this workflow for? Accountants & Bookkeepers Small Business Owners E-commerce Managers Finance Teams How it works 1. Trigger on Successful Payment: The workflow starts instantly when a payment_intent.succeeded event is received from Stripe via a webhook. This means it only runs after a payment is confirmed. 2. Get Customer Details: It uses the customer ID from the payment to fetch the customer's full details (name and email) from Stripe. 3. Check for Customer in QuickBooks: The workflow then searches your QuickBooks account to see if a customer with that name already exists. 4. Create Customer if New: If the customer is not found in QuickBooks, a new customer record is automatically created using the information from Stripe. 5. Generate Sales Receipt: Finally, using the correct customer record (either existing or newly created) and the payment amount, the workflow creates and saves a new sales receipt in QuickBooks, perfectly matching the Stripe transaction. Key Requirements to Use This Template 1. n8n Instance: An active n8n account (Cloud or self-hosted). 2. Stripe Account: An active Stripe account with API access. You must be able to create and manage webhooks. 3. QuickBooks Online Account: An active QuickBooks Online account with API access to manage customers and sales receipts. Setup Instructions 1. Configure the Webhook Trigger: Copy the webhook URL from the Capture Payment (Webhook) node in n8n. In your Stripe dashboard, go to Developers > Webhooks and add a new endpoint. Paste the n8n webhook URL and have it listen for the payment_intent.succeeded event. 2. Connect Stripe: In the Get a customer node, connect your Stripe account credentials. 3. Connect QuickBooks: In all three QuickBooks nodes (Find Customer, Create a customer, and Create a payment), connect your QuickBooks Online account using OAuth2 credentials. 4. Activate Workflow: Save the workflow and toggle the "Active" switch to ON. Your accounting automation is now live! Connect with us Website: https://www.intuz.com/services Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started
by David Hernรกndez Lujรกn
Whoโs it for This workflow is for system administrators or self-hosted n8n users who want to automatically check and update their n8n instance to the latest version โ with Telegram notifications for every step. How it works The workflow runs daily at 9 AM or every time n8n starts. It retrieves your current version using the Execute Command node. It checks the latest release from the official n8n GitHub API. It compares both versions and decides whether an update is needed. If an update is available: Sends a Telegram alert. Verifies that there are no running executions. Runs the update command safely. Sends a confirmation message when done. If your instance is already up to date, it sends a โlatest versionโ message instead. Requirements Self-hosted n8n** instance with access to run terminal commands. A valid Telegram Bot API credential (configured in n8n Credentials; not hardcoded). SSH credentials** To run commands on the server where n8n is installed n8n API credentials** To query running executions How to set up Import this workflow into your n8n instance. Connect your Telegram Bot credential to the Telegram nodes. Adjust the chat ID and message thread ID if needed. (Optional) Change the schedule time in the Schedule Trigger node. Save and activate the workflow. How to customize Change the update command if youโre running n8n via Docker: docker pull n8nio/n8n:latest
by Fahmi Fahreza
Analyze Trustpilot & Sitejabber sentiment with Decodo + Gemini to Sheets Sign up for Decodo HERE for Discount This template scrapes public reviews from Trustpilot and Sitejabber with a Decodo tool, converts findings into a flat, spreadsheet-ready JSON, generates a concise sentiment summary with Gemini, and appends everything to Google Sheets. Itโs ideal for reputation snapshots, competitive analysis, or lightweight BI pipelines that need structured data and a quick narrative. Whoโs it for? Marketing teams, growth analysts, founders, and agencies who need repeatable review collection and sentiment summaries without writing custom scrapers or manual copy/paste. How it works A Form Trigger collects the Business Name or URL. Set (Config Variables) stores business_name, spreadsheet_id, and sheet_id. The Agent orchestrates the Decodo tool and enforces a strict JSON schema with at most 10 reviews per source. Gemini writes a succinct summary and recommendations, noting missing sources with: โThereโs no data in this website.โ A Merge node combines JSON fields with the narrative. Google Sheets appends a row. How to set up Add Google Sheets, Gemini, and Decodo credentials in Credential Manager. Replace (YOUR_SPREADSHEET_ID) and (YOUR_SHEET_ID) in Set: Config Variables. In Google Sheets, select Define below and map each column explicitly. Keep the parser and agent connections intact to guarantee flat JSON. Activate, open the form URL, submit a business, and verify the appended row.
by SpaGreen Creative
Automated WhatsApp Welcome Messages for Sales Leads with Google Sheets & Rapiwa Who is this for? This automation is ideal for sales teams, digital marketers, support agents, or small business owners who collect leads in Google Sheets and want to automatically send WhatsApp welcome messages. It's a cost-effective and easy-to-use solution built for those not using the official WhatsApp Business API but still looking to scale communication. What this Workflow Does This n8n automation reads leads from a connected Google Sheet, verifies if the provided WhatsApp numbers are valid using the Rapiwa API, and sends a personalized welcome message. It updates the sheet based on delivery success or failure, and continues this process every 5 minutes โ ensuring new leads are automatically engaged. Key Features Automatic Scheduling**: Runs every 5 minutes (adjustable) Google Sheets Integration**: Reads and updates lead data WhatsApp Number Validation**: Confirms number validity via Rapiwa Personalized Messaging**: Uses lead name for custom messages Batch Processing**: Sends up to 60 messages per cycle Safe API Usage**: Adds 5-second delay between each message Error Handling**: Marks failed messages as not sent and unverified Live Status Updates**: Sheet columns are updated after each attempt Loop Logic**: Repeats continuously to catch new rows How to Use Step-by-step Setup Prepare Your Google Sheet Copy this Sample Sheet Ensure it includes the following columns: WhatsApp No name (note: trailing space is required) row_number status, check, validity Connect Google Sheets in n8n Use OAuth2 credentials to allow n8n access Set the workflow to fetch rows where check is not empty Get a Rapiwa Account Sign up at https://rapiwa.com Add your WhatsApp number Retrieve your Bearer Token from your Rapiwa dashboard Configure HTTP Request Nodes Use Rapiwa's API endpoints: Verify Number: https://app.rapiwa.com/api/verify-whatsapp Send Message: https://app.rapiwa.com/api/send-message Add your Bearer Token to the header Start Your Workflow Run the n8n automation It will read leads, clean phone numbers, verify WhatsApp validity, send messages, and update the sheet accordingly Requirements A Google Sheet with correctly formatted columns Active Rapiwa subscription (~$5/month) A valid Bearer Token from Rapiwa Your WhatsApp number connected to Rapiwa n8n instance with: Google Sheets integration (OAuth2 setup) HTTP Request capability Google Sheet Column Reference | name | number | email | time | check | validity | status | |-----------------|--------------|-------------------|-----------------------------|---------|------------|-----------| | Abdul Mannan | 8801322827799| contact@spagreen.net| September 14th 2025, 10:34 | checked | verified | sent | | Abdul Mannan | 8801322827798| contact@spagreen.net| September 14th 2025, 10:34 | checked | unverified | not sent | Workflow Logic Summary Trigger Every 5 Minutes Fetch All Rows with Pending Status Limit to 60 Rows per Execution Clean and Format Phone Numbers Check Number Validity via Rapiwa Condition Check: If valid โ Send Message If invalid โ Update status as not sent, unverified Send WhatsApp Message via Rapiwa Update Sheet Row On success: sent, verified, checked On failure: not sent, unverified Delay 5 seconds before next message Repeat for next lead Customization Ideas Add image or document sending support via Rapiwa Customize messages based on additional fields (e.g., product, service) Log failures to a separate sheet Send admin email for failed batches Add support for multilingual messages Notes & Warnings The column name "name " includes a space โ do not remove or rename it. International number format is required for Rapiwa to work correctly. If you're sending many messages, increase the Wait node delay to prevent API throttling. Support WhatsApp Support: Chat Now Discord: Join SpaGreen Community Facebook Group: SpaGreen Support Website: https://spagreen.net Developer Portfolio: Codecanyon SpaGreen
by Rahul Joshi
๐ Description This workflow automatically classifies new Stack Overflow questions by topic, generates structured FAQ content using GPT-4o-mini, logs each entry in Google Sheets, saves formatted FAQs in Notion, and notifies your team on Slack โ ensuring your product and support teams stay aligned with real-world developer discussions. ๐ค๐ฌ๐ โ๏ธ What This Template Does Step 1: Monitors Stack Overflow RSS feeds for new questions related to your selected tags. โฑ๏ธ Step 2: Filters out irrelevant or incomplete questions before processing. ๐งน Step 3: Uses OpenAI GPT-4o-mini to classify each question into a topic category (Frontend, Backend, DevOps, etc.). ๐ง Step 4: Generates structured FAQ content including summaries, technical insights, and internal guidance. ๐ Step 5: Saves formatted entries into your Notion knowledge-base database. ๐ Step 6: Logs all FAQ data into a connected Google Sheet for analytics and tracking. ๐ Step 7: Sends real-time Slack notifications with quick links to the new FAQ and the original Stack Overflow post. ๐ Step 8: Provides automatic error detection โ any failed AI or Notion step triggers an instant Slack alert. ๐จ ๐ก Key Benefits โ Builds a continuously updated, AI-driven knowledge base โ Reduces repetitive support and documentation work โ Keeps product and dev teams aware of trending community issues โ Enhances internal docs with verified Stack Overflow insights โ Maintains an audit trail via Google Sheets โ Alerts your team instantly on errors or new FAQs ๐งฉ Features Automatic Stack Overflow RSS monitoring Dual-layer OpenAI integration (Topic Classification + FAQ Generation) Structured Notion database integration Google Sheets logging for analytics Slack notifications for new FAQs and error alerts Custom tag-based question filtering Near real-time updates (every minute) Built-in error handling for reliability ๐ Requirements OpenAI API Key (GPT-4o-mini access) Notion API credentials with database access Google Sheets OAuth2 credentials Slack bot token with chat:write permissions Stack Overflow RSS feed URL for your preferred tags ๐ฅ Target Audience SaaS or product teams building internal FAQ and knowledge systems Developer relations and documentation teams Customer-support teams automating knowledge reuse Technical communities curating content from Stack Overflow ๐งญ Setup Instructions Add your OpenAI API credentials in n8n. Connect your Notion database and update the page or database ID. Connect Google Sheets credentials and select your tracking sheet. Connect your Slack account and specify your notification channel. Update the RSS Feed URL with your chosen Stack Overflow tags. Run the workflow manually once to test connectivity, then enable automation.
by Jadai kongolo
Author: Jadai Kongolo Overview This comprehensive n8n workflow automates the entire production pipeline for creating viral "versus" style battle videos. The system generates dramatic AI-powered fight scenes between animals (or any characters you choose), complete with photorealistic imagery, cinematic effects, and automatic multi-platform publishing. Perfect for content creators looking to generate engaging short-form content at scale without manual editing or design work. Use Cases Viral Social Media Content: Automatically produce trending "X vs Y" battle videos that perform exceptionally well on TikTok, Instagram Reels, and YouTube Shorts. These comparison-style videos consistently generate high engagement and shares. Educational Entertainment: Create visually stunning educational content comparing animals, historical figures, sports teams, or any competitive matchups while maintaining viewer interest through dramatic AI-generated imagery. Automated Content Pipeline: Build a hands-free content factory that can produce multiple videos per day on schedule, complete with automatic posting to all major social platforms through integrated social media management tools. ๐ check out the UGC version of this here How It Works Stage 1 - Scene Generation The workflow begins by fetching a main character from your Google Sheets database (filtered by "To Do" status). An AI agent powered by GPT-4.1-mini then generates eight unique opponents from your specified category, ensuring each comes from a different environment or background for maximum variety and interest. Stage 2 - AI Image Creation The system creates three distinct types of images for each matchup: Close-Up Portraits: Generates fierce, intimidating close-up shots of both the main character and each opponent using Flux image generation through PiAPI. The AI creates hyper-realistic, photorealistic images showing each character roaring with detailed textures, dramatic lighting, and threatening expressions. Battle Aftermath Scenes: A separate AI agent determines the realistic winner based on each character's strengths, then generates a dramatic full-body scene showing the victor standing dominantly over the defeated opponent. These images include visible battle scars, wounds, and cinematic composition that makes the outcome unmistakably clear. The workflow includes intelligent polling mechanisms (90-second waits) to ensure all images are fully generated before proceeding, then aggregates and stores all image URLs in your Google Sheet for reference. Stage 3 - Video Assembly Using Creatomate's video rendering API, the workflow combines all generated images with background music and animated transitions into a polished final video. The template creates a fast-paced montage showing all eight battles with "VS" graphics and dynamic cuts timed to music beats. Stage 4 - Multi-Platform Publishing Once rendered, the video is automatically uploaded to Blotato's social media management platform and simultaneously published to: Instagram Reels** with optimized captions TikTok** with proper AI-generated content disclosure YouTube Shorts** as unlisted for review The workflow updates your Google Sheet with "Created" status and final video URL for tracking and analytics. Customization Options Content Themes Modify the Google Sheet to change from animals to any category: superheroes, historical warriors, vehicles, mythical creatures, sports teams, etc. Adjust AI prompts in the "Scene Creator" node to control opponent selection criteria Edit the "Image Prompt Generator" to customize visual style (fantasy, sci-fi, realistic, cartoon, etc.) Video Production Change video dimensions in "Generate Close Ups" and "Generate Scene" nodes for different platform requirements Replace the Creatomate template with your own design for different visual styles Swap background music by updating the music source URL in the "Render Video" node Adjust the number of battles per video (currently 8 scenes) Publishing Settings Configure posting schedules via the Schedule Trigger node Modify platform-specific settings (privacy levels, comments, duets) in Instagram/TikTok/YouTube nodes Add or remove social platforms by connecting additional Blotato API endpoints Customize captions using data from your Google Sheet AI Models Switch between different OpenRouter models for cost/quality tradeoffs Use GPT-4.1 for complex winner determination and GPT-4.1-mini for faster scene generation Experiment with different Flux models through PiAPI for various artistic styles Prerequisites Google Sheets**: Connected Google account with access to the workflow template OpenRouter API**: For GPT-4.1 and GPT-4.1-mini access PiAPI Account**: For Flux image generation (use referral code for bonus credits) Creatomate Account**: For video rendering with template access Blotato Account**: For multi-platform social media publishing (use promo code "NATE30" for 30% off for 6 months) ๐ ๏ธ Setup Guide Make a copy of this Google Sheet Template and connect it to the five Google Sheet nodes in the workflow: Get Main Character Add Close Ups Add Winner Get Elements Update Video Status Connect your OpenRouter API key to the two OpenRouter nodes in the "Output Parser & Chat Models" section: GPT 4.1-mini GPT 4.1 Create a PiAPI account and connect your API key to: Generate Close Ups Generate Scene Get Close Ups Get Winners Create a Creatomate account and connect your template ID and API key to the Render Video node. You can duplicate the same template shown in the video by using the source code linked in the same Skool post where you downloaded the workflow. Connect your Blotato account and get your API key to enable auto-publishing: Configure the Upload to Blotato node Add your account IDs to Instagram, TikTok, and YouTube nodes Customize the Schedule Trigger node to set your desired posting frequency (daily, weekly, etc.) The Generate authentic, influencer-style UGC videos on autopilot version of this AI video generator can be found here.