AutomationMart
Home/Browse/Personal shopper chatbot for WooCommerce with RAG using Google Drive and openAI
n8n

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

n8nn8n21 modulesv1.0
OpenAIGoogle DriveWooCommerceLinkedIn

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: - S

At a glance

Personal shopper chatbot for WooCommerce with RAG using Google Drive and openAI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI, Google Drive, WooCommerce, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
OpenAI, Google Drive, WooCommerce, LinkedIn
Modules
21
Price
Free
Version
v1.0
Personal shopper chatbot for WooCommerce with RAG using Google Drive and openAI workflow diagram

About this workflow

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: 2. Product Search (WooCommerce Integration) - AI Agent: - If search: true, routes the request to the personalshopper 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 personalshopper 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 for consulting and support or add me on Linkedin.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Transcribe new long mp3 files from Google Drive with Google Cloud Speech

Every time a new mp3 audio file longer than 1 minute is added to Google Drive, Make will automatically transcribe it with Google Cloud Speech and save text to Google Docs document.

Free

Create CS-Cart orders from new WooCommerce orders

Make will watch your WooCommerce orders at regular intervals and create CS-Cart orders. If a product doesn't exist in CS-Cart, it will be created.

Free

Custom deal recommendations by email using Forms, Bright Data & GPT-4o-mini

This n8n workflow template automates the process of collecting and delivering the "Top Deals of the Day" from MediaMarkt, tailored to user preferences. By combining user-submitted forms, Bright Data web scraping, GPT-4o-mini deal generation, and email delivery, this workflow sends personalized product recommendations straight to a user’s inbox. > ⚠️ Note: This workflow uses community nodes (Bright Data and Document Generator) which only work on self-hosted n8n instances. --- 🚀 What It Does -

Free

Smart Shopify agent: AI-powered abandoned cart recovery

AI Cart Recovery Agent: Smart Abandoned Checkout Assistant Transform abandoned carts into recovered sales with intelligent automation. This sophisticated n8n workflow monitors checkout abandonment, implements smart waiting periods, and sends AI-generated personalized recovery emails only when needed - maximizing conversions while respecting customer experience. 🔄 How It Works This intelligent 7-step recovery system recovers lost sales automatically: Step 1: Initial Abandonment Detection The work

Free

Generate a daily multi-asset market report with TwelveData, Groq and Google Sheets

Multi-Asset Daily Market Snapshot This workflow fully automates the creation of a daily multi-asset market report. It retrieves live pricing data for specified indices, forex pairs and commodities using the TwelveData API, manages rate limits safely and feeds the normalized data into a Groq-powered AI (Llama-3). The AI generates a professional, institutional-grade market summary which is then automatically logged in Google Sheets and emailed to your inbox. Quick Implementation Steps 1

Free

Extend and merge UGC viral videos using Kling 2.1, then publish on social media

This workflow automates the full pipeline for extending short Viral UGC-style videos using AI, merging them, and finally publishing the output to cloud storage or social media platforms (TikTok, Instagram, Facebook, Linkedin, X, and YouTube). It integrates multiple external APIs (Fal.ai, Runpod/Kling 2.1, Postiz, Upload-Post, Google Sheets, Google Drive) to create a smooth end-to-end video-generation system. --- Key Advantages 1. ✅ Full End-to-End Automation The wo

Free

Turn new Shopify products into SEO blogs with Perplexity, Gemini and Sheets

Shopify Product-to-Blog Automation with Perplexity web search, Gemini AI Agent & Google Sheets Shopify Blog Automation (From Shopify product to SEO-optimized blog post — fully automated) This workflow is an advanced n8n-powered automation that transforms newly created Shopify products into professionally written, SEO-ready blog posts using AI. By combining Shopify Webhooks, Google Sheets, AI

Free

AI agent for realtime insights on meetings

Video Guide I prepared a detailed guide explaining how to build an AI-powered meeting assistant that provides real-time transcription and insights during virtual meetings. []( Youtube Link Who is this for? This workflow is ideal for business professionals, project managers, and team leaders who require effective transcription of meetings for improved documentation and note-taking. It's particularly beneficial for those who conduct frequent virtual meetings across various platforms like Zoom and

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free