Automated invoice-PO matching with Google Gemini AI and email notifications
Ready for 3.0What this workflow does
This AI workflow has 14 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive, Google Gemini Chat Model, Google Sheets and Microsoft Outlook.
How it runs
Trigger: On Google Drive events (file created).
- Download file (Google Drive): download
- Extract from File: extracts data from a file (pdf)
- Information Extractor: extracts structured fields from text with AI, with model: Google Gemini Chat Model
- Switch: routes items into 2 branches
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 2 tools (PO_DB, Update_Row); output parser: Structured Output Parser
- Append row in sheet (Google Sheets): append
- If: checks a condition and branches into true / false
- Send a message (Microsoft Outlook): uses Microsoft Outlook
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Switch
n8n-nodes-base.switch - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
From the author
Automated Invoice-Processing AI Agent for n8n Overview The Automated Invoice-Processing AI Agent in n8n is designed to streamline and optimize invoice management for finance teams and accounts payable (AP) professionals. This solution addresses the common…