Bulk auto-publish videos to social networks with AI copy and client approval
This workflow automates batch video publishing prep from a Google Drive folder with AI-generated, platform-specific copy and a simple approval queue in Google Sheets. Perfect for Agencies, content creators or Teams --- What This Workflow Does Fetches videos from a Google Drive folder You provide a folder ID and the workflow lists all files, filtering to keep only .mp4. Builds a simple publishing calendar You configure: Start date Cadence (daily, 5/week, 3/week) Timezone One Publish Hour shared across all selected platforms The workflow creates: Schedule Date Schedule DateTime for each video Analyzes each video with AI Gemini performs a structured analysis of the video to understand: What happens in the content Key topics Tone Audience intent Generates platform-specific social copy For each video, the AI creates unique text for: TikTok Instagram Reels YouTube Shorts The prompts are language-aware: If the video is in English, the titles/descriptions are generated in English. If the video is in Spanish, they are generated in Spanish. Saves everything to Google Sheets as drafts Each video becomes one row with: Titles, descriptions, hashtags/tags A single shared Schedule DateTime Status = draft Auto-publishes approved rows (Flow 2) Every hour: Loads the sheet Filters rows where Status = approved Downloads the Drive file Schedules the video to the selected platforms Updates Status = scheduled --- Sheet Structure The tracking sheet is designed to be a clean approval queue. Recommended columns: Video ID Video Name Index Status Schedule Date Schedule DateTime TikTok Title TikTok Description TikTok Hashtags Instagram Title Instagram Description Instagram Hashtags YouTube Title YouTube Description YouTube Tags Summary Profile Platforms Created At --- How Approval Works New rows start as draft. You revise any copy directly in Sheets. When ready, change Status to approved. Flow 2 schedules the video and updates the row. --- Requirements Google Drive access Google Sheets access Gemini API key Upload-Post account with connected social profiles --- Installation & Setup Create your tracking sheet Copy this sheet in your drive https://docs.google.com/spreadsheets/d/1cegJHxj7Kx4Tg8gMr3uixpzToNc62VEvuuz37iFvnRw/edit?usp=sharing Connect credentials in n8n Google Drive OAuth Google Sheets OAuth Gemini credentials Upload-Post credentials Run the form Provide: Drive Folder ID Profile Username Platforms Timezone Start Date Cadence Publish Hour Google Sheet ID If you want to explore the API used for publishing These docs can help for custom extensions: social media API --- Ideal Use Cases Creators batching Shorts/Reels/TikToks and wanting a single approval queue Agencies that need a simple client-friendly review workflow Teams building internal content ops with predictable scheduling --- Notes This version keeps scheduling simple with one Schedule DateTime per video shared across all selected platforms. If you later want per-platform times, extend the calendar builder to generate separate datetimes again.
By Juan Carlos Cavero GraciaCreate Branded Social Media Images with Bannerbear (Sync/Async modes)
Automatically create branded social media graphics, certificates, thumbnails, or marketing visuals using Bannerbear's template-based image generation API. Bannerbear's API is primarily asynchronous by default: this workflow shows you how to use both asynchronous (webhook-based) and synchronous modes depending on your needs. What it does This workflow connects to Bannerbear's API to generate custom images based on your pre-designed templates. You can modify text, colors, and other elements programmatically. By default, Bannerbear works asynchronously: you submit a request, receive an immediate 202 Accepted response, and get the final image via webhook or polling. This workflow demonstrates both the standard asynchronous approach and an alternative synchronous method where you wait for the image to be generated before proceeding. How it works Set parameters - Configure your Bannerbear API key, template ID, and content (title, subtitle) Choose mode - Select synchronous (wait for immediate response) or asynchronous (standard webhook delivery) Generate image - The workflow calls Bannerbear's API with your modifications Receive result - Get the image URL, dimensions, and metadata in PNG or JPG format Async mode (recommended): The workflow receives a pending status immediately, then a webhook delivers the completed image when ready. Sync mode: The workflow waits for the image generation to complete before proceeding. Setup requirements A Bannerbear account (free tier available) A Bannerbear template created in your dashboard Your API key and template ID from Bannerbear For async mode: ability to receive webhooks (production n8n instance) How to set up Get Bannerbear credentials: Sign up at bannerbear.com Create a project and design a template Copy your API key from Settings > API Key Copy your template ID from the API Console Configure the workflow: Open the "SetParameters" node Replace the API key and template ID with yours Customize the title and subtitle text Set call_mode to "sync" or "async" For async mode (recommended): Activate the "Webhook_OnImageCreated" node Copy the production webhook URL Add it to Bannerbear via Settings > Webhooks > Create a Webhook Set event type to "image_created" Customize the workflow Modify the template parameters to match your Bannerbear template fields Add additional modification objects for more dynamic elements (colors, backgrounds, images) Connect to databases, CRMs, or other tools to pull content automatically Chain multiple image generations for batch processing Store generated images in Google Drive, S3, or your preferred storage Use async mode for high-volume generation without blocking your workflow
By Elodie TasiaAutomate tax compliance validation with OpenAI anomaly detection & accounting integration
How It Works Automates revenue data validation and intelligent anomaly detection with scheduled weekly processing. Fetches revenue data, applies dual OpenAI models for categorization and anomaly detection, identifies outliers or suspicious patterns, and synchronizes clean data with accounting software. Includes correction workflow through Connection Agent for data quality remediation. System generates compliance summaries and automatically sends reports to tax agents via Gmail. Designed for accounting firms, tax professionals, and finance teams requiring enterprise-grade data validation, fraud detection, and regulatory compliance without manual review bottlenecks. Setup Steps Configure OpenAI API keys for categorization and anomaly detection models Connect revenue data source and accounting software via Connection Agent Define anomaly detection thresholds and categorization Set email templates for tax agent communication Configure weekly schedule trigger timing Prerequisites OpenAI API key, accounting software credentials, revenue data source connectivity, Gmail account Use Cases Accounting firm multi-client processing, monthly/quarterly tax compliance Customization Adjust anomaly thresholds per business rules, customize categorization rules for industry standards Benefits Reduces data validation time by 85%, eliminates manual categorization errors, detects fraud patterns
By Cheng Siong Chin