The Weekly Number, Assembled and Sent

The numbers that decide things — cost per booked job, close rate by source — are never computed at all.

The raw numbers live in five places. Someone spends a morning a week copying them into a deck nobody has read by Thursday, and anything that needs two of those places joined never gets made.

Every node with its icon, as on the n8n canvasstarts a runa model or a parser, wired into the node above itHover a node for its name and type

• 01Pull Sources

  14 nodes · 17 connections · 5 notes

  Google Ads, Meta, the CRM, Stripe and CallRail, each on its own

• 02Reconcile & Upsert

  7 nodes · 7 connections · 5 notes

  one row per week: update or append, never both

• 03Compute Derived Metrics

  9 nodes · 8 connections · 5 notes

  the ratios and deltas, em-dash-guarded

• 04Narrative & Delivery

  7 nodes · 6 connections · 4 notes

  the arithmetic shown to a model with no tools

• 05Anomaly Watcher

  13 nodes · 14 connections · 4 notes

  every four hours, on its own schedule

The gates, 2 If nodes, decide whether anything happens next: a countable part of the system, not a claim about it. The 23 sticky notes carry the reasoning on the canvas, at the point it applies.

HoverTap a card to read what it prevents.

• The model is not allowed to do arithmetic

  The model is not allowed to do arithmetic

  Every ratio is computed upstream and shown with its working, and the agent that writes the narrative has zero tools connected. It can phrase a number; it cannot produce one.

• The em-dash contract

  The em-dash contract

  A zero denominator gives an em-dash — never Infinity, NaN or a fabricated $0.00 — and a change measured against last week’s em-dash stays an em-dash.

• One source of truth for leads

  One source of truth for leads

  The ad platforms contribute spend and clicks only. Leads and bookings come from the CRM, so two disagreeing counts never share a row.

• Nothing is silently dropped

  Nothing is silently dropped

  An unknown lead source is counted as “other”, and a charge with no matching deal is kept as unattributed revenue — an ugly line beats a hidden mismatch.

• A week is counted by the calendar

  A week is counted by the calendar

  The previous week is found by subtracting seven real days. Some years have 53 ISO weeks, and string arithmetic breaks once a year.

• Three alarms, not one

  Three alarms, not one

  A spend spike, spend with no clicks and dead call volume are three different failures — and a quiet night outside business hours is not one of them.

• Built, not yet deployed. The importability checks pass and every Code node’s logic was run against mocked data; it has not run against live Google Ads, Meta, HubSpot, Stripe and CallRail accounts.
• The CRM side is HubSpot-shaped. Another CRM means swapping one request and its field names; everything after it is CRM-agnostic.
• Only one page is read from Stripe and HubSpot — fine below about a hundred charges or deals a week.
• Amounts are assumed to be in US dollars.