Extract Invoice Data from PDFs with Gemini AI to Google Sheets 📄

Description

📄 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.