AI Agents

Build an intelligent agent powered by WordPress content

53 nodes 371 196 Automatic trigger
Download

Workflow Description

Automate extraction of WordPress site content and convert it into semantic vectors stored in Supabase, then deploy an OpenAI-powered intelligent agent that answers user queries based on your site's actual content. This creates a knowledge-aware chatbot that provides accurate, contextual responses while tracking all interactions in Postgres.

How it works

  1. 1.Extract pages and posts from WordPress database automatically
  2. 2.Segment content into chunks and vectorize using OpenAI embeddings
  3. 3.Store vectors and text in Supabase for semantic search retrieval
  4. 4.Route user messages to an intelligent agent that searches indexed content
  5. 5.Log conversation history in Postgres for analytics and quality tracking

Use cases

  • Customer support chatbot answering questions from your actual website content
  • Semantic search engine that understands intent behind user inquiries
  • Automated responses to frequently asked questions based on your documentation
  • Intelligent assistant combining WordPress knowledge with conversational AI

Requirements

  • OpenAI API key for embeddings and chat models
  • WordPress site with direct database access or API connectivity
  • Active Supabase account for vector storage and semantic search
  • Postgres database for conversation history and relationship tracking

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

OpenAI Document Default Data Loader Text Splitter Postgres WordPress Supabase Split In Batches Vector Store Chat Trigger AI Agent

Details

Trigger Automatic trigger
Nodes 53
Apps 10
Views 371
Downloads 196

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (53)

/

When clicking ‘Test workflow’

Manual Trigger

#1

Embeddings OpenAI

OpenAI

#2

Default Data Loader

Document Default Data Loader

#3

Token Splitter

Text Splitter Token Splitter

#4

Embeddings OpenAI1

OpenAI

#5

OpenAI Chat Model

OpenAI

#6

Postgres Chat Memory

Memory Postgres Chat

#7

Respond to Webhook

Webhook

#8

Set fields

Set

#9

Embeddings OpenAI2

OpenAI

#10

Default Data Loader1

Document Default Data Loader

#11

Token Splitter1

Text Splitter Token Splitter

#12

Markdown1

Markdown

#13

Postgres

Postgres

#14

Aggregate

Aggregate

#15

Aggregate1

Aggregate

#16

Aggregate2

Aggregate

#17

Sticky Note

Sticky Note

#18

Sticky Note1

Sticky Note

#19

Sticky Note2

Sticky Note

#20

Wordpress - Get all posts

Wordpress

#21

Wordpress - Get all pages

Wordpress

#22

Sticky Note3

Sticky Note

#23

Set fields1

Set

#24

Filter - Only published & unprotected content

Filter

#25

HTML To Markdown

Markdown

#26

Supabase - Store workflow execution

Supabase

#27

Sticky Note4

Sticky Note

#28

Every 30 seconds

Schedule Trigger

#29

Sticky Note5

Sticky Note

#30

Wordpress - Get posts modified after last workflow execution

HTTP Request

#31

Wordpress - Get posts modified after last workflow execution1

HTTP Request

#32

Set fields2

Set

#33

Filter - Only published and unprotected content

Filter

#34

Loop Over Items

Split In Batches

#35

Set fields3

Set

#36

Set fields4

Set

#37

Store documents on Supabase

Vector Store Supabase

#38

Store workflow execution id and timestamptz

Supabase

#39

Aggregate documents

Aggregate

#40

Sticky Note6

Sticky Note

#41

Sticky Note7

Sticky Note

#42

Postgres - Create documents table

Postgres

#43

Postgres - Create workflow execution history table

Postgres

#44

Merge Wordpress Posts and Pages

Merge

#45

Merge retrieved WordPress posts and pages

Merge

#46

Postgres - Filter on existing documents

Postgres

#47

Supabase - Delete row if documents exists

Supabase

#48

Switch

Switch

#49

When chat message received

Chat Trigger

#50

Supabase - Retrieve documents from chatinput

Vector Store Supabase

#51

AI Agent

Agent

#52

Supabase Vector Store

Vector Store Supabase

#53

Similar Templates

Intelligent Airtable data processing and automatic table updates

20 nodes

Build an AI agent that answers user questions from documents

33 nodes

Intelligent workflow automation with text classification and AI analysis

22 nodes

Process Google Drive Files with OpenAI Intelligence

21 nodes

Build an intelligent agent memory system with Google Sheets

17 nodes

Extract Gmail Data and Populate Google Sheets Automatically

7 nodes