AI-Powered MIS Agent — Workflow n8n

Élevé complexité Déclencheur96 nœuds AI👁 437 vuespar Kumar Shivam

Aperçu

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

Nœuds utilisés

Google SheetsPostgresGoogle DriveGmailCodeAI AgentEmbeddings OpenAIOpenAI Chat ModelSimple MemoryRecursive Character Text SplitterCalculatorCall n8n Workflow ToolPinecone Vector StoreDefault Data LoaderOpenAIText ClassifierInformation Extractor

Aperçu du workflow

Conditional Routing
it matches the regex and identifies whether it is a go
File upload
If it is a file upload if it is a drive link copy that
Email Trigger system to classify specific mai
Folders Link
Data Upload to Designated folders
* Whenever a specific mail hits your inbox
it will classify the mail types routes the attachment
Data Logger
* Every day the schedule triggers the files to move fro
* You ca
Intent Routing and File link Aggregation
* This section routes the intent of the user based on t
* this can be extended for extra capabilites.
Predefined Folder Links
Current Folder location
Search Files in a Folder recursively
Destination folder location
List of Operations
* Append
* Inner Join
* Left Join
* Right Join
* Summarise data
Data Consolidation
* Append
* Inner Join (Join)
* Right Join
* Left Join
* At the end of the task it will generate the file and
Aggregate Data By Given Columns /Group By /Su
Data Cleaning/Transformation
* clean /replace missing values
* Fetch Data type
* Change Data type
* Replace any value
* gives clean file at the end in the drive
Using the AI-Powered MIS Agent Workflow
1. Deploy the supplied JSON workflow in n8n and switch
2. Copy the public URL from the Chat Trigger node.
3. POST a body like `{"q
Structured Json
* sends formatted json instructions to the code block a
Structured Json
* sends formatted json instructions to the code block a
Convert The cleaned file into Csv and Upload
* Final set node is accessing the weblink and name of f
Convert The Merge Operation into Csv and Upl
* Final set node is accessing the weblink and name of f
This node only returns the fetched data types
no storing required into drive
* Fetched data dtypes goes to the bot and returned on t
Merge Operation using Python
* Upper code node is doing inner,left,outer join
* lower code node is used to append the two data inputs
Cleaning Operation using Python
* Upper code node is doing inner,left,outer join
* lower code node is used to append the two data inputs
Merge all the Links IDs and Name of files
* Sends the merged infos of all files in the folders to
📚 🧠 Knowledge Base
Folder and File Links updated to the Data Bas
* Whenever a File is created in specific folder it will
to a database table where there all information about
Upload to the postgres db
Aggregation only
It present the aggregated result in the chat interface
Grouping with aggregation
It present the grouped result as a link of the csv file
tooltooltoolmemoryembedmodelmodelmodelmodeldoctool
G
Gmail Trigger
S
Schedule Trigger
Gmail
Google Drive
Text Classifier
OpenAI Chat Model1
I
If1
I
If2
Google Drive1
Google Drive2
Google Drive3
Google Drive4
Google Drive5
Google Drive6
W
When Executed by Another…
Google Drive10
Code
I
If
W
When chat message received
D
Daily Sales
A
Address
C
customer_info
D
Drive Folders URL
D
Drive Folders URL1
Daily Sales Folder
Address Folder
customer_info folder
M
Merge
Master
W
Wait
Google Sheets2
Google Sheets6
E
Edit Fields5
E
Edit Fields6
E
Edit Fields7
Code3
Code4
Code5
M
Merge2
W
Wait1
OpenAI Chat Model3
OpenAI Chat Model4
C
Convert to File
Google Drive7
E
Edit Fields
I
If3
Code2
E
Edit Fields2
Google Sheets
E
Edit Fields1
Code6
C
Convert to File1
Google Drive8
E
Edit Fields10
OpenAI
I
If5
Google Sheets3
E
Edit Fields12
Code8
Operation Classifier
JSON PARSER (Join)
OpenAI Chat Model7
G
Google Sheets8
Call n8n Workflow Tool1
Simple Memory1
Calculator
MIS Agent1
Pinecone Vector Store
L
Loop Over Items
Default Data Loader
Recursive Character Text…
Knowledge_base
Download files
G
Google Drive Trigger
Postgres2
G
Google Drive Trigger1
G
Google Drive Trigger2
E
Edit Fields8
E
Edit Fields9
E
Edit Fields11
G
Google Drive Trigger3
E
Edit Fields13
P
Postgres
Embeddings OpenAI
Google Sheets4
E
Edit Fields14
Code7
E
Edit Fields15
OpenAI1
S
Switch1
Code10
S
Switch
C
Convert to File2
Google Drive9
E
Edit Fields3
W
When clicking ‘Test work…
96 nodes100 edges

Comment ça fonctionne

  1. 1

    Déclencheur

    Le workflow démarre avec un déclencheur déclencheur.

  2. 2

    Traitement

    Les données transitent par 96 nœuds, connecting agent, chattrigger, code.

  3. 3

    Sortie

    Le workflow termine son automatisation et livre le résultat à la destination configurée.

Détails des nœuds (96)

GO

Google Sheets

googleSheets

#1
PO

Postgres

postgres

#2
GO

Google Drive

googleDrive

#3
GM

Gmail

gmail

#4
CO

Code

code

#5
AI

AI Agent

n8n-nodes-langchain.agent

#6
EM

Embeddings OpenAI

n8n-nodes-langchain.embeddingsOpenAi

#7
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#8
SI

Simple Memory

n8n-nodes-langchain.memoryBufferWindow

#9
RE

Recursive Character Text Splitter

n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter

#10
CA

Calculator

n8n-nodes-langchain.toolCalculator

#11
CA

Call n8n Workflow Tool

n8n-nodes-langchain.toolWorkflow

#12
PI

Pinecone Vector Store

n8n-nodes-langchain.vectorStorePinecone

#13
DE

Default Data Loader

n8n-nodes-langchain.documentDefaultDataLoader

#14
OP

OpenAI

n8n-nodes-langchain.openAi

#15
TE

Text Classifier

n8n-nodes-langchain.textClassifier

#16
IN

Information Extractor

n8n-nodes-langchain.informationExtractor

#17

Comment importer ce workflow

  1. 1Cliquez sur le bouton Télécharger JSON à droite pour enregistrer le fichier du workflow.
  2. 2Ouvrez votre instance n8n. Accédez à Workflows → Nouveau → Importer depuis un fichier.
  3. 3Sélectionnez le fichier ai-powered-mis-agent téléchargé et cliquez sur Importer.
  4. 4Configurez les identifiants pour chaque nœud de service (clés API, OAuth, etc.).
  5. 5Cliquez sur Tester le workflow pour vérifier que tout fonctionne, puis activez-le.

Ou collez directement dans n8n → Importer depuis JSON :

{ "name": "AI-Powered MIS Agent", "nodes": [...], ...}

Intégrations

agentchattriggercodeconverttofiledocumentdefaultdataloaderembeddingsopenaiexecuteworkflowtriggergmailgmailtriggergoogledrivegoogledrivetriggergooglesheetsgooglesheetstoolifinformationextractorlmchatopenaimanualtriggermemorybufferwindowmergeopenai

Obtenir ce workflow

Téléchargez et importez en un clic

Télécharger JSONVoir sur n8n.io
Nœuds96
Complexitéhigh
Déclencheurtrigger
Vues437
CatégorieAI

Créé par

Kumar Shivam

Kumar Shivam

@shivam840708

Tags

agentchattriggercodeconverttofiledocumentdefaultdataloaderembeddingsopenaiexecuteworkflowtriggergmailgmailtriggergoogledrive

Nouveau sur n8n ?

n8n est un outil d'automatisation de workflows gratuit et open-source. Hébergez-le vous-même ou utilisez la version cloud.

Obtenir n8n gratuitement →

Related AI Workflows

AGCOFIGM+10
high

Automate Digital Product Delivery: Stripe to Gmail via n8n

Transform your post-purchase operations with this high-performance n8n workflow designed for digital creators and SaaS founders. Instead of manual fulfillment, this automation acts as a 24/7 digital concierge. It begins by scanning Stripe for successful transactions, cross-referencing buyer data against a centralized Google Sheets inventory to identify the correct digital asset. Utilizing advanced AI via GPT-4o, the system then drafts a personalized onboarding email, including secure access credentials and custom instructions, ensuring a premium customer experience without manual intervention. This flow eliminates the 'human-in-the-middle' delay, significantly reducing support tickets related to missing downloads. By integrating an AI agent, the workflow can intelligently parse complex product variations, making it far more robust than standard linear automations. Whether you are selling automation templates, software licenses, or protected PDF guides, this system provides a scalable infrastructure that grows with your sales volume while maintaining a personal touch through LLM-generated content. **Common Use Cases:** - Scaling a niche digital marketplace for selling specialized code snippets or design assets. - Automating the distribution of unique software license keys and documentation after a SaaS subscription purchase. - Delivering personalized AI-generated consulting reports or audit results based on customer input data.

Scheduled·25 nodes
AGCHCOEX+10
high

Automated AI Resume Parser & JD Matcher via n8n & GPT-4

Transform your recruitment funnel with this advanced AI-driven candidate evaluation engine. This n8n workflow eliminates manual screening fatigue by autonomously analyzing batches of resumes against specific job descriptions. Using GPT-4 and LangChain's structured output parsers, the system extracts key qualifications, scores them against your criteria, and generates objective alignment reports. The process begins with a custom n8n form for document upload, followed by intelligent text extraction from PDFs. The data is then processed through an LLM chain to ensure unbiased scoring. Results are synchronized directly to Google Sheets for centralized tracking, while high-match alerts are dispatched via Slack and SendGrid to keep hiring managers informed in real-time. This workflow is essential for high-volume recruitment agencies and scaling startups that need to maintain a rigorous, auditable, and data-backed shortlisting process without increasing headcount or sacrificing quality of hire. **Common Use Cases:** - High-volume university recruitment and internship screening - Technical talent sourcing for niche engineering roles - Internal mobility matching for large corporate restructuring

Trigger·21 nodes
AGCHGMGM+5
medium

AI Gmail Auto-Labeler: Smart Inbox Sorting with GPT-4 & n8n

Stop drowning in a cluttered inbox and regain control of your digital communication. This advanced n8n automation leverages GPT-4's natural language processing to intelligently analyze, categorize, and label incoming Gmail messages in real-time. Unlike basic filter rules that rely on rigid keywords, this workflow understands the context and sentiment of every email, ensuring high-precision organization. The process begins with a Gmail Trigger that captures new messages. It then passes the content through a LangChain LLM chain where OpenAI evaluates the intent—distinguishing between urgent client requests, internal project updates, or low-priority newsletters. Using structured output parsing, the workflow extracts key metadata and applies the appropriate Gmail labels automatically. This eliminates the manual cognitive load of triaging emails, allowing your team to focus on high-value tasks rather than administrative upkeep. Whether you are managing high-volume support tickets or complex sales inquiries, this workflow ensures that critical messages are highlighted and organized without human intervention. **Common Use Cases:** - Automated Customer Support Triage: Instantly tag emails as 'Urgent Support', 'Feature Request', or 'Billing' to speed up response times. - Sales Lead Prioritization: Automatically identify high-intent inquiries and label them for immediate follow-up by account executives. - Project Management Sync: Categorize incoming vendor updates and stakeholder feedback by project name or department for better visibility.

Trigger·11 nodes
AGGMGOLM+3
medium

AI Dental Lead Follow-up: n8n, OpenAI & Google Sheets Sync

Stop losing high-value patients to delayed responses. This advanced n8n workflow bridges the gap between lead capture and appointment booking by deploying an AI-driven engagement layer. When a prospect submits a query via your website or landing page, the automation immediately triggers, logging the data into Google Sheets for centralized tracking. Instead of sending a generic auto-reply, the integrated LangChain agent utilizes GPT-4/3.5 to analyze the specific treatment interest—be it Invisalign, dental implants, or routine cleaning—and crafts a personalized, empathetic response delivered via Gmail. The workflow includes a strategic 'Wait' node to mimic natural human timing and a 'Memory Buffer' to maintain context if the lead replies. This system is essential for clinics looking to scale their patient acquisition without increasing administrative headcount, ensuring every inquiry is nurtured instantly with professional, clinical-grade communication. By automating the initial touchpoint, your front-desk team can focus on confirmed arrivals rather than chasing cold leads. **Common Use Cases:** - Automated Patient Triage: Categorizing and responding to specific dental treatment inquiries based on urgency and procedure type. - Medical Spa Lead Nurturing: Instantly engaging prospects interested in high-ticket aesthetic treatments to increase conversion rates. - Multi-Location Clinic Sync: Centralizing lead data from various web forms into a single Google Sheet while maintaining personalized local email follow-ups.

Trigger·8 nodes
AGCOGOHT+8
high

Automate AI UGC Video Production with Google Sheets & Veo

Transform your digital marketing strategy by automating the production of high-converting User-Generated Content (UGC) at scale. This sophisticated n8n workflow eliminates the logistical bottleneck of traditional content creation by orchestrating a seamless pipeline between Google Sheets and advanced AI video models. By leveraging NanoBanana Pro for precise image synthesis and Veo 3.1 for fluid motion, the system takes three distinct visual inputs—your product, a chosen persona, and a target environment—and blends them into hyper-realistic, selfie-style video assets. The automation begins by monitoring a Google Sheet for new campaign parameters, triggers an intelligent AI agent to handle complex image processing, and manages asynchronous API calls to ensure high-fidelity video rendering. This is an enterprise-grade solution for performance marketers who need to refresh creative assets daily without manual intervention. It effectively handles the heavy lifting of prompt engineering and file management, allowing you to focus on strategy while the workflow generates 8-second, platform-ready clips optimized for the TikTok and Instagram algorithms. **Common Use Cases:** - Scaling creative testing for TikTok and Meta Ads by generating hundreds of product variants - Automating personalized influencer-style shoutouts for e-commerce loyalty programs - Rapid prototyping of social media video content for global brand localization

Scheduled·24 nodes
@BAGCOIF+7
high

Automate AI Twitter Threads via Telegram & n8n (No-Code)

Streamline your social media presence with this enterprise-grade n8n automation that bridges the gap between raw inspiration and professional X (Twitter) publishing. By integrating Telegram as a mobile command center, this workflow allows you to dictate or type thread ideas on the go. The system leverages OpenAI’s LLMs and LangChain agents to draft high-engagement thread structures, which are then sent back to your private Telegram chat for review. Unlike basic automation, this setup features a sophisticated 'human-in-the-loop' approval system. You can interactively refine the AI-generated content, request edits, or finalize the draft. Once you provide the 'Okay' confirmation, the workflow automatically formats and publishes the entire thread to X via the Blotato integration. This eliminates the friction of manual drafting and copy-pasting, ensuring your brand stays active without the constant overhead of social media management. It is the perfect solution for creators and businesses looking to maintain a high-quality digital presence using a voice-to-thread mobile pipeline. **Common Use Cases:** - Thought Leadership: Convert spontaneous voice memos into structured educational threads while commuting. - Event Live-Tweeting: Rapidly draft and approve professional event summaries from a mobile device without opening the X app. - Content Repurposing: Send links or snippets of long-form articles to Telegram to generate 'tweetable' summaries for social distribution.

Trigger·19 nodes