🎬 YouTube shorts automation tool 🚀
🎬 YouTube Shorts Automation Tool 🚀 Automate the creation of high-performing YouTube Shorts in minutes! Who is this for? 🎯 Content Creators: Generate engaging short videos effortlessly. Marketing Agencies: Produce client-ready content quickly. Business Owners: Promote products/services through viral short-form content. What problem does this solve? 🛠️ Creating short-form video content is time-consuming, complex, and skill-intensive. This workflow automates video creation, eliminating the need for video editing expertise while ensuring SEO optimization, high-quality visuals, and professional voiceovers. How it works 🌟 Enter your video idea into the chat interface. AI generates a script optimized for engagement and SEO. Voiceover is created with realistic AI narration. Relevant visuals are selected to match the script. The video is assembled and delivered via a shareable link. Setup ⚙️ (5-10 min) Connect required APIs (most have free tiers). Follow the guided setup (video tutorial included). Start generating professional YouTube Shorts instantly! Required APIs 🔗 Content Generation: OpenAI, ElevenLabs (script & voiceover) Media Processing: Cloudinary, Replicate (images & storage) Integration Tools: 0codekit, Creatomate (video assembly) Customization 🎨 Adjust script styles & voiceover preferences. Modify visuals to match your brand. Optimize video length and format. 🚀 Start automating your YouTube Shorts today and grow your audience effortlessly!
By Jonas BuschExtract spending history from gmail to google sheet
How it works Fetch transaction notification emails (including attachments) Clean up data Let AI (Basic LLM Chain node) generate bookkeeping item Send to Google sheet Details The example fetch email from Gmail lables, suggested using filters to automatically orgianize email into the labels Data will send to "raw data" sheet Example google sheet: https://docs.google.com/spreadsheets/d/1_IhdHj8bxtsfH2MRqKuU2LzJuzm4DaeKSw46eFcyYts/edit?gid=1617968863gid=1617968863
By hanaAI Customer Support Chat for Web Hosting with Google Gemini & WHMCS
This n8n template implements a Customer Support Chat Agent for Web Hosting Companies with Google Gemini, Google Sheets Knowledge base and WHMCS API to Check Domain Name Availability Who's it for This template is designed for web hosting companies, domain registrars, and IT service providers who want to automate their customer support with an AI-powered chatbot. It's perfect for businesses looking to provide 24/7 customer assistance for hosting plans, domain services, and technical support while maintaining a professional, human-like interaction experience. How it works / What it does This workflow creates an AI-powered customer support chatbot that provides comprehensive assistance for web hosting and domain services. The AI agent (named Matt) automatically: Receives customer queries through a webhook endpoint Captures customer information (name and email) at the start of each session Processes natural language requests using Google Gemini AI Accesses real-time information from multiple Google Sheets knowledge bases: Shared Hosting Plans (pricing, features, specifications) Domain Prices (registration, transfer, renewal costs) Hosting Features (technical capabilities and specifications) FAQs (common questions and answers) Payment Method Details (accepted payment options) Company Offerings (available products and services) Checks domain availability via WHMCS API integration Provides accurate, contextual responses based on the knowledge base Maintains conversation history with session-based memory Stores complete chat sessions in Google Sheets for analysis and follow-up The system ensures 100% accuracy by only providing information that exists in the knowledge base, eliminating guesswork and maintaining brand consistency. How to set up Configure Google Sheets Knowledge Base Set up a Google Sheets document with the following sheets: SharedHostingPlans: Hosting plan details, pricing, and specifications Domain_Prices: Domain registration and renewal pricing Hosting_Features: Technical features and capabilities FAQs: Frequently asked questions and answers PaymentMethodDetails: Payment options and instructions Offerings: Available products and services Update the Google Sheets credentials in each tool node 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 Configure WHMCS API (Optional) Replace YourWHMCSIdentifier with your actual WHMCS API identifier Replace YourWHMCSSecret with your actual WHMCS API secret Update https://yourwhmcsurl.com/includes/api.php with your WHMCS domain This enables domain availability checking for customers Set up Chat Storage Create a Google Sheet for storing chat inquiries Update the document ID and credentials in the Chat_Inquiries node This will automatically store all customer conversations for analysis 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 Requirements Google Sheets account with the knowledge base set up Google Gemini API account with appropriate credentials n8n instance (self-hosted or cloud) WHMCS installation (optional, for domain availability checking) Web hosting or domain services business 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 Customize the agent's name (currently "Matt") Enhance Knowledge Base Add more Google Sheets tools for additional information sources Include product catalogs, pricing tables, or technical documentation Add multi-language support for international customers Improve Customer Experience Add domain suggestion algorithms based on customer input Integrate with your existing customer database for personalized recommendations Add notification systems (email, Slack, SMS) for high-value inquiries Security Enhancements Implement API key rotation and monitoring Add request validation and sanitization Set up usage analytics and abuse prevention Key Features Real-time information access from Google Sheets knowledge base AI-powered natural language processing for customer queries Session-based memory for contextual conversations Automatic domain availability checking via WHMCS API Professional, customer-focused responses that maintain brand standards Complete chat history storage for analysis and follow-up Scalable webhook architecture for high-volume usage Multi-tool integration for comprehensive customer support Use Cases 24/7 customer support automation for web hosting companies Sales team assistance with real-time product information Customer self-service portals with intelligent assistance Lead generation through proactive service recommendations Customer retention via improved support experience Support ticket reduction by handling common queries automatically Chat Session Management The workflow automatically manages chat sessions with the following features: Unique Session IDs for each customer conversation Automatic customer information capture (name and email) Conversation history tracking with chronological message storage Session persistence across multiple interactions Data export to Google Sheets for analysis and follow-up Example Customer Interactions The AI agent can handle various customer scenarios: Hosting Plan Inquiries: Detailed information about shared hosting plans, features, and pricing Domain Services: Domain availability checking, pricing, and registration guidance Technical Support: Feature explanations, setup guidance, and troubleshooting Payment Information: Accepted payment methods and transaction processes General Support: Company information, service offerings, and FAQ responses This template transforms your web hosting business by providing instant, accurate customer support while maintaining the personal touch that customers expect from professional service providers. The AI agent becomes an extension of your support team, handling routine inquiries and allowing human agents to focus on complex technical issues.
By Omer FayyazSend AI-enhanced economic calendar alerts to Telegram with Gemini-2.0-Flash
Stay ahead of the markets with this fully automated n8n workflow that delivers real-time, AI-formatted economic calendar updates directly to your Telegram channel or group. Powered by the Economic Events Calendar API via RapidAPI, this workflow is perfect for traders, investors, and financial community managers who want timely notifications about high- and medium-impact global economic events—no coding required. Key Features Automated Alerts: Receive upcoming economic calendar updates for the next 3 days (customizable window) straight to Telegram. AI-Enhanced Formatting: Economic news are grouped by date and importance, with clear, emoji-rich summaries for maximum readability and engagement. Flexible Scheduling: Default update interval is every 3 days, adjustable to daily or any custom frequency. Customizable Date Range: Easily set the window for economic event coverage (e.g., today to 7 days ahead). No Coding Needed: Simple setup—just plug in your API keys and Telegram credentials. How to Set Up ++Step 1:++ Get Your RapidAPI Key & Subscribe to the Economic Calendar Endpoint Visit RapidAPI (https://rapidapi.com/) and sign up for a free account (free plan includes limited requests per month). After registering, click your profile icon in the top-right corner and select "User Settings". From the left menu, choose "Applications". Click on "default app" and copy your API Key. Paste this key inside the workflow node labeled "Set API Key for RapidAPI & Dates" under the "x-rapidapi-key" field. ++Step 2:++ Connect Google Gemini (or OpenAI) Model Add your Gemini API credentials in n8n for advanced AI formatting and structuring of economic updates. ++Step 3:++ Set Up Your Telegram Bot Create a bot with @BotFather, get your API token, and add it to n8n’s Telegram credentials. Obtain your Telegram chat or group ID (use @RawDataBot for this). ++Step 4:++ Customize Date Range (Optional) By default, the workflow fetches economic calendar updates for the next 3 days, but you can adjust it to any custom window (e.g., today to 7 days ahead). ++Step 5:++ Activate the Workflow Schedule how often you want news updates (default: every 3 days; can be as frequent as daily). The workflow will automatically fetch, format, and send the latest economic calendar updates to your Telegram. Who Is This For? Retail and professional traders Financial influencers and Telegram group admins Community managers seeking hands-off, real-time macroeconomic alerts Why Choose This Workflow? Save Time: No more manual economic calendar checks. Stay Informed: Instantly know about key market-moving events. Easy Integration: Works out-of-the-box with n8n and Telegram. Get started today and never miss a critical economic event again!
By Malik HashirMonitor & auto-heal AWS EC2 instances with multi-channel alerts
This n8n workflow automates the monitoring, health assessment, and self-healing of AWS EC2 instances in production environments. It runs periodic checks, identifies unhealthy instances based on status and metrics, restarts them automatically, and notifies teams via multi-channel alerts while logging data for auditing and reporting. Key Features Triggers health checks every 5 minutes to proactively monitor EC2 fleet status. Fetches and loops through all production EC2 instances for individualized analysis. Evaluates instance health using AWS metrics and custom thresholds to detect issues like high CPU or stopped states. Performs automatic restarts on unhealthy instances to minimize downtime. Sends instant WhatsApp notifications for urgent alerts, detailed email reports for team review, and logs metrics to Google Sheets for long-term tracking. Includes sticky notes for quick reference on configuration, self-healing logic, and alert setup. Workflow Process The Schedule Trigger node runs the workflow every 5 minutes, ensuring frequent health monitoring without overwhelming AWS APIs. The Get EC2 Instances node fetches all production-tagged EC2 instances from AWS, filtering by environment (e.g., tag: Environment=Production). The Loop Over Instances node iterates through each fetched instance individually, allowing parallel processing for scalability. The Check Instance Status node retrieves detailed health metrics for the current instance via AWS API (e.g., status checks, CPU utilization, and state). The Health Status Check node evaluates the instance's status against predefined thresholds (e.g., failed system checks or high load); if healthy, it skips to logging. The Analyze Health Data node assesses metrics in depth to determine action (e.g., restart if CPU > 90% for 5+ minutes) and prepares alert payloads. The Restart Instance node automatically initiates a reboot on unhealthy instances using AWS EC2 API, with optional dry-run mode for testing. The WhatsApp Notification node (part of Multi-Channel Alerts) sends instant alerts via Twilio WhatsApp API, including instance ID, issue summary, and restart status. The Email Report node generates and sends a detailed HTML report to the team via SMTP, summarizing checked instances, actions taken, and metrics trends. The Google Sheets Logging node appends health data, timestamps, and outcomes to a specified spreadsheet for historical analysis and dashboards. The Sticky Notes nodes provide inline documentation: one for AWS credential setup, one explaining self-healing thresholds, and one for alert channel configurations. Setup Instructions Import the workflow into n8n and activate the Schedule Trigger with a 5-minute cron expression (e.g., /5 *). Configure AWS credentials in the Get EC2 Instances, Check Instance Status, and Restart Instance nodes using IAM roles with EC2 read/restart permissions. Set up Twilio credentials in the WhatsApp Notification node, including your Twilio SID, auth token, and WhatsApp-enabled phone numbers for sender/receiver. Add SMTP credentials (e.g., Gmail or AWS SES) in the Email Report node, and update sender/receiver email addresses in the node parameters. Link Google Sheets in the Google Sheets Logging node by providing the spreadsheet ID, sheet name, and OAuth credentials for write access. Customize health thresholds in Health Status Check and Analyze Health Data (e.g., via expressions for CPU/memory limits). Test the workflow by manually executing it on a small set of instances and verifying alerts/logging before enabling production scheduling. Review sticky notes within n8n for quick tips, and monitor executions in the dashboard to fine-tune intervals or error handling. Prerequisites AWS account with EC2 access and IAM user/role for DescribeInstances, DescribeInstanceStatus, and RebootInstances actions. Twilio account with WhatsApp sandbox or approved number for notifications. SMTP email service (e.g., Gmail, Outlook) with app-specific passwords enabled. Google Workspace or personal Google account for Sheets integration. n8n instance with AWS, Twilio, SMTP, and Google Sheets nodes installed (cloud or self-hosted). Production EC2 instances tagged consistently (e.g., Environment=Production) for filtering. Modification Options Adjust the Schedule Trigger interval to hourly for less frequent checks or integrate with AWS CloudWatch Events for dynamic triggering. Expand Analyze Health Data to include advanced metrics (e.g., disk I/O via CloudWatch) or ML-based anomaly detection. Add more alert channels in Multi-Channel Alerts, such as Slack webhooks or PagerDuty integrations, by duplicating the WhatsApp/Email branches. Enhance Google Sheets Logging with charts or conditional formatting via Google Apps Script for visual dashboards. Implement approval gates in Restart Instance (e.g., via email confirmation) to prevent auto-restarts in sensitive environments. Explore More AI Workflows: Get in touch with us for custom n8n automation!
By Oneclick AI Squad