Templates / Extract purchase order data to Excel via Telegram using OCR and Google Gemini

Extract purchase order data to Excel via Telegram using OCR and Google Gemini

Unknown

by Ramdoni ✓ · 291 views · created 2026-06-08 · Document Extraction, AI Summarization

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What 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).

  1. Detect File Type (Code): runs custom JavaScript code
  2. Route by File Type (Switch): routes items into 3 branches
  3. Mapping PDF (Edit Fields (Set)): sets 2 fields: chat_id, file_id
  4. Notifikasi file sedang diproses (Telegram): uses Telegram
  5. Mapping Image (Edit Fields (Set)): sets 2 fields: chat_id, file_id
  6. Notifikasi file invalid (Telegram): uses Telegram
  7. Get PDF (Telegram): work with file
  8. Get Image (Telegram): work with file
  9. Extract PDF Text (Extract from File): extracts data from a file (pdf)
  10. Extract Text from Image (OCR) (Tesseract Node): uses Tesseract Node

…plus 12 more steps. See the full node list below.

Services it uses

TelegramMicrosoft Excel 365Google GeminiTesseractjs (community)

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)

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…

Excerpt from Ramdoni's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.