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.
File Handling
If it's a Drive link, it extracts the file ID and copies it to the correct folder. If it's an attachment, it uploads directly.
Scheduled Data Management
Periodically moves or logs files from predefined folders using a schedule trigger.
Data Cleaning and Processing
Performs data cleaning and transformation tasks like replacing missing values, standardizing formats, and joining datasets based on criteria provided by the user.
Final Output
Cleaned and processed files are saved in designated folders with their public links shared back through the system.
Set Up Steps
Configure Nodes:
Gmail Trigger: Detects relevant incoming emails.
-
Text Classifier: Uses OpenAI model to categorize email content.
-
Regex Conditions: Determine whether a link or attachment is present.
-
Google Drive Operations: Upload or copy files to categorized folders.
-
Python Nodes: Handle data manipulation using Pandas.
-
Google Sheets Nodes: Extract, clean, and write structured data.
-
LLM-based Chat Models: Extract and apply cleaning configurations.
Connect Nodes:
-
Seamlessly connect Gmail inputs, classification, file processing, and data logic.
-
Output links or processed files are uploaded back to Drive and ready to share.
-
Credentials:
Ensure OAuth credentials for Gmail, Google
Drive, and OpenAI are correctly set.
Ideal For
-
Sales & CRM teams managing large volumes of email-based reports.
-
Data teams needing structured pipelines from unstructured email inputs.
-
Businesses looking to automate classification, storage, and transformation of routine data.
Testing and Additional customization
- If you want to test this bot capability
before purchasing the workflow.
ask me on my mail
[email protected]
I will share the chat url and the links of
associated google drives to see the result
once you are satisfied then we are good to
go.
I have just kept $1 for testing purposes
because of paid open ai .
-If there is any customization needed like charts and other request like adding databases feel free to let me know i can do it accordingly.
- This is the first version i will come with more advancements based on the request and responses.