Extract and process invoices with GPT-4, Google Drive, and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs on Google Drive events (file created). Along the way it connects Google Sheets, Google Drive and OpenAI Chat Model.
How it runs
Trigger: On Google Drive events (file created).
- Download file (Google Drive): download
- Extract from File: extracts data from a file (pdf)
- Invoice Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Chart of Accounts); memory: Simple Memory; output parser: Structured Output Parser
- Update Booking List (Google Sheets): append
- Edit Fields (Edit Fields (Set)): sets 1 field: data
- Move file (Google Drive): move
- Save to Drive (Google Drive): uses Google Drive
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 Sheets
n8n-nodes-base.googleSheets - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Google Drive
n8n-nodes-base.googleDrive - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Extract from File
n8n-nodes-base.extractFromFile - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
This template is a fully automated AI invoice processing workflow for n8n. It watches a Google Drive folder for new invoice PDFs, extracts all key information using an AI Agent, assigns the correct booking account, saves the renamed invoice in the right Drive…