New Project: Building an Intelligent ChatBot for File Analysis using n8n + Gemini + Pinecone
In this project, I designed a complete workflow on n8n that performs the following:
Analyzes files using AI (including datasheets or any other type of documents)
Automatically uploads files from Google Drive
Stores the embedded data in a Pinecone Vector Database
Uses Google Gemini (PaLM) as the LLM for question answering and analysis
Saves the processed files’ name and ID in Google Sheets
Executes automated scheduling to refresh the knowledge base every two hours
Result:
An intelligent assistant capable of analyzing technical or textual content within files and providing accurate, professional answers based solely on the uploaded and processed files.
In other words, all responses are strictly derived from the documents that have been uploaded and indexed — ensuring reliability, transparency, and precision.
You can upload any type of file (technical, educational, reports, research, etc.), and the system will automatically understand and analyze it intelligently and efficiently.
It also saves a significant amount of time and effort, freeing users from the long and tedious search through data to find the needed information — all you have to do is ask your question, and the bot handles the rest.
This project opens the door for applying AI in automated and intelligent document analysis, making it a valuable tool for engineers, researchers, and developers.