Extract Indonesian stock (IDX) trades from Telegram invoices with Gemini AI

Automatically extract stock transactions from Indonesian broker trade confirmation documents sent via Telegram using AI vision.

How it works:

Send a PDF or image of your broker trade confirmation to the bot. The workflow downloads the file, encodes it, and sends it to OpenRouter (Gemini) for AI extraction. All detected transactions are displayed in a single confirmation message with ✅ Save All / ❌ Cancel buttons. The extracted data is stored temporarily using workflow static data, ready to be forwarded to any destination on confirm.

Features:

Supports PDF and image (JPG, PNG, screenshot) Handles multi-transaction documents — all shown in one batch confirmation Indonesian market aware — quantity in lots (1 lot = 100 shares) Extracts: ticker, company name, type, quantity, price, fee, total, date, broker, confidence score Low-confidence extractions handled gracefully Modular — connect the confirm output to any node (HTTP Request, Google Sheets, Airtable, Notion, database, etc.) Required credentials:

Telegram account — your bot token from BotFather OpenRouter API — Header Auth credential (Authorization: Bearer sk-or-v1-...) Setup:

Import workflow Add credentials Expose n8n via HTTPS (Cloudflare Tunnel, ngrok, or public server) Activate workflow — webhook registers automatically Send a broker PDF to your bot Default model: google/gemini-2.5-flash-lite via OpenRouter (free tier available)