Process invoices from email: AI extraction and validati

This workflow automates the processing of incoming supplier invoices received via email. It extracts data from PDF attachments using AI (LangChain via OpenRouter), validates it against master data in Google Sheets, archives files into structured folders on Google Drive, and sends notifications. Ideal for organizations aiming to eliminate manual data entry and improve financial accuracy.

## Who it´s for
- Accounting departments handling regular incoming invoices
- Finance operators requiring automated data entry
- SMBs with high volumes of email-based supplier invoices
- Outsourced accounting services managing multiple clients

## What the automation does
- Monitors Gmail for new emails with invoice attachments
- Extracts attachments and text, sends content to LangChain via OpenRouter for parsing
- Validates invoice details against vendor and terms data in a Google Sheets master table
- Sends notification to responsible staff for manual review if validation fails
- Organizes successfully processed invoices into date-based folders (daily/monthly) on Google Drive
- Assigns unique IDs to invoices and updates totals in a central summary sheet
- Triggered by new email or scheduled execution

## What´s included
- Ready-to-use n8n workflow
- Trigger logic: new Gmail message and schedule-based start
- Integrations with Gmail, Google Sheets, Google Drive, OpenRouter, and LangChain
- Branching logic, reprocessing, and batching capabilities
- Basic setup and adaptation guide

## Requirements for setup
- n8n instance with workflow execution access
- Gmail account with read access to messages and attachments
- Google Cloud project with enabled Google Sheets and Google Drive APIs
- OpenRouter API key for AI model access
- Pre-configured master data sheet in Google Sheets with vendor information

## Benefits and outcomes
- Eliminates manual data entry from invoices
- Reduces errors in vendor details, amounts, and references
- Provides centralized, well-structured document storage
- Enables fast reconciliation with master reference data
- Automatically aggregates totals for reporting
- Accelerates financial closing and audit preparation
- Scales easily with growing supplier count and invoice volume

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.