Skip to content
FlowHubFluxonLab
A
AI Automationfree

WordPress - AI Chatbot to enhance user experience - with Supabase and OpenAI

by Datakiadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAAI AgentDDefault Data LoaderEmbeddings OpenAIEmbeddings OpenAIHTTP RequestHTTP RequestOpenAI Chat ModelOpenAI Chat ModelPostgresPostgresPostgres Chat MemoryPostgres Chat MemorySupabaseSupabaseSupabase Vector StoreSupabase Vector StoreToken SplitterToken SplitterWordpressWordpress
Share Post Share
MaWhen clicking ‘Test workflow’When clicking ‘…Embeddings OpenAIEmbeddings Open…DDDefault Data LoaderDefault Data Lo…TSToken SplitterEmbeddings OpenAI1Embeddings Open…OpenAI Chat ModelOpenAI Chat Mod…MPPostgres Chat MemoryPostgres Chat M…RTRespond to WebhookRespond to Webh…SeSet fieldsEmbeddings OpenAI2Embeddings Open…DDDefault Data Loader1Default Data Lo…TSToken Splitter1MaMarkdown1PostgresAgAggregateAgAggregate1AgAggregate2Wordpress - Get all postsWordpress - Get…Wordpress - Get all pagesWordpress - Get…SeSet fields1FiFilter - Only published & unprotected contentFilter - Only p…MaHTML To MarkdownSupabase - Store workflow executionSupabase - Stor…ScEvery 30 secondsHRWordpress - Get posts modified after last workflow executionWordpress - Get…HRWordpress - Get posts modified after last workflow execution1Wordpress - Get…SeSet fields2FiFilter - Only published and unprotected contentFilter - Only p…SILoop Over ItemsSeSet fields3SeSet fields4VSStore documents on SupabaseStore documents…Store workflow execution id and timestamptzStore workflow …AgAggregate documentsAggregate docum…Postgres - Create documents tablePostgres - Crea…Postgres - Create workflow execution history tablePostgres - Crea…MeMerge Wordpress Posts and PagesMerge Wordpress…MeMerge retrieved WordPress posts and pagesMerge retrieved…Postgres - Filter on existing documentsPostgres - Filt…Supabase - Delete row if documents existsSupabase - Dele…SwSwitchChWhen chat message receivedWhen chat messa…VSSupabase - Retrieve documents from chatinputSupabase - Retr…AgAI AgentVSSupabase Vector StoreSupabase Vector…12345678910111213
1/5
FLOWS
STEPS · 13
Run manually by an operator

This is the first version of a template for a RAG/GenAI App using WordPress content. As creating, sharing, and improving templates brings me joy 😄, feel free to reach out on LinkedIn if you have any ideas to enhance this template! How It Works This template includes three workflows: Workflow 1**: Generate embeddings for your WordPress posts and pages, then store them in the Supabase vector store. Workflow 2**: Handle upserts for WordPress content when edits are made. Workflow 3**: Enable chat functionality by performing Retrieval-Augmented Generation (RAG) on the embedded documents. Why use this template? This template can be applied to various use cases: Build a GenAI application that requires embedded documents from your website's content. Embed or create a chatbot page on your website to enhance user experience as visitors search for information. Gain insights into the types of questions visitors are asking on your website. Simplify content management by asking the AI for related content ideas or checking if similar content already exists. Useful for internal linking. Prerequisites Access to Supabase for storing embeddings. Basic knowledge of Postgres and pgvector.

Tags

n8nreference-onlyagentdocument-default-data-loaderembeddings-open-ailm-chat-open-aimemory-postgres-chatpostgressupabasetext-splitter-token-splittervector-store-supabasewordpress
Connects
AAI AgentDDefault Data LoaderembeddingsopenaiEmbeddings OpenAIWHTTP RequestopenaichatmodelOpenAI Chat ModelpostgresPostgres
CategoryAI Automation
Triggermanual
Complexityadvanced
Nodes45
AddedOct 28, 2024

Related workflows

See all AI Automation
ACembeddingsopenai
free

Route WhatsApp support requests with Claude, Supabase, HubSpot and Slack

Quick overview This workflow turns incoming WhatsApp messages (text, audio, images, and documents) into actionable support interactions by extracting content, detecting sentiment, and using an AI agent with a Supabase knowledge base to route requests to Google Calendar, HubSpot, Slack, Gmail, and back to WhatsApp. How it works Receives incoming WhatsApp messages via a WhatsApp webhook trigger. Routes the message by type and converts it into text using OpenAI Whisper for audio, OpenAI GPT-4o Vision for images, or a PDF extractor for documents (or passes text messages through). Loads the sender’s session context from Supabase and runs sentiment/language detection on the extracted text. Uses a LangChain AI agent (Claude) with Supabase vector search (with OpenAI embeddings and Cohere reranking) plus tool access (Google Calendar, HubSpot, Slack, and Gmail) to produce a structured intent, response, and metadata. Logs conversation analytics (intent, sentiment, message type, and response length) to an n8n Data Table. Routes by intent to either create a Google Calendar event, create/update a HubSpot contact, email a document via Gmail (and upload it to Google Drive), create a HubSpot ticket

by Multifly
ACDgmail
free

AI: Summarize podcast episode and enhance using Wikipedia

The workflow automates the process of creating a summarized and enriched podcast digest, which is then sent via email. Note that to use this template, you need to be on n8n version 1.19.4 or later.

by n8n Team
Dgoogledriveopenaichatmodelsummarizationchain
free

Load and summarize Google Drive files with AI

This workflow includes advanced features like text summarization and tokenization, it's ideal for automating document processing tasks that require parsing and summarizing text data from Google Drive. To use this template, you need to be on n8n version 1.19.4 or later.

by n8n Team