RAG (Retrieval Augmented Generation) is the most popular tool to give AI agents access to your knowledge base so it can be a domain expert for your documents. It’s also very easy to implement in no code tools such as n8n since it’s so widely adopted and supported. It comes with its fair share of shortcomings though because RAG: - Can't analyze tables well - no ability to calculate averages, sums, or trends - Misses the "big picture" because documents are split into small pieces - Struggles with connecting information across documents and sections - Can't dynamically switch between document lookup and data analysis How do you solve for all of these limitations? The answer is with Agentic RAG and I show you exactly how to implement this with n8n in this video with a template you can download and use right now (link below). Agentic RAG gives AI agents the ability to reason more about how it explores the knowledge base, self-improve RAG lookups, and choose between different tools based on the user's question. When asked about trends in a spreadsheet, it uses SQL to calculate precise answers. When context is needed from an entire document, it searches the full text instead of a RAG lookup. The agent intelligently switches between these approaches. This gives you: - Accurate calculations for numerical data - Complete document context when needed - Connected insights across all your information - Dynamic switching between search and analysis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Download the ultimate n8n RAG agent template here: https://github.com/coleam00/ottomator-agents/tree/main/n8n-agentic-rag-agent I created an agentic RAG agent in Python as well: https://www.youtube.com/watch?v=_R-ff4ZMLC8 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Check out Unstract, a free and open source tool to turn unstructured documents into structured data as workflows you can deploy as API endpoints or ETL pipelines! Dealing with unstructured data for RAG AI agents is super common so this is a really useful tool for us agent builders to include in our RAG pipelines: https://github.com/Zipstack/unstract They have fantastic documentation for using their platform as well: https://docs.unstract.com/unstract/index.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 00:00 - Shortcomings of RAG 01:32 - Introducing the n8n Agentic RAG Template 05:14 - Agentic RAG Agent Demo 09:28 - Unstract 11:30 - Setting up Supabase for Our Agent 14:23 - RAG Pipeline Deep Dive 26:26 - Building Our Agent and its RAG Tools 32:36 - Last Demo 33:29 - Outro ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Join me as I push the limits of what is possible with AI. I'll be uploading videos at least two times a week - Sundays and Wednesdays at 7:00 PM CDT!