⚛️🐋🤖 Extract data from YAPE receipts via Telegram OCR and store in Google Sheets

Detailed Technical Description

This n8n workflow automates Yape payment receipt processing, integrating Telegram bot, AI-powered OCR, and Google Sheets automation. By leveraging ChatGPT 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 refines and formats the extracted text, storing it in Google Sheets 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 🔑 Google Sheets API Key – Required to store extracted data. Setup Guide ⚛️ ChatGPT API Key – Used for OCR and AI text extraction. Get it here 🐋 DeepSeek API Key – Processes extracted text into structured data. Get it here

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:

This workflow is perfect for businesses, freelancers, and individuals who need a fully automated solution to process Yape 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.