Automated File Processing and AI Analysis Workflow

This n8n workflow automates the process of searching, downloading, extracting data from files, analyzing content with AI, and updating Google Sheets, triggered manually for flexible execution.

The workflow begins when a user manually starts it via the ‘When clicking ‘Execute workflow’’ trigger. It then searches for relevant files and folders in Google Drive. For each file found, the workflow downloads the file and extracts its content. The extracted data is processed with an AI agent, utilizing an Azure OpenAI Chat Model with memory buffer to maintain context.

The AI agent analyzes or interacts with the extracted content, and the results are appended or updated into a Google Sheet, enabling continuous data logging and analysis. The workflow employs a loop to handle multiple files efficiently and uses sticky notes to add comments or notes during the process for easy documentation.

This automation is particularly useful for workflows involving regular data extraction from files, AI-based content analysis, and continuous data updating in spreadsheets, such as in content management, data auditing, or report generation scenarios.