AutomationMart
Home/Browse/Log Telegram receipt images to Excel 365 using Tesseract OCR and GPT-4.1-mini
n8n

Log Telegram receipt images to Excel 365 using Tesseract OCR and GPT-4.1-mini

n8nn8n18 modulesv1.0
OpenAITelegramGemini

Log receipt transactions from Telegram images to Excel using OCR and AI OCR + AI + Duplicate Protection (n8n Workflow) Overview This workflow automatically converts receipt images or payment proof sent via Telegram into structured financial records stored in Excel 365. Core flow: The system is designed to reduce manual data entry errors and improve financial visibility by turning unstructured receipt images into reliable financial records. ⸻ How it works This workflow captures receipt images sen

At a glance

Log Telegram receipt images to Excel 365 using Tesseract OCR and GPT-4.1-mini is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI, Telegram, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
OpenAI, Telegram, Gemini
Modules
18
Price
Free
Version
v1.0
Log Telegram receipt images to Excel 365 using Tesseract OCR and GPT-4.1-mini workflow diagram

About this workflow

Log receipt transactions from Telegram images to Excel using OCR and AI OCR + AI + Duplicate Protection (n8n Workflow) Overview This workflow automatically converts receipt images or payment proof sent via Telegram into structured financial records stored in Excel 365. Core flow: The system is designed to reduce manual data entry errors and improve financial visibility by turning unstructured receipt images into reliable financial records. ⸻ How it works This workflow captures receipt images sent to a Telegram bot and converts them into structured financial records in Excel. When a user sends an image, the workflow downloads the file and extracts the text using OCR. The extracted text is then analyzed by an AI model (OpenAI or Gemini) to identify key transaction details such as date, amount, merchant, and transaction type. The workflow validates the extracted data and generates a unique duplicate key. It then checks Excel to ensure the transaction has not already been recorded. If no duplicate is found, the transaction is appended to the Excel sheet. The user receives a confirmation message in Telegram indicating whether the transaction was successfully recorded or rejected due to missing data or duplication. Workflow Nodes The workflow contains the following nodes: 1. Telegram Trigger 1. Edit Fields (extract chatid and imageid) 1. Condition (validate image exists) 1. Telegram Get File 1. Tesseract OCR 1. AI Agent (ChatGPT / Gemini) 1. Edit Field (JSON Output Parsing) 1. Excel 365 – Get Configuration 1. Edit Field – Normalize & Generate duplicatekey 1. Condition – Validate required fields 1. Excel 365 – Lookup duplicatekey 1. Condition – Duplicate Check 1. Excel 365 – Append Transaction 1. Telegram – Send Confirmation Message 🧠 What This Workflow Does This workflow automatically: - Captures receipt images from Telegram - Extracts text using OCR - Converts OCR text into structured transaction data using AI - Validates required financial fields - Prevents duplicate transaction entries - Saves valid records into Excel - Sends confirmation messages to Telegram Setup steps 1. Create a Telegram bot using @BotFather and copy the Bot Token. 2. Add Telegram credentials in n8n using the Bot Token. 3. Prepare an Excel file in OneDrive or SharePoint with a TRANSACTIONS sheet. 4. Configure Microsoft Excel credentials in n8n. 5. Add either OpenAI or Google Gemini credentials for the AI parsing step. 6. If running self-hosted n8n, ensure Tesseract OCR is installed. 7. Activate the workflow and send a receipt image to the Telegram bot to test. 8. 🎯 Key Benefits • Reduce financial recording errors • Eliminate repetitive manual data entry • Improve cashflow visibility • Simple photo-based financial recording • Scalable foundation for AI-powered financial automation 🚀 Use Cases This workflow is useful for: • Small business owners • Online sellers • Freelancers • Finance administrators • Personal expense tracking 📌 Notes • Duplicate detection is based on a composite transaction key • OCR accuracy depends on image quality • AI parsing improves recognition compared to OCR-only approaches 🧱 Requirements To run this workflow you need: • n8n (Cloud or Self-Hosted) • Telegram Bot Token • Microsoft Excel 365 Account • OpenAI API Key or Google Gemini API Key • Tesseract OCR (for self-hosted installations) 🏁 Result After setup, users can simply send receipt photos to Telegram and the workflow will automatically convert them into structured financial records stored in Excel. No manual bookkeeping required. Built for automation lovers, small businesses, and teams who want simple but powerful financial tracking using n8n.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Send AI job application auto-replies with Gmail, OpenAI GPT-4o and SMTP

This workflow automatically replies to job applications received via email using AI. It monitors a Gmail inbox for incoming job application emails, filters relevant messages, and uses an AI agent to generate professional and personalized responses. The workflow then sends the reply back to the applicant using SMTP. Key Features: - Detects job application emails automatically - Uses AI to generate professional HR responses - Structured output parsing for reliable responses - Sends replies usin

Free

Auto-categorize blog posts with OpenAI GPT-4, GitHub, and Google Sheets for Astro/Next.js

Automatically Assign Categories and Tags to Blog Posts with AI This workflow streamlines your content organization process by automatically analyzing new blog posts in your GitHub repository and assigning appropriate categories and tags using OpenAI. It compares new posts against existing entries in a Google Sheet, updates the metadata for each new article, and records the suggested tags and categories for review — all in one automated pipeline. --

Free

Update Airtable records based on ChatGPT assistant responses

Automatically update Airtable records with insights from ChatGPT responses. Trigger updates in Airtable based on AI-generated data for streamlined record management.

Free

Transform RSS feeds into content with GPT-4o for Medium, LinkedIn & Instagram

Related News to Content Marketing Automation Overview This workflow automatically collects news from an RSS feed, identifies the most relevant article(s), and generates ready-to-use social media and blog content tailored for Medium, LinkedIn, and Instagram. It’s ideal for: • Marketing teams who want a steady flow of fresh content. • Social media managers looking to save time on research and writing. • Startups and creators who want consistent posting with minimal effort. Instead o

Free

Manage invoices and contacts via chat with the Fakturoid AI agent

Overview Fakturoid AI Agent is an AI-powered invoicing assistant for Czech freelancers and small businesses. It connects to Fakturoid — the most popular Czech invoicing platform — and lets you manage invoices and contacts through natural conversation. No switching tabs, no filling forms. Just chat in Czech and the agent handles the rest. The agent understands context across the conversation. Tell it to create an invoice for a client you just looked up and it won't ask for their ID again — it alr

Free

Create a new Airtable record for every new email received in Gmail using ChatGPT

This template creates a new Airtable record for every email received in Gmail. Use ChatGPT to generate insightful content for each record.

Free

AI-powered multi-channel lead outreach with JotForm, Gemini AI & HeyReach

AI-Powered Outreach Engine (Jotform + Gemini AI + HeyReach + Data Tables) 🚀 Overview This workflow turns every Jotform submission — whether from your website or a live marketing campaign — into a fully automated, AI-personalized outreach sequence. Using Google Gemini AI, it instantly generates LinkedIn messages and email content tailored to each lead’s company and context. Depending on the data provided (like LinkedIn profile or email), it automatically routes the mess

Free

Monitor TP-Link Omada network disconnections with Gmail & Pushover

Monitor device disconnections from Omada emails to Google Sheets with Pushover alerts Who’s it for This workflow is designed for IT admins, network engineers, or small business owners who need to automatically monitor device connectivity from Omada Controller email alerts. If you want a lightweight, low-cost solution for tracking device uptime without complex monitoring software, this template is for you. How it works The workflow listens for Omada Controller email alerts using Gmail, parses eac

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free