Who is this workflow for? This workflow creates a Retrieval Augmented Generation (RAG) chatbot that enables employees to seamlessly access information from company documents stored in Google Drive. By automatically indexing documents into a Pinecone vector database and utilizing Google’s Gemini AI, the chatbot delivers accurate and up-to-date responses to employee inquiries..

What does this workflow do?

  • Document Monitoring:
  • Two Google Drive Trigger nodes monitor a specific Google Drive folder for new or updated files.
  • File Downloading:
  • When changes are detected, the Google Drive node downloads the affected document.
  • Content Loading:
  • The Default Data Loader node extracts the content from the downloaded document.
  • Text Splitting:
  • The Recursive Character Text Splitter node divides the document into smaller, manageable text chunks.
  • Embeddings Generation:
  • The Embeddings Google Gemini node generates embeddings for each text chunk using the text-embedding-004 model.
  • Indexing in Pinecone:
  • The Pinecone Vector Store node indexes the text chunks and their embeddings into the company-files Pinecone index.
  • User Interaction:
  • The Chat Trigger node receives employee questions through a chat interface and forwards them to the AI Agent node.
  • Information Retrieval:
  • The AI Agent node utilizes a Vector Store Tool linked to Pinecone in query mode to fetch relevant text chunks based on the user’s question.
  • Response Generation:
  • The retrieved information and the user’s question are sent to the Google Gemini (gemini-pro) node.
  • Google Gemini generates a comprehensive and informative answer based on the provided documents.
  • Context Management:
    • A Window Buffer Memory node connected to the AI Agent maintains short-term memory, allowing for context-aware and natural conversations.

🤖 Why Use This Automation Workflow?

  • Enhanced Information Access: Quickly retrieve information from a centralized repository of company documents.
  • Automated Indexing: Automatically updates the vector database with new or modified documents, ensuring responses are always based on the latest information.
  • Advanced AI Integration: Leverages Google’s Gemini AI for generating context-aware and precise answers, improving the overall user experience.

👨‍💻 Who is This Workflow For?

  • Organizations: Looking to improve internal knowledge management and support.
  • IT Teams: Managing company document systems and seeking efficient integration with AI tools.
  • Developers: Building intelligent chatbots that integrate with Google Drive and advanced AI models.

🎯 Use Cases

  1. Employee Support: Provide instant answers to HR policies, company guidelines, and procedural questions.
  2. Knowledge Management: Centralize access to project documentation, technical manuals, and training materials for easy retrieval.
  3. Onboarding Assistance: Help new employees navigate company resources and understand organizational processes through an interactive chatbot.

TL;DR

This workflow delivers a powerful RAG chatbot that integrates Google Drive with Pinecone and Google’s Gemini AI, enabling organizations to provide their employees with accurate, timely, and contextually relevant information from company documents. By automating document indexing and leveraging advanced AI for response generation, businesses can enhance internal knowledge access and support.

Help us find the best n8n templates

About

A curated directory of the best n8n templates for workflow automations.