Invoice Reconciliation Automation
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs on Google Drive events (file created). Along the way it connects Google Sheets, Slack, Gmail and Google Drive and 1 more.
How it runs
Trigger: On Google Drive events (file created).
- Download file (Google Drive): download
- Extract from File: extracts data from a file (pdf)
- 04 | Code Split PDF Attachments into Items (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- 07 | Code Parse and Enrich Invoice Data (Code): runs custom JavaScript code
- 08 | Google Sheets Append to Invoice Log (Google Sheets): append or update
- 11 | Code Generate Weekly Summary Stats (Code): runs custom JavaScript code
- 10 | Slack Alert Finance on Overdue Invoices (Slack): uses Slack
- 12 | Gmail Email Weekly Report to Finance (Gmail): uses Gmail
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 (9)
- Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger
From the author
How it works Watches a Google Drive folder and triggers automatically when a new invoice PDF is uploaded Extracts raw text from the PDF and passes each invoice through an OpenAI powered agent that returns structured fields like vendor, amount, due date, and…