Process Receipts: Google Vision OCR, AI, Telegram to Sheets

This workflow streamlines financial tracking by allowing users to send receipt photos directly to a Telegram bot. Google Vision API performs OCR to extract text from the image, which is then analyzed by an LLM via OpenRouter to identify key details like date, vendor, invoice number, items (name, qty, price, total), and category. Structured data is appended to a Google Sheets template row-by-row for easy accounting.

Benefits include massive time savings on manual data entry, reduced errors from OCR+AI parsing, and real-time mobile capture via Telegram. It's ideal for freelancers, small businesses, or anyone managing expenses, enabling quick categorization and querying of past transactions via text commands to the bot, powered by a Sheets-based AI agent.

Setup is straightforward: add your Telegram bot token, Google Vision API key, OpenRouter key, and connect Google Sheets. Use the provided template for instant compatibility. Handles multiple items per receipt and sends formatted summaries back to users for verification.