Automated Invoice OCR Extraction & Structuring with AI to Sheets

This n8n workflow streamlines invoice processing by enabling users to upload invoice images through a form. Files are securely stored in Google Drive, then processed with Google Vision API for accurate OCR text detection. The extracted text is fed into Gemini LLM (via OpenRouter) to intelligently parse and structure key details like date, voucher number, transaction details, vendor, and value into a consistent JSON format.

A structured output parser ensures data reliability, followed by cleaning steps that format numerics by removing currency symbols. The refined data is appended or updated in a Google Sheets spreadsheet, matched by file ID for deduplication. Real-time Telegram notifications deliver transaction summaries to specified chats, keeping teams informed instantly.

Ideal for healthcare practices managing appointment-related invoices or any business handling vendor bills. Benefits include massive time savings on manual data entry, reduced errors from AI-powered extraction, seamless integrations, and scalable automation. Perfect for accounting teams, clinics, or e-commerce ops processing high volumes of invoices.