Extract and save invoice data from Google Drive to Sheets with Dumpling AI

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?

Manually reading invoice PDFs, extracting relevant data, and entering it into spreadsheets is time-consuming and error-prone. This workflow automates that process—watching a Google Drive folder, extracting structured invoice data using Dumpling AI, and saving the results into Google Sheets.

---

What this workflow does

1. Watches a specific Google Drive folder for new invoices. 2. Downloads the uploaded invoice file. 3. Converts the file into a Base64 format. 4. Sends the file to Dumpling AI’s extract-document endpoint with a detailed parsing prompt. 5. Parses Dumpling AI’s JSON response using a Code node. 6. Splits the items array into individual rows using the Split Out node. 7. Appends each invoice item to a preformatted Google Sheet along with the full header metadata (order number, PO, addresses, etc.).