Personal shopper chatbot for WooCommerce with RAG using Google D
This workflow combines OpenAI, Retrieval-Augmented Generation (RAG), and WooCommerce to create an intelligent personal shopping assistant. It handles two sce...
🔌 Nodes & Integrations Used (12)
📖 Implementation & Setup Guide
This workflow combines **OpenAI**, **Retrieval-Augmented Generation (RAG)**, and **WooCommerce** to create an intelligent personal shopping assistant. It handles two scenarios: 1. **Product Search**: Extracts user intent (keywords, price ranges, SKUs) and fetches matching products from WooCommerce. 2. **General Inquiries**: Answers store-related questions (e.g., opening hours, policies) using RAG and documents stored in Google Drive.
---
**How It Works**
#### **1. Chat Interaction & Intent Detection** - **Chat Trigger**: - Starts when a user sends a message (*"When chat message received"*). - **Information Extractor**: - Uses OpenAI to analyze the message and determine if the user is **searching for a product** or asking a **general question**. - Extracts: - `search` (true/false). - `keyword`, `priceRange`, `SKU`, `category` (if product-related). - Example: ```json { "search": true, "keyword": "red handbags", "priceRange": { "min": 50, "max": 100 }, "SKU": "BAG123", "category": "women's accessories" } ```
#### **2. Product Search (WooCommerce Integration)** - **AI Agent**: - If `search: true`, routes the request to the `personal_shopper` tool. - **WooCommerce Node**: - Queries the WooCommerce store using extracted parameters (`keyword`, `priceRange`, `SKU`). - Filters products in stock (`stockStatus: "instock"`). - Returns matching products (e.g., "red handbags under €100").
#### **3. General Inquiries (RAG System)** - **RAG Tool**: - If `search: false`, uses the **Qdrant Vector Store** to retrieve store information from documents. - **Google Drive Integration**: - Documents (e.g., store policies, FAQs) are stored in Google Drive. - Downloaded, split into chunks, and embedded into Qdrant for semantic search. - **OpenAI Chat Model**: Generates answers based on retrieved documents (e.g., "Our store opens at 9 AM").
**Set Up Steps**
#### **1. Configure the RAG System** - **Google Drive Setup**: - Upload store documents . - Update the **Google Drive2** node with your folder ID. - **Qdrant Vector Database**: - Clean the collection (update **Qdrant Vector Store** node with your URL). - Use **Embeddings OpenAI** to convert documents into vectors.
#### **2. Configure OpenAI & WooCommerce** - **OpenAI Credentials**: - Add your API key to all OpenAI nodes (`OpenAI Chat Model`, `Embeddings OpenAI`, etc.). - **WooCommerce Integration**: - Connect your WooCommerce store (credentials in the `personal_shopper` node). - Ensure product data is synced and accessible.
#### **3. Customize the AI Agent** - **Intent Detection**: - Modify the **Information Extractor**’s system prompt to align with your store’s terminology. - **RAG Responses**: - Update the tool description to reflect your store’s documents.
---
**Notes** This template is ideal for e-commerce businesses needing a hybrid assistant for product discovery and customer support.
**Need help customizing?** [Contact me](mailto:info@n3w.it) for consulting and support or add me on [Linkedin](https://www.linkedin.com/in/davideboizza/).
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Personal_shopper_chatbot_for_WooCommerce_with_RAG_using_Google_D.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....