Automated Invoice Data Extraction and Entry to Google Sheets

This workflow automates the process of extracting structured data from invoice files stored in Google Drive and saving it into Google Sheets. Starting with a trigger that monitors a specific Google Drive folder for new invoice files, the workflow downloads each new invoice, converts the file to Base64 format, and sends it to Dumpling AI for data extraction. Dumpling AI parses the invoice to retrieve key details such as order number, date, PO number, and line items. The JSON response from Dumpling AI is then parsed, and individual line items are split for row-wise insertion into a Google Sheet. This process enables seamless, automated data entry for invoicing and bookkeeping purposes, ensuring efficiency and accuracy in financial workflows.