Abdul Matheen This workflow corresponds to n8n.io template #10123 — we link there as the canonical source.
This workflow follows the Agent → Google Drive recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "BYzxNRz3ownaQd4R",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "PO_Invoice_Matching_V1",
"tags": [],
"nodes": [
{
"id": "67440d4f-4122-4732-92a4-cf62bf064159",
"name": "Google Drive Trigger",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-992,
-208
],
"parameters": {
"event": "fileCreated",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": "1cxnSBv6t7SAgJDJZxAOtPXO0RZH7rfKf",
"cachedResultUrl": "https://drive.google.com/drive/folders/1cxnSBv6t7SAgJDJZxAOtPXO0RZH7rfKf",
"cachedResultName": "Invoices"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "98a803af-25a6-4933-a0eb-29afa7fe95ac",
"name": "Download file",
"type": "n8n-nodes-base.googleDrive",
"position": [
-768,
-208
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 3
},
{
"id": "ecadedd7-ba41-4212-8ec0-57c8ce47d075",
"name": "Extract from File",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-544,
-208
],
"parameters": {
"options": {},
"operation": "pdf"
},
"typeVersion": 1
},
{
"id": "301efe65-f9d1-41d4-9b9b-1727eec6e2ac",
"name": "Information Extractor",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
-320,
-208
],
"parameters": {
"text": "={{ $json.text }}",
"options": {},
"attributes": {
"attributes": [
{
"name": "Vendor Name",
"required": true,
"description": "vendor name from whom teh invoice came"
},
{
"name": "Invoice Number",
"required": true,
"description": "Invoice number"
},
{
"name": "Invoice Date",
"required": true,
"description": "Invoice date from the invoice"
},
{
"name": "Total Amount",
"type": "number",
"required": true,
"description": "Total amount including the tax amount"
},
{
"name": "PO Number",
"required": true,
"description": "PO number from invoice"
},
{
"name": "PO Date",
"required": true,
"description": "PO date from invoice"
},
{
"name": "Qty",
"type": "number",
"required": true,
"description": "Quantity from invoice"
},
{
"name": "Rate",
"type": "number",
"required": true,
"description": "rate from invoice table"
},
{
"name": "Net Amount",
"required": true,
"description": "Net Amount Excluding Tax"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "ec28ded6-e060-481d-9434-c1b86130ac67",
"name": "Google Gemini Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
-256,
16
],
"parameters": {
"options": {}
},
"credentials": {
"googlePalmApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "70cf4980-33f4-4c61-ac16-e3ea16fbf92c",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
32,
-208
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Hight Dollar",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0e897f8d-3ee6-470a-a090-16766c79f679",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.output['Total Amount'] }}",
"rightValue": 5000
}
]
},
"renameOutput": true
},
{
"outputKey": "Direct Payment",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "338c9b39-e0ef-43fd-9dce-efd2fed4adf7",
"operator": {
"type": "number",
"operation": "lt"
},
"leftValue": "={{ $json.output['Total Amount'] }}",
"rightValue": 5000
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.3
},
{
"id": "23b35100-3876-4f9f-bcca-52710f96f354",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
320,
-256
],
"parameters": {
"text": "={{ $json.output['PO Number'] }}\n{{ $json.output['PO Date'] }}\n{{ $json.output.Qty }}\n{{ $json.output.Rate }}\n{{ $json.output['Net Amount'] }}",
"options": {
"systemMessage": "=You are expert in finance checker. \n\n\nYou task is to verify the the details from from PO_DB tool\n\n\nIf all are matched then update the invoice number {{ $json.output['Invoice Number'] }} in the Upadet_Row tool \n\nUpdate \"MATCHING\" OR \"NOT MATCHING\" in the matching or not matching column in Upadet_Row\n\nUpdate the comments on the matching on the \"Remarks\" column of Upadet_Row tool\n\nIf matching give a seprate output as TRUE or give as FALSE\nAlso send teh remarks to the as output\n\n{\n\"match\":TRUE\n\"remarks\":\"value\"\n\n}\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "664fe47a-83cb-4cfd-b210-a175b0d6a312",
"name": "Google Gemini Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
256,
-32
],
"parameters": {
"options": {}
},
"credentials": {
"googlePalmApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "6604eac1-8429-4dad-9ede-350fd8d2b591",
"name": "PO_DB",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
384,
-32
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-H7zfvdx6NgBPrlveD8hXeW2q38VhtO_aO_2Sik1M0/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1T-H7zfvdx6NgBPrlveD8hXeW2q38VhtO_aO_2Sik1M0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-H7zfvdx6NgBPrlveD8hXeW2q38VhtO_aO_2Sik1M0/edit?usp=drivesdk",
"cachedResultName": "PO_Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "10a033f5-b15d-402d-81c1-a9ee6753b90e",
"name": "Update_Row",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
512,
-32
],
"parameters": {
"columns": {
"value": {
"Remarks": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Remarks', ``, 'string') }}",
"PO Number": "={{ $json.output['PO Number'] }}",
"Invoice Number": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Invoice_Number', ``, 'string') }}",
"Matching or Not Matching": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Matching_or_Not_Matching', ``, 'string') }}"
},
"schema": [
{
"id": "PO Number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PO Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Vendor Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Vendor Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PO Date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "PO Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Qty",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Qty",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rate",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Rate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Amount",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tax",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Tax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Total Amount",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Total Amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Invoice Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Invoice Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Matching or Not Matching",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Matching or Not Matching",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Remarks",
"type": "string",
"display": true,
"required": false,
"displayName": "Remarks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"PO Number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-H7zfvdx6NgBPrlveD8hXeW2q38VhtO_aO_2Sik1M0/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1T-H7zfvdx6NgBPrlveD8hXeW2q38VhtO_aO_2Sik1M0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-H7zfvdx6NgBPrlveD8hXeW2q38VhtO_aO_2Sik1M0/edit?usp=drivesdk",
"cachedResultName": "PO_Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "860e77ab-9c58-4548-be34-7d8bbff8a06a",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
720,
-256
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7c2043db-c9cb-4366-b04f-be71973234de",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.match }}",
"rightValue": "true"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "79803fd2-cea1-4f89-80bb-2263774b12dd",
"name": "Append row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
928,
-416
],
"parameters": {
"columns": {
"value": {
"Qty": "={{ $('Switch').item.json.output.Qty }}",
"Tax": "0",
"Rate": "={{ $('Switch').item.json.output.Rate }}",
"Amount": "={{ $('Switch').item.json.output['Net Amount'] }}",
"Status": "Process payment",
"PO Date": "={{ $('Switch').item.json.output['PO Date'] }}",
"PO Number": "={{ $('Switch').item.json.output['PO Number'] }}",
"Vendor Name": "={{ $('Switch').item.json.output['Vendor Name'] }}",
"Total Amount": "={{ $('Switch').item.json.output['Net Amount'] }}",
"Invoice Number": "={{ $('Switch').item.json.output['Invoice Number'] }}"
},
"schema": [
{
"id": "PO Number",
"type": "string",
"display": true,
"required": false,
"displayName": "PO Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Vendor Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Vendor Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PO Date",
"type": "string",
"display": true,
"required": false,
"displayName": "PO Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Qty",
"type": "string",
"display": true,
"required": false,
"displayName": "Qty",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rate",
"type": "string",
"display": true,
"required": false,
"displayName": "Rate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Amount",
"type": "string",
"display": true,
"required": false,
"displayName": "Amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tax",
"type": "string",
"display": true,
"required": false,
"displayName": "Tax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Total Amount",
"type": "string",
"display": true,
"required": false,
"displayName": "Total Amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Invoice Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Invoice Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1km2dOTGoExdJjaQvXYMlz80IvnCHSAPY6kL1AavomUo/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1km2dOTGoExdJjaQvXYMlz80IvnCHSAPY6kL1AavomUo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1km2dOTGoExdJjaQvXYMlz80IvnCHSAPY6kL1AavomUo/edit?usp=drivesdk",
"cachedResultName": "Payment Process"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "bd4a913c-2fd9-4f19-b712-eecfc766e814",
"name": "Send a message",
"type": "n8n-nodes-base.microsoftOutlook",
"position": [
960,
-80
],
"parameters": {
"subject": "=Invoice # {{ $('Information Extractor').item.json.output['Invoice Number'] }} Not Matching\n\n\n",
"bodyContent": "=Hi Team,\n\n\nThe invoice # {{ $('Switch').item.json.output['Invoice Number'] }} doent match with PO {{ $('Switch').item.json.output['PO Number'] }}\n\nRemarks: {{ $json.output.remarks }}\n\n\nThanks",
"toRecipients": "user@example.com",
"additionalFields": {}
},
"credentials": {
"microsoftOutlookOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 2
},
{
"id": "fd896f77-5a44-4772-bf2b-fb258c639ec1",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
640,
96
],
"parameters": {
"jsonSchemaExample": "{\n\"match\":\"true\",\n\"remarks\":\"Invoice macthed\"\n\n}\n"
},
"typeVersion": 1.3
},
{
"id": "44330d6b-06af-4d6b-864e-91c243adb29a",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1104,
-592
],
"parameters": {
"width": 688,
"height": 320,
"content": "## Invoice PO matching process\n\n1. It extracts the data from invoice\n2. Using AI model extract the required fields from teh data\n3. Check if teh amount is greater than 5000 \n4. Send for review with PO detais\n5. Match teh invoice data with PO data\n6. Update the information as payment process if matchs\n7. Else send an email to fianace team as not matched\n"
},
"typeVersion": 1
},
{
"id": "b3d2c3de-2632-46d7-bbfe-a50faf2b293a",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
-224
],
"parameters": {
"color": 3,
"width": 1024,
"height": 224,
"content": "\n\n\n\n\n\n\n\n\n\n\n\n\n\nExtract the invoice data and extarct the required information from invoice"
},
"typeVersion": 1
},
{
"id": "2c8ccecd-6fdf-4bbf-995c-3d6269966477",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-432
],
"parameters": {
"width": 528,
"content": "Check the amount is greater than 5000 and validated with PO database"
},
"typeVersion": 1
},
{
"id": "6826e75f-1496-4abd-b2a3-4ebabe0b9dd5",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
784,
-592
],
"parameters": {
"width": 320,
"content": "Approval for payment process"
},
"typeVersion": 1
},
{
"id": "ac78f8cc-0413-40df-a6df-8de8175b9003",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
80
],
"parameters": {
"width": 320,
"content": "Send email if not match"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "d1ea1b19-2a18-45af-97df-1bf1e2710996",
"connections": {
"If": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"PO_DB": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
],
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Update_Row": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Download file": {
"main": [
[
{
"node": "Extract from File",
"type": "main",
"index": 0
}
]
]
},
"Extract from File": {
"main": [
[
{
"node": "Information Extractor",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Trigger": {
"main": [
[
{
"node": "Download file",
"type": "main",
"index": 0
}
]
]
},
"Information Extractor": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Information Extractor",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Google Gemini Chat Model1": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleDriveOAuth2ApigooglePalmApigoogleSheetsOAuth2ApimicrosoftOutlookOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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 challenge of verifying invoice data manually, cross-checking it…
Source: https://n8n.io/workflows/10123/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This automation is designed to help you generate AI-powered music tracks, cover art, and fully rendered music videos — all triggered from a simple Telegram chat and managed via Google Sheets.
OpenAI Chat, Memory Buffer Window, Output Parser Structured +11
CV → Match → Screen → Decide, all automated
HTTP Request, Information Extractor, Google Sheets +7
A fully automated Telegram-based personal finance tracker that: Accepts receipts as images, PDFs, or plain text Uses Google Gemini Vision for OCR & intelligent extraction Logs every expense into Googl
Telegram Trigger, Agent, Google Gemini Chat +8
This workflow automates the extraction and processing of invoice data from PDFs stored in a Google Drive folder. It leverages Google Drive, Google Sheets, and Gemini AI to streamline invoice managemen
Google Gemini Chat, Google Sheets, HTTP Request +5
This workflow is designed to evaluate newly added CVs for Diversity, Equity, and Inclusion (DEI) eligibility. It automatically ingests CVs from Google Drive, extracts key fields, analyzes them with Az
Lm Chat Azure Open Ai, Output Parser Structured, Google Sheets Tool +5