Automate invoice processing with AI data extraction, Google Drive & Sheets
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive, Google Sheets and OpenAI Chat Model.
How it runs
Trigger: On Google Drive events (file created).
- Search files and folders (Google Drive): work with file folder
- Loop (Loop Over Items (Split in Batches)): loops over the items in batches
- GetFile (Google Drive): download
- ExtractFromPDF (Extract from File): extracts data from a file (pdf)
- Information Extractor: extracts structured fields from text with AI, with model: OpenAI Chat Model
- GetYearFolder (Google Drive): work with file folder
- GetMonthFolder (Google Drive): work with file folder
- MoveFile (Google Drive): move
- UpdateFileName (Google Drive): update
- AddToOverview (Google Sheets): append
…plus 9 more steps. See the full node list below.
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 (10)
- Google Drive
n8n-nodes-base.googleDrive - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Extract from File
n8n-nodes-base.extractFromFile - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Split Out
n8n-nodes-base.splitOut - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if
From the author
🧾 Automated Invoice Processing - n8n Workflow 📖 Workflow Description This n8n workflow automates the complete processing of PDF invoices with AI-powered data extraction. The workflow monitors a Google Drive folder, extracts important invoice data, and…