Templates / WordPress - AI chatbot to enhance user experience - with Supabase and OpenAI

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

Needs changes

by Dataki ✓ · 13,094 views · created 2024-10-28 · Support Chatbot, AI RAG

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 45 nodes and runs on a schedule (every second) (plus 2 other triggers). Along the way it connects Embeddings OpenAI, OpenAI Chat Model, Postgres Chat Memory and Postgres and 3 more. It also calls mydomain.com over HTTP.

How it runs

Trigger: On a schedule (every second) (plus 2 other triggers).

  1. Postgres: run a query
  2. Wordpress: get many
  3. Wordpress: get many (page)
  4. Supabase - Retrieve documents from chatinput (Supabase Vector Store): searches the Supabase vector store, with embeddings: Embeddings OpenAI
  5. Wordpress - Get posts modified after last workflow execution (HTTP Request): calls mydomain.com
  6. Wordpress - Get posts modified after last workflow execution (HTTP Request): calls mydomain.com
  7. Merge: merges the data from its input branches
  8. Aggregate: combines items into one
  9. Merge: merges the data from its input branches
  10. Set fields (Edit Fields (Set)): sets 9 fields: publication_date, modification_date, content_type…

…plus 23 more steps. See the full node list below.

Services it uses

Embeddings OpenAIOpenAI Chat ModelPostgres Chat MemoryPostgresWordpressSupabaseSupabase Vector Store

HTTP calls to: mydomain.com

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • AI Agent v1 (old agent modes) in AI Agent (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Removed in 3.0Replace with
AI Agent v1 (old agent modes)
AI Agent (v1.6)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (22)

From the author

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…

Excerpt from Dataki's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.