The flow
Starts it 1Model 2Logic 8Service 8
The steps in the order they run, from what starts it.
- 1Rack Power Threshold AlertWebhookStarts it
- 2Overage Drafting ModelLm Chat Open AiModel
- 3Normalize Alert PayloadSetLogic
- 4Draft Overage Invoice AdjustmentAgentModel
- 5Fetch Customer Contract Power AllocationGoogle SheetsService
- 6Request Ops Manager ApprovalGmailService
- 7Compute Overage Amount & Billing TierCodeLogic
- 8Branch on ApprovalSwitchLogic
- 9Check Overage ThresholdIfLogic
- 10Commit Overage ChargeHttp RequestService
- 11Apply Manager Override AmountCodeLogic
- 12Log Waiver GrantedData TableService
- 13Log Grace Period PassSetLogic
- 14Merge Billing OutcomesMergeLogic
- 15Notify Customer No ChargeGmailService
- 16Shape Billing RecordSetLogic
- 17Log Billing DecisionData TableService
- 18Update Sheets Billing LedgerGoogle SheetsService
- 19Notify FinanceTelegramService
How it's built
- Starts on
- Another system calling it
- Steps
- 19, with 2 branches
- Size
- Medium: a working afternoon
- Connects to
- Gmail, Google Sheets, Telegram, n8n data table
- Model
- OpenAI
Questions
What does it need to run?
An n8n account, plus your own Gmail, Google Sheets and Telegram accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.
What starts it?
It starts on another system calling it.
Does it use AI?
Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.
How long does it take to set up?
Plan an afternoon. 19 steps is enough that you should read each one before running it.
How do I import it?
Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.
Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 19 steps before you point it at anything that matters.