{"product_id":"telegram-receipt-ocr-to-google-sheets-via-n8n-openai","title":"Telegram Receipt OCR to Google Sheets via n8n + OpenAI","description":"\u003ch3\u003eTurn Telegram receipt photos into structured expense rows in Google Sheets (with n8n + OpenAI OCR)\u003c\/h3\u003e\n\u003cp\u003eSend a receipt image to your Telegram bot, and this n8n workflow automatically extracts the vendor, date, total amount, and tax using OpenAI (gpt-4.1-mini), then appends the results to your Google Sheets expense tracker—fully automated.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTriggers on Telegram receipts:\u003c\/b\u003e When a receipt image\/document is sent to your Telegram bot, n8n downloads the file via the \u003ci\u003eTelegram Trigger\u003c\/i\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCreates a public image URL:\u003c\/b\u003e The workflow uploads the image using \u003ci\u003eUploadToURL\u003c\/i\u003e to generate a permanent public link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts receipt fields with OpenAI:\u003c\/b\u003e It sends the public image URL to \u003ci\u003eOpenAI (gpt-4.1-mini)\u003c\/i\u003e and instructs the model to return strict JSON containing \u003cb\u003evendor, date, total amount, and tax\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWrites to Google Sheets:\u003c\/b\u003e The workflow parses the JSON response and appends a new row to the specified spreadsheet tab with: \u003cb\u003eVendor\u003c\/b\u003e, \u003cb\u003eDate\u003c\/b\u003e, \u003cb\u003eTax\u003c\/b\u003e, and \u003cb\u003eTotal Amount\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003ePersonal or team expense tracking:\u003c\/b\u003e Capture receipts from a mobile device in Telegram and keep a clean Google Sheets ledger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSaaS operator workflows:\u003c\/b\u003e Route receipt images from staff to a centralized sheet without manual data entry.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAutomation engineers:\u003c\/b\u003e Use this as a practical template for Telegram → OCR → Google Sheets pipelines.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n Telegram Trigger\u003c\/b\u003e for receipt image\/document intake\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUploadToURL\u003c\/b\u003e to generate a public image URL for processing\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e via \u003ci\u003en8nn8n-nodes-langchainopen ai\u003c\/i\u003e using \u003cb\u003egpt-4.1-mini\u003c\/b\u003e to extract fields as strict JSON\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e with OAuth2 to append rows to the target expense tracker tab\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSetup requirement:\u003c\/b\u003e Ensure your Google Sheet contains columns for \u003cb\u003eVendor\u003c\/b\u003e, \u003cb\u003eDate\u003c\/b\u003e, \u003cb\u003eTax\u003c\/b\u003e, and \u003cb\u003eTotal Amount\u003c\/b\u003e, and configure Telegram, UploadToURL, and OpenAI credentials in n8n.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223958769843,"sku":"N8N-20887","price":40.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/IWabywopPU08bB1vMSIrC_hT7ml2Id.png?v=1791969877","url":"https:\/\/buyflowscripts.com\/products\/telegram-receipt-ocr-to-google-sheets-via-n8n-openai","provider":"N8N Commerce","version":"1.0","type":"link"}