Workflow Templates

🛡 CyberScan – AI-Powered Vulnerability Scanner with Nessus, OpenAI, and Google Sheets 👤 Who’s it for Security teams, DevOps engineers, vulnerability analysts, and automation builders who want to eliminate repetitive Nessus scan parsing, AI-based risk triage, and manual reporting. Designed for orgs following NIST CSF or CISA KEV compliance guidelines. ⚙️ How it works / What it does Runs scheduled or manual scans via the Nessus API. Processes scan results and extracts asset + vulnerability data. Uses a custom AI-based risk metric (LEV) to triage findings into: 🚨 Expert review ✅ Self-healing 🕵️ Monitoring Automatically sends email alerts for critical CVEs. Exports daily summaries to Google Sheets (or your own BI system). Maps to NIST CSF (Identify, Protect, Detect, Respond, Recover). 🧰 How to set up Nessus: Add your Nessus API credentials and instance URL. Google Sheets: Authenticate your Google account. OpenAI / LLM: Use your API key if adding LLM triage or rewrite prompts. Email: Update SMTP credentials and alert recipient address. Set your targets: Adjust asset ranges or scan UUIDs as needed. ⚠️ All setup steps are explained in sticky notes inside the workflow. 📋 Requirements Nessus Essentials (Free) or Nessus Pro with API access. SMTP service (e.g. Gmail, Mailgun, SendGrid). Google Sheets OAuth2 credentials. Optional: OpenAI or other LLM provider for LEV scoring and CVE insights. 🛠 How to customize the workflow Swap Google Sheets with Airtable, Supabase, or PostgreSQL. Change scan logic or asset list to fit your internal network scope. Adjust AI scoring logic to match internal CVSS thresholds or KEV tags. Expand alerting logic to include Slack, Discord, or webhook triggers. 🔒 No sensitive data included. All credentials and sheet links are placeholders.

Who is this template for? This template is ideal for small businesses, agencies, and solo professionals who want to automate appointment scheduling and caller follow-up through a voice-based AI receptionist. If you’re using tools like Google Calendar, Airtable, and Vapi (Twilio), this setup is for you. What problem does this workflow solve? Manual call handling, appointment booking, and email coordination can be time-consuming and prone to errors. This workflow solves that by automating the receptionist role: answering calls, checking calendar availability, managing appointments, and storing call summaries—all without human intervention. What this workflow does This Agent Receptionist manages inbound voice calls and scheduling tasks using Vapi and Google Calendar. It checks availability, books or updates calendar events, sends email confirmations, and logs call details into Airtable. The workflow includes built-in logic for slot management, email triggers, and storing call transcripts. Setup Instructions Duplicate Airtable Base: Use this Airtable base templateBASE LINK Import Workflow: Load provided JSON into your n8n instance. Credentials: Connect your Google Calendar and Airtable credentials in n8n. Activate Workflow: Enable workflow to get live webhook URLs. Vapi Configuration: Paste provided system prompt into Vapi Assistant. Link the appropriate webhook URLs from n8n (GetSlots, BookSlots, UpdateSlots, CancelSlots, and end-of-call report). Disclaimer Optimized for cloud-hosted n8n instances. Self-hosted users should verify webhook and credential setups.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Overview This is a Telegram Bot capable of receiving information from the user in the form of text messages, voice messages, images or documents (e.g., presentations, PDFs, HTML pages), and publishing posts to the user's social platforms. The bot always sends the user a draft of the post for verification before publishing it. The bot saves relevant information to its long-term memory (vector store), so you don't need to repeat it in every interaction (e.g., who you are, your company, product, etc.). This template supports creating posts in LinkedIn and X. Setup Requirements To use this template your will need: Google's AI Studio API key. Get one here: https://aistudio.google.com/app/apikey Telegram Bot API key. You receive one when you register a new Telegram Bot via @BotFather bot in Telegram. LinkedIn API key. Follow the instructions here to create one: https://docs.n8n.io/integrations/builtin/credentials/linkedin/ X API key. Follow the instructions here to create one: https://docs.n8n.io/integrations/builtin/credentials/twitter/ Step-by-step instruction Import this template Create a new Telegram Bot or get an API key for existing one. Configre Telegram nodes with Telegram API key. Obtain a Google's AI Studio API key. Set it in "Describe document", "Describe audio" and "Google Gemini Chat Model". Create an API key for LinkedIn. Create an API key for X. Set our LinkedIn key in "Create post in LinkedIn" nodes. Set your X key in "Create X (Twitter) post" node. Other Bright-colored notes in the template highlight information that needs to be set before launching the template.

