Turn websites into RAG chatbot knowledge bases with Apify, OpenAI and Pinecone

This n8n template transforms any website into a fully functional RAG-ready chatbot knowledge base. It crawls sites using the AI Training Data Scraper community node, chunks content intelligently, generates embeddings, and stores everything in Pinecone for semantic search-powered conversations. Perfect for turning documentation, blogs, or marketing sites into instant AI chat assistants.

Use cases Convert documentation sites into intelligent support chatbots Build product knowledge bases from marketing websites Create internal search tools from company intranets Power customer support agents with scraped competitor analysis Generate training data for fine-tuning company-specific AI models

Good to know This workflow connects to external services requiring API credentials. Works on n8n Cloud and self-hosted instances. Initial setup takes 10 minutes including community node installation.

Requirements n8n Cloud or self-hosted instance Community Node Apify API key OpenAI API key Pinecone account & index

Customising this workflow Replace Pinecone with Qdrant, Weaviate, or pgvector for self-hosted vector storage Swap OpenAI embeddings with Ollama or Hugging Face for zero-cost processing Add content filtering by language, code presence, or section type Extend with conversation memory using Redis or Postgres Build a frontend dashboard for managing multiple website indexes Add multi-site RAG (query across multiple domains simultaneously)