LLM Interactive AI Chat for Google Drive Documents

This workflow creates an AI-powered document chat system using Pinecone and OpenAI for querying Google Drive documents. Key nodes include Document Setup Trigger (initiates document processing), Google Drive Downloader (fetches files), Text Splitter (chunks documents), Pinecone Document Storage (stores vectors), Chat Interface Trigger (handles queries), Document Chat Agent (processes queries with OpenAI gpt-4o-mini), and response nodes (Setup Success Response, Invalid URL Error, File Download Error, Chat Input Error, Content Filter Error, Response Generation Error). To customize for other document sources, update Document Configuration’s document_url and source.\n\nSetup Requirements and Configuration: Install n8n from n8n.io for self-hosting or sign up at cloud.n8n.io. Create a Google Cloud account at console.cloud.google.com; enable Drive API, and create OAuth credentials. Get an OpenAI API key from platform.openai.com under ‘API Keys.’ Obtain a Pinecone API key from app.pinecone.io; create an index (e.g., ‘document-chat-index’). In n8n, import the JSON workflow. Configure Google Drive Downloader with OAuth credentials, OpenAI nodes with API key, and Pinecone nodes with API key and index name under ‘Credentials.’ Set Chat Interface Trigger to HTTPS webhook. Ensure server supports API calls.\n\nTesting and Deployment Steps: Activate the workflow; run Document Setup Trigger with a valid Google Drive URL to populate Pinecone. Get the Chat Interface Trigger webhook URL; integrate with your app. Test by sending queries (e.g., ‘Summarize the document’). Success response returns document-based answers. Error responses handle invalid URLs, file access issues, or inappropriate queries. Check logs for errors like ‘Invalid Google Drive credentials,’ ‘Pinecone index not found,’ or ‘OpenAI API rate limit.’ Validate responses: ensure answers are accurate, document-specific, and <800 tokens. Debug using n8n logs for network or credential issues. Ensure stable internet for reliable API and webhook performance. Customize document_url in Document Configuration for other files.