Sync WordPress Content to Pinecone Vector Store

This workflow automates the synchronization of published and private WordPress content (pages and posts) via REST API into Pinecone's vector database. It processes content into clean JSON, generates embeddings with OpenAI (or compatible models), and upserts them into Pinecone, enabling semantic search and retrieval for AI agents.

Key benefits include keeping your LLM chatbot's knowledge base always up-to-date without manual intervention or retraining. Ideal for website owners wanting to power AI assistants with live site data, reducing setup time and ensuring scalability as content grows.

Use cases: Enhance customer support chatbots with site-specific info, build RAG systems for content-heavy sites, or create intelligent search over blogs/portfolios. Runs on a schedule (e.g., daily), supports self-hosted n8n, and requires minimal configuration via credentials.

No workflow modifications needed—manage content in WordPress as usual. Filters and folder structures are adjustable for custom setups.