WooCommerce AI post-sales chatbot with GPT-4o, RAG, Google Drive and Telegram
This WooCommerce-integrated chatbot is designed to transform post-sales customer support by combining automation and artificial intelligence to deliver fast, secure, and personalized assistance. The chatbot retrieves real-time order information, including shipping details and tracking numbers, after verifying the customer's identity through a strict email-based authentication system. Beyond order management, the chatbot answers frequently asked questions about return policies, delivery times, and terms of service using RAG. If a request is too complex, the system seamlessly escalates it to a human operator via Telegram, guaranteeing no customer query goes unresolved. --- Key Features of the Chatbot Order Tracking: Retrieves real-time tracking information for WooCommerce orders, including carrier URLs and pickup dates. Order Details Retrieval: Provides customers with past/current order information after strict email verification. Policy & FAQ Assistance: Answers questions about shipping, returns, and store policies using a vectorized knowledge base (ToS tool). Identity Verification: Ensures privacy by requiring exact email-order matches before sharing sensitive data. Human Escalation: Transfers complex issues to human agents via Telegram when the AI cannot resolve them. Context-Aware Conversations: Maintains dialogue context using memory buffers for seamless interactions. --- Who Benefits from This Chatbot? E-commerce Stores: WooCommerce businesses needing 24/7 automated post-sales support. Customer Support Teams: Reduces ticket volume by handling repetitive queries (tracking, policies). SMBs: Small-to-medium businesses lacking resources for full-time support staff. Customers: Shoppers who want instant, self-service access to order status and FAQs. --- How It Works Customer Interaction: The workflow starts when a customer sends a chat message, triggering the AI agent. Identity Verification: The agent requests the order number and associated email, strictly verifying the match before proceeding. Order & Tracking Retrieval: Using WooCommerce API tools (getorder, gettracking), it fetches order details and tracking information. Policy & Support: The ToS tool answers shipping and policy questions, while human_assistance escalates unresolved issues to a human agent via Telegram. Memory & Context: A buffer memory retains conversation context for coherent interactions. --- Set Up Steps Configure Qdrant Vector Store: Replace QDRANTURL and COLLECTION in the nodes to set up document storage. Add Telegram Chat ID: Insert your Telegram CHATID in the humanassistance node for escalations. Integrate WooCommerce Tracking Plugin: Install the YITH WooCommerce Order Tracking plugin and update the HTTP request URL in the tracking node. Test & Activate: Verify the workflow by testing order queries and ensuring proper email verification. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
By DavideAutomated SEO watchlist: continuous audits with Decodo, Gemini & Google Sheets
Automated SEO Watchlist: Continuous Audits Powered by Decodo, Gemini and Google Sheets Automate continuous SEO audits with Decodo and Gemini AI — live data, smart insights, and Google Sheets tracking with team alerts. Who’s it for This workflow is designed for SEO specialists, marketing teams, agencies, and website owners who want an effortless, automated way to monitor SEO health. It’s perfect for ongoing audits, content monitoring, and proactive SEO management — without the manual workload. How it works / What it does Every five days, the workflow: Reads a list of URLs from Google Sheets. Uses Decodo to fetch live on-page data — titles, meta descriptions, headings, schema, links, and Core Web Vitals. Passes that data to Gemini AI for an advanced SEO analysis and scoring based on key factors (content, metadata, links, speed, and structure). Parses results via a Structured Output Parser for clean JSON output. Stores findings in Google Sheets and sends a Telegram alert when the audit completes. Why Decodo matters Decodo is the backbone of this workflow. It powers the real-time page inspection, ensuring Gemini AI has complete, accurate data to analyze. Decodo transforms static audits into live, intelligent monitoring — making your SEO insights far more actionable and reliable. How to set up Connect your Decodo API credentials. Add your Google Sheets URL list. Configure your Telegram bot credentials. Enable the workflow — it runs automatically every 5 days. Requirements Decodo API credentials Google Sheets OAuth connection Telegram Bot token n8n instance (Cloud or Self-hosted) How to customize the workflow Change the trigger interval in the Schedule Trigger node. Modify the SEO Analyzer (LLM Chain) weights for different scoring. Extend the Store Result node to integrate with dashboards or databases. Adjust the AI prompt for additional SEO checks (e.g., backlinks, readability, image optimization). ✅ Highlights Automated SEO auditing Real-time data from Decodo Smart analysis powered by Gemini AI Structured reporting in Google Sheets Team notifications via Telegram
By Rully Saputra