Who is this workflow for? Enhance your WooCommerce store with an intelligent Personal Shopper Chatbot that leverages OpenAI and Retrieval-Augmented Generation (RAG) technologies. This workflow provides a seamless shopping experience by assisting customers in product searches and addressing general inquiries using your existing Google Drive documents..

What does this workflow do?

1. Chat Interaction & Intent Detection

  • Chat Trigger: The workflow activates when a user sends a message through the chat interface.
  • Information Extractor: Utilizes OpenAI to analyze the incoming message to determine the user’s intent:
  • Product Search: Identifies if the user is searching for a product and extracts relevant details such as keywords, price range, SKU, and category.
  • General Inquiry: Determines if the user is asking a general question about the store.

Example Extraction:

{  "search": true,  "keyword": "red handbags",  "priceRange": { "min": 50, "max": 100 },  "SKU": "BAG123",  "category": "women's accessories"}

2. Product Search (WooCommerce Integration)

  • AI Agent Routing: If a product search is detected (search: true), the request is routed to the personal_shopper tool.
  • WooCommerce Node:
  • Queries the WooCommerce store using the extracted parameters.
  • Filters products that are in stock (stockStatus: "instock").
  • Returns a list of matching products, such as “red handbags under €100.”

3. General Inquiries (RAG System)

  • RAG Tool: If a general inquiry is detected (search: false), the workflow employs the Qdrant Vector Store to retrieve relevant store information from your documents.
  • Google Drive Integration:
  • Stores documents like store policies and FAQs in Google Drive.
  • Downloads and processes these documents by splitting them into chunks and embedding them into Qdrant for semantic search.
  • OpenAI: Generates accurate responses based on the retrieved information, for example, “Our store opens at 9 AM.”

Setup Steps

1. Configure the RAG System

  • Google Drive Setup:
  • Upload your store-related documents to Google Drive.
  • Update the Google Drive2 node with your specific folder ID.
  • Qdrant Vector Database:
  • Clean the existing collection.
  • Update the Qdrant Vector Store node with your database URL.
  • Use OpenAI to convert your documents into vector embeddings for efficient semantic search.

2. Configure OpenAI & WooCommerce

  • OpenAI Credentials:
  • Add your OpenAI API key to all relevant OpenAI nodes within the workflow.
  • WooCommerce Integration:
  • Connect your WooCommerce store by providing the necessary credentials in the personal_shopper node.
  • Ensure that your product data is regularly synced and accessible for accurate search results.

3. Customize the AI Agent

  • Intent Detection:
  • Modify the Information Extractor’s system prompt to align with your store’s specific terminology and needs.
  • RAG Responses:
  • Update the tool descriptions to reflect the content and structure of your store’s documents, ensuring relevant and accurate responses.

🤖 Why Use This Automation Workflow?

  • Enhanced Customer Experience: Provide instant, accurate responses to customer queries, improving satisfaction and engagement.
  • Automated Product Discovery: Streamline the product search process, helping customers find exactly what they need with ease.
  • Efficient Information Management: Utilize your existing store documents for quick access to policies and FAQs, reducing the need for manual support.

👨‍💻 Who is This Workflow For?

This workflow is ideal for e-commerce business owners, WooCommerce store managers, and customer support teams seeking to implement an automated, intelligent assistant to improve product discovery and customer support without extensive technical expertise.

🎯 Use Cases

  1. Product Search Assistance: Help customers find products based on keywords, price ranges, SKUs, and categories seamlessly within your WooCommerce store.
  2. Customer Support: Automatically answer common store-related questions such as operating hours, return policies, and shipping information.
  3. Sales Optimization: Increase sales by guiding customers to products that match their preferences and needs through intelligent recommendations.

TL;DR

This Personal Shopper Chatbot workflow integrates OpenAI and RAG with WooCommerce to deliver an intelligent and automated shopping assistant. By handling product searches and general inquiries efficiently, it enhances customer experience, streamlines support operations, and drives sales growth for your e-commerce business.

Get started with n8n
Need help with n8n?

Related

Automate Incident Notifications from ServiceNow to Slack

Streamline notifications by automating ServiceNow incident alerts directly in Slack, improving response time and collaboration. 

  • 526
  • 11

Email Summarization and Messaging Automation with n8n and Openrouter

Streamline email management by summarizing and messaging efficiently with n8n and Openrouter; automate tasks and improve communication. 

  • 541
  • 17

Automate Social Media Insights for Pre-Call Preparation

Discover social media insights to enhance pre-call prep. Leverage automation for real-time data analysis and streamlined information gathering. 

  • 531
  • 18

Help us find the best n8n templates

About

A curated directory of the best n8n templates for workflow automations.

Navigation

Submit