This n8n workflow automates the process of extracting data from invoices received via email, processing receipt images from Google Drive, and storing the structured data in a spreadsheet, all while supporting image-based invoice recognition and notification features.
The workflow begins with listening for incoming emails through Gmail or images via Telegram, then it splits email attachments and images into batches for processing. For email attachments, it checks if they are receipts, extracts relevant information by converting images to base64 strings, and sends them to Gemini API for OCR processing. The extracted data is then converted into JSON strings and parsed, ready to be added row-by-row into a Google Sheet.
Simultaneously, receipt images stored in Google Drive are retrieved, renamed, and saved back after processing. Notifications and file management are handled throughout the workflow, with wait nodes to ensure sequential data handling.
Practical use cases for this workflow include automated expense report generation, receipt archiving, and data entry for financial management systems. It simplifies manual efforts and ensures real-time processing of invoices and receipts received via email or images, significantly streamlining administrative workflows.
Reviews
There are no reviews yet.