Quick overview
Quick overview This workflow monitors a Google Sheets Invoices tab for new rows, compares each line’s invoiced unit price against the agreed contract price in a Contract Prices tab, logs the result to an Overcharge Report tab, and sends Telegram alerts only for overcharges or unknown item codes. How it works Triggers every minute when a new row is added to the Invoices sheet in Google Sheets. Reads the current Contract Prices sheet from the same Google Sheets document. Matches each new invoice line to a contract line by Item Code and calculates price difference, overcharge amount, and a status (OK, OVERCHARGED, Undercharged - Check, or Item Not Found - Verify Code). Appends the evaluated invoice line and status to the Overcharge Report sheet in Google Sheets to keep an audit trail. Checks whether the status is OVERCHARGED or Item Not Found - Verify Code. Sends a formatted Telegram message to your chat for flagged lines, and ends silently for everything else. Setup Connect Google Sheets OAuth2 credentials for both the Google Sheets Trigger and Google Sheets nodes, and ensure the workflow points to your spreadsheet and the Invoices, Contract Prices, and Overcharge Report tabs. Add a Telegram bot credential and set the Telegram chat ID where alerts should be delivered. Ensure your sheet headers match the fields used for matching and calculations (for example Item Code, Invoiced Unit Price ($), Quantity, and Agreed Price ($)). An n8n automation workflow template by Abdullah Latif.
Abdullah Latif
web
free
Others in the same category, ranked by how often they are opened.
