AI-Powered PDF Invoice Extraction to Sheets & Email Alerts

This n8n workflow monitors a designated Google Drive folder for new PDF invoice uploads. Upon detection, it leverages AI via LangChain and an LLM (like Ollama or GPT-4O-MINI) to intelligently parse and extract key details such as invoice number, client name, email, address, phone, dates, and total amount. The extracted structured data is then seamlessly appended to a Google Sheet serving as an Invoice Database, ensuring centralized and automated record-keeping without manual data entry.

Benefits include significant time savings for accounting teams by eliminating tedious PDF reading and data transcription, reducing errors from manual input, and providing real-time visibility into new invoices. It scales effortlessly for high-volume billing operations and integrates multiple Google services with local AI for privacy-focused processing on self-hosted n8n instances.

Ideal use cases: Small to medium businesses handling client invoicing, freelance billing automation, accounts payable tracking, or any scenario requiring automated document ingestion. Prerequisites include configured credentials for Google Drive, Sheets, Gmail, and LLM provider; a prepared Sheet with specific columns; and testing with sample PDFs for accuracy.

Setup is straightforward: Clone the workflow, link credentials, specify the Drive folder and Sheet URL, and activate. Advanced users can tweak AI prompts for custom fields or integrate additional notifications.