Automate invoice processing with OCR.Space, GPT-4 & Google Drive to Gmail
Needs changesWhat this workflow does
This AI workflow has 18 nodes and runs on Google Drive events (specific folder). Along the way it connects Google Drive, Google Sheets, OpenAI Chat Model and Gmail. It also calls api.ocr.space over HTTP.
How it runs
Trigger: On Google Drive events (specific folder).
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Google Drive: download
- HTTP Request: calls api.ocr.space (POST)
- Merge: merges the data from its input branches
- Edit Fields (Edit Fields (Set)): sets 1 field: text
- Error (Gmail): uses Gmail
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 1 tool (Google Sheets); output parser: Structured Output Parser
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: api.ocr.space
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (14)
- Merge
n8n-nodes-base.merge - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - No Operation, do nothing
n8n-nodes-base.noOp - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger
From the author
How it works - Watches a Google Drive folder for new (scanned) invoices. Each new file automatically triggers the workflow. - Downloads and processes each invoice through OCR Space to extract the text. - Extracts the company name (e.g. from the “billed to”…