Export Wordpress to PineCone vector store
Click here to access this Workflow for free. --- Make your website the knowledge base of your LLM chatbot !wp.png This workflow automatically syncs your Word...
🔌 Nodes & Integrations Used (5)
📖 Implementation & Setup Guide
**[Click here to access this Workflow for free](https://www.bonzai.pro/auth?action=buyPrice%2Cpri_2mR5_5248)**.
---
Make your website the knowledge base of your LLM chatbot 
This workflow automatically syncs your WordPress content (Pages and Posts) into a vector database like Pinecone, making it searchable and usable by AI agents through embeddings. This allows your AI chatbot to stay continuously up to date with your latest site content — without manual uploads or retraining steps.
It pulls all published and private content via WordPress's REST API, processes the data into clean JSON, and sends it to Pinecone using vector embeddings (OpenAI by default, but swappable). This enables a dynamic AI knowledge base that grows with your website.
Best of all, you don’t need to modify your workflow: keep managing your content in WordPress — this automation takes care of the rest.
---
Requirements
- A WordPress site with API access
- Pinecone account credentials (API Key + Environment)
- OpenAI account (or any LLM with embedding capabilities)
- An n8n instance (cloud or self-hosted)
---
Setup
- **Configure WordPress Access:**
- - Create HTTP credentials in n8n with your WordPress site's base URL and authentication.
- - This workflow uses the REST API to fetch `pages` and `posts`.
2. **Connect Pinecone and OpenAI:** - Set up credentials for both Pinecone and OpenAI in n8n's Credentials Manager. - The workflow automatically uses them in the relevant nodes.
3. **Set Your Schedule:** - The workflow starts with a Schedule node. Open it to adjust how often the sync runs (e.g., daily, weekly).
4. **Check the Nodes:** - Make sure your folder structure and API URLs match your WordPress setup. - Adjust filters if needed (only published and private content is fetched by default).
---
Usage
Once the workflow is active:
- It runs on a defined schedule.
- It fetches all WordPress Pages and Posts.
- It converts them into structured JSON, including metadata (title, tags, URL, categories, etc.).
- It generates embeddings (via OpenAI) and sends them to Pinecone.
- All vectors are stored with rich metadata for easy use in search/chat-based AI tools.
You’ll have a continuously refreshed, vectorized copy of your WordPress site content.
---
Customization
- **Replace Pinecone:** You can swap Pinecone for any other vector database by updating the vector node.
- **Swap Embedding Provider:** You’re not limited to OpenAI — just replace the embedding step with your LLM of choice.
- **Selective Sync:** If you want to sync only posts or only pages:
- - Delete the node that fetches the type you don’t want.
- - Remove the associated Merge node.
- **Schedule:** Edit the first node to control how often the automation runs.
--- ### If you need any help, or have any question, feel free to come discuss about it on **[Telegram](https://www.bonzai.pro/theo_marcadet/lp/7018)**
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Export Wordpress to PineCone vector store.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related RAG & Vector DB Workflows
View All in RAG & Vector DB →AI Document Note Generator from Folder
Production-ready n8n automation template for AI Document Note Generator from Folder built by AhiXLight. Seamlessly connects Local File Trigger, Document Default Data Loader, Text Splitter Recursive Character Text Splitter with 42 configured nodes.
AI-Powered Document Note Generator
Production-ready n8n automation template for AI-Powered Document Note Generator built by AhiXLight. Seamlessly connects Local File Trigger, Document Default Data Loader, Text Splitter Recursive Character Text Splitter with 42 configured nodes.
AI crew to automate fundamental stock analysis Q A workflow
How it works: Using a Crew of AI agents (Senior Researcher, Visionary, and Senior Editor), this crew will automatically determine the right questions to ask ...
Amazon Keyword Suggestion Storage Workflow
Production-ready n8n automation template for Amazon Keyword Suggestion Storage Workflow built by AhiXLight. Seamlessly connects Airtable, HTTP Request with 12 configured nodes.