AI-powered short-form video generator with OpenAI, Flux, Kling, and ElevenLabs
Who is this for? Content creators, digital marketers, and social media managers who want to automate the creation of short-form videos for platforms like TikTok, YouTube Shorts, and Instagram Reels without extensive video editing skills. What problem does this workflow solve? Creating engaging short-form videos consistently is time-consuming and requires multiple tools and skills. This workflow automates the entire process from ideation to publishing, significantly reducing the manual effort needed while maintaining content quality. What this workflow does This all-in-one solution transforms ideas into fully produced short-form videos through a 5-step process: Generate video captions from ideas stored in a Google Sheet Create AI-generated images using Flux and the OpenAI API Convert images to videos using Kling's API Add voice-overs to your content with Eleven Labs Complete the video production with Creatomate by adding templates, transitions, and combining all elements The workflow handles everything from sourcing content ideas to rendering the final video, and even notifies you on Discord when videos are ready. Setup (Est. time: 20-30 minutes) Before getting started, you'll need: n8n installation (tested on version 1.81.4) OpenAI API Key (free trial credits available) PiAPI (free trial credits available) Eleven Labs (free account) Creatomate API Key (free trial credits available) Google Sheets API enabled in Google Cloud Console Google Drive API enabled in Google Cloud Console OAuth 2.0 Client ID and Client Secret from your Google Cloud Console Credentials How to customize this workflow to your needs Adjust the Google Sheet structure to include additional data like video length, duration, style, etc. Modify the prompt templates for each AI service to match your brand voice and content style Update the Creatomate template to reflect your visual branding Configure notification preferences in Discord to manage your workflow This workflow combines multiple AI technologies to create a seamless content production pipeline, saving you hours of work per video and allowing you to focus on strategy rather than production.
Generate SQL queries from schema only - AI-powered
This workflow is a modification of the previous template on how to create an SQL agent with LangChain and SQLite. The key difference – the agent has access only to the database schema, not to the actual data. To achieve this, SQL queries are made outside the AI Agent node, and the results are never passed back to the agent. This approach allows the agent to generate SQL queries based on the structure of tables and their relationships, without having to access the actual data. This makes the process more secure and efficient, especially in cases where data confidentiality is crucial. 🚀 Setup To get started with this workflow, you’ll need to set up a free MySQL server and import your database (check Step 1 and 2 in this tutorial). Of course, you can switch MySQL to another SQL database such as PostgreSQL, the principle remains the same. The key is to download the schema once and save it locally to avoid repeated remote connections. Run the top part of the workflow once to download and store the MySQL chinook database schema file on the server. With this approach, we avoid the need to repeatedly connect to a remote db4free database and fetch the schema every time. As a result, we reach greater processing speed and efficiency. 🗣️ Chat with your data Start a chat: send a message in the chat window. The workflow loads the locally saved MySQL database schema, without having the ability to touch the actual data. The file contains the full structure of your MySQL database for analysis. The Langchain AI Agent receives the schema, your input and begins to work. The AI Agent generates SQL queries and brief comments based solely on the schema and the user’s message. An IF node checks whether the AI Agent has generated a query. When: Yes: the AI Agent passes the SQL query to the next MySQL node for execution. No: You get a direct answer from the Agent without further action. The workflow formats the results of the SQL query, ensuring they are convenient to read and easy to understand. Once formatted, you get both the Agent answer and the query result in the chat window. 🌟 Example queries Try these sample queries to see the schema-driven AI Agent in action: Would you please list me all customers from Germany? What are the music genres in the database? What tables are available in the database? Please describe the relationships between tables. - In this example, the AI Agent does not need to create the SQL query. And if you prefer to keep the data private, you can manually execute the generated SQL query in your own environment using any database client or tool you trust 🗄️ 💭 The AI Agent memory node does not store the actual data as we run SQL-queries outside the agent. It contains the database schema, user questions and the initial Agent reply. Actual SQL query results are passed to the chat window, but the values are not stored in the Agent memory.
AI-powered stock analysis assistant with Telegram, Claude & GPT-4O Vision
"Ade Technical Analyst" is a dual-workflow AI system combining conversational intelligence with visual chart analysis through Telegram. The system features 11 primary nodes for conversation management and 8 secondary nodes for chart generation and analysis. Core Components: Telegram Integration: Message handling with dynamic typing indicators AI Personality: "Ade" - a financial analyst with 50+ years NYSE/LSE experience using Claude 3.5 Sonnet Chart Generation: TradingView integration via Chart-IMG API with MACD and volume indicators Visual Analysis: GPT-4O vision for technical pattern recognition Memory System: Session-based conversation context retention Target Users Individual traders seeking professional-grade analysis without subscription costs Financial advisors wanting 24/7 AI-powered client support Investment educators needing interactive learning tools Fintech companies requiring white-label analysis solutions Setup Requirements Critical Security Fix Needed: Remove hardcoded API key from Chart-IMG node immediately Store all credentials securely in n8n credential manager Required APIs: OpenRouter (Claude 3.5 Sonnet) OpenAI (GPT-4O vision) Chart-IMG API Telegram Bot Token Technical Prerequisites: n8n version 1.7+ with Langchain nodes Webhook configuration for Telegram Dual-workflow setup with proper ID referencing Workflow Requirements Security Compliance: Never hardcode API keys in workflow JSON files Use n8n credential manager for all sensitive data Implement proper session isolation for user data Include mandatory financial disclaimers Performance Specifications: Model temperature: 0.8 for balanced responses Token limit: 500 for optimized performance Dark theme charts with professional indicators Session-based memory management Need help customizing? Contact me for consulting and support or add me on LinkedIn
🤖 AI content generation for auto service 🚘 automate your social media📲!
Who Is This For? 🚘This workflow is designed for auto service / car repair businesses looking to streamline their social media marketing with Ai tools and automation via n8n. Whether you’re a small garage owner, a car repair shop, an automotive specialist or automechanic - this tool helps you maintain an active online presence without spending hours creating content. 💪🏼 Though this template is set up for Auto Service daily content uploads, but the underlying logic is universal. You can easily adapt it for any niche by editing prompts, adding nodes, and creating or uploading a variety of content to any platform. You can use any LLM and generative AI of your choice. Personally, I prefer the smooth and effective results from ChatGPT 4.1 combined with GPT Image 1. But you can generate videos instead of images for your posts as well 😉 What Problem Is This Workflow Solving? 🤦♂️ Many auto service businesses struggle with consistently posting engaging content due to time constraints or lack of marketing expertise. 💎This workflow solves that by automating the content creation and posting process, ensuring your social media channels stay fresh and active, ultimately attracting more customers. What This Workflow Does: Generates daily social media posts tailored specifically to the auto service niche using AI. Allows easy customization of post and image prompts. Integrates research links through the Tavily Internet Search tool for relevant content. Supports starting posts based on reference article links via Google Sheets. Automatically publishes posts to your connected social media platforms. Enables scheduled or trigger-based posting for maximum flexibility. How It Works? Easy, actually ☺️ AI creates daily social media content made just for Auto Service. You can simply edit prompts for both posts and images, set up news or articles research links via the Tavily Internet Search tool. You can also start the workflow with a reference article link through Google Sheets. 🎯 Consistently posting relevant and actual niche content helps attract new customers, all while leveraging AI and n8n tools to keep the process seamless and cost-effective. Set Up Steps: I kept it quick and simple for you ✨ If you’re happy with the current LLM and image model configurations, just connect your OpenAI API credentials to enable AI content generation. Link your social media accounts (Facebook, Telegram, X, etc.) for autoposting. Optionally connect Google Sheets if you want to trigger posts based on sheet updates with reference links. Customize prompts as needed to match your brand voice, style and marketing tasks. Choose between: 1) Scheduled automatic generation and posting at the same time as socials algorythms like it. 2) Google Sheets trigger with reference. 3) Manual start. How to Customize This Workflow to Your Needs? Switch AI models and edit prompts to better reflect your specific services or promotions. Add or modify research links in Tavily to keep your posts timely and relevant. Adjust posting schedules to match peak engagement times for your audience. Expand or reduce the number of social platforms integrated depending on your marketing strategy. Use Google Sheets to batch upload ideas or curate specific content topics. After adjusting a few settings, activate the workflow and let it run. 🤖 The system will then automatically publish your content across your selected social platforms — saving you time and effort. 📌 You’ll find more detailed tips and additional ai models for customizing ai generation process inside the workflow via sticky notes. 💬 Need help? For additional guidance, feel free to message me — here’s my profile in the n8n community for direct contact 👈 click!
Email support agent w/ Gemini & GPT fallback using Gmail + Google Sheets
📧 Master Your First AI Email Agent with Smart Fallback! Welcome to your hands-on guide for building a resilient, intelligent email support system in n8n! This workflow is specifically designed as an educational tool to help you understand advanced AI automation concepts in a practical, easy-to-follow way. --- 🚀 What You'll Learn & Build: This powerful template enables you to create an automated email support agent that: Monitors Gmail for new customer inquiries in real-time. Processes requests using a primary AI model (Google Gemini) for efficiency. Intelligently falls back to a secondary AI model (OpenAI GPT) if the primary model fails or for more complex queries, ensuring robust reliability. Generates personalized and helpful replies automatically. Logs every interaction meticulously to a Google Sheet for easy tracking and analysis. --- 💡 Why a Fallback Model is Game-Changing (and Why You Should Learn It): Unmatched Reliability (99.9% Uptime): If one AI service experiences an outage or rate limits, your automation seamlessly switches to another, ensuring no customer email goes unanswered. Cost Optimization: Leverage more affordable models (like Gemini) for standard queries, reserving premium models (like GPT) only when truly needed, significantly reducing your API costs. Superior Quality Assurance: Get the best of both worlds – the speed of cost-effective models combined with the accuracy of more powerful ones for complex scenarios. Real-World Application: This isn't just theory; it's a critical pattern for building resilient, production-ready AI systems. --- 🎓 Perfect for Beginners & Aspiring Automators: Simple Setup: With drag-and-drop design and pre-built integrations, you can get this workflow running with minimal configuration. Just add your API keys! Clear Educational Value: Learn core concepts like AI model orchestration strategies, customer service automation best practices, and multi-model AI implementation patterns. Immediate Results: See your AI agent in action, responding to emails and logging data within minutes of setup. --- 🛠️ Getting Started Checklist: To use this workflow, you'll need: A Gmail account with API access enabled. A Google Sheets document created for logging. A Gemini API key (your primary AI model). An OpenAI API key (your fallback AI model). An n8n instance (cloud or desktop). --- Embark on your journey to building intelligent, resilient automation systems today!
Explore n8n nodes in a visual reference library
WATCH THE n8n STARTER GUIDE 👇 [](https://www.youtube.com/watch?v=It3CkokmodE&list=PL1Ylp5hLJfWeL9ZJ0MQ2sK5y2wPYKfZdE&index=1&pp=gAQBiAQBsAQB) This template is featured in the n8n Starter Guide series. The template is free, but comes with two additional PDFs and a Quick Start video if you grab the full download pack on gumroad. How it works This template is a visual map of many useful n8n nodes. It groups nodes like Triggers, AI tools, and App connectors onto the canvas. Explore the sections to learn about different nodes and easily copy them for your own workflows. It acts as a handy visual reference guide. Set up steps • Setup takes about 5 minutes. • Import the template into your n8n instance. • Explore the node categories visually on the canvas. • A Quick Start video is included in the download pack, along with a prompts PDF and PDF with links to other awesome n8n templates here on the n8n template gallery.
Automate WhatsApp booking system with GPT-4 Assistant, Cal.com and SMS reminders
AI-powered WhatsApp booking system with instant SMS confirmations Who is this for? This workflow is designed for solo entrepreneurs, consultants, coaches, clinics, or any business that handles client appointments and wants to automate the entire scheduling experience via WhatsApp — without the need for live agents. What problem is this workflow solving? Responding to inbound messages, collecting booking details, suggesting available times, and sending reminders can be a huge time drain. This workflow eliminates manual handling by: Automating WhatsApp conversations with an AI assistant Booking appointments directly into Cal.com Sending timely SMS reminders before appointments It ensures you never miss a lead or a follow-up — even while you sleep. What this workflow does From a single WhatsApp message, the workflow: Triggers via a WhatsApp webhook Uses GPT-4 to handle conversation flow and qualify the prospect Collects name, email, selected service Calls Cal.com API to fetch available time slots Books the appointment and stores it in Google Sheets Sends a confirmation message via WhatsApp Periodically scans for upcoming appointments Sends SMS reminders to clients 2 hours before their session Setup Connect your Webhook node to a WhatsApp API (e.g., 360dialog, Twilio, or Ultramsg) Add your OpenAI API key for the GPT-4 nodes Configure your Cal.com API key and set your calendar ID Link your Google Sheets with fields like: name, email, date, time, status, reminder_sent Connect your SMS service (e.g., sms77) with API credentials Adjust the schedule in the reminder node as needed How to customize this workflow to your needs Change the language or tone of the AI assistant by editing the system prompt in the GPT node Filter available time slots by service, team member, or duration Modify the reminder timing (e.g., 1 hour before, 24h before, etc.) Add conditional logic to route users to different booking flows based on their responses Integrate additional CRMs or notification channels like email or Slack 📄 Documentation: Notion Guide --- Need help customizing? Contact me for consulting and support : Linkedin / Youtube
Track AI agent token usage and estimate costs in Google Sheets
This n8n template demonstrates how to obtain token usage from AI Agents and places the data into a spreadsheet that calculates the estimated cost of the execution. Obtaining the token usage from AI Agents is tricky, because it doesn't provide all the data from tool calls. This workflow taps into the workflow execution metadata to extract token usage information. Works well with OpenAI, Google and Anthropic. Other LLM providers might need small tweaks. How it works The AI Agent executes and then calls a subworkflow to calculate the token usage. The data is stored in Google Sheets The spreadsheet has formulas to calculate the estimated cost of the execution. How to use The AI Agent is used as an example. Feel free to replace this with other agents you have. Call the subworkflow AFTER all the other branches have finished executing. Requirements LLM account (OpenAI, Gemini...) for API usage. Google Drive and Sheets credentials n8n API key of your instance
Extract invoice data from Google Drive to Sheets with Mistral OCR and Gemini
Extract data from any PDF or image invoice dropped in Google Drive directly into Google Sheets – powered by AI OCR. Free, fully modifiable n8n workflow. Optional add-ons for pro features. 🚀 What this template does Stop typing invoice data by hand. Drop a PDF or phone-snapshot into your Invoices Inbox folder in Google Drive and this n8n workflow will: Auto-OCR the document with the Mistral OCR API Match any fields you list in Row 1 of your Google Sheet (totally schema-agnostic) Append a clean, structured row – every time Works with both PDFs and images, in any language supported by Mistral. Template JSON included, ready to import into self-hosted or n8n Cloud 👀 Who’s this for? Freelancers & agencies processing client invoices Small finance teams on Google Workspace Anyone self-hosting n8n who wants an AI OCR flow without glue-code No coding skills required – but flow tweaking is possible for power users. 🛠 Upcoming PRO Add-Ons I am also working on PRO add-ons for this template: Add-On 1 – Error Handling & Alerts (ships Jul 2025)• Flags missing fields, branches to Email/Slack notification; prevents silent failures Add-On 2 – Auto-Currency Converter (ships Jul 2025)• Detects invoice currency symbol/code → converts Total into your base currency via a free FX API Add-On 3 – VAT / GST Breakdown (ships Jul 2025)• Extracts VAT number, net, tax rate, tax amount, gross – ready for EU/UK/AU filings To pre-order these please see: https://ysqander.gumroad.com/l/N8N-AI-Workflow-Invoice-Data-Extraction-LITE
Image creation with OpenAI and Telegram
Image Creation with OpenAI and Telegram Check this channel: AutoTechAi_bot Description: In the realm of automation and artificial intelligence, n8n offers a sophisticated platform for seamlessly integrating AI algorithms to enhance image creation and communication processes. This innovative workflow leverages the capabilities of OpenAI and Telegram to facilitate creative image generation and streamline communication channels, ultimately enhancing user engagement and interaction. How to Use: Set Up Credentials: Configure credentials for the Telegram account and OpenAI API to enable seamless integration. Configure Nodes: Telegram Trigger Node: Set up the node to initiate the workflow based on incoming messages from users on Telegram. OpenAI Node: Utilize advanced AI algorithms to analyze text content from messages and generate intelligent responses. Telegram Node: Send processed data, including images and responses, back to users on Telegram for seamless communication. Merge Node: Organize and combine processed data for efficient handling and integration within the workflow. Aggregate Node: Aggregate all item data, including binaries if specified, for comprehensive reporting and analysis purposes. Run Workflow: Initiate the workflow to leverage AI-enhanced image processing and communication capabilities for enhanced user interactions. Monitor Execution: Keep an eye on the workflow execution for any errors or issues that may occur during processing. Customize Workflow: Tailor the workflow nodes, parameters, or AI models to align with specific business objectives and user engagement strategies. Experience Benefits: Embrace the power of AI-driven image processing and interactive communication on Telegram to elevate user engagement and satisfaction levels. By following these steps, businesses can unlock the transformative potential of AI integration in image creation and communication workflows using n8n. Elevate your user engagement strategies and deliver exceptional experiences to your audience through innovative AI-driven solutions. Embark on a journey of innovation and efficiency with AI integration in image creation and communication workflows using n8n!
Automated video creation using Google Veo3 and n8n workflow
Who is this for? Content creators, social media managers, digital marketers, and businesses looking to automate video production without expensive equipment or technical expertise. What problem is this workflow solving? Traditional video creation requires cameras, editing software, voice recording equipment, and hours of post-production work. This workflow eliminates all these barriers by automatically generating professional videos with audio using just text prompts. What this workflow does This automated workflow takes video ideas from Google Sheets, generates optimized prompts using AI, creates videos through Google's V3 model via Fal AI, monitors the generation progress, and saves the final video URLs back to your spreadsheet for easy access and management. Setup Sign up for Fal AI account and obtain API key Create Google Sheet with video ideas and status columns Configure n8n with required credentials (Google Sheets, Fal AI API) Import the workflow template Set up authentication for all connected services Test with sample video idea How to customize this workflow to your needs Modify the AI prompts to match your brand voice, adjust video styles and camera movements, change polling intervals for video generation status, customize Google Sheet column mappings, and add additional processing steps like thumbnail generation or social media posting.
Enhance customer chat by buffering messages with Twilio and Redis
This n8n workflow demonstrates a simple approach to improve chat UX by staggering an AI Agent's reply for users who send in a sequence of partial messages and in short bursts. How it works Twilio webhook receives user's messages which are recorded in a message stack powered by Redis. The execution is immediately paused for 5 seconds and then another check is done against the message stack for the latest message. The purpose of this check lets use know if the user is sending more messages or if they are waiting for a reply. The execution is aborted if the latest message on the stack differs from the incoming message and continues if they are the same. For the latter, the agent receives the buffered messages up to that point and is able to respond to them in a single reply. Requirements A Twilio account and SMS-enabled phone number to receive messages. Redis instance for the messages stack. OpenAI account for the language model. Customising the workflow This workflow should work for other common messaging platforms such as Whatsapp and Telegram. 5 seconds too long or too short? Adjust the wait threshold to suit your customers.