002 Machines 02 / 07
Override Watch
The account manager hears seven days before a custom price expires and talks to the customer before the bill does.
- Status
- Running
- Since
- Running since February 2026
- Built with
- n8n · Redash · Slack
- Proof
- Co-owned with RevOps
01 The miss
Custom prices expired quietly and the customer got a bill shock.
Corrected Override Watch K.A.
02 The machine
An n8n workflow on a schedule, every weekday morning. It finds every custom price ending in seven days and posts each one to the account manager in Slack. On Fridays it looks further ahead, so a weekend expiry still gets its warning. Co-owned with RevOps.
03 How it runs
- How Override Watch runs, step by step:
- Redash query to n8n
- n8n to Account manager
- n8n to Weekend bridge (a guard)
- Weekend bridge to Account manager (a guard)
04 Under the hood
- The oldest machine on this page: running since February 2026.
- Runs every weekday at 09:00. On Fridays the window stretches from seven days to nine, so a price ending over the weekend still gets its warning.
- The query does the finding; n8n runs it and posts each price to the right account manager.
- Co-owned with RevOps.
-- custom prices that end in seven days-- on Fridays, seven to nine: the weekend bridgeselect account, account_manager, custom_price_ends_onfrom custom_priceswhere custom_price_ends_on between current_date + 7 and current_date + case when is_friday(current_date) then 9 else 7 endorder by custom_price_ends_on;Written for this page. Table and column names are made up; the real query stays in the company.
05 What changed
- The account manager hears seven days ahead and talks to the customer first.
06 What I can show
The code lives in a company repo, so this page describes it.