Personal Shopper Chatbot for WooCommerce with RAG using Google Drive and openAI

n8n template #2784

Summary

This workflow combines OpenAI, Retrieval-Augmented Generation (RAG), and WooCommerce to create an intelligent personal shopping assistant. It handles two scenarios: Product Search: Extracts user intent (keywords, price ranges, SKUs) and fetches matching products from WooCommerce. 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: sear

How to set it up

Open template #2784 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 4 credentials under Credentials → Add credential: Google Drive, Embeddings OpenAI, OpenAI Chat Model, Qdrant Vector Store. Then open each of those nodes and pick the credential.
Check the model in the AI Agent node. The template may point at a model your account can't use; swap it for one you have access to.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Personal Shopper Chatbot for WooCommerce with RAG using Google Drive and openAI" (https://n8n.io/workflows/2784). It uses: HTTP Request, Google Drive, AI Agent, Embeddings OpenAI, OpenAI Chat Model, Simple Memory, Token Splitter, Calculator, Default Data Loader, Qdrant Vector Store, Vector Store Question Answer Tool, Information Extractor. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

HTTP Request Google Drive AI Agent Embeddings OpenAI OpenAI Chat Model Simple Memory Token Splitter Calculator Default Data Loader Qdrant Vector Store Vector Store Question Answer Tool Information Extractor

Questions

Yes. Davide Boizza published it free on n8n.io as a verified creator, and it has 12K views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Drive, Embeddings OpenAI, OpenAI Chat Model, Qdrant Vector Store. The other 8 nodes are built into n8n.

Similar workflows

NameViews