Kay Abraham

Local time in Prague:

002 Machines 03 / 07

Overdue Monitor

Overdue invoices reach the right account manager in a daily digest, before finance has to escalate.

Status
Running
Since
Running since July 2026
Built with
n8n · Redash · Slack
Proof
Co-owned with RevOps

01 The miss

Invoices sat twenty-plus days overdue and nobody acted until finance escalated.

Corrected Overdue Monitor K.A.

02 The machine

An n8n workflow on Redash and Slack. Every day it reads the overdue invoices, groups them by account manager and posts each one a digest. Notes and snoozes are read back from the channel. Finance ops gets a Monday summary. Co-owned with RevOps.

03 How it runs

  1. How Overdue Monitor runs, step by step:
  2. Redash to Group
  3. Group to Daily digest
  4. Group to Monday summary
  5. Daily digest to Listen (a guard)
  6. Listen to Group (fed back)
Made-up item

04 Under the hood

  1. On version 5.1.1.
  2. Notes and snoozes are read back from the Slack channel, so a snoozed invoice stays out of the digest.
  3. Retries the warehouse query and stays inside Slack's block and character limits.
  4. Reads the free-text notes people leave in the channel.
  5. Code in Apify's GitHub, co-owned with RevOps.
overdue_monitor.yaml Sketch
schedule: every dayread: overdue invoices          # Redashgroup_by: account_managerpost: one digest each           # Slacklisten:                         # read back from the channel  - notes  - snoozes                     # a snoozed invoice stays quietmonday: summary for finance opsversion: 5.1.1

The workflow as a node list, written for this page. The n8n export stays in a company repo.

05 What changed

  • Each account manager gets a daily digest of their overdue invoices.
  • Finance ops gets a Monday summary.

06 What I can show

The code lives in a company repo, so this page describes it.

Back to the machines