📄Description This automation workflow enables users to upload files via an N8N form, automatically analyzes the content using Google Gemini agents, and delivers the analyzed results via email along with a chatbot link. The system leverages Llama Cloud API, Google Gemini LLM, Pinecone vector database, and Gmail to provide a seamless, multilingual content analysis experience. ✅ Prerequisites Before setting up this workflow, ensure the following are in place: An active N8N instance. Access to Llama Cloud API. Google Gemini LLM API keys (for Translator & Analyzer agents). A Pinecone account with an active index. A Gmail account with API access configured. Basic knowledge of N8N workflow setup. ⚙️ Setup Instructions Deploy the N8N Form Create a public-facing form using N8N. Configure it to accept: File uploads. User email input. File Preprocessing Store the uploaded files temporarily. Organize and preprocess them as needed. Content Extraction using Llama Cloud API Feed the files into the Llama Cloud API. Extract and parse the content for further processing. Translation (if required) Use a Translator Agent (Google Gemini). Check if the content is in English. If not, translate it. Content Analysis Forward the (translated) content to the Analyzer Agent (Google Gemini). Perform deep analysis to extract insights. Vector Storage in Pinecone Store both: The parsed and translated content. The analyzed content. Use Pinecone to store the content as embeddings for chatbot use. User Notification via Gmail Send the analyzed content and chatbot link to the user’s provided email using Gmail API. 🧩 Customization Guidance To add more languages: Update the translation logic to include additional language support. To modify analysis depth: Adjust the prompts sent to the Gemini Analyzer Agent. To change the chatbot behavior: Retrain or reconfigure the chatbot to utilize the new Pinecone index contextually. 🔁 Workflow Summary User uploads files and email via N8N form. Files are parsed using Llama Cloud API. Content is translated (if needed) using Gemini Translator Agent. Translated content is analyzed by the Gemini Analyzer Agent. Parsed and analyzed data is stored in Pinecone. User receives email with analyzed results and a chatbot link.

