{"product_id":"telegram-receipt-logging-to-google-sheets-vat-ready-with-n8n","title":"Telegram Receipt Logging to Google Sheets (VAT-ready) with n8n","description":"\u003ch3\u003eLog German receipt photos from Telegram into VAT-ready Google Sheets—automatically with n8n\u003c\/h3\u003e\n\u003cp\u003eTurn messy receipt images into structured, German tax-ready expense rows. With this \u003cstrong\u003eTelegram Receipt Logging to Google Sheets (VAT-ready) with n8n\u003c\/strong\u003e workflow, you send a receipt photo in Telegram, and it extracts the data using \u003cstrong\u003eOpenAI Vision\u003c\/strong\u003e, stores the image in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and appends a correctly handled \u003cstrong\u003eAusgaben\u003c\/strong\u003e entry to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including VAT\/deductibility logic and duplicate detection.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram trigger + access control:\u003c\/strong\u003e It triggers on incoming Telegram messages or button callbacks and only processes chat IDs configured in the workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceipt data extraction (OpenAI Vision):\u003c\/strong\u003e When you send a receipt photo, it downloads the image and uses \u003cstrong\u003eGPT-4o-mini vision\u003c\/strong\u003e to extract key fields like merchant, date, gross\/net, VAT, currency, and payment method.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQuality checks:\u003c\/strong\u003e If required fields are missing or the receipt is unreadable, it replies in Telegram requesting a clearer photo.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive storage:\u003c\/strong\u003e For readable receipts, it creates a descriptive filename, uploads the image to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and continues processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCost center classification + German tax notes:\u003c\/strong\u003e It calls OpenAI again to classify the expense into a cost center and generate German tax-related notes, including deductibility and VAT recoverability flags.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVAT-ready calculations:\u003c\/strong\u003e It calculates deductible amounts and VAT fields in-code using German rules (including net vs. gross deduction base and VAT blocking cases), generates a tracking ID, and checks for likely duplicates in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDuplicate handling:\u003c\/strong\u003e If a duplicate is suspected, it posts a Telegram warning with \u003cem\u003e“Add anyway”\u003c\/em\u003e or \u003cem\u003e“Ignore”\u003c\/em\u003e. Otherwise, it appends the row to the \u003cstrong\u003eAusgaben\u003c\/strong\u003e tab and sends a confirmation with buttons.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eVAT-ready expense logging for freelancers and SaaS operators directly from Telegram.\u003c\/li\u003e\n  \u003cli\u003eAutomated receipt triage when multiple people submit receipts to a shared bot.\u003c\/li\u003e\n  \u003cli\u003eReducing duplicate entries with Telegram-based approval for “Add anyway”.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ tools:\u003c\/strong\u003e set, code, switch, Telegram, sticky note, Google Drive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e OpenAI Vision using \u003cstrong\u003eGPT-4o-mini vision\u003c\/strong\u003e for structured receipt extraction and classification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutput:\u003c\/strong\u003e Updates \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (logs to the \u003cstrong\u003eAusgaben\u003c\/strong\u003e tab) with VAT\/deductibility handling and duplicate detection.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114615918771,"sku":"N8N-20026","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/aRJwN7jrlwPZnX6MCwSZJ_VePtmwZO.png?v=1790586367","url":"https:\/\/buyflowscripts.com\/products\/telegram-receipt-logging-to-google-sheets-vat-ready-with-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}