{"product_id":"n8n-google-sheets-invoice-price-compliance-telegram-alerts","title":"n8n Google Sheets Invoice Price Compliance + Telegram Alerts","description":"\u003ch3\u003eInstantly detect invoice price overcharges in Google Sheets and alert your team via Telegram\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e automatically monitors a Google Sheets \u003cstrong\u003eInvoices\u003c\/strong\u003e tab, compares each new invoice line’s \u003cstrong\u003eInvoiced Unit Price ($)\u003c\/strong\u003e against the \u003cstrong\u003eagreed Contract Prices\u003c\/strong\u003e, logs results for audit purposes, and sends \u003cstrong\u003eTelegram alerts only for overcharges or unknown item codes\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers every minute\u003c\/strong\u003e when a new row is added to the \u003cem\u003eInvoices\u003c\/em\u003e sheet (Google Sheets Trigger).\u003c\/li\u003e\n  \u003cli\u003eReads the \u003cem\u003eContract Prices\u003c\/em\u003e tab from the same Google Sheets document.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches invoice lines to contract lines by Item Code\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalculates \u003cstrong\u003eprice difference\u003c\/strong\u003e, \u003cstrong\u003eovercharge amount\u003c\/strong\u003e, and a status:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003eOK\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eOVERCHARGED\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eUndercharged - Check\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eItem Not Found - Verify Code\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eAppends the evaluated line and status to an \u003cstrong\u003eOvercharge Report\u003c\/strong\u003e tab to maintain an audit trail.\u003c\/li\u003e\n  \u003cli\u003eSends a \u003cstrong\u003eformatted Telegram message\u003c\/strong\u003e \u003cstrong\u003eonly\u003c\/strong\u003e when the status is \u003cstrong\u003eOVERCHARGED\u003c\/strong\u003e or \u003cstrong\u003eItem Not Found - Verify Code\u003c\/strong\u003e; otherwise it ends silently.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators reconciling vendor invoices against contract pricing in near real-time.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers implementing \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e-based compliance checks with \u003cstrong\u003en8n\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e notifications.\u003c\/li\u003e\n  \u003cli\u003eProcurement teams flagging suspect invoices and missing Item Codes for quick verification.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e Trigger (new rows in \u003cem\u003eInvoices\u003c\/em\u003e) and Google Sheets node (reads \u003cem\u003eContract Prices\u003c\/em\u003e, writes to \u003cem\u003eOvercharge Report\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003eLogic nodes including \u003cstrong\u003eif\u003c\/strong\u003e and \u003cstrong\u003ecode\u003c\/strong\u003e for matching by \u003cem\u003eItem Code\u003c\/em\u003e and computing overcharges.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e node for alerts to a configured chat ID.\u003c\/li\u003e\n  \u003cli\u003eIncludes supporting workflow elements such as \u003cstrong\u003eno op\u003c\/strong\u003e and \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow clarity.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e Ensure your sheet headers match the fields used for matching and calculations (e.g., \u003cstrong\u003eItem Code\u003c\/strong\u003e, \u003cstrong\u003eInvoiced Unit Price ($)\u003c\/strong\u003e, \u003cstrong\u003eQuantity\u003c\/strong\u003e, and \u003cstrong\u003eAgreed Price ($)\u003c\/strong\u003e).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001883119795,"sku":"N8N-19445","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/P3CXs8ZodN3qhBqqrKlLz_WuQHJzBB.png?v=1789118295","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-invoice-price-compliance-telegram-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}