Extract purchase order data to Excel via Telegram using OCR and Google Gemini
UnknownWhat this workflow does
This AI workflow has 23 nodes and runs on Telegram events (message). Along the way it connects Telegram, Microsoft Excel 365, Google Gemini and Tesseractjs (community).
How it runs
Trigger: On Telegram events (message).
- Detect File Type (Code): runs custom JavaScript code
- Route by File Type (Switch): routes items into 3 branches
- Mapping PDF (Edit Fields (Set)): sets 2 fields: chat_id, file_id
- Notifikasi file sedang diproses (Telegram): uses Telegram
- Mapping Image (Edit Fields (Set)): sets 2 fields: chat_id, file_id
- Notifikasi file invalid (Telegram): uses Telegram
- Get PDF (Telegram): work with file
- Get Image (Telegram): work with file
- Extract PDF Text (Extract from File): extracts data from a file (pdf)
- Extract Text from Image (OCR) (Tesseract Node): uses Tesseract Node
…plus 12 more steps. See the full node list below.
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 Extract Text from Image (OCR)).
Nodes used (10)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Code
n8n-nodes-base.code - Telegram
n8n-nodes-base.telegram - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Extract from File
n8n-nodes-base.extractFromFile - Tesseract Node
n8n-nodes-tesseractjs.tesseractNode - If
n8n-nodes-base.if - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini
From the author
Quick Overview This workflow accepts purchase order PDFs or images via Telegram, extracts text using PDF parsing or Tesseract OCR, uses Google Gemini to convert the text into structured JSON, validates key fields, and appends the results to a Microsoft Excel…