Extract data from YAPE receipts via Telegram OCR and stor
Detailed Technical Description This n8n workflow automates Yape payment receipt processing, integrating Telegram bot, AI-powered OCR, and Google Sheets autom...
🔌 Nodes & Integrations Used (7)
📖 Implementation & Setup Guide
Detailed Technical Description This **n8n** workflow automates [Yape](https://www.yape.com.pe/) payment receipt processing, integrating [Telegram bot](https://core.telegram.org/bots), AI-powered OCR, and [Google Sheets](https://support.google.com/docs/answer/6000292) automation. By leveraging **[ChatGPT](https://chatgpt.com/)** Vision Computing, it extracts and structures transaction details, eliminating the need for manual entry. Ideal for freelancers, businesses, and finance teams, this workflow ensures error-free, real-time financial tracking. The AI agent powered by **[DeepSeek](https://www.deepseek.com/)** refines and formats the extracted text, storing it in [Google Sheets](https://support.google.com/docs/answer/6000292) for easy accessibility and reporting. Users can track payments, monitor cash flow, and generate financial reports without any manual work. This seamless integration boosts efficiency, reduces errors, and automates financial record-keeping with 100% accuracy.
🛠️ Technologies Used: ✅**n8n** – Workflow orchestrator. ✅**Telegram** – Handles image reception and notifications. ✅**Google Drive** – Manages file creation and storage. ✅**Google Sheets** – Automatically logs extracted data into spreadsheets.
🤖Artificial Intelligence: ✅**ChatGPT** Vision Computing – Performs OCR on payment receipts. ✅**DeepSeek** AI – Organizes and converts extracted data into a structured format.
---
📌 pre-conditions: 📩 `A Telegram Bot` – Must be created to receive images. [Setup Guide](https://core.telegram.org/bots/features#creating-a-new-bot) 🔑 `Google Sheets API Key` – Required to store extracted data. [Setup Guide](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets/) ⚛️ `ChatGPT API Key` – Used for OCR and AI text extraction. [Get it here](https://help.openai.com/en/articles/4936850-where-do-i-find-my-openai-api-key) 🐋 `DeepSeek API Key` – Processes extracted text into structured data. [Get it here](https://platform.deepseek.com/api_keys) ---
#### 1️⃣ Image Reception & OCR Processing 📩 The user attaches a Yape payment receipt image to the Telegram bot conversation. 🤳🏻
#### 2️⃣ Analyze Image (OCR) 👁️🗨️ A ⚛️**ChatGPT** Vision Computing model processes the image and extracts all visible text, ensuring high-accuracy OCR for structured data extraction.
#### 3️⃣ Analyze and format text Intelligent Data Processing with AI 🤖 The extracted text is sent to a 🐋**DeepSeek-based** AI agent that: Identifies and structures key transaction details (amount, date, sender, transaction ID, etc.). Converts the data into a structured JSON format.
#### 4️⃣ Data Storage in Google Sheets 📊 **Google Drive** integration is established. If the Google Sheets file does not exist, it is automatically created.
Extracted data is automatically recorded in the corresponding spreadsheet, enabling effortless tracking and streamlined financial organization.
🚀 Benefits: ✅ Time-saving – Eliminates manual payment processing. ✅ Error-free data entry – Reduces human mistakes in record-keeping. ✅ 100% automation – No manual intervention required. ✅ Seamless integration – Easily connects with other workflows.
--- 💡**NOTE**: _The extracted transaction data will be stored in a Google Sheets file with the following columns:_
| Column Name | Description | |:---------------------:|-----------------------------------------------------------| | **id** | Unique identifier for each transaction. | | **beneficiaryName** | Name of the recipient of the payment. | | **amount** | Payment amount in the specified currency. | | **currency** | Currency used for the transaction (e.g., PEN, USD). | | **company** | The entity or service handling the transaction. | | **date** | Date of the transaction in a human-readable format. | | **hour** | Time of the transaction. | | **originalDate** | The exact date extracted from the receipt. | | **dateToISO** | Standardized ISO 8601 date format. | | **operation** | Type of financial operation (e.g., deposit, transfer). | | **operationNumber** | Unique operation number provided by the payment system. | | **beneficiaryNumber** | Account or phone number of the recipient. | | **commission** | Any commission or fee charged for the transaction. | | **account** | Account number or reference used for the payment. | | **channel** | Payment method used (e.g., app, POS, bank transfer). | | **agentCode** | Identifier of the agent or entity processing the payment. |
---
This workflow is perfect for **businesses**, **freelancers**, and **individuals** who need a fully automated solution to process [Yape](https://www.yape.com.pe/) payment receipts efficiently. By leveraging **AI-powered** OCR and structured data extraction, it eliminates manual effort, reduces errors, and ensures that all transactions are accurately logged in Google Sheets. Whether you're managing **personal finances**, **freelance payments**, or **business transactions**, this system provides a seamless, hands-free approach to financial tracking, allowing you to focus on what truly matters.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
_Extract_data_from_YAPE_receipts_via_Telegram_OCR_and_stor.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....