Sync WordPress Content to Pinecone for AI Chatbots with OpenAI
Description
Categories
📊 Productivity🤖 AI & Machine Learning📢 Marketing
Nodes Used
n8n-nodes-base.setn8n-nodes-base.setn8n-nodes-base.setn8n-nodes-base.setn8n-nodes-base.setn8n-nodes-base.mergen8n-nodes-base.mergen8n-nodes-base.aggregaten8n-nodes-base.aggregaten8n-nodes-base.aggregate
PriceFree
Views0
Last Updated11/28/2025
workflow.json
{
"meta": {
"instanceId": "ff93c7924b638fb6ca7815d8ed0b9e89bc1a4b863863649bb0ed513cdccf1946",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "b1b712ea-6f07-46f8-94c2-14bd6bdf5e9b",
"name": "Pages-> clear JSON formatted for vector store insertion",
"type": "n8n-nodes-base.set",
"position": [
220,
-880
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "272efeb5-05a8-4c26-b2cb-89c939adab26",
"name": "Posts -> clear JSON formatted for vector store insertion",
"type": "n8n-nodes-base.set",
"position": [
220,
-1040
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "4189f388-7e0a-4472-bb4b-bb7f0c4b9215",
"name": "Tags-> JSON",
"type": "n8n-nodes-base.set",
"position": [
-1520,
-880
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1d882cd0-789d-4ebb-a886-cad6dbbeebc7",
"name": "Categories -> JSON",
"type": "n8n-nodes-base.set",
"position": [
-1520,
-1040
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "06a234b8-2d62-49ce-9af5-f819375426d5",
"name": "Schedule Trigger1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-2620,
-960
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "75e306b9-053f-4d4e-86dd-82213f32b8d9",
"name": "Sticky Note18",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2360,
-1140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7b382a05-88ff-4b27-aecf-8c9270b37ce5",
"name": "Sticky Note17",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2720,
-1140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0aa35208-233b-4e20-a53b-b1fc54edc367",
"name": "Sticky Note15",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1520,
-1800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ae7a7208-52f5-4b66-b871-dae01429ba7a",
"name": "[WP] GET CATEGORIES",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1820,
-1040
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "64ef642b-4ccf-4549-a283-7a521264517f",
"name": "[WP] GET TAGS",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1820,
-880
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "33978a9b-7de2-4e6f-8816-9580cd2ab11e",
"name": "Aggregate",
"type": "n8n-nodes-base.aggregate",
"position": [
-1320,
-1040
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d9ad07be-08cf-4286-bdc7-9f7e007b16d3",
"name": "Aggregate1",
"type": "n8n-nodes-base.aggregate",
"position": [
-1320,
-880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1673c33c-90ed-4bd2-be03-990265f17f14",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
-1020,
-960
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "2f1c7c16-a757-4e28-9a25-973fad715e2a",
"name": "Aggregate2",
"type": "n8n-nodes-base.aggregate",
"position": [
-820,
-960
],
"parameters": {},
"typeVersion": 1
},
{
"id": "99b3cb22-9c03-450f-a56a-231c0004e88e",
"name": "Pinecone Vector Store",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
1360,
-1260
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "d559e18b-524c-4cb5-bc35-51647d4dc186",
"name": "Embeddings OpenAI",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
1160,
-1020
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c77093c7-4954-4a69-b6fa-29bdd21a0a7d",
"name": "Default Data Loader",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
1540,
-1020
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fb346a65-05b7-49f2-b77e-3ab10d4b2dbd",
"name": "Token Splitter",
"type": "@n8n/n8n-nodes-langchain.textSplitterTokenSplitter",
"position": [
2160,
-960
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ccc22205-af40-47eb-b94f-136d966c4e3d",
"name": "Merge1",
"type": "n8n-nodes-base.merge",
"position": [
520,
-960
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "736f2a14-1fc1-4df0-9dc8-1c2b63d82705",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1560,
-1180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f67565d0-a9a7-4133-a3d0-ac72a82b5569",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2000,
-1400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0305c38f-bd97-45fc-b18e-80ee5c5a6e5b",
"name": "Site URL",
"type": "n8n-nodes-base.set",
"position": [
-2260,
-960
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2fca8703-5a10-4fce-9267-e1a3babb97a2",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
-1180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9a23a97e-22b5-43c7-8347-0681bd23b6dc",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-560,
-1400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "345ac3fd-92ac-4b29-bd93-2b3020d6d756",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1380,
-1100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ff528727-c6fc-40d8-834c-bfadf2f50212",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
-1100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c0e2c9af-96dc-48a4-8475-d4365cd7e55c",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
2000,
-1100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f65ceb7e-dec1-48e1-9f81-ed14708c39c0",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1000,
-1400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "13ad323e-1c01-4cd3-b144-6d0d6eaddcc9",
"name": "[WP] EXPORT POSTS",
"type": "n8n-nodes-base.httpRequest",
"position": [
-380,
-1040
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "cdbf1253-f733-4bea-a308-e318eaee86f7",
"name": "[WP] EXPORT PAGES",
"type": "n8n-nodes-base.httpRequest",
"position": [
-380,
-880
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "39bebd28-d546-46de-8fe0-170106224e5e",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1940,
-1140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fec9d70d-b6ad-4489-b547-137c41b4a1f5",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-500,
-1140
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge": {
"main": [
[
{
"node": "Aggregate2",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "Pinecone Vector Store",
"type": "main",
"index": 0
}
]
]
},
"Site URL": {
"main": [
[
{
"node": "[WP] GET TAGS",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Aggregate1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Aggregate2": {
"main": [
[
{
"node": "[WP] EXPORT POSTS",
"type": "main",
"index": 0
},
{
"node": "[WP] EXPORT PAGES",
"type": "main",
"index": 0
}
]
]
},
"Tags-> JSON": {
"main": [
[
{
"node": "Aggregate1",
"type": "main",
"index": 0
}
]
]
},
"[WP] GET TAGS": {
"main": [
[
{
"node": "Tags-> JSON",
"type": "main",
"index": 0
}
]
]
},
"Token Splitter": {
"ai_textSplitter": [
[
{
"node": "Default Data Loader",
"type": "ai_textSplitter",
"index": 0
}
]
]
},
"Embeddings OpenAI": {
"ai_embedding": [
[
{
"node": "Pinecone Vector Store",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Schedule Trigger1": {
"main": [
[
{
"node": "Site URL",
"type": "main",
"index": 0
}
]
]
},
"[WP] EXPORT PAGES": {
"main": [
[
{
"node": "Pages-> clear JSON formatted for vector store insertion",
"type": "main",
"index": 0
}
]
]
},
"[WP] EXPORT POSTS": {
"main": [
[
{
"node": "Posts -> clear JSON formatted for vector store insertion",
"type": "main",
"index": 0
}
]
]
},
"Categories -> JSON": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Default Data Loader": {
"ai_document": [
[
{
"node": "Pinecone Vector Store",
"type": "ai_document",
"index": 0
}
]
]
},
"[WP] GET CATEGORIES": {
"main": [
[
{
"node": "Categories -> JSON",
"type": "main",
"index": 0
}
]
]
},
"Pages-> clear JSON formatted for vector store insertion": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 1
}
]
]
},
"Posts -> clear JSON formatted for vector store insertion": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
}
]
]
}
}
}