Automated Document Processing and Email Notification Workflow

This n8n workflow automates the process of extracting information from newly added documents in Google Drive and responding with relevant email notifications. It begins with a trigger on Google Drive when a new file is created. The workflow then downloads the file, extracts text from PDF documents, and uses a language model (Ollama) to analyze and extract key information. An information extractor node processes this data, which is then stored in a vector database (PostgreSQL PGVector) for future reference. Subsequently, a customized email is generated using an AI language model and sent via Gmail. Additionally, the workflow updates a Google Spreadsheet with relevant details for record-keeping. This setup is practical for automating document analysis, knowledge management, and communication workflows, especially in environments with frequent document uploads needing prompt summarization and response.