Automated Invoice Processing with OCR and AI

This workflow automates the entire process of invoice management, from upload to data extraction and logging. When a user submits an invoice via a form, the workflow uploads the image to Google Drive, then downloads and converts it to Base64 for OCR via Google Vision API. The extracted text is processed with a language model (LLM) to identify key details such as date, voucher number, vendor, and amount, which are then cleaned and structured into a consistent format. The structured data is appended or updated in Google Sheets for record-keeping, and a summary notification is sent through Telegram. This automation streamlines invoice handling, reducing manual data entry, and ensuring real-time updates and notifications, ideal for accounting and administrative workflows.