Extract and save invoice data from Google Drive to Sheets with Dumpling AI
Ready for 3.0What this workflow does
This workflow has 7 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive and Google Sheets. It also calls app.dumplingai.com over HTTP.
How it runs
Trigger: On Google Drive events (file created).
- Download Invoice File (Google Drive): download
- Convert invoice File to Base (Extract from File): extracts data from a file (binary to propery)
- Send file to Dumpling AI for Data Extraction (HTTP Request): calls app.dumplingai.com (POST)
- Parse Dumpling AI JSON Response (Code): runs custom JavaScript code
- Split line Items from Invoice (Split Out): splits a list into separate items
- Save Data to Google Sheet (Google Sheets): append
Services it uses
HTTP calls to: app.dumplingai.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 - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets
From the author
Who is this for? This workflow is perfect for operations teams, accountants, e-commerce businesses, or finance managers who regularly process digital invoices and need to automate data extraction and record-keeping. --- What problem is this workflow solving?…