RAG & app with WordPress content
Workflow Description
An advanced template that integrates WordPress content processing with RAG (Retrieval-Augmented Generation) technology to build an intelligent agent capable of answering user questions based on your site's content. It uses OpenAI models and vector storage to deliver precise, context-aware results.
How it works
- 1.Extract WordPress content and segment it into processable paragraphs
- 2.Convert text to numerical vectors using OpenAI embedding models
- 3.Store vectors in Supabase database for fast retrieval
- 4.Process user questions through an interactive chat interface
- 5.Retrieve relevant content from the database and generate intelligent responses
- 6.Maintain conversation history in PostgreSQL to enhance future interactions
Use cases
- Automate customer support with a knowledge engine that understands your site content
- Build an intelligent assistant that provides accurate answers grounded in your company resources
Requirements
- Valid OpenAI API key with sufficient permissions
- Secure connection to PostgreSQL database and active Supabase account
- Access to WordPress site with content ready for processing
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (53)
When clicking ‘Test workflow’
Manual Trigger
Embeddings OpenAI
OpenAI
Default Data Loader
Document Default Data Loader
Token Splitter
Text Splitter Token Splitter
Embeddings OpenAI1
OpenAI
OpenAI Chat Model
OpenAI
Postgres Chat Memory
Memory Postgres Chat
Respond to Webhook
Webhook
Set fields
Set
Embeddings OpenAI2
OpenAI
Default Data Loader1
Document Default Data Loader
Token Splitter1
Text Splitter Token Splitter
Markdown1
Markdown
Postgres
Postgres
Aggregate
Aggregate
Aggregate1
Aggregate
Aggregate2
Aggregate
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Wordpress - Get all posts
Wordpress
Wordpress - Get all pages
Wordpress
Sticky Note3
Sticky Note
Set fields1
Set
Filter - Only published & unprotected content
Filter
HTML To Markdown
Markdown
Supabase - Store workflow execution
Supabase
Sticky Note4
Sticky Note
Every 30 seconds
Schedule Trigger
Sticky Note5
Sticky Note
Wordpress - Get posts modified after last workflow execution
HTTP Request
Wordpress - Get posts modified after last workflow execution1
HTTP Request
Set fields2
Set
Filter - Only published and unprotected content
Filter
Loop Over Items
Split In Batches
Set fields3
Set
Set fields4
Set
Store documents on Supabase
Vector Store Supabase
Store workflow execution id and timestamptz
Supabase
Aggregate documents
Aggregate
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Postgres - Create documents table
Postgres
Postgres - Create workflow execution history table
Postgres
Merge Wordpress Posts and Pages
Merge
Merge retrieved WordPress posts and pages
Merge
Postgres - Filter on existing documents
Postgres
Supabase - Delete row if documents exists
Supabase
Switch
Switch
When chat message received
Chat Trigger
Supabase - Retrieve documents from chatinput
Vector Store Supabase
AI Agent
Agent
Supabase Vector Store
Vector Store Supabase