Automate invoice data extraction from Google Drive to Airtable using Nanonets OCR & Command-R
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive, OpenAI, Airtable and OpenAI Chat Model.
How it runs
Trigger: On Google Drive events (file created).
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- file name & ID (Edit Fields (Set)): sets 2 fields: fileId, orfilename
- Download file (Google Drive): download
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Data Cleaner (OpenAI): uses OpenAI
- Move failed (Google Drive): move
- Airtable: create
- Move successful (Google Drive): move
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)
- Google Drive
n8n-nodes-base.googleDrive - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - No Operation, do nothing
n8n-nodes-base.noOp - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Airtable
n8n-nodes-base.airtable - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
How it works This template creates a fully automated "hands-off" pipeline for processing financial documents. It's perfect for small businesses, freelancers, or operations teams who want to stop manually entering invoice and receipt data. When you drop a new…