IT Support Chatbot: Google Drive, Pinecone & Gemini AI Doc Processing

This n8n workflow consists of two interlinked automations for IT support teams: a document ingestion workflow and a chat query workflow. The ingestion process triggers on new files in a Google Drive folder, downloads them, extracts text, cleans and splits content using code nodes, generates embeddings with Google Gemini, and stores them in Pinecone for semantic search.

The chat query workflow activates via a chat trigger when employees ask support questions. It performs vector similarity search in Pinecone to retrieve relevant document chunks, constructs a detailed prompt combining context and query, and uses an OpenRouter Chat Model (powered by Gemini) to deliver clear, step-by-step AI responses.

Key benefits include transforming static docs into an interactive knowledge base, reducing support ticket times, and providing context-aware answers without manual searching. Ideal for organizations with extensive IT documentation like troubleshooting guides and configs, saving hours weekly for support teams.

Use cases: Large enterprises automating helpdesk, remote teams accessing up-to-date guides instantly, or scaling knowledge sharing across departments.