Scan receipt images from Google Drive with Gemini and log to Google Sheets
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive and Google Sheets. It also calls googleapis.com over HTTP.
How it runs
Trigger: On Google Drive events (file created).
- Filter Image or PDF (If): checks a condition and branches into true / false
- Download File (Google Drive): download
- Convert to Base (Code): runs custom JavaScript code
- Gemini OCR (HTTP Request): calls an HTTP API (POST)
- Parse JSON Response (Code): runs custom JavaScript code
- Append to Sheet (Google Sheets): append
- Move to Processed (Google Drive): move
- Check Remaining Files (HTTP Request): calls googleapis.com
- Has More Files? (If): checks a condition and branches into true / false
- Wait: waits 30 seconds
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: googleapis.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)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - If
n8n-nodes-base.if - Google Drive
n8n-nodes-base.googleDrive - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait
From the author
Who is this for Freelancers, small business owners, and accountants who want to automate receipt management without manual data entry. What this workflow does This workflow monitors a Google Drive folder for new receipt images or PDFs. When a file is…