AI-powered MIS agent

The AI-powered MIS Agent is an intelligent, automated system built using n8n that streamlines email-based data collection and document organization for businesses. It classifies incoming emails, extracts and processes attachments or Drive links, and routes them to the correct destination folders in Google Drive. Additionally, it provides advanced file operations like cleaning, merging, joining, and transforming data.

Advantages 📥 Automated Email and File Management Detects and processes emails containing attachments or Drive links, ensuring seamless classification and routing of business-critical files.

🧠 AI-Based Classification Uses LLMs (like GPT-4o Mini) to classify emails into categories such as Daily Sales, Customer Info, and Address based on their content. 📂 Smart File Routing and Upload Recognizes whether a file is a direct attachment or a Google Drive link, extracts the file ID if necessary, and uploads it to predefined folders. 📊 Powerful Data Operations Supports operations like append, join, group by, aggregation, and standardization of data directly from spreadsheets using Python and Pandas within the workflow.

🔁 Scheduled and Triggered Automation Supports scheduled runs and real-time email triggers, making it highly reliable and timely.

🔧 Fully Modular and Scalable Easily expandable with more logic, new folders, or different workflows. Clean architecture and annotations make maintenance simple.

How It Works Email Trigger The system uses a Gmail trigger to monitor incoming emails with specific labels or attachments.

Classification An LLM-based text classifier identifies the purpose of the email (e.g., sales data, address list, customer details).

Conditional Logic Regex-based conditions check if the email contains Google Drive links or attachments.