Extract invoice data from PDFs with Gemini AI to Google Sheets 📄

📄 Automated Invoice Processing (n8n + AI + Google Workspace)

This workflow automates the extraction and processing of invoice data from PDFs stored in a Google Drive folder. It leverages Google Drive, Google Sheets, and Gemini AI to streamline invoice management.

Key Features - Automatic Detection: Monitors a Google Drive folder for new invoices. - AI-Powered Extraction: Uses Gemini AI to extract structured data including Supplier, Buyer, Items, Total Amount, Tax, and Payment Terms. - Data Logging: Appends extracted invoice information to a Google Sheet and tracks processed documents to avoid duplicates. - Notifications: Sends email alerts once invoices are successfully processed. - Flexible & Extensible: Can be integrated with ERP/CRM systems, Slack/Telegram notifications, or OCR for scanned PDFs.

💡 Perfect for: Small to medium businesses, accountants, and operations teams looking to reduce manual invoice data entry and improve accuracy.