Extract invoice data from PDFs with AI - Google Sheets Email alerts
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 10 nodes and runs on Google Drive events. Along the way it connects Gmail, Ollama Model, Postgres PGVector Store and Google Drive and 2 more.
How it runs
Trigger: On Google Drive events.
- Download Binary - file (Google Drive): uses Google Drive
- Extract from PDF (Extract from File): extracts data from a file
- Update DB - spreadsheet (Google Sheets): uses Google Sheets
- Information Extractor: extracts structured fields from text with AI, with model: Ollama Model
- Create Email Agent (OpenAI): uses OpenAI, with 1 tool (Postgres PGVector Store)
- Send Email (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp - Ollama Model
@n8n/n8n-nodes-langchain.lmOllama - Postgres PGVector Store
@n8n/n8n-nodes-langchain.vectorStorePGVector - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets
From the author
Built by Setidure Technologies This smart n8n automation extracts invoice details from PDF files uploaded to Google Drive using AI, logs them to a Google Sheet, and notifies the billing team via email — all without manual intervention. ⚠️ Note: This workflow…