by Paul Roussel
Who's it for This workflow is perfect for app developers, SaaS founders, and mobile growth teams who need constant UGC-style video ads without hiring creators or agencies. If you're spending $500+ per creator and waiting weeks for videos, this automates the entire process for $2-5 per video in 8 minutes. How it works Upload an app screen recording, and this n8n workflow handles everything: Gemini AI analyzes the recording and generates a UGC ad structure (hook, problem, solution, CTA with word limits). It describes the ideal actor, emotional journey, and visual style. Sora 2 then generates a hyper-realistic AI actor delivering the script naturally. VideoBGRemover removes the actor's background and composites them picture-in-picture over your screen recording with audio mixing. The result is a scroll-stopping UGC ad ready for TikTok, Instagram, and Facebook. Set up steps Setup takes ~10 minutes and requires 3 API keys: Get your Gemini API key from Google AI Studio Get your FAL AI key for Sora 2 access Get your VideoBGRemover API key at https://videobgremover.com/n8n Add all three keys to n8n environment variables Connect Google Drive for output storage Test with the included sample screen recording The workflow includes 7 detailed sticky notes explaining each section (Gemini analysis, Sora generation, VideoBGRemover composition, output handling). Requirements Google Gemini API key (for video analysis) FAL AI API key (for Sora 2 access) VideoBGRemover API key Google Drive account (for final video storage) App screen recordings in vertical format (9:16 recommended, 4-12 seconds) How to customize Modify the Gemini prompt to adjust ad tone, script word limits, or actor descriptions. Change composition settings in the VideoBGRemover node (position, size, audio mix). Add your own post-processing nodes for branding, captions, or multi-platform exports.
by Jaures NYA
This workflow automates the process of generating personalized UGC (User-Generated Content) images based on form submissions. It accepts a form with a character type (e.g., male/female) and an uploaded image, merges them, sends them to an AI model (Google Gemini via OpenRouter) for creative generation, and posts the resulting content as a Telegram photo message. Who’s it for This automation template is designed for marketers, AI creators, content teams, or interactive community platforms that want to let users submit content (image + character type), enrich it with AI-generated descriptions, and instantly publish results to Telegram — without writing a single line of code. How it works Trigger: Workflow starts when a form is submitted by a user. Extract file: The uploaded image file is converted to a Base64 string. Merge data: The character type and image data are combined into one payload. Format to Data URL: The image is wrapped as a proper data:image/... format for API use. Prepare payload: The text and image are mapped into a structure compatible with Gemini API. Generate AI content: Sends the input to Google Gemini (via OpenRouter) to generate a UGC description. Transform response: Cleans and extracts the result from Gemini’s response. Convert back to file: Transforms the Base64 image back into a real image file. Send to Telegram: The image and its AI-generated description are sent as a photo message to your Telegram channel. How to use Set up a form with a dropdown for character type (e.g., Male/Female) and an image upload field. Configure the Gemini API access through OpenRouter. Connect your Telegram bot and channel to receive the final result. Start the workflow → users submit the form, and their data is processed and shared as AI-enhanced UGC. Requirements OpenRouter API key to access Google Gemini. A Telegram Bot connected to your Telegram channel. ❓ Need help Contact me for consulting and support: LinkedIn / YouTube / Skool
by HoangSP
Who’s it for Teams that want to turn a chat prompt into a researched, ready-to-post social update—optionally published to Facebook. What it does / How it works Chat Trigger receives the user prompt Topic Agent optionally calls a research sub-workflow for fresh sources Outputs are validated into a structured JSON Post Writing Agent crafts a concise Vietnamese post (Optional) Facebook Graph API publishes to your Page How to set up Connect OpenAI & Facebook in Credentials (no API key inside nodes). In Tool: Call Perplexity Researcher, set your research workflowId. In Publish: Facebook Graph API, set your Page ID and edge. Adjust prompts/tone and the LANGUAGE in CONFIG. Test the flow with sample prompts in the chat. Requirements n8n (Cloud or self-hosted) OpenAI API key (stored in Credentials) Facebook Page publish permissions (Optional) a research workflow for Perplexity How to customize the workflow Add moderation/review gates before publishing. Duplicate the publish path for other platforms. Store outputs in Sheets/Notion/DB for auditing. Tune model choice & temperature for your brand voice. Security Avoid hardcoding secrets in HTTP or Code nodes. Keep identifiers (Page IDs, workflowIds) configurable in CONFIG.
by Quinten Alexander
Your Personal RSS Feed of YouTube Videos! This workflow creates an RSS feed containing the most recent videos published by your favorite channels. Use it in combination with your favorite RSS reader and don't miss out on any of your favorite creators' content without all the distractions of YouTube. You can even play the video right from your RSS reader without ever having to visit YouTube itself! Who's it for This workflow is for everyone who likes to keep updated about videos from their favorite creator through their preferred RSS app. How it works The RSS client triggers the webhook of this workflow The RSS feeds from your selected channels are pulled from YouTube The resulting feeds are filtered so only the normal videos (no shorts), posted in the last week, remain For each video, the video player and the full video description are pulled from the YouTube API For each video, an RSS item is created containing this video player and the video description as the content The RSS items are cached in a Redis database to prevent pulling the same information from the YouTube API on each webhook call A full RSS feed is built and returned to the calling webhook How to set up Follow the steps in the red notes (from 1 to 4) to configure the workflow: Set the IDs of the channels you want to watch Configure your Redis credentials Configure your Google/YouTube API credentials Copy the webhook URL and paste it into your RSS reader Don't forget to activate the workflow! Only the nodes inside a red node need configuration; all other nodes are good to go. You are, however, free to change those nodes to your liking! Requirements This workflow has 2 requirements: A Redis database used to cache the RSS items (see the blue note on how to set up a Redis database yourself) Google API credentials to access the YouTube API Customizing this workflow Add any YouTube channel you want by adding their channel ID in the "Set Channels" node at the start of this workflow. If you aren't afraid of some XML RSS code, you can dive into the code blocks and change the resulting RSS feed. You can change the feed's title, description, or image. Or go all in on text processing and process the video description before it is added to the RSS items (such as removing sponsors or links to social media). You can also extend this workflow by adding RSS items from other feeds or sources.
by Budi SJ
Automated App Analysis & ASO Report Generator This workflow automates the process of analyzing a mobile app from the Google Play Store and generating a professional ASO (App Store Optimization) Report. Simply submit a Play Store URL, and the workflow will fetch app intelligence data, parse it, run an AI-based analysis, and deliver a formatted report in Google Docs. A Telegram notification with the document link ensures you never miss a new report. ✨ Key Features Form Input Trigger** – Start the workflow by submitting a Play Store URL. Automated Data Retrieval** – Uses HTTP request to fetch app intelligence (via SensorTower or similar APIs). Smart Data Parsing** – Extracts essential app details, competitor insights, reviews, downloads, and revenue data. AI-Powered ASO Report** – Generates a professional analysis using LLM (Gemini via OpenRouter) with structured sections: 📱 App Overview ⭐ User Ratings & Reviews 📊 Competitor Analysis 📈 Market Insights 💡 Actionable Recommendations Google Docs Integration** – Creates and updates a Google Doc with the generated report. Instant Notification** – Sends a Telegram message with the app report link for quick access. 🔐 Required Credentials To run this workflow, you’ll need: SensorTower API (or alternative App Intelligence API)** – for app details, reviews, competitors, and market data. OpenRouter API** – to access LLM model. Google Docs OAuth2** – to create and update the ASO report in Google Docs. Telegram API** – for instant notifications with the report link. 🎁 Benefits Save Time** – Automates the manual process of app research and reporting. Consistent Reporting** – Ensures every report follows a professional structure with clear sections. Actionable Insights** – Get AI-generated recommendations to improve app performance and competitiveness. Collaboration-Ready** – Reports are stored in Google Docs for easy sharing and editing. Real-Time Alerts** – Stay updated via Telegram whenever a new report is generated.
by Xavier Tai
💰 Package Recommender with Sales Pipeline Tracking What It Does Automatically recommends the right service package based on budget, sends beautifully formatted proposal emails with case studies, logs everything to a sales pipeline tracker, and schedules your follow-up reminders. Converts inquiries into booked calls without manual proposal writing. How It Works Form Trigger → Lead submits budget and challenge details Log to Pipeline → All inquiry data saved to tracking sheet Budget Router → Directs to Basic ($0-3K), Standard ($3-6K), or Premium ($6K+) Set Package Variables → Loads appropriate features, pricing, case study Send Proposal Email → Gorgeous HTML email with personalized package details Update Pipeline → Marks "Package Sent" and sets follow-up date (+3 days) Calendar Reminder → Creates event in 3 days reminding you to follow up 🚀 SETUP INSTRUCTIONS Step 1: Create Sales Pipeline Sheet Create Google Sheet with tab "Package Inquiries" Add columns: Timestamp | Name | Email | Phone | Budget | Timeline | Challenge | Package Recommended | Package Price | Status | Date Sent | Follow-Up Date Update YOUR_GOOGLE_SHEET_ID in nodes 2, 7, and calendar description Step 2: Customize Package Details Edit nodes 4, 5, 6 (Set Package Details nodes) Update pricing, features, and case studies for your services Replace booking links with your actual Calendly/scheduling URLs Adjust package names if needed Step 3: Configure Email Template Edit node 7 email design/branding Update "Your Name" and signature Customize colors (currently: purple gradient, green CTA) Test email rendering across devices Step 4: Setup Calendar Integration Add Google Calendar OAuth2 credentials Verify follow-up timing (currently +3 days) Customize reminder description with your workflow Update Google Sheet link in calendar event
by Janak Patel
Use this template if you’re collecting leads in Google Sheets manually or automatically and need to send them emails daily using any personal or professional email provider. It’s simple yet effective. I’ve kept it easy so that anyone without technical or coding knowledge can still automate their emails and achieve excellent ROI. Setting up the workflow takes only 15 minutes. How it works: We connect Google Sheets with n8n to automatically fetch lead data. Google Sheets is used because it’s easy and widely accessible. Then, n8n sends emails daily at your scheduled times to the respective email addresses, using the subject lines and body text you've configured. It also verifies emails before sending. It checks email availability, deliverability, and updates the Google Sheet/CRM with the respective fields. Requirements: A Google Sheet/Excel/CRM tools with leads (A sample Google Sheet link is provided in the template) A working email account with SMTP information (SMTP info for the top 10 email providers is provided in the template) API key from any email verification tool (We use the Hunter API key in our use case. You can find the link in the template.) Setup Steps: You need a Google Sheet where you're collecting leads. You can replace Google Sheets with your CRM tool. Connect it using your credentials. Replace the manual trigger with a scheduled trigger to automate emails at your preferred time. Replace the email verification tool/Hunter API with your own API key. Add your SMTP credentials to connect the template with your preferred email provider. Using SMTP, you can send emails through Gmail, Outlook, Zoho, or any similar provider. This makes sending emails simple and cost-efficient. Note: SMTP, which stands for Simple Mail Transfer Protocol, is a communication protocol used to send email messages between mail servers. After sending the email, we update the Google Sheet with “Sent”; hence, the email is not sent again the next day.
by Muhammad Saqib
Automated Certificate Generator with Google Sheets, Slides, and Gmail Delivery 🎓 This workflow is designed for educators, trainers, and event organizers who want to automatically generate and send digital certificates. It takes participant data from Google Sheets, personalizes a Google Slides certificate template, converts it into PDF, saves it in Google Drive, and emails it directly to participants using Gmail. ✅ Setup Instructions Prepare Google Sheets Create a sheet with these required columns: Name → Participant’s full name Email → Recipient email address Score (optional) → For filtering or record keeping Add at least one row of test data. Create Google Slides Template Design your certificate (branding, colors, etc.). Add a placeholder [NAME] where the participant’s name should appear. Set up Google Drive Create a folder to store generated PDF certificates. Copy the folder URL for use in the workflow. Connect Google Services in n8n Add credentials for Google Sheets, Google Slides, Google Drive, and Gmail. Replace placeholders (Sheet ID, Slides template ID, Destination folder ID) in the workflow. Customize Gmail Delivery Update the subject and body of the Gmail node. The certificate PDF will be automatically attached to each email. 🎨 Customization Options Certificate Design**: Modify your Slides template (logos, colors, extra fields). Dynamic Fields**: Add placeholders like [COURSE] or [DATE] and map them from your sheet. Email Body**: Personalize with variables such as {{$json["Name"]}}. File Naming**: Adjust file naming in the "Copy File" and "Download File" nodes. This template streamlines certificate distribution, making it ideal for schools, universities, training programs, and webinars.
by Intuz
This n8n template from Intuz provides a complete solution to automate your order creation process. It seamlessly syncs order data from an Airtable base directly to your Shopify store, creates the official order, and automatically sends a beautiful confirmation email to the customer, closing the loop by updating the status in Airtable. Who's this workflow for? E-commerce Managers Operations Teams Businesses with Custom Order Processes (e.g., B2B, phone orders, quotes) Shopify Store Owners using Airtable as a CRM How it works 1. Triggered from Airtable: The workflow starts instantly when an Airtable Automation sends a signal via a webhook. This happens when you mark an order as ready to be processed in your Airtable base. 2. Fetch Order Details: n8n receives the record ID from Airtable and fetches the complete order details, including customer information and the specific line items for that order. 3. Create Order in Shopify: All the gathered information is used to create a new, official order directly in your Shopify store. 4. Send Confirmation Email: Once the order is successfully created in Shopify, a professionally formatted HTML order confirmation email is sent to the customer via Gmail. 5. Update Airtable Status: Finally, the workflow updates the original order record in Airtable, marking its status as "Done" to prevent duplicate processing and keep your records in sync. Key Requirements to Use This Template 1. n8n Instance: An active n8n account (Cloud or self-hosted). 2. Airtable Base: An Airtable base on a "Pro" plan or higher (required for Airtable Automations). It should contain tables for Orders and Order Line Items. 3. Shopify Store: An active Shopify store with API access permissions. 4. Gmail Account: A Gmail account to send confirmation emails. Setup Instructions 1. Configure the n8n Workflow: Webhook Node: Activate the workflow to get the Production URL from the "Webhook" node. Copy this URL. Airtable Nodes: In the Get a record and Update record nodes, connect your Airtable credentials and select the correct Base and Table IDs. Shopify Node: In the Create an order node, connect your Shopify store using OAuth2 credentials. Gmail Node: In the Send a message node, connect your Gmail account. 2. Set Up the Airtable Automation (Crucial Step): Go to your Airtable base and click on "Automations". Create a new automation. For the trigger, select "When a record meets conditions". Choose your Orders table and set a condition that makes sense for you (e.g., When "Shopify Ordered" is "Pending"). For the action, choose "Run a script". Paste the code below into the script editor: JavaScript const inputConfig = input.config(); const recordId = inputConfig.recordId; const webhookUrl = 'PASTE_YOUR_N8N_PRODUCTION_URL_HERE'; await fetch(webhookUrl, { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ recordId: recordId }), }); ReplacePASTE_YOUR_N8N_PRODUCTION_URL_HERE with the Production URL you copied from n8n. Add an input variable to the script named recordId and set its value to the "Airtable record ID" from the trigger step. Test the script and turn your Airtable Automation ON. 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 Workflow Automation Click here- Get Started
by Alexander Schnabl
Monitor expiring EntraID application secrets and notify responsible Stay ahead of credential expirations by automatically detecting Entra ID application client secrets and certificates that are about to expire, and sending a neatly formatted email report. What this workflow solves Expired client secrets and certificates are a common cause of unexpected outages and failed integrations. Manually checking expiration dates across many Entra ID applications is tedious and easy to miss. This workflow automates the discovery and reporting of credentials that will expire within a configurable time window. Key features Fetches all Microsoft Entra ID applications along with: Client secrets (passwordCredentials) Certificates (keyCredentials) Splits credentials into individual entries for easier processing Filters credentials expiring within the next N days (configurable) Normalizes results into a consistent structure including: Application name App ID Credential type (Client Secret / Certificate) Credential name + ID Days remaining until expiration Generates an HTML table report, sorted by application name Sends an email only when expiring items are found (otherwise does nothing) How it works Fetches all Entra ID applications and their credential metadata via Microsoft Graph Separates client secrets and certificates into individual entries Filters entries that expire within the configured time window Builds a normalized list of expiring items with days remaining Emails an HTML table report (only if results exist) Setup requirements Microsoft Entra ID app registration* with Microsoft Graph *Application permissions**: Application.Read.All In n8n: Create Microsoft Graph OAuth2 credentials (Client Credentials flow recommended) Assign those credentials to the Get EntraID Applications and Secrets HTTP Request node Update the Set Variables node: notificationEmail: where to send the report daysBeforeExpiry: alert window in days (e.g., 14) Notes The email table highlights soon-to-expire credentials more prominently (based on remaining days). For automation, replace the manual trigger with a Schedule Trigger (e.g., daily/weekly). The workflow accesses metadata only (names/IDs/expiry), not secret values.
by Omer Fayyaz
This n8n template implements a Chatbot with Google Gemini to Check Domain Name Availability using the WHMCS API Who's it for This template is designed for domain registrars, web hosting companies, and IT service providers who use WHMCS (Web Host Manager Complete Solution) and want to offer automated domain availability checking to their customers. It's perfect for businesses looking to enhance their customer support with AI-powered domain search assistance. How it works / What it does This workflow creates an AI-powered customer support chatbot that automatically checks domain name availability using WHMCS API integration. When customers ask about domain availability, the AI agent: Receives customer queries through a webhook endpoint Processes natural language requests using Google Gemini AI Automatically checks domain availability via WHMCS DomainWhois API Provides verified, accurate responses with available alternatives Maintains conversation context throughout the session The system ensures 100% accuracy by only suggesting domains that have been verified as available, eliminating guesswork and improving customer trust. How to set up 1. Configure WHMCS API Credentials Replace Your_WHMCS_Identifier with your actual WHMCS API identifier Replace Your_WHMCS_Secret with your actual WHMCS API secret Update https://your_whmcs_url.com/includes/api.php with your WHMCS domain 2. Set up Google Gemini API Configure your Google Gemini API credentials in the Google Gemini Chat Model node Ensure you have sufficient API quota for your expected usage 3. Deploy the Webhook The workflow creates a unique webhook endpoint for receiving customer queries Use this endpoint URL in your customer-facing application or chat interface 4. Test the Integration Send a test query to verify domain checking functionality Ensure proper error handling and response formatting Requirements WHMCS installation** with API access enabled Google Gemini API account** with appropriate credentials n8n instance** (self-hosted or cloud) Domain registrar business** or similar service offering How to customize the workflow Modify AI Agent Behavior Edit the system message in the AI Agent node to change the bot's personality and response style Adjust response length and tone to match your brand voice Add Additional Tools Integrate with other WHMCS APIs for pricing, registration, or management Add notification systems (email, Slack, SMS) for high-value domain inquiries Implement rate limiting or usage tracking Enhance Customer Experience Add domain suggestion algorithms based on customer input Integrate with your existing customer database for personalized recommendations Add multi-language support for international customers Security Enhancements Implement API key rotation and monitoring Add request validation and sanitization Set up usage analytics and abuse prevention Key Features Real-time domain availability checking** via WHMCS API AI-powered natural language processing** for customer queries Session-based memory** for contextual conversations Automatic alternative domain suggestions** when requested domains are unavailable Professional, customer-focused responses** that maintain brand standards Scalable webhook architecture** for high-volume usage Use Cases Customer support automation** for domain registrars Sales team assistance** with real-time domain availability Customer self-service portals** with intelligent domain search Lead generation** through proactive domain suggestions Customer retention** via improved support experience This template transforms your domain business by providing instant, accurate domain availability information while maintaining the personal touch that customers expect from professional service providers.
by Vinay
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 📖 Extract Data from Invoices with OCR, Gemini AI, and Airtable This template automates the process of extracting key details from invoices (PDF, JPG, PNG) and storing them in Airtable using OCR + AI. It eliminates manual data entry by leveraging Tesseract OCR, Google Gemini AI, and Airtable, with optional Telegram notifications. The workflow is ideal for freelancers, small businesses, and finance teams who need a lightweight and automated solution for handling invoice data. 🔑 Features ✅ Supports JPG, PNG, and PDF invoices 🧠 Automatically extracts: Invoice Number, Invoice Date (standardized to YYYY-MM-DD), Subtotal, Tax, Total, Currency, Vendor Name, Email, Phone, and Ship-to Address 📤 Sends structured data into Airtable automatically 📬 Sends a Telegram notification once data is processed (optional) 🔁 Triggers automatically when new files are dropped into a folder ⚠️ Disclaimer This workflow uses community nodes (n8n-nodes-tesseractjs, n8n-nodes-pdf-page-extract). It works best on self-hosted n8n or n8n cloud instances where these nodes are available. You must install and configure these nodes before importing the workflow. ⚙️ Setup & Configuration Install Docker with n8n. Mount your folder (e.g., ~/self-hosted-ai/ocr-bot:/shared) so invoices can be dropped into /shared/ocr/. Import the provided JSON workflow into n8n. Replace credentials: Google Gemini API key Airtable base + token Telegram bot token (optional) Drop a sample invoice (PDF/JPG/PNG) into the configured folder. Check Airtable for structured data and Telegram (if enabled) for confirmation. 🧠 Customization Modify the AI prompt to extract additional fields. Replace Airtable with Google Sheets or another database if preferred. Update the Telegram node with your own Chat ID for notifications. 💡 Tip: Add a screenshot of the workflow in n8n to help users quickly understand the node structure.