Templates / Personal shopper chatbot for WooCommerce with RAG using Google Drive and openAI

Personal shopper chatbot for WooCommerce with RAG using Google Drive and openAI

Needs changes

by Davide Boizza ✓ · 13,795 views · created 2025-01-23 · Support Chatbot, AI Chatbot

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 21 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Vector Store Question Answer, Qdrant Vector Store and Embeddings OpenAI and 2 more.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

  1. HTTP Request: calls an HTTP API (POST)
  2. Edit Fields (Edit Fields (Set)): sets 2 fields: sessionId, chatInput
  3. Google Drive: work with file folder
  4. Information Extractor: extracts structured fields from text with AI, with model: OpenAI Chat Model
  5. Google Drive: download
  6. AI Agent: runs an AI agent, with model: OpenAI Chat Model; 3 tools (RAG, Calculator, personal_shopper); memory: Window Buffer Memory
  7. Qdrant Vector Store: stores documents in the Qdrant vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader

Services it uses

OpenAI Chat ModelVector Store Question AnswerQdrant Vector StoreEmbeddings OpenAIWooCommerceGoogle Drive

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • AI Agent v1 (old agent modes) in AI Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Removed in 3.0Replace with
AI Agent v1 (old agent modes)
AI Agent (v1.7)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (16)

From the author

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…

Excerpt from Davide Boizza's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.