AI Ad Scraper & Image Generator with Facebook Ad Library Categories: PPC Automation, Creative Generation, Competitive Intelligence This workflow creates an end-to-end ad library scraper and AI image spinner system that automatically discovers competitor ads, analyzes their design elements, and generates multiple unique variations ready for your own campaigns. Built to eliminate 60-70% of manual creative work for PPC agencies, this system transforms competitor research into actionable ad variants in minutes. Benefits Automated Competitor Research** - Scrapes Facebook Ad Library for active competitor campaigns automatically AI-Powered Creative Analysis** - Uses OpenAI vision to comprehensively analyze ad design elements and copy Intelligent Image Generation** - Creates 3+ unique variations per source ad while maintaining effective layouts Complete Asset Organization** - Automatically organizes source ads and generated variations in structured Google Drive folders Campaign-Ready Output** - Generates Google Sheets database with direct links to all assets for immediate campaign deployment Massive Time Savings** - Replaces hours of manual creative work with automated competitive intelligence and generation How It Works Facebook Ad Library Scraping: Connects to Facebook's Ad Library through Apify scraper integration Searches active ads based on keywords, industries, or competitor targeting Filters for image-based ads and removes video-only content for processing Intelligent Asset Organization: Creates unique Google Drive folder structure for each scraped ad campaign Separates source competitor ads from AI-generated variations Maintains organized asset library for easy campaign management and iteration AI-Powered Creative Analysis: Uses OpenAI's vision model to comprehensively describe each competitor ad Identifies design elements, color schemes, layout patterns, and messaging approaches Generates detailed creative briefs for intelligent variation generation Smart Image Variation System: Creates 3 unique style variations per source ad using advanced AI prompting Maintains effective layout structures while changing colors, fonts, and styling Customizes messaging and branding to match your business requirements Campaign Database Integration: Logs all source ads and generated variations in organized Google Sheets Provides direct links to all assets for immediate campaign deployment Tracks performance data and creative iterations for ongoing optimization Required Setup Configuration Google Drive Structure: The workflow automatically creates this folder organization: PPC Thievery (Parent Folder) ├── [Ad Archive ID] (Per Campaign) │ ├── 1. Source Assets (Original competitor ads) │ └── 2. Spun Assets (AI-generated variations) Google Sheets Database Columns: timestamp - Unique record identifier ad_archive_id - Facebook's internal ad identifier page_id - Advertiser's Facebook page ID original_image_url - Direct link to source competitor ad page_name - Advertiser's business name ad_body - Original ad copy text date_scraped - When the ad was discovered spun_prompts - AI-generated variation instructions asset_folder - Link to campaign's Google Drive folder source_folder - Link to original ads folder spun_folder - Link to generated variations folder direct_spun_image_link - Direct link to generated ad image Set Variables Configuration: Update these values in the "Set Variables" node: googleDriveFolderId - Your parent Google Drive folder ID changeRequest - Your brand-specific variation instructions spreadsheetId - Your Google Sheets database ID Apify API Setup: Create Apify account and obtain API key Replace <your-apify-api-key-here> with actual credentials Customize search terms in the JSON body for your target competitors Adjust scraping count (default: 20 ads per run) Business Use Cases PPC Agencies** - Automate competitive research and creative generation for client campaigns E-commerce Brands** - Monitor competitor advertising strategies and generate response campaigns Marketing Teams** - Scale creative production with AI-powered competitive intelligence Freelance Marketers** - Offer advanced competitive analysis and creative services to clients SaaS Companies** - Track competitor messaging and generate differentiated ad variations Agency Teams** - Replace manual creative research with automated competitive intelligence systems Revenue Potential This system revolutionizes PPC agency economics: 60-70% reduction** in manual creative work and competitive research time 3-5x faster** campaign launch times with ready-to-use creative assets $2,000-$5,000 service value** for comprehensive competitive intelligence and creative generation Scalable competitive advantage** through automated monitoring of competitor campaigns Premium positioning** offering AI-powered creative intelligence that competitors can't match manually Difficulty Level: Advanced Estimated Build Time: 2-3 hours Monthly Operating Cost: ~$100 (Apify + OpenAI + Google APIs) Watch My Complete Live Build Want to see me build this entire system from scratch? I walk through every component live - including the ad library integration, AI analysis setup, image generation pipeline, and all the debugging that goes into creating a production-ready competitive intelligence system. 🎥 See My Live Build Process: "Ad Library Scraper & AI Image Spinner System (N8N Build)" This comprehensive tutorial shows the real development process - including advanced AI prompting for image generation, competitive analysis strategies, and the organizational systems that make this scalable for agency use. Set Up Steps Initial Database Setup: Run the initialization flow once to create your Google Drive folder and Sheets database Copy the generated folder ID and spreadsheet ID into the "Set Variables" node Configure your brand-specific change request template for consistent output Apify Integration: Set up Apify account with Facebook Ad Library scraper access Configure API credentials and test with small ad batches Customize search parameters for your target competitors and industries AI Service Configuration: Connect OpenAI API for vision analysis and image generation Set up appropriate rate limiting to control processing costs Test the complete AI pipeline with sample competitor ads Google Services Setup: Configure Google Drive API credentials for automated folder creation Set up Google Sheets integration for campaign database management Test the complete asset organization and tracking workflow Campaign Customization: Define your brand guidelines and messaging requirements in the change request Set up variation templates for different campaign types and industries Configure batch processing limits based on your API usage requirements Production Optimization: Remove the limit node for full-scale competitive monitoring Set up automated scheduling for regular competitive intelligence gathering Monitor and optimize AI prompts based on generated creative quality Advanced Optimizations Scale the system with: Multi-Platform Scraping:** Extend to LinkedIn, Twitter, and Google Ads for comprehensive competitive intelligence Performance Tracking:** Integrate with ad platforms to track performance of generated variations Style Guide Automation:** Create industry-specific variation templates for consistent brand application A/B Testing Integration:** Automatically test generated variations against source ads for performance optimization CRM Integration:** Connect competitive intelligence data with sales and marketing systems Important Considerations API Rate Limits:** Built-in delays prevent service overload and ensure reliable operation Creative Quality:** System generates multiple variations to account for AI generation variability Legal Compliance:** Use generated variations as inspiration while respecting intellectual property rights Cost Management:** Monitor OpenAI image generation costs and adjust batch sizes accordingly Competitive Ethics:** Focus on learning from successful patterns rather than direct copying Why This System Works The competitive advantage lies in speed and scale: Minutes vs. Hours:** Generate campaign-ready creative variations in minutes instead of hours of manual work Systematic Analysis:** AI vision provides consistent, comprehensive analysis that humans might miss Organized Intelligence:** Structured asset management enables rapid campaign deployment and iteration Scalable Monitoring:** Automated competitive research that scales beyond manual capacity Quality Variations:** Multiple AI-generated options ensure high-quality creative output Check Out My Channel For more advanced automation systems and proven agency-building strategies that generate real revenue, explore my YouTube channel where I share the exact methodologies used to scale automation agencies to $72K+ monthly revenue.

