WordPress AI Chatbot with Supabase & OpenAI RAG

This advanced n8n template consists of three interconnected workflows to create a Retrieval-Augmented Generation (RAG) AI chatbot powered by WordPress content, Supabase pgvector, and OpenAI. The first workflow fetches all WordPress posts and pages, generates embeddings with OpenAI, and stores them in a Supabase vector database for efficient semantic search. The second handles real-time upserts, automatically updating embeddings when content is edited or added. The third enables interactive chat functionality, retrieving relevant documents via vector similarity search and generating context-aware responses with OpenAI.

Key benefits include seamless integration of GenAI into your website without custom coding, improved user engagement through intelligent Q&A, insights into visitor queries for content optimization, and simplified internal content management like suggesting related articles or internal links. It's ideal for enhancing UX on informational sites, blogs, or documentation portals.

Prerequisites are straightforward: a Supabase project with pgvector extension, WordPress site access, OpenAI API key, and timezone alignment. This template saves weeks of development time, offering enterprise-grade AI capabilities for sales, support, or lead generation pipelines by turning static content into dynamic, conversational experiences.