PDF RAG Agent with Telegram Chat & Auto-Ingestion from Google Drive

Description

How it works

This workflow creates an intelligent document assistant called "Mookie" that can answer questions based on your uploaded documents. Here's how it operates:

Document Ingestion:** The system can automatically load PDF files from Google Drive or accept PDFs uploaded directly through Telegram, then processes and stores them in a PostgreSQL vector database using Mistral embeddings
Smart Retrieval:** When users ask questions via Telegram or a web chat interface, the AI agent searches through the stored documents to find relevant information using vector similarity matching
Contextual Responses:** Using GPT-4 and the retrieved document context, Mookie provides accurate answers based solely on the ingested documents, avoiding hallucination by refusing to answer questions not covered in the stored materials
Memory & Conversation:** The system maintains conversation history for each user, allowing for natural follow-up questions and contextual discussions

Set up steps

Estimated setup time: 30-45 minutes
You'll need to configure several external services and credentials:

Set up a PostgreSQL database with PGVector extension for document storage
Create accounts and API keys for Azure OpenAI (GPT-4), Mistral Cloud (embeddings), and Google Drive access
Connect your own LLM's if you don't have these credentials.
Configure a Telegram bot and obtain API credentials for chat functionality
Update webhook URLs throughout the workflow to match your n8n instance
Test the document ingestion pipeline with sample PDFs
Verify the chat interfaces (both Telegram and web) are responding correctly

>The workflow includes approval mechanisms for PDF ingestion and handles both automated bulk processing from Google Drive and real-time document uploads through Telegram. Read the sticky notes provided in the template code for clear instructions.