Recognize invoices / receipts from Google Drive and put them into Google Sheets
Ready for 3.0What this workflow does
This workflow has 9 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Drive and Google Sheets. It also calls receipt-and-invoice-ocr-api.p.rapidapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Load files from Google Drive folder (Google Drive): work with file folder
- Get already processed rows from Sheets (Google Sheets): uses Google Sheets
- Filter processed files (Merge): merges the data from its input branches
- Download file for OCR (Google Drive): download
- OCR recognize (HTTP Request): calls receipt-and-invoice-ocr-api.p.rapidapi.com (POST)
- Unserialize response JSON (Code): runs custom JavaScript code
- Save OCR result into Sheets (Google Sheets): append or update
Services it uses
HTTP calls to: receipt-and-invoice-ocr-api.p.rapidapi.com
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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets
From the author
This workflow allows you to recognize a folder with receipts or invoices (make sure your files are in .pdf, .png, or .jpg format). The workflow can be triggered via the "Test workflow" button, and it also monitors the folder for new files, automatically…