Specialized Wordpress RAG Chatbot w/ Postgres Content Creation

This workflow is for WordPress website owners who want to offer an AI chatbot that answers questions using their website content. It is also for those who want to automate the process of keeping their AI chatbot updated with the latest website information. This workflow sets up a WordPress-powered chatbot. It enables the chatbot to answer questions using content directly from a WordPress website. The workflow also automatically updates the chatbot with new or changed website content. First, ensure you have a WordPress website and a Supabase project. You need to configure credentials for both WordPress and Supabase within n8n. Then, you will run the initial embedding workflow to populate your Supabase database with your existing WordPress content. After that you will configure the scheduled workflow to constantly monitor WordPress for new changes. Finally, you can embed the chatbot into your website by configuring the chatbot trigger. WordPress website, Supabase project, n8n instance, OpenAI API Key. You can customize the content included in the chatbot by filtering WordPress posts and pages. You can also adjust the chunk size for text splitting and the AI agent's system message to refine its responses and behavior. Key Technologies: n8n,WordPress,Supabase (Postgres with pgvector extension),OpenAI (for embeddings and chat),LangChain (for AI agents and vector store integration) Automation Value: Automatically creates and updates a knowledge base for an AI chatbot from WordPress content. Enables real-time customer support by providing an AI chatbot that answers questions based on up-to-date website information. Reduces manual effort in maintaining a chatbot's knowledge base. Improves user experience by providing instant answers to common questions. Allows for personalized AI responses by incorporating chat history. Automatically indexes new and updated WordPress content for the RAG system. Best Practices: Regularly review and refine the filtering conditions for WordPress content to ensure only relevant information is used to train the chatbot.