Extract & Save Invoice Data from Google Drive to Sheets with Dumpling AI

This workflow monitors a designated Google Drive folder for new invoice uploads, automatically downloads the PDF files, converts them to Base64, and sends them to Dumpling AI's extract-document endpoint with a custom prompt for structured data extraction including order numbers, dates, PO numbers, addresses, models, descriptions, quantities, unit prices, and totals.

The AI response is parsed via a Code node to handle the JSON structure, then split into individual line items using a Split Out node. Each item, along with header metadata, is appended as a new row to a pre-formatted Google Sheet, ensuring organized record-keeping without manual intervention.

Ideal for operations teams, accountants, e-commerce businesses, and finance managers, it saves hours of tedious data entry, reduces errors, and scales effortlessly for high-volume invoice processing. Setup requires Google Drive folder ID, Sheets configuration with specific headers, and Dumpling AI API credentials.