OpenAI with RAG andWooCommerce
Workflow Description
An advanced automation template that combines OpenAI's language model with RAG (Retrieval-Augmented Generation) to create an intelligent chatbot. It retrieves data from WooCommerce stores, processes documents via vector embeddings, and maintains conversation context for seamless customer interactions.
How it works
- 1.Receive customer inquiries through the chat trigger interface
- 2.Search the vector database for relevant information using OpenAI embeddings
- 3.Extract product data and orders from WooCommerce based on query context
Use cases
- Intelligent customer support that answers questions about products, inventory, and pricing in real-time
- Process complex document queries by loading and splitting content from Google Drive and external sources
- Publish structured responses and insights to social media channels like Twitter/X automatically
Requirements
- Valid OpenAI API key configured for language model and embedding operations
- Connected WooCommerce store and Google Drive accounts for real-time data access
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (25)
When chat message received
Chat Trigger
Window Buffer Memory
Memory Buffer Window
Calculator
Tool Calculator
Edit Fields
Set
OpenAI Chat Model
OpenAI
RAG
Tool Vector Store
Qdrant Vector Store
Vector Store Qdrant
Embeddings OpenAI
OpenAI
OpenAI Chat Model1
OpenAI
personal_shopper
Woo Commerce Tool
Information Extractor
Information Extractor
OpenAI Chat Model2
OpenAI
Google Drive2
Google Drive
Google Drive1
Google Drive
Embeddings OpenAI3
OpenAI
Default Data Loader2
Document Default Data Loader
Token Splitter1
Text Splitter Token Splitter
When clicking ‘Test workflow’
Manual Trigger
HTTP Request
HTTP Request
Sticky Note
Sticky Note
Qdrant Vector Store1
Vector Store Qdrant
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
AI Agent
Agent