Stock Analysis Agent (Hebrew, RTL, GPT-4o) Overview Get comprehensive stock analysis with this AI-powered workflow that provides actionable insights for your investment decisions. On a weekly basis, this workflow: Analyzes stock data from multiple sources (Chart-img, Twelve Data API, Alphavantage) Performs technical analysis using advanced indicators (RSI, MACD, Bollinger Bands, Resistance and Support Levels) Scans financial news from Alpha Vantage to capture market sentiment Uses OpenAI's GPT-4o to identify patterns, trends, and trading opportunities Generates a fully styled, responsive HTML email (with proper RTL layout) in Hebrew Sends detailed recommendations directly to your inbox Perfect for investors, traders, and financial analysts who want data-driven stock insights - combining technical indicators with news sentiment for more informed decisions. Setup Instructions Estimated setup time: 15 minutes Required credentials: OpenAI API Key Chart-img API Key (free tier) Twelve Data API Key (free tier) Alpha Vantage API Key (free tier) SMTP credentials (for email delivery) Steps: Import this template into your n8n instance. Add your API keys under credentials. Configure the SMTP Email node with: Host (e.g., smtp.gmail.com), Port (465 or 587), Username (your email), Password (app-specific password or login). Activate the workflow. Fill in the Form. Enjoy! (Check your Spam mailbox) Customization Tips Modify the analysis timeframe (daily, weekly, monthly) Add integrations with trading platforms or portfolio management tools Adjust the recommendation criteria based on your risk tolerance Why Use This? This is more than just stock data. It's an intelligent financial assistant that combines technical analysis with market sentiment to provide actionable recommendations - automatically. Important Note: This report is being generated automatically and does not constitute an investment recommendation. Please consult a licensed investment advisor before making any investment decisions.

Automatically create Google Tasks from new Gmail emails labeled "To-Do". Who is this for? This template is perfect for individuals and teams who want to boost their productivity by automatically converting important emails into actionable tasks in Google Tasks. What problem is this workflow solving? Manually managing emails and creating tasks can be tedious. This workflow ensures you never miss a follow-up by instantly turning important emails into tasks without switching between apps. What this workflow does? Watches for new emails in Gmail with the label "To-Do". Creates a new Google Task with the email subject as the task title and the email snippet as notes. Sets the task due date to 24 hours after the email is received. Setup Create a label "To-Do" in your Gmail account if it doesn't already exist. Connect your Gmail and Google Tasks accounts to n8n using OAuth2 credentials. Import the workflow into n8n and activate it. How to customize this workflow to your needs? Change the Gmail label to a different one (e.g., "Important", "Follow-up"). Modify the due date logic in the expression if you want more/less time to complete tasks: {{ $now.add(2, 'days').toISOString() }} Add additional Gmail filters (like only unread emails) to refine which emails create tasks.

In this guide, we’ll walk you through setting up an AI-driven workflow that automatically fetches daily sales, food waste, and customer feedback data from Google Sheets, generates actionable insights using AI, merges them into a comprehensive report, and sends it as an email draft. Ready to automate your restaurant’s daily insights? Let’s dive in! What’s the Goal? Automatically retrieve daily sales data, food waste records, and customer feedback from Google Sheets. Use AI to analyze data and generate insights, including top performers, waste reduction recommendations, and feedback summaries. Merge the insights into a structured daily report. Send the report as an AI-generated email draft for review or sending. Enable scheduled automation for daily insights delivery. By the end, you’ll have a self-running system that delivers daily restaurant insights effortlessly. Why Does It Matter? Manual data analysis and reporting are time-consuming and error-prone. Here’s why this workflow is a game-changer: Zero Human Error**: AI ensures accurate and consistent insights. Time-Saving Automation**: Instantly process data and draft reports, boosting efficiency. Scheduled Delivery**: Receive insights daily without manual effort. Actionable Insights**: Empower your team with data-driven decisions. Think of it as your tireless data analyst that keeps your restaurant informed. How It Works Here’s the step-by-step magic behind the automation: Step 1: Trigger the Workflow Initiate the workflow daily using the Daily Report Scheduler node (e.g., every day at a set time). Step 2: Fetch Daily Sales Data Retrieve sales data from the Google Sheet using the Fetch Daily Sales Data node. Step 3: Fetch Daily Food Waste Records Retrieve food waste data from the Google Sheet using the Fetch Daily Food Waste Records node. Step 4: Fetch Customer Feedback Retrieve customer feedback from the Google Sheet using the Fetch Customer Feedback node. Step 5: Normalize Sales Records Process and standardize sales data for AI analysis. Step 6: Normalize Waste Data Process and standardize food waste data for AI analysis. Step 7: Normalize Feedback Data Process and standardize customer feedback data for AI analysis. Step 8: AI Sales Insights Generator Use AI (e.g., Google Chat Model) to analyze sales data, identify top performers, and provide recommendations. Step 9: AI Waste Reduction Insights Generator Use AI to analyze waste data and suggest reduction strategies. Step 10: AI Feedback Summary Use AI to summarize customer feedback and identify common themes. Step 11: Format Sales Output Structure the sales insights into a readable format. Step 12: Format Waste Output Structure the waste reduction insights into a readable format. Step 13: Format Feedback AI Output Structure the feedback summary into a readable format. Step 14: Merge & Create Email Combine all formatted insights into a single daily report email draft. Step 15: Prepare Email Content Finalize the email content for sending. Step 16: Send Daily Report Send the AI-generated daily summary email via Gmail. How to Use the Workflow? Importing a workflow in n8n is a straightforward process that allows you to use pre-built workflows to save time. Below is a step-by-step guide to importing the Restaurant Daily Insights Automation workflow in n8n. Steps to Import a Workflow in n8n Obtain the Workflow JSON Source the Workflow: Workflows are shared as JSON files or code snippets, e.g., from the n8n community, a colleague, or exported from another n8n instance. Format: Ensure you have the workflow in JSON format, either as a file (e.g., workflow.json) or copied text. Access the n8n Workflow Editor Log in to n8n (via n8n Cloud or self-hosted instance). Navigate to the Workflows tab in the n8n dashboard. Click Add Workflow to create a blank workflow. Import the Workflow Option 1: Import via JSON Code (Clipboard): Click the three dots (⋯) in the top-right corner to open the menu. Select Import from Clipboard. Paste the JSON code into the text box. Click Import to load the workflow. Option 2: Import via JSON File: Click the three dots (⋯) in the top-right corner. Select Import from File. Choose the .json file from your computer. Click Open to import. Setup Notes Google Sheet Columns**: Sales Data Sheet: Date, Item Name, Quantity Sold, Revenue, Cost, Profit. Food Waste Records Sheet: Date, Item Name, Waste Quantity, Reason, Timestamp. Customer Feedback Sheet: Date, Customer Name, Feedback Text, Rating, Timestamp. Google Sheets Credentials**: Configure OAuth2 settings in the fetch nodes with your Google Sheet ID and credentials. AI Models**: Set up the AI nodes (e.g., Google Chat Model) with appropriate API credentials. Gmail Integration**: Authorize the Send Daily Report node with Gmail API credentials to send emails. Scheduling**: Adjust the Daily Report Scheduler node to your preferred time (e.g., daily at 9 AM).

How it works • RSS feed monitors your blog for new posts automatically • Extracts and cleans full article content from the blog post • AI Chain (GPT-4o) transforms content into 5 platform-optimized formats (LinkedIn, Twitter, Instagram, Email, Video) • Unsplash API suggests relevant images for each content piece • Slack notification alerts content team with preview of all formats • Airtable logs everything for content calendar tracking • Optional auto-posting to LinkedIn and Twitter (disabled by default) • Structured output parser ensures all 5 formats are generated correctly with proper character limits Set up steps • Time to set up: 10-15 minutes • Replace RSS feed URL with your blog's feed (common formats: /feed, /rss, /feed.xml) • Get Slack channel ID for content team notifications • Create Airtable base with 14 columns (Original_Title, Original_URL, Published_Date, LinkedIn_Post, LinkedIn_Hashtags, Twitter_Thread, Twitter_Hashtags, Instagram_Caption, Instagram_Hashtags, Email_Subject, Email_Body, Video_Script, Suggested_Images, Status) • Add credentials: OpenAI (GPT-4o), Unsplash API, Slack OAuth2, Airtable Token • Replace placeholder IDs in Slack and Airtable nodes • Optional: Enable LinkedIn/Twitter auto-posting nodes and add OAuth2 credentials What you'll need • OpenAI API - GPT-4o access for AI content repurposing • Unsplash API - Free tier available for image suggestions • Slack - Standard workspace for team notifications • Airtable - Free plan works for content tracking • Blog with RSS feed - WordPress, Ghost, Medium, Webflow all supported • LinkedIn/Twitter OAuth2 (optional) - For auto-posting feature Who this is for Content creators, marketing teams, and agencies that want to maximize content ROI by automatically repurposing blog posts into platform-specific content. Perfect for B2B companies publishing regular blog content who need consistent multi-platform presence without manual reformatting.

//ASMR AI Workflow Who is this for? Content Creators, YouTube Automation Enthusiasts, and AI Hobbyists looking to autonomously generate and publish unique, satisfying ASMR-style YouTube Shorts without manual effort. What problem does this solve? This workflow solves the creative bottleneck and time-consuming nature of daily content creation. It fully automates the entire production pipeline, from brainstorming trendy ideas to publishing a finished video, turning your n8n instance into a 24/7 content factory. What this workflow does 1. Two-Stage AI Ideation & Planning: Uses an initial AI agent to brainstorm a short, viral ASMR concept based on current trends. A second "Planning" AI agent then takes this concept and expands it into a detailed, structured production plan, complete with a viral-optimized caption, hashtags, and descriptions for the environment and sound. 2. Multi-Modal Asset Generation: Video:* Feeds detailed scene prompts to the *ByteDance Seedance** text-to-video model (via Wavespeed AI) to generate high-quality video clips. Audio:* Simultaneously calls the *Fal AI** text-to-audio model to create custom, soothing ASMR sound effects that match the video's theme. Assembly:** Automatically sequences the video clips and sound into a single, cohesive final video file using an FFMPEG API call. 3. Closed-Loop Publishing & Logging: Logging:** Initially logs the new idea to a Google Sheet with a status of "In Progress". Publishing:** Automatically uploads the final, assembled video directly to your YouTube channel, setting the title and description from the AI's plan. Updating:** Finds the original row in the Google Sheet and updates its status to "Done", adding a direct link to the newly published YouTube video. Notifications:** Sends real-time alerts to Telegram and/or Gmail with the video title and link, confirming the successful publication. Setup Credentials: You will need to create credentials in your n8n instance for the following services: OpenAI API Wavespeed AI API (for Seedance) Fal AI API Google OAuth Credential (enable YouTube Data API v3 and Google Sheets API in your Google Cloud Project) Telegram Bot Credential (Optional) Gmail OAuth Credential Configuration: This is an advanced workflow. The initial setup should take approximately 15-20 minutes. Google Sheet:* Create a Google Sheet with these columns: idea, caption, production_status, youtube_url. Add the *Sheet ID** to the Google Sheets nodes in the workflow. Node Configuration:** In the Telegram Notification node, enter your own Chat ID. In the Gmail Notification node, update the recipient email address. Activate:** Once configured, save and set the workflow to "Active" to let it run on its schedule. How to customize Creative Direction:* To change the style or theme of the videos (e.g., from kinetic sand to soap cutting), simply edit the systemMessage in the *"2. Enrich Idea into Plan"* and *"Prompts AI Agent"** nodes. Initial Ideas:* To influence the AI's starting concepts, modify the prompt in the *"1. Generate Trendy Idea"** node. Video & Sound:* To change the video duration or sound style, adjust the parameters in the *"Create Clips"* and *"Create Sounds"** nodes. Notifications:* Add or remove notification channels (like Slack or Discord) after the *"Upload to YouTube"** node.

How it works This workflow automatically publishes Instagram and Facebook posts using Google Sheets as a content calendar. Users add post details to a sheet, and the workflow handles scheduling, image processing, posting, and status updates without manual intervention. Step-by-step Scheduled Trigger The workflow runs automatically at a fixed interval (for example, every 15 minutes) to check for posts that are ready to be published. Configuration & Credentials A configuration step stores reusable values such as spreadsheet ID, sheet name, and platform settings, keeping the workflow easy to customize and secure. Data Retrieval & Filtering Posts are read from Google Sheets and filtered to include only rows marked as “Pending” and scheduled for the current time or earlier. Image Handling If an image link is provided, the workflow downloads the image from Google Drive. If no image is present, the post continues as text-only. Platform Routing Based on the selected platform (Instagram, Facebook, or both), the workflow routes the post to the appropriate publishing path. Social Media Publishing The post is published to Instagram and/or Facebook using the connected business account credentials. Status Update After publishing, the workflow updates the original Google Sheet with the post status (Success or Failed), published timestamp, and error message if applicable.

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.