Automated Invoice Processing and Data Extraction Workflow

This n8n workflow automates the process of extracting invoice data from PDFs stored in Google Drive and updating a Google Sheet with the parsed information. It triggers when new invoice files are uploaded to a designated Google Drive folder, downloads the files for OCR processing, and uses the Mistral AI API to extract structured data from the invoices. The workflow ensures efficiency by checking for already processed files, avoiding duplication, and consolidating OCR results. It also includes steps for optical character recognition (OCR) on images and PDF documents, and for extracting specified invoice details such as Invoice Number, Date, Amount, and IBAN. The data is then saved into a Google Sheet, providing a streamlined solution for financial record-keeping and document management.