by Daniel Lianes
Auto-generate SEO blog posts from Google Trends to WordPress This workflow provides complete blog automation from trend detection to publication. It eliminates manual content research, writing, and publishing by using AI agents, Google Trends analysis, and WordPress integration for hands-free blog management that scales your content strategy. Overview This workflow automatically handles the entire blog creation pipeline using advanced AI coordination and SEO optimization. It manages trend discovery, topic selection, content research, writing, HTML formatting, and WordPress publishing with built-in internal linking and comprehensive performance tracking. Core Function: Autonomous blog generation that transforms trending Google searches into SEO-optimized WordPress posts with zero manual intervention, maintaining consistent publishing schedules while capturing emerging traffic opportunities. Key Capabilities Automated trend detection** - Discovers emerging topics using Google Trends via SerpAPI before they become saturated AI-powered topic selection** - Intelligent evaluation of search volume, user intent, and competition levels Content research automation** - Perplexity API integration for reliable source gathering and fact verification SEO-optimized writing** - AI agents create keyword-focused, engaging content with proper structure Internal linking intelligence** - Automatic cross-linking with existing posts for enhanced SEO authority WordPress publishing** - Direct publication with semantic HTML formatting and complete metadata Performance tracking** - Comprehensive logging in Google Sheets for analytics and optimization Tools Used n8n**: Workflow orchestration platform managing the entire automation pipeline SerpAPI**: Google Trends data access and trend analysis for keyword discovery Perplexity API**: Reliable content research and fact-checking for authoritative sources OpenRouter**: Gateway to multiple AI models for specialized content generation tasks WordPress API**: Direct publishing integration with full metadata and formatting control Google Sheets**: Performance logging, internal link database, and analytics tracking Built-in SEO Logic**: Automated slug generation, meta descriptions, and HTML optimization How to Install Import the Workflow: Download the JSON file and import into your n8n instance Configure API Access: Set up SerpAPI, Perplexity, and OpenRouter credentials in n8n WordPress Integration: Add WordPress site credentials and enable REST API access Google Sheets Setup: Create tracking spreadsheet using provided template structure Schedule Configuration: Set desired publication frequency (daily, weekly, or custom) Content Customization: Adjust AI prompts and SEO parameters for your niche Test Execution: Run manual test to verify all integrations work correctly Use Cases Content Marketing Automation**: Maintain consistent blog publishing without manual content creation SEO Traffic Capture**: Generate optimized posts targeting trending keywords before competition Authority Building**: Regular publication on emerging topics to establish thought leadership Organic Growth Strategy**: Systematic content creation that builds domain authority over time Content Calendar Management**: Automated scheduling eliminates manual planning and publishing Internal Link Building**: Systematic SEO improvement through intelligent cross-linking strategy Setup requirements SerpAPI account**: For Google Trends data access and trend monitoring capabilities Perplexity API**: Professional content research and reliable source verification OpenRouter account**: Access to GPT-4.1 and other advanced AI models for content generation WordPress site**: With REST API enabled and proper user permissions configured Google Sheets**: For comprehensive performance tracking and internal link database management Total setup time: 15-20 minutes once all API accounts are properly configured. How to customize Content Focus: Modify trend detection parameters and keyword filters to target your specific niche. Adjust topic selection criteria based on your content strategy and audience interests. Writing Style: Customize AI writing prompts to match your brand voice, adjust article length requirements, modify tone and complexity, or update HTML template structure for consistent formatting. SEO Strategy: Update internal linking logic for your site structure, modify meta description templates, adjust keyword density parameters, or customize slug generation patterns. Publishing Control: Change automation frequency, add human review checkpoints, integrate with social media platforms, or connect to email marketing systems for content distribution. Performance Optimization: Adjust Google Sheets tracking columns, modify trend analysis parameters, or integrate with analytics platforms for deeper insights. Google Sheets Template The workflow includes a pre-configured Google Sheets template for tracking: Publication dates and performance metrics Target keywords and search volume data Internal link mapping and SEO improvements Content performance analytics WordPress URLs and metadata tracking Template Structure: Date Published | Title | Slug | Target Keyword | WordPress URL | Internal Links Added | Traffic Data Was this helpful? Let me know! I truly hope this automated blog system helps scale your content strategy. Your feedback helps me create better automation resources for the community. Want to take content automation further? If you're looking to optimize your content strategy or need custom automation solutions: Advisory (Discovery Call): Have content goals but unsure how automation can help? Let's explore how AI-powered workflows can transform your content pipeline and drive organic growth. Schedule a Discovery Call Custom Content Automation: Need a tailored solution for your specific content workflow, CMS integration, or multi-platform publishing strategy? Let's build the perfect automation for your needs. Book Content Automation Consulting Stay Updated on Automation For more content automation strategies, AI workflow tips, and business automation insights: Follow me on LinkedIn #n8n #automation #wordpress #seo #contentmarketing #ai #blogging #googletrends #serpapi #perplexity #workflow #contentautomation #seooptimization #aiwriting #blogautomation #digitalmarketing #contentcreation #organicgrowth #inboundmarketing #productivity
by Easy8.ai
Auto-Generate SEO FAQ Answers from Google Sheets with OpenAI Intro/Overview This workflow automates the process of generating SEO-optimized FAQ answers using AI, pulling questions from a Google Sheet and writing answers back into the same sheet. It’s ideal for content marketers, SEO specialists, and digital teams looking to scale FAQ content generation with minimal manual input. By combining the power of Google Sheets, AI, and WordPress, the workflow transforms raw questions into structured, keyword-targeted answers tailored for specific audiences — ready for use on landing pages, blogs, or help centers, and automatically publishes them as WordPress posts. How it works Schedule Trigger**: Executes the workflow at a set interval to check for new or unprocessed questions in the Google Sheet. Get Questions from Sheet**: Reads from a specific Google Sheet, targeting columns for: Question (FAQ prompt) KW (target SEO keyword) Audience (intended reader) Article (desired WordPress post title) Filter**: Ensures only rows without an existing answer are processed (i.e., empty "Answer" column). Generate FAQ Answer**: Passes the question, keyword, and audience to the OpenAI Chat Model using a structured prompt to generate: A concise TL;DR-style summary A detailed, SEO-optimized markdown-formatted answer OpenAI Chat Model**: Utilizes GPT-4 Turbo with a controlled temperature (0.7) and token limit (1000) to produce structured, on-brand, keyword-optimized content. Parse FAQ Answer**: Extracts and formats the AI response into separate fields for writing back to the sheet. Update Sheet with Answer**: Writes the AI-generated answer into the Answer column of the same row in the source Google Sheet. WordPress Node**: Publishes each generated answer as a new WordPress post Uses “Create Post” operation Title: Taken from the Article column in the sheet Content: Uses the detailed AI-generated answer Requires valid WordPress credentials (REST API / Application Password) How to Use Importing the Workflow Download or import the workflow JSON into your n8n instance. Credential Setup Connect your Google Sheets credentials. Add your OpenAI API Key in the relevant node. Connect your WordPress credentials for content publishing. Node Assignment Update the following: Google Sheet ID Sheet range (ensure it includes all relevant columns) Timezone & Schedule Adjust the Schedule Trigger node to match your preferred time and frequency (e.g., every weekday at 9 AM). Testing Guidance Add a few sample FAQ entries in your sheet. Run the workflow manually to verify: Prompt quality Answer accuracy Proper sheet update Successful WordPress post creation Example Use Cases Marketing teams generating bulk FAQ content for landing pages SEO professionals creating keyword-optimized responses for user queries Agencies producing personalized FAQ sections for multiple client niches SaaS companies automating knowledge base content with targeted messaging Content teams publishing AI-generated FAQs directly to WordPress blogs Requirements ✅ Google Account with access to the target Google Sheet ✅ OpenAI API Key (GPT-4 Turbo or equivalent) ✅ WordPress account with REST API or Application Password access ✅ Google Sheet with the following columns: Question: The FAQ prompt KW: Target keyword for SEO Audience: Intended reader persona Article: Desired WordPress post title Answer: Output column (leave empty initially) Customization (Optional Section) Tone & Style**: Modify the system prompt to reflect your brand voice (e.g., friendly, expert, concise). Model**: Use a different AI model (e.g., Gemini, Claude, or OpenAI GPT-4.1). Output Format**: Adjust the markdown output to use different heading levels, bullet styles, or HTML if required. Audience Logic**: Expand the input options to fine-tune responses for more specific demographics or buyer personas. Multi-output Options**: Extend the workflow to post content to Notion, CMS, or documentation platforms alongside Google Sheets and WordPress. This automation accelerates content creation, automatically keeps your FAQ sections SEO-friendly, and publishes the results directly to WordPress — keeping your content pipeline running hands-free once deployed.
by DANIEL RUIZ
What this workflow does This workflow automatically generates and publishes Instagram content using AI. It: Generates content ideas using AI Creates images automatically Edits images (resize/format) Publishes directly to Instagram How it works Trigger starts the workflow (manual or scheduled) AI generates a content idea and prompt Image is generated via API Image is processed and formatted Post is published automatically Setup Connect your OpenAI (or AI provider) credentials Add your image generation API key Connect your Instagram account (Optional) Connect Google Drive for storage Setup time: 15–20 minutes
by Natnail Getachew
Who’s it for This workflow is ideal for: Content creators producing daily historical or educational videos YouTube automation enthusiasts building AI-driven channels Educators sharing engaging historical facts in short-form video format Anyone creating an automated AI video pipeline with human approval How it works This workflow automates the full pipeline of generating and publishing historical videos: Triggers daily at 1 AM and initializes retry tracking (maximum 3 attempts) Fetches historical events for the current date and selects one randomly Uses Google Gemini to generate a cinematic text-to-video script Sends the prompt to fal.ai (Hunyuan LoRA) to generate a short video Polls the generation status every 30 seconds until the video is ready Downloads the generated video and sends it to Telegram with context Waits for manual approval via Telegram If approved → uploads the video to YouTube and sends a confirmation message If declined → retries with a new event (up to 3 attempts total) How to set up Import the workflow into n8n Configure your Telegram credentials Set your Telegram Chat ID using a variable or Set node (avoid hardcoding) Configure HTTP Header Auth credentials for fal.ai (API key required) Set up Google Gemini API credentials Connect your YouTube account using OAuth2 (Optional) Adjust the schedule time in the trigger node Activate the workflow Requirements n8n (cloud or self-hosted) fal.ai account and API key (for video generation) Google Gemini API access YouTube account with upload permissions Telegram account for approval notifications How to customize the workflow Adjust retry limits in the retry logic node Modify video parameters (resolution, frames, aspect ratio) in the fal.ai request Change the script style by editing the Gemini prompt Replace the historical events API with another content source Customize Telegram messages or approval flow
by Miftah Rahmat
Automate Water Bill Calculations with Telegram, Gemini AI, and Google Sheets This workflow automates the calculation of monthly water bills. Residents can send a photo of their water meter along with their name via Telegram. The workflow uses Gemini AI to extract the meter reading, calculates the usage difference compared to the previous month, and updates a Google Sheet with the billing details. Finally, the workflow sends a summary back via Telegram. Don’t hesitate to reach out if you have any questions or run into issues! 🙌 Requirements A Telegram bot token (created via BotFather). A Google account with access to Google Sheets. A Gemini API key (). A pre-created Google Sheet with the required columns. Google Sheet Setup Create a new Google Sheet with the following columns: Nama, Volume Sebelumnya, Volume Saat Ini, Harga/m³, Jumlah Bayar, Beban, Total Bayar, Tanggal Input Workflow Setup Instructions Connect Google Sheets Add your Google Sheets credentials in n8n. Link the workflow to your sheet with the structure above. Set Up Telegram Bot Create a Telegram bot via BotFather. Copy your bot token into the Telegram Trigger node. Configure Gemini AI Obtain a Gemini API key from Google AI Studio. Add it to your n8n credentials. The workflow will parse the meter reading from the uploaded image. Example Calculation Previous Volume: 535 m³ Current Volume: 545 m³ Usage: 10 m³ Price per m³: Rp3.000 Fixed cost: Rp3.000 Total Bill: Rp33.000 How It Works User sends a photo of the water meter with caption (name). Telegram Trigger receives the message. Gemini AI reads the meter number from the photo. Workflow fetches previous volume from Google Sheets. Usage and total bill are calculated. Data is stored back into Google Sheets. Bot replies in Telegram with detailed bill info. Customization Change Harga/m³ in the sheet to match your community’s water price. Update Beban if your community uses a different fixed fee. Edit the Telegram reply message node to adjust wording. With this workflow, you can streamline water billing for residents, ensure accuracy, and save time on manual calculations.
by PTS
Who this is for Anybody using Firefly III, especially home/self-hosted users, who want to add some level of automation to their transaction tracking, either in addition to or because they can't or don't want to use the dataimporter How it works - posting transactions User sends a transaction screenshot/image or statement to a Telegram bot Gemini analyzes it based on the user's requirements (asset account IDs & categories) The transaction information is parsed to create a suitable POST to a Firefly instance The transaction(s) are posted to Firefly via its API, using an OAuth2 credential How it works - requesting budget reports User sends the word 'Report' via telegram A 'GET' API request is sent to Firefly for all budgets between the beginning of the month and the request date, including remaining amounts for each This is converted to a CSV file The CSV is sent to the user via Telegram Prerequisites Telegram, and knowledge of how to set up a bot (search for BotFather in Telegram) An existing instance of Firefly III with admin access for creating OAuth2 credentials How to set it up - Credentials Open Telegram, and search for BotFather Create a new bot by following the instructions Save the API key provided In n8n, create a new Telegram credential using the info for the new bot Create an OAuth client in Firefly, using the redirect URL found in n8n's OAuth2 API credential creator Fill the n8n OAuth2 API credential form as Authorization Code, filling in the remaining parameters from the info created in Firefly Create a Gemini credential following the instructions in n8n How to set it up - the workflow Set the credential in each Telegram node Set the Firefly credential in each http node Set the correct base URL for the Firefly instance in each http node Set the desired Gemini credential and model in each AI node Set the correct Bank IDs (as per Firefly) and preferred categories in the AI node system message Customization options The user can specify all types of asset and expense accounts, as well as a specific list of categories and descriptions for Gemini to use. Gemini can also be swapped out for any other AI/LLM. Additionally, anyone can build on this by reviewing the Firefly API documents to automate almost any other part of the Firefly software.
by Jannik Hiller
How it works Runs on schedule (Monday-Friday at 9 AM) to automate lead generation Searches for companies on Google Maps by location and category Extracts owner information from company websites and impressum pages Enriches leads with email addresses and LinkedIn profiles using Lemlist Generates personalized compliment messages using Claude AI Creates custom video messages with Pitchlane Uploads qualified leads to your CRM for follow-up Set up steps Configure Google Maps search parameters (location, category, search terms) Add Serper API credentials for Google Maps search Connect Lemlist for lead enrichment and upload Configure Pitchlane API credentials for video creation Set up Google Docs for documentation and notes Connect Claude AI for personalized message generation Adjust the schedule trigger time if you want a different time than 9 AM Keep detailed workflow notes in the sticky notes inside your workflow
by Dahiana
Who's it for Marketing teams, content creators, and agencies managing Webflow CMS sites who need to optimize SEO metadata at scale. How it works The workflow fetches CMS items from Webflow, then uses AI to rewrite titles and descriptions to meet SEO best practices (50-60 character titles, 120-155 character meta descriptions). It automatically publishes changes back to Webflow and logs all updates to Google Sheets for audit purposes. Requirements Webflow site with CMS collections MCP Webflow OAuth2 credentials Any LLM api Google Sheets for logging (optional) How to set up Get your collection ID: In Webflow, go to your CMS collection → copy the collection ID Update Set Fields node: Replace collectionId with yours Update Format for Update node: Replace collectionId Match field names: If your collection uses different fields than "name" and "project-summary", update the agent prompt and Format for Update code Test first: Set batch size to 1 and run on a single item Scale up: Increase batch size gradually How to customize Change character limits: Adjust minTitleLength, maxTitleLength, minSummaryLength, maxSummaryLength in Set Fields node. Add more fields like alt-text, post body, slug, etc. Different field names: Update agent system prompt, Structured Output Parser schema, and Format for Update code
by Afigo Sam
🚀 Overview Transform your Telegram channel or group into a fully functional, automated e-commerce storefront. This n8n workflow template allows you to sell both physical and digital products directly within Telegram, utilizing Paystack for secure checkout and Google Sheets as a lightweight, free database for inventory and order management. Say goodbye to complex website builders and monthly subscription fees. With this serverless setup, you can launch a store in minutes and manage everything from a simple spreadsheet. ✨ Key Features 🛒 Interactive Shopping Cart:** Users can browse products, select quantities, and manage their cart entirely through seamless Telegram inline buttons. 💳 Secure Payments:** Direct integration with the Paystack API generates unique, secure checkout links for every order. 📦 Smart Fulfillment:** Automatically detects if an order is digital or physical. Digital goods (e.g., PDFs, E-books via Google Drive) are delivered instantly upon payment confirmation. Physical orders are marked as "Paid" and queued for shipping. 📊 Free Database (Google Sheets):** No SQL required! Manage your product catalog, track active user sessions, and view order history entirely within Google Sheets. 🔍 Order Tracking System:** Customers can use the /orders command or search by their unique ORD- ID to view their purchase history, resume pending payments, or track shipped items. ⚙️ Built-in Validation:** Includes robust data validation for email addresses (catching common typos like .con) and physical delivery addresses. 🛠 Prerequisites To run this template, you will need the following accounts: Telegram: A free Telegram Bot Token (obtained via BotFather). Paystack: A Paystack account to receive payments (you will need your Secret Key). Google Workspace: A Google account to host the Google Sheets database and Google Drive (if selling digital files). 📝 Setup Instructions 1. Database Setup Create a new Google Sheet (Template; https://docs.google.com/spreadsheets/d/1x58FYmsdo2K2dKNm81LgCSrGvHwhenkJTtjDIxc8-2w/edit?gid=187299608#gid=187299608 with three tabs: Products, Orders, and Session. Products Tab Headers: id, name, price, type (physical/digital), stock, description, file_url (optional, for digital goods). Orders Tab Headers: order_id, reference, user_id, email, address, items_json, total, status, payment_link, tracking, created_at. Session Tab Headers: user_id, chat_id, state, cart_json, selected_product_id, selected_product_name, selected_product_price, selected_product_type, input_quantity, input_email, input_address. 2. n8n Node Configuration Import this template into your n8n workspace. Update the Google Sheets credentials and replace the Document ID in all sheet nodes with your specific spreadsheet ID. Add your Telegram Bot Token via n8n's credential manager to activate the Telegram Trigger and messaging nodes. Locate the nodes containing the YOUR_PAYSTACK_SECRET_KEY placeholder (e.g., Paystack Init Transaction) and insert your actual Paystack Secret Key. 3. Webhook Activation Double-click the Paystack Webhook node. Copy the "Production URL" provided by n8n. Log into your Paystack Dashboard, navigate to Settings > Webhooks, and paste the URL. This ensures your bot receives real-time payment confirmations. 💡 Use Cases Digital Creators:** Sell e-books, courses, templates, or software directly to your Telegram audience with instant file delivery. Local Businesses:** Automate orders for physical goods, food delivery, or merchandise without needing a dedicated website. Dropshipping:** Seamlessly collect orders and addresses before forwarding them to suppliers. 🔗 Apps Integrated Telegram Paystack Google Sheets Google Drive (Optional) You can also test the workflow live on Telegram: @sellvia_paystack_bot or https://t.me/sellvia_paystack_bot) 👋 Need help or want to customize this workflow? 📺 Contact: Fiverr 📩 Consultation: Book Appointment
by Afigo Sam
Transform your Telegram channel or group into a fully functional, automated e-commerce storefront. This n8n workflow template allows you to sell both physical and digital products directly within Telegram, utilizing Flutterwave for secure checkout and Google Sheets as a lightweight, free database for inventory and order management. Say goodbye to complex website builders and monthly subscription fees. With this serverless setup, you can launch a store in minutes and manage everything from a simple spreadsheet. ✨ Key Features 🛒 Interactive Shopping Cart: Users can browse products, select quantities, and manage their cart entirely through seamless Telegram inline buttons. 💳 Secure Payments: Direct integration with the Flutterwave API generates unique, secure checkout links for every order. 📦 Smart Fulfillment: Automatically detects if an order is digital or physical. Digital goods (e.g., PDFs, E-books via Google Drive) are delivered instantly upon payment confirmation. Physical orders are marked as “Paid” and queued for shipping. 📊 Free Database (Google Sheets): No SQL required! Manage your product catalog, track active user sessions, and view order history entirely within Google Sheets. 🔍 Order Tracking System: Customers can use the /orders command or search by their unique ORD- ID to view their purchase history, resume pending payments, or track shipped items. ⚙️ Built-in Validation: Includes robust data validation for email addresses (catching common typos like .con) and physical delivery addresses. 🛠 Prerequisites To run this template, you will need the following accounts: Telegram: A free Telegram Bot Token (obtained via BotFather). Flutterwave: A Flutterwave account to receive payments (you will need your Secret Key and hash/Encryption Key). Google Workspace: A Google account to host the Google Sheets database and Google Drive (if selling digital files). 📝 Setup Instructions Database Setup Create a new Google Sheet (Template; https://docs.google.com/spreadsheets/d/1x58FYmsdo2K2dKNm81LgCSrGvHwhenkJTtjDIxc8-2w/edit?gid=187299608#gid=187299608 with three tabs: Products, Orders, and Session. Products Tab Headers: id, name, price, type (physical/digital), stock, description, file_url (optional, for digital goods). Orders Tab Headers: order_id, reference, user_id, email, address, items_json, total, status, payment_link, tracking, created_at. Session Tab Headers: user_id, chat_id, state, cart_json, selected_product_id, selected_product_name, selected_product_price, selected_product_type, input_quantity, input_email, input_address. n8n Node Configuration Import this template into your n8n workspace. Update the Google Sheets credentials and replace the Document ID in all sheet nodes with your specific spreadsheet ID. Add your Telegram Bot Token via n8n’s credential manager to activate the Telegram Trigger and messaging nodes. Locate the nodes containing the YOUR_FLUTTERWAVE_SECRET_KEY placeholder (e.g., Flutterwave Init Transaction) and insert your actual Flutterwave Secret Key. Webhook Activation Double-click the Flutterwave Webhook node. Copy the “Production URL” provided by n8n. Log into your Flutterwave Dashboard, navigate to Settings > Webhooks, and paste the URL. This ensures your bot receives real-time payment confirmations. 💡 Use Cases Digital Creators: Sell e-books, courses, templates, or software directly to your Telegram audience with instant file delivery. Local Businesses: Automate orders for physical goods, food delivery, or merchandise without needing a dedicated website. Dropshipping: Seamlessly collect orders and addresses before forwarding them to suppliers. 🔗 Apps Integrated Telegram Flutterwave Google Sheets Google Drive (Optional) You can also test the workflow live on Telegram: @flutterwave_sell_bot or http://t.me/flutterwave_sell_bot) 👋 Need help or want to customize this workflow? 📺 Contact: Fiverr 📩 Consultation: Book Apoointment
by Mariyan Nijan
What this workflow does This workflow builds a Retrieval-Augmented Generation (RAG) document chat assistant inside n8n using Supabase Vector Store and AI models. The workflow allows users to upload documents, convert them into embeddings, store them inside Supabase pgvector, and query them through an AI chat interface using semantic search. When a user sends a question through the webhook endpoint, the workflow retrieves the most relevant document chunks from Supabase and uses an AI model to generate a grounded response based on the uploaded documents. This template includes: Document ingestion pipeline Recursive text chunking AI embeddings generation Supabase vector storage Semantic retrieval AI-powered document question answering Webhook API integration for frontend apps How it works The workflow is split into two main parts: Document ingestion pipeline Downloads documents from Google Drive Extracts text from PDFs Splits text into smaller chunks Generates embeddings using AI models Stores embeddings inside Supabase pgvector RAG chat pipeline Receives user questions through a webhook Searches Supabase vector database for relevant content Retrieves matching document chunks Sends retrieved context to the AI model Returns grounded responses back to the frontend Requirements n8n instance Supabase account with pgvector enabled Google Drive account AI provider credentials (OpenRouter, Gemini, or OpenAI) Setup Create a Supabase project and enable pgvector Create the required documents table and match_documents function Connect your Supabase credentials in n8n Connect your AI model credentials Add your Google Drive credentials Upload your documents and run the ingestion workflow Use the webhook endpoint to connect your frontend application Setup typically takes around 15–30 minutes. How to customize You can customize this workflow by: Switching AI providers (Gemini, OpenRouter, OpenAI) Adjusting chunk size and retrieval count Connecting your own frontend UI Adding support for multiple document sources Expanding the workflow into a multi-user knowledge assistant This workflow is designed as a practical starting point for building AI-powered document assistants and RAG applications inside n8n.
by Davide
This workflow is a complete AI-powered customer support automation for e-commerce businesses. The system allows customers to interact with an AI assistant directly through WhatsApp. This chatbot can: Answer customer questions in real time Retrieve order information from WooCommerce Search products and provide recommendations Access company policies and FAQs using RAG (Retrieval-Augmented Generation) Escalate conversations to human support when necessary Maintain conversation memory for contextual interactions Apply AI guardrails for safer conversations Key Advantages 1. ✅ Fully Automated Customer Support The workflow dramatically reduces manual customer support workload by automating: FAQs Order tracking Product inquiries Return policy questions Technical troubleshooting This enables 24/7 support availability without human intervention. 2. ✅ Native WhatsApp Integration Using Whapi, customers can communicate through WhatsApp — one of the most widely used messaging platforms globally. 3. ✅ AI-Powered Product Assistance The assistant can: Search products in WooCommerce Compare items Recommend products Check stock availability Provide real-time pricing This transforms the chatbot into an intelligent sales assistant, increasing conversion opportunities. 4. ✅ RAG Knowledge Base with Qdrant The workflow uses Retrieval-Augmented Generation (RAG) powered by Qdrant vector search. 5. ✅ Human Escalation System When the AI cannot solve an issue, the workflow automatically escalates the conversation to human support via Gmail. 6. ✅ Multi-Model AI Architecture The workflow combines: Google Gemini for conversational reasoning OpenAI embeddings for semantic retrieval 7. ✅ Persistent Conversation Memory The Window Buffer Memory node maintains contextual conversations. 8. ✅ Built-In Guardrails & Security The workflow includes AI Guardrails to: Filter inappropriate content Block unsafe requests Prevent policy violations Improve AI reliability This is essential for production-ready AI assistants. 9. ✅Real-Time WooCommerce Integration The chatbot interacts directly with WooCommerce APIs to: Retrieve customer profiles Access order history Check shipment status Query products This provides live data instead of static responses. 10. ✅ Modular & Scalable Architecture The workflow is highly modular: Easily customizable Extendable with new tools Compatible with additional APIs Scalable for large e-commerce operations New AI tools or integrations can be added without redesigning the entire system. Ideal Use Cases This workflow is ideal for: E-commerce stores Fashion brands Electronics retailers Customer support automation AI sales assistants WhatsApp commerce Technical support automation Multilingual support systems This workflow represents a production-ready AI customer support system capable of combining conversational AI, semantic search, real-time e-commerce operations, and human escalation into a single automated pipeline. How it works WhatsApp message reception The workflow starts when a WhatsApp message is received via the Get WhatsApp webhook (Whapi). It checks if the message is of type text — if not, it replies with a message saying only text is supported. Guardrails & policy check The message passes through a Guardrails node that filters inappropriate content or policy violations. If the message violates policies, a rejection reply is sent. Customer support AI Agent The message is passed to an AI Agent (powered by Google Gemini or OpenAI). The agent has access to: Memory (Window Buffer Memory) to keep conversation context. Tools for: Retrieving company knowledge via rag_search (from Qdrant). Fetching WooCommerce orders, products, and customers. Performing calculations. Escalating to human support via Gmail. The agent follows a detailed system prompt covering product info, order assistance, technical support, and escalation logic. Response normalization & sending The agent's raw output is cleaned (newlines/tabs escaped) via a Code node. The cleaned response is sent back to the customer via Whapi (Send WhatsApp). Knowledge base vectorization (separate flow) A separate part of the workflow (triggered manually) loads documents from Google Drive, splits them into chunks, generates embeddings via OpenAI, and stores them in Qdrant for semantic search. Set up steps Configure external services & credentials Whapi: Sign up (FREE TRIAL available), get API credentials, and set the webhook URL in Whapi settings to point to your n8n webhook. OpenAI: Create an API key for embeddings and chat model (or use Google Gemini). Qdrant: Set up a Qdrant instance (e.g., on Hetzner) and create API credentials. Google Drive: Authenticate to access document folders. WooCommerce: Generate API keys for order/product/customer retrieval. Gmail: Authenticate for human support escalation. Create Qdrant collection Run the Create collection HTTP request node (update QDRANTURL and COLLECTION name). Upload & vectorize documents Place your knowledge base files (PDFs, text, Google Docs) in a Google Drive folder. Set the folder ID in the Get folder node. Run the manual trigger to load, split, embed, and store documents into Qdrant. Configure the AI Agent Set the system prompt (already provided in the E-Commerce Customer Support AI Agent node). Choose the language model (Gemini or OpenAI) and connect credentials. Ensure all tools (rag_search, WooCommerce nodes, calculator, Gmail) are enabled and properly connected. Set webhook & activate workflow Copy the webhook URL from the Get WhatsApp node. Paste it into your Whapi dashboard as the incoming message webhook. Toggle the workflow to active. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.