Website Content Chatbot with Pinecone, Airtable & OpenAI for RAG Applications

This n8n workflow shows how to extract website content, index it in Pinecone, and leverage Airtable to power a chat agent for customer Q&A.

Use cases include:
Building a knowledge base from your website.
Creating a chatbot that answers customer queries using your own site content.
Powering RAG workflows for FAQs, support docs, or product knowledge.

How it works Workflow starts with a manual trigger or chat message.
Website content is fetched via HTTP Request.
The HTML body is extracted and converted into clean Markdown.
Text is split into chunks (~500 chars with 50 overlap) using the Character Text Splitter.
OpenAI embeddings** are generated for each chunk.
Content and embeddings are stored in Pinecone with namespace separation.
A Chat Agent (powered by OpenAI or OpenRouter) retrieves answers from Pinecone and Airtable.
Memory buffer** allows multi-turn conversations.
A billing tool (Airtable) provides dynamic billing-related answers when needed.

How to use Replace the sample website URL in the HTTP Request node with your own domain or content source. Update Normalize code based on markdown content output to remove noise. Adjust chunk size in the Text Splitter for your website markdown output.
In this example, the Character Text Splitter with separator ###### worked really well.
Always check the Markdown output to fine-tune your splitting logic.
Update Pinecone namespace to match your project.
Customize the Chat Agent system prompt to fit your brand voice and response rules.
Connect to your own Airtable schema if you want live billing/payment data access.

Requirements OpenAI account** (for embeddings + chat model).
Pinecone account** (vector DB for semantic search).
Airtable account** (if using the billing tool).
(Optional) OpenRouter account (alternative chat model provider).
n8n self-hosted or cloud.

Need Help?
Ask in the n8n Forum!

Happy Automating! 🚀