Parse invoices & documents with Gemini AI, OCR, and Google Sheets integration
UnknownWhat this workflow does
This AI workflow has 10 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets, Google Gemini Chat Model and Tesseractjs (community).
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Check file type (Switch): routes items into 3 branches
- Image to Text (Tesseract Node): uses Tesseract Node
- PDF to Text (Extract from File): extracts data from a file (pdf)
- CSV to JSON (Extract from File): extracts data from a file
- Format data from text (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Invoice data (Google Sheets): append or update
- Transfrom data (Code): runs custom JavaScript code
- Invoice Data (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-tesseractjs is verified or supports 3.0 (used in Image to Text).
Nodes used (8)
- Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Webhook
n8n-nodes-base.webhook - Extract from File
n8n-nodes-base.extractFromFile - Tesseract Node
n8n-nodes-tesseractjs.tesseractNode
From the author
Smart Document Parser for Invoices, Logs or Sensor Reports (PDF/Image to Google Sheets) This n8n workflow automatically parses documents such as invoices, sensor logs or structured PDFs/images (including scanned docs or CSVs), extracts key fields like totals,…