Project Overview:
Finance teams and founders waste hours manually reading uploaded PDF invoices, typing vendor figures into databases, and drafting follow-up emails. I engineered an end-to-end AI Invoice Processing & Executive Alert Pipeline in self-hosted n8n that parses PDF uploads using Qwen LLMs, logs structured records into Airtable CRM, and automatically dispatches CEO reminder emails via Gmail.
System Architecture & Workflow Breakdown:

Complete n8n workflow architecture showing PDF invoice form ingestion, Qwen LLM parsing, Airtable CRM logging, JSON-structured email drafting, and automated Gmail delivery.
How the 6-Stage Automation Pipeline Works:
Invoice Form Upload Trigger: Captures incoming PDF invoices submitted through a dedicated upload form.
PDF Raw Text Extraction: Automatically extracts raw text layers from uploaded PDF documents for AI processing.
AI Invoice Field Parsing (Qwen LLM): Analyzes the extracted invoice text to isolate vendor names, invoice numbers, dates, line items, and totals.
Airtable CRM Sync: Creates a clean, structured database record in Airtable automatically (
create: record).AI Executive Reminder Drafting (Qwen + JSON Schema Parser): Generates a structured summary and reminder alert formatted via a strict Email JSON Schema Output Parser.
Automated Gmail Dispatch: Sends the formatted executive reminder email directly to the CEO (
send: message).Live Execution & Verified Run:

Verified live execution run with green checkmarks across all nodes — confirming real-time PDF extraction, Airtable record creation, and automated CEO reminder dispatch.
Key Results & Technical Highlights:
End-to-end hands-free execution from PDF upload to Airtable entry and Gmail notification.
Strict JSON Schema output parsing guarantees reliable, error-free email formatting on every run.
Modular self-hosted n8n architecture with full data privacy and zero middleman fees.
0 likes · 0 views · Nov 16, 2026
Automated AI Invoice Parser in n8n using Qwen LLMs, JSON schema validation, Airtable CRM, and Gmail alerts.