Projects

What I've actually built, not a skills list.

Short on time? Start here

The builds follow the same rules: code does the math, AI quotes are checked against their source, and risky changes wait for a person’s approval. How I build.

Filter by system:

Pipeline & Forecasting

The Pipeline Forecast Engine

~5 min read

Every week, open Salesforce deals are forecast from historical stage-by-stage win odds instead of a gut-feel commit. Deals that have sat in a stage far longer than usual are discounted, and each one is named with the dollars it drags off the number. Claude writes the forecast note for Slack, and every run is logged so the trend becomes its own audit trail.

n8n Cloud · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

A forecast usually arrives as one of two numbers, and both are wrong in a predictable way. The naive number adds up everything in the pipeline, as if every open deal will close. The CRM number multiplies each deal by a stage probability that someone typed into Salesforce setup years ago and nobody has checked since. Neither tells a sales leader which deals are actually pulling the quarter down, so the forecast call turns into a debate about the total instead of a conversation about the five deals that need attention.

A revenue leader on LinkedIn described the last week of a quarter: the forecast revised three times, and “everyone in the room knows which four deals are being carried on hope.” His diagnosis is the one this build acts on: a stage percentage “knows nothing about how this deal is behaving right now.”

This isn’t a niche complaint. In a sales-performance software vendor’s 2024 survey of 405 sales and finance leaders, four in five said they had missed a quarterly forecast in the past year, and half of the sales leaders said their forecasts were off by 10% or more. A B2B consultancy’s guidance on stage probabilities names the cause this build goes after: probabilities nobody reviews let the forecast drift from reality over time.

The Build

This extends the win-rate method from an earlier build in this series, which computed one aggregate win rate from real closed deals. Here it's broken out by stage. For each of four forecast stages (Qualification, Discovery, Proposal, Negotiation), code computes three things from closed-deal history. First, the share of deals that reached the stage and went on to close won. Second, the median number of days deals spent in it. Third, the win rate of deals that sat there more than twice the median. That last rate is shrunk toward the stage's normal rate when the sample is small, so three stalled deals can't swing the number on their own.

Each week n8n pulls every open Salesforce opportunity and maps its stage onto those four. It keeps the deals closing this quarter, or next quarter when fewer than seven days remain. It then works out how long each deal has been in its current stage. A fresh deal is weighted by its stage's historical odds. A deal past its stage's stall line is weighted by the lower stalled odds, and the difference is that deal's drag on the forecast. Four numbers come out side by side: the naive total, Salesforce's own probability-weighted total, the historical stage-weighted total, and the stall-adjusted forecast with a one-standard-deviation range. The code also flags deals with passed close dates, missing amounts, or a stage the CRM silently ignores. Claude writes only the short note and a confidence read; every figure is computed before it sees the data. Slack gets the forecast and the flagged deals, and each run is logged to a Forecast Snapshots table so week-over-week change is on the record.

Weekly run: every open Salesforce opportunity + closed-deal stage history + last snapshot → Per stage, in code: win odds, median days, stall line, stalled-deal odds → Each deal weighted by its stage odds, or its stalled odds past the stall line
Naive vs. CRM vs. historical vs. stall-adjusted, plus drag per deal and data flags → Claude writes the note and a confidence read, never the numbers → Forecast + flagged deals to Slack, snapshot logged for the trend

Real vs. Simulated

The open pipeline, the deal amounts, stages and dates, the 87 closed deals and their win/loss outcomes, the forecast math, Claude's note and the Slack post are all real. One piece had to be seeded: stage history. This Trailhead Playground org has never moved a deal through its stages. Salesforce's own Opportunity History has 110 rows for 107 deals, and only 3 deals ever changed stage. Every closed deal was created directly as Closed Won or Closed Lost, so there's no record of which stages it passed through or how long it sat in each.

So a one-off setup workflow generated a plausible stage path for each closed deal with a fixed, documented rule, anchored to that deal's real close date and real outcome. Days per stage are log-normal with medians of 21, 28, 24 and 18 days. Lost deals drop out at Qualification, Discovery, Proposal or Negotiation 30, 30, 25 and 15% of the time. The random generator uses a fixed seed, so the 296 seeded rows can be reproduced exactly. Two consequences are worth stating plainly. The rule also has lost deals linger 1.8× longer in the stage where they die, so the finding that stalled deals close less often is an input of the seed. It shows how the mechanics work, not something this data discovered. And 18 of the 87 historical deals are Trailhead's own sample opportunities, all of them wins, which lifts every stage's odds. The forecast says so itself: its confidence is capped at low whenever the stage history is seeded.

The open pipeline was trimmed by rule, not by hand. Thirteen of the 20 open deals are Trailhead sample opportunities whose close dates passed in May 2024. Any open deal more than 180 days past its close date is treated as abandoned, excluded from the number, and counted in the Slack footer, which left seven real Fortavault deals in the Q4 forecast.

A Real Salesforce Bug: A Stage the Forecast Can't See

Two open deals, Castleton Freight ($62K) and Pemberton University ($33K), sit in a stage called “Proposal/Negotiation.” That stage isn't part of the org's configured sales process. Salesforce gives it a 0% probability and puts both deals in the Omitted forecast category, so the CRM's own weighted forecast drops $95K of mid-funnel pipeline without a warning. The engine maps that stage to Proposal like any other, weights it with the historical odds, and flags both deals by name in Slack so someone fixes the stage.

A Real Wording Bug: “Closed 9 Days Ago”

The workflow ran first with its Slack and logging steps switched off. The numbers were right, but Claude described Northwind Freight, an open $145K deal whose close date had passed, as having “closed 9 days ago.” Anyone skimming would read that as a done deal. Claude also quoted an internal field name and said the history wasn't real at all, when only the stage paths are seeded. The prompt now says that every deal it sees is open, that a passed close date means the date needs updating, and that it must never quote field names. The live run says “overdue close dates that need updating” and explains that the outcomes are real and the stage paths are seeded.

A Real Slack Bug: Strikethrough by Accident

The live post had one more problem, visible in the screenshot below. Claude wrote the two drag figures as approximations, “(~$15K) and Larkspur Health Partners (~$11K)”. Slack treats any text between two tildes as strikethrough, so the middle of the sentence went out crossed through and looked like a correction nobody made. The fix is in code rather than the prompt, because a prompt can't guarantee a model never uses a character. The post-builder now converts every tilde in Claude's text to “≈” before it reaches Slack. A verification run with posting switched off came back reading “≈$15K drag”. The Intent Signal Monitor's digest uses the same model-written-text-into-Slack pattern, so it got the same fix.

The Live Forecast

The Q4 2026 forecast from the live run, with per-stage numbers from the history table:

Naive pipeline $402K (7 open deals closing by Dec 31) Salesforce stage % $181K (CRM probabilities; 2 deals at 0%) Historical stage odds $347K Stall-adjusted forecast $321K range $267K–$376K, confidence: low Qualification 70% win (n=87) median 21d stall line 42d stalled 47% Discovery 79% win (n=77) median 31d stall line 62d stalled 50% Proposal 88% win (n=69) median 25d stall line 50d stalled 80% Negotiation 97% win (n=63) median 17d stall line 34d stalled 82% Drag: Northfield Regional Bank $62K, 47d in Qualification −$15K Larkspur Health Partners $48K, 47d in Qualification −$11K

Claude's unedited note, exactly as posted:

Our stall-adjusted Q4 2026 forecast is $321K (range $267K–$376K), well below the naive pipeline total of $402K and above Salesforce's probability-weighted figure of $181K. Stalled deals account for roughly $26K of drag, led by Northfield Regional Bank (~$15K) and Larkspur Health Partners (~$11K), both stuck in Qualification beyond 42 days. Two deals carry overdue close dates that need updating: Northwind Freight Co. (9 days past) and Pemberton University (15 days past). Salesforce silently excludes Castleton Freight Co. ($62K) and Pemberton University ($33K) because their "Proposal/Negotiation" stage carries 0% probability. Confidence: low. Win/loss outcomes are real, but the stage-by-stage history behind the per-stage odds is seeded rather than fully observed, limiting confidence in the modeled probabilities.

Live Run

The Pipeline Forecast Engine workflow graph in n8n
The live workflow graph in n8n: open deals, stage history and the last snapshot are loaded, the forecast is computed in code, Claude writes the note, then it's posted to Slack and logged.
The real Slack forecast post from a live run
The real Slack post from the live run: four forecast numbers side by side, Claude's note and confidence read, and every flagged deal with its drag or data problem. The crossed-out phrase in the note is the tilde bug described above, fixed after this run.

Impact (measured from live runs)

$402K → $321K
naive pipeline vs. the stall-adjusted forecast, with the $26K of stall drag traced to two named deals
$95K
of open pipeline Salesforce's own forecast silently drops because its stage carries 0% / Omitted, now flagged by name
13 of 20
open deals excluded by rule as abandoned (close dates 2+ years past), counted in every post rather than quietly ignored

Catching a Funnel Leak Before It Craters the Quarter

~3 min read

A rolling two-proportion z-test flags a real win-rate drop in Salesforce, and Claude traces it back to the actual pricing change buried in the loss notes instead of a vague "conversion is down."

n8n Cloud · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Most funnel dashboards can tell you conversion dropped; almost none can tell you why, and a bare percentage swing shown to a sales leader is not an action item. Worse, small day-to-day wobble in a pipeline gets mistaken for a real problem constantly — someone eyeballs a chart, sees a dip, and fires off an all-hands alarm over what turns out to be ordinary noise. Both failure modes come from the same root cause: nothing is actually testing whether a swing is statistically real before asking a human to explain it.

A B2B SaaS design founder on LinkedIn described a client call where the team could see exactly where users dropped off but not why, and put it in one line: “The dashboard shows the symptom.”

Practitioners describe both halves. A growth leader writing about the gap between reporting and diagnosis put it simply: showing what’s happening in a dashboard is informative, not insightful. An experimentation community newsletter recommends control limits for the second failure, so teams stop overreacting to normal fluctuation. This build does both in order: it tests whether the swing is real, and only then asks why.

The Build

This one is deliberately single-system — Salesforce only, no HubSpot or Clay layered in — because the whole point is that the statistics, not another data source, are what make the alert trustworthy. A weekly scan pulls every Closed Won and Closed Lost opportunity from a scoped set of accounts, and a Code node computes a rolling win rate: the last two weeks against a trailing six-week baseline. Whether the drop is real is answered by an actual two-proportion z-test, computed by hand in JavaScript (pooled proportion, standard error, a from-scratch erf approximation for the normal CDF) — not an LLM eyeballing a chart and not a third-party stats library. Deciding "is this significant or just noise" is exactly the kind of question that should be deterministic math, not a model's judgment call.

Only when the drop clears p < 0.05 does the workflow hand off to Claude, and only with the specific evidence that matters: the real loss notes from the Closed Lost deals inside the flagged window, not the whole book of business. Claude's job is narrow — find the actual pattern in those notes, name it explicitly if multiple deals cite the same cause, and separate it from losses that are just normal deal risk — then draft a plain-English hypothesis and a concrete next action. That goes to Slack, and every flagged run's stats and hypothesis are logged to a Data Table for a trend line over time; a run with no significant drop ends quietly.

Weekly Salesforce scan → Code node: rolling win rate + z-test → Significant drop? → Claude reads the actual loss notes → Hypothesis + action posted to Slack → Logged to Data Table

The Statistical Test

The significance check itself, unedited from the live workflow — this is what decides whether Claude ever gets involved:

const pooled = (wonCurrent + wonBase) / (totalCurrent + totalBase); const se = Math.sqrt(pooled * (1 - pooled) * (1 / totalCurrent + 1 / totalBase)); const z = se > 0 ? (pCurrent - pBase) / se : 0; const pValue = 2 * (1 - normalCdf(Math.abs(z))); const significant = pValue < 0.05 && pCurrent < pBase;

Root-Cause Drafter System Prompt

Same Fortavault context as the other builds, with a narrow job: find the real pattern in the loss notes, don't invent one.

You are a GTM analytics assistant for Fortavault, Inc., a fictional data protection and security platform (cloud backup, ransomware recovery, zero-trust access, compliance reporting). Products: Fortavault Backup Cloud, Fortavault Shield, Fortavault Access, Fortavault Insights. Key competitors: Veyron Data, Ashcombe Systems, Cyphertide, Northgate Cloud Security, Ridgeline Compliance. A statistical check has flagged a real drop in Salesforce win rate for opportunities closing in the last 2 weeks compared to the trailing 6-week baseline. You are given the aggregate stats and the actual loss-reason notes from the Closed Lost opportunities in the flagged window. Read the notes for a real pattern - do not guess generically. If multiple notes cite the same specific cause, name it explicitly and quantify how many of the losses it explains. Write a plain-English root-cause hypothesis (3-4 sentences) a RevOps leader could act on, plus a specific, concrete recommended next action. Respond with a JSON object with exactly two fields: hypothesis (string) and recommendedAction (string).

A Real Flagged Run

This is the actual output from a live run, unedited: win rate held around 69% for six weeks, then cratered to 25% (9 of 12 deals lost) in the most recent two-week window — a drop the z-test scored at z = −2.70, p = 0.0068. Claude was handed only the nine loss notes from that window, with no hint about what to look for:

The August 1 Fortavault Shield list price increase is the dominant driver of the win rate collapse, directly explaining 7 of the 9 losses (78%) in the current window. Across deals spanning Backup Cloud, Access, and Insights — not just Shield standalone — the Shield price hike pushed total contract values over pre-approved budget ceilings, causing procurement rejections, champion escalation failures, and at least one explicit deferral to next fiscal year. One note quantified the shock as a 22% jump over the quote prospects had already budgeted against, suggesting the increase was not telegraphed to buyers early enough in the sales cycle for them to seek internal re-approval. The remaining two losses (Pinegate University re-org, Oakmere Legal/Cyphertide relationship) appear unrelated to pricing and represent normal deal risk.

Live Run

The Funnel Leak Detective workflow graph in n8n
The live workflow graph in n8n — weekly Salesforce scan, the hand-rolled z-test in a Code node, the significance gate, and Claude's grounded root-cause hypothesis before the Slack post and Data Table log.
The real Funnel Leak Detective finding posted to Slack
The real Slack post from the run above — the win-rate swing, the z-score and p-value, and Claude's hypothesis and recommended action.

Impact (measured from live runs)

69% → 25%
baseline vs. flagged-window win rate
p = 0.0068
statistical significance of the drop, not a guess
7 of 9
window losses correctly traced to one shared root cause

The Pipeline Debt Ledger

~3 min read

A weekly audit reads the deal-note text on every real open Salesforce opportunity, has Claude extract the specific commitments a rep actually made, checks each one against an approved roadmap/policy reference, and posts a plain-English risk digest before finance or the deal owner find out at close.

n8n Cloud · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Deal notes are where the real risk in a pipeline actually lives — a verbal discount past the approved threshold, a feature promised before it's on the roadmap, an SLA a rep agreed to on a call to keep a deal moving. None of that shows up as a field on the Opportunity record; it's buried in free text, and by the time anyone reads it closely the deal has already closed and the company is on the hook. A pipeline review that only checks stage and amount is blind to the actual commitments sitting inside the notes.

A product marketing founder on LinkedIn described how this compounds as a sales team grows: “10 reps, each promising a slightly different moon to hit their number. Every new deal adds to the debt.”

Sales leaders interviewed by a SaaS industry publication described the pattern directly: reps making side deals, promises in email outside the formal contract, and working around pricing controls to give extra discount. No field captures any of it, which is why this build reads the notes where it actually lives.

The Build

A weekly scan pulls every real open Opportunity from this Salesforce org (roughly 90 total records built up across this series) and keeps only the ones that are both still open and carry actual text in their Description field — 11 real records passed that filter. Each one goes to a Claude agent alongside a fixed policy reference (discount-approval tiers, which features are actually on the roadmap and at what stage, support-tier and SLA rules) set once in a Config node so the policy itself can change without touching any prompt or downstream logic. The agent's only job is to pull out genuine customer-facing commitments from the note text and classify each one as confirmed (matches policy) or risky (exceeds it, is unconfirmed, or needed a sign-off that never happened), using a structured-output parser so the result is always clean JSON rather than prose to re-parse.

Of the 11 opportunities with real deal notes, 7 produced zero commitments — their notes turned out to be unrelated real leftover context from earlier days in this series, not customer promises, and the agent correctly recognized that and returned an empty list rather than inventing something to flag. The other 4 produced 8 genuine commitments, 5 of them classified risky. Every risky one gets logged to a Data Table with its full rationale, and a single digest posts to a shared Slack channel with all 5 flags in one message — nothing about a clean deal ever reaches Slack.

Weekly scan: real open Salesforce opportunities with non-empty deal notes (11 of ~90 opportunities in the org) → Claude extracts genuine customer commitments per opportunity, checked against a fixed policy/roadmap reference → Classify each commitment confirmed or risky (structured output)
Flatten to risky commitments only (5 of 8 total extracted) → Log every risky commitment to a Data Table → Post one digest to a shared Slack channel

Real vs. Simulated

The Salesforce org, the 11 opportunities the filter actually found, Claude's extraction and risk classification, the Data Table rows, and the Slack post are all real. The one manufactured piece is the deal-note text on 4 opportunities: this org had no existing notes written as sales promises, so 4 real Opportunity records had their real Description field updated through Salesforce's own update API with realistic promise language — a 25% verbal discount, an unbudgeted dedicated CSM, a white-labeled app with no roadmap backing, an unauthorized 4-hour SLA. From that point on the workflow has no way to tell those 4 apart from any other real record; it reads all 11 the same way.

A Real Guardrail, Tested Against Real Leftover Data

This was the most useful accident in the build. One of the 11 records the filter picked up wasn't a seeded promise at all — it was Castleton Freight Co. – Fleet Rollout, a real Opportunity from the MAP-CRM Discrepancies build earlier in this series, still carrying its old description field verbatim:

Seed data for Fixing MAP-CRM Discrepancies (Day 4). Control case: correctly aligned, should NOT be flagged.

Read literally, that's an instruction aimed straight at an AI reading it. The system prompt tells the agent to ignore anything in the note text that reads like internal metadata or meta-commentary about the record and to never treat it as a directive, no matter how it's phrased — and on the real, unscripted run, it held: Claude returned an empty promises array for that record, the same as the six other genuinely clean ones, rather than reasoning about whether to comply with text embedded in the data it was analyzing.

A Real Nuance the Binary Check Would Have Missed

United Oil Refinery Generators was meant as a clean example when the seed text was written — every fact in it is accurate: an 8% discount within standard authority, a dedicated CSM that's genuinely earned at that contract value, and a Data Cloud connector correctly described as beta with a real Q3 GA target. The agent still flagged one piece of it:

Data Cloud connector will be included in the customer's contract at no extra cost once generally available (Q3 GA target). — The Q3 GA target and beta status of the Data Cloud connector are confirmed by the approved roadmap. However, the commitment that it will be included at no extra cost is a pricing/licensing promise that has no backing in the approved policy reference. There is no stated policy that beta features graduating to GA are automatically folded into existing contracts without additional charge. This requires explicit sign-off from Product, Finance, or Legal before it can be treated as a binding commitment.

The timeline was real and on-roadmap; the pricing commitment bolted onto it wasn't. A simple pass/fail check against "is this feature coming" would have cleared the whole sentence. Separating what's confirmed from what's merely adjacent to something confirmed is the actual value this kind of audit adds over a keyword scan.

Live Run

The Pipeline Debt Ledger workflow graph in n8n
The live workflow graph in n8n — real Salesforce opportunity notes feeding a Claude agent with a structured-output parser, fanning out to a Data Table log and a Slack digest.
The real Slack digest from a live Pipeline Debt Ledger run, listing 5 risky commitments across 4 deals
The real Slack digest from the live run — 5 risky commitments across 4 deals, each line built from Claude's actual extraction and rationale rather than a template.

Impact (measured from live runs)

11 / ~90
real Salesforce opportunities were open with actual deal-note text, out of ~90 in the org after filtering out closed and blank records
5 / 8
extracted commitments classified risky across 4 deals — the other 3, on one same deal, were confirmed against policy
7 / 11
opportunities — including one with instruction-like leftover text — correctly returned zero flags

The Territory Rebalancer

~4 min read

A monthly scan sizes real Salesforce territory value, checks real HubSpot engagement and the result of a real Clay enrichment attempt, then has Claude draft a specific rep-reassignment proposal that only ever takes effect after a real Slack approval — it never touches Salesforce ownership on its own.

n8n Cloud · Salesforce (OAuth2) · Clay · HubSpot API · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Territory rebalancing usually runs on guesses: a manager eyeballs account counts, assumes TAM from a vague sense of company size, and moves accounts around without checking whether anyone is actually engaging with them. Guess wrong on TAM and you can hand a rep a territory that looks big on paper but is full of dead accounts. Ignore engagement entirely and you can move a warm account away from momentum it doesn't need disrupted, while leaving a real, valuable, completely neglected territory untouched. And in this org specifically, the starting problem is more basic than any of that: every single account, across every territory, is owned by one person.

A total-rewards leader on LinkedIn described the human side: on paper everything can look balanced, but “one rep inherits a territory loaded with potential while someone else gets the leftovers.”

The lever is real. An analyst firm’s 2024 brief for sales leaders warns that unbalanced territories create friction and lead to inconsistent results, and long-cited sales-consulting research puts the payoff of better alignment at a 2 to 7% revenue lift with exactly the same sales force. The weak point is the inputs, which is why this build grounds every proposal in real deal value, enrichment and engagement data before proposing a move.

The Build

On the first of the month, the workflow pulls every real Salesforce account whose Industry falls into one of six named verticals — Insurance, Legal, Financial Services, Healthcare, Manufacturing, Retail — along with each account's real Opportunities, and groups them into territories with a real summed opportunity amount (every stage, open and closed). It separately pulls every real HubSpot contact, once, with real tracked engagement properties, and matches them to each territory's accounts by company name. Then it fetches a seeded "Sales Reps Roster" Data Table: this Salesforce org has exactly one real User (Adam Giuriceo, who owns all 26 accounts), and the Salesforce node has no operation to create new Users, so three candidate reps and their stated capacities are seeded as the honest stand-in for reps who don't exist as real Salesforce Users yet.

For firmographic sizing, the workflow doesn't guess TAM from a round number — a real Clay enrichment was run on a sampled account per territory, operating the real Clay account directly through the browser (Clay has no webhook or API on the free plan, so the workflow can't call it); those six results are stored as fixed text in the workflow's Code node rather than re-fetched each month. All six lookups came back "Company Not Found," a real result reported honestly rather than smoothed into a made-up employee count, so opportunity amount from Salesforce becomes the sizing anchor instead. All of this — real account count, real opportunity amount, real engagement read, the stored Clay finding, and the candidate rep's capacity — gets handed to a Claude agent that drafts a specific per-territory move with a rationale and a revenue tradeoff. The proposal posts to Slack as an interactive approval message; nothing happens to Salesforce until a human clicks Approve, and even then the only effect is a logged row in a Territory Rebalance Proposals Data Table.

Monthly scan: real Salesforce accounts + opportunities by territory → Compute real account count + opportunity amount per territory → Fetch real HubSpot contacts + engagement → Fetch seeded Sales Reps Roster (capacity per territory)
Attach stored Clay enrichment finding (one-time real run) → Claude drafts rebalancing proposal (structured output) → Post to Slack for human approval (sendAndWait) → Approved or declined → logged to Data Table (Salesforce ownership never touched)

Real vs. Simulated

The account count, the opportunity amount, and the engagement read are entirely real: real Salesforce accounts and Opportunities, real HubSpot contacts pulled live, and a genuine Clay company-enrichment attempt, run once by hand through the actual Clay account and stored in the workflow — not a fabricated positive result papered over the honest "Company Not Found" every one of the six sampled domains returned. The one deliberately seeded piece is the three candidate reps (Marcus Webb, Priya Shah, Elena Cho) and their stated capacities, because this Salesforce org has exactly one real User and no way to create more through the API — seeded to make a real rebalancing decision possible, not simulated to fake engagement or revenue data. The proposal Claude drafts is real AI output grounded in that real data, but it is never allowed to act on its own: it never writes to Salesforce at all: an approval only logs a Data Table row, never a Salesforce Owner field, and declined proposals are logged too.

A Real n8n Bug: Slack's Silent Block-Text Limit

The first live run failed at the approval step with Slack error response: "invalid_blocks". The message was built by concatenating Claude's summary, a full verbose rationale-and-tradeoff sentence for all six proposed moves, and the entire raw real-data appendix into one block — comfortably past Slack's roughly 3,000-character limit on a single block's text. Shortening the moves list to real dollar figures and account counts instead of AI prose closed most of the gap, but the run after that still failed the same way, because the untouched AI-written summary alone was still long enough to push it over. The actual fix was pulling the compact per-territory line from the real enriched data object rather than from Claude's output text at all, and truncating the summary defensively. The first version of that truncation cut the summary off mid-word on a live Slack post before a person watching caught it, so the final version truncates on a sentence boundary instead — a small thing, but the kind of detail that's invisible until someone is actually looking at the real output.

A Real n8n Bug: A Territory Name That Didn't Match Itself

The first fully-approved run logged six rows to the Territory Rebalance Proposals table with every enrichment field blank — no owner, no rep, no account count, no dollar value. The cause: on that run, Claude's structured output named one move's territory "Healthcare → Marcus Webb" instead of the bare "Healthcare" the rest of the pipeline expected, so the code node's exact-match lookup against the real enriched territory data silently returned nothing for every field it needed. The fix was matching on case-insensitive substring containment instead of exact equality, so a territory name with extra text attached still resolves to the right real record. Re-running produced a fully populated, correct log; the six blank rows from the buggy run were then removed with a one-off cleanup workflow rather than left in place to look better than they were.

A Real Proposal, a Real Approval

Insurance is the highest-value territory in this run — 5 real accounts totaling $686,712 in real Salesforce opportunity amount, one cold HubSpot contact, and a genuine "Company Not Found" from Clay on Palisade Underwriting Group. Here's Claude's unedited rationale for moving it off the sole owner and onto its named candidate rep:

Insurance holds 5 accounts and $686,712 in total contract value — the largest single-territory dollar value in this review — all currently owned by Adam Giuriceo. HubSpot API shows 1 of 5 accounts has a contact on file, but tracked page views are zero and marketing engagement is none, meaning the contact record exists but is entirely cold. Clay's live enrichment of Palisade Underwriting Group (palisadeunderwritingdemo.io) returned 'Company Not Found,' confirming no external firmographic data is available. Priya Shah has stated capacity for 6 accounts. At $686,712, this is the highest-value territory in the review and the strongest case for dedicated ownership — a single rep covering all 26 accounts in the org cannot give this vertical the attention its contract value warrants. The zero-engagement HubSpot signal means there is no warm pipeline to disrupt. RECOMMENDATION: MOVE to Priya Shah.

The candidate reps come from the seeded roster by territory, not from Claude, and the roster double-books all three of them: Elena Cho takes Manufacturing (4 accounts) and Retail (3), a combined 7 against her stated 5-account capacity; Marcus Webb takes Healthcare (4) and Legal (6), 10 against his 6; and Priya Shah takes Insurance (5) and Financial Services (4), 9 against her 6. Nothing in the workflow checks capacity in code, so those conflicts sit with RevOps to resolve before anything moves. A capacity check is arithmetic and belongs in code rather than in Claude's narration, which makes it the obvious next fix.

Live Run

The Territory Rebalancer workflow graph in n8n
The live workflow graph in n8n — real Salesforce territory data merged with real HubSpot engagement and a real Clay finding, drafted by Claude, gated behind a Slack sendAndWait approval before anything gets logged.
A real live Clay enrichment table showing Company Not Found for all six sampled Fortavault demo accounts
The real Clay account, operated live through the browser — a genuine "Company Not Found" on all six sampled demo domains, reported honestly instead of papered over with an invented employee count.
The real Slack approval message for the Territory Rebalancer proposal, with Approve and Decline buttons
The real Slack approval message from the successful run — six proposed moves with real dollar values and account counts, waiting on an actual human click before anything gets logged.

Impact (measured from live runs)

$3,060,032
real Salesforce opportunity amount (all stages) evaluated for reassignment across 26 accounts, all under one owner
6 / 6
real Clay enrichment lookups returned a real, honestly-reported "Company Not Found" — zero fabricated firmographics
0
Salesforce Owner fields changed automatically — every move required a real Slack approval and only ever reaches a Data Table log

How This Would Actually Reassign Ownership

The brief calls for a logged, human-reviewed recommendation, not an automatic reassignment, and this build never crosses that line. But the automation to actually move ownership is one more node, not a redesign: right after Approved? resolves true, a Salesforce node with resource: 'account', operation: 'update' can target each approved territory's account Ids and set OwnerId to the new rep's Salesforce User Id, using the exact same authenticated OAuth2 credential already wired into every other Salesforce node here — no new auth, no new node type. The real blocker in this org is upstream of that update call: OwnerId has to point at an actual Salesforce User record, and the Salesforce node's user resource has no create operation, so Marcus Webb, Priya Shah, and Elena Cho would need to exist as real Users (provisioned in Setup, each needing an assigned license) before an update node could hand them anything. That's the actual reason this build stops at the Data Table log instead of wiring the reassignment through — not a missing automation step, but missing real seats for reps who don't exist yet in this Trailhead Playground org.

Targeting & Lead Scoring

The ICP & TAM Definition Engine

~4 min read

Instead of an ICP written by committee, this reverse-engineers one from 87 real closed Salesforce deals — win rate by industry, size, and revenue, each with a z-score — runs a live Clay enrichment that refuses to accept the wrong company, and has Claude turn only the evidence that holds up into an ICP and a rough TAM, logged for later builds to reuse.

n8n Cloud · Salesforce (OAuth2) · Clay · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Most ideal-customer-profile documents are written once, by committee, from whatever the loudest people in the room believe about who buys — and then never revisited. Nobody checks whether the traits in the ICP actually predict winning, and the TAM number beside it is usually a round figure someone typed onto a slide. Every downstream system that scores or routes leads then inherits that guess as if it were fact.

A founder and AI architect on LinkedIn described where most ICPs come from: “a handful of first customers, some assumptions, maybe a few good guesses,” after which the document is rarely touched again.

A sales-intelligence vendor’s guide to ICP mistakes names the same failure: many companies build their ICP from assumptions, incomplete CRM records or a handful of memorable deals instead of from won-deal data. This build starts from the deals instead.

The Build

Once a quarter, the workflow pulls every closed Opportunity from Salesforce — 87 real deals (61 won, 26 lost) across 39 accounts, reusing the accounts seeded across earlier builds in this series rather than a fresh set. Each account was also run through a real Clay enrichment (operated through the browser, since Clay still has no API on this plan), with the results kept in a Data Table the workflow reads; none passed the wrong-company guardrail, so company size comes from Salesforce instead, where 31 of the accounts are seeded. A Code node then does the part that matters: it groups every deal by industry, employee band, and revenue band, computes each segment's win rate against the 70.1% baseline, and runs a two-proportion z-test of that segment against everyone else. Segments with fewer than 5 deals or fewer than 3 accounts are labeled too thin to count — one big customer's repeat deals aren't independent evidence.

Only then does Claude get involved. It receives the computed table, not the raw deals, with instructions to pick 2–3 criteria from segments that clear the thresholds, quote the real numbers behind each, label weak results as weak, and say plainly when a dimension doesn't predict anything. For TAM it estimates only a company count; the dollar figure is multiplied out in code from the real median won deal ($58,740 — a median, because one $2.1M sample deal would otherwise inflate every number). The ICP posts to Slack and each criterion is logged to an ICP Definitions Data Table so the Lead Grading build later in this series can grade fit against evidence instead of guessing again.

Quarterly: 87 real closed Salesforce deals + live Clay enrichment results → Guardrail: reject Clay matches that aren't the same company → Win rate by industry, size, revenue — z-score vs. everyone else, thin segments flagged
Claude picks 2–3 criteria that hold up, estimates a company count only → TAM = count × real median won deal, computed in code → Slack post + ICP Definitions Data Table for the Lead Grading Engine to reuse

Real vs. Simulated

The win/loss history is entirely real: 87 closed Opportunities in the Trailhead Salesforce org, and every win rate and z-score is computed from them. The Clay enrichment is real too — all 29 account domains were run through the live Clay account — and its results were honest and unflattering: 24 came back Company Not Found (Fortavault's accounts use fictional demo domains), one domain was invalid, and the only 4 "matches" were the wrong companies (see below). So employee counts and revenue for 31 Fortavault accounts were seeded into Salesforce with a disclosed rule: average deal size × 0.012 employees, with a fixed per-name jitter, revenue at $180K per employee. The rule never looks at whether an account won or lost, and the seeded account IDs are listed in the workflow itself so every run labels them. The TAM company count is Claude's rough knowledge-based estimate — this isn't connected to a licensed market-sizing database — while the deal-size half of the TAM math is real.

A Real Data Problem: Clay Matched the Wrong Companies

Four of the Salesforce sample accounts have real-looking domains, and Clay returned a confident match for each. None was the right company. burlington.com came back as Burlington Stores, a retailer with 40,628 employees — not Burlington Textiles. uos.com, United Oil & Gas in Salesforce, came back as MediaOptions, a 9-person internet company. edgecomm.com resolved to an electronics manufacturer in India, and genepoint.com to a manufacturing firm while Salesforce calls GenePoint biotech. Accepting those blindly would have put a 40,000-person retailer and a 9-person startup into the size analysis. The Code node now only accepts a Clay match when the company names overlap meaningfully (after stripping words like "Inc" and "Group") and the industry agrees with Salesforce. All four were rejected, and the reason for each is written into the run's provenance note rather than silently dropped.

A Real Bug: A Truncated Caveat and an Invented Source

The first successful run posted a Slack message whose data-honesty line ended mid-word — "so industry class…" — because the truncation helper only fell back to a sentence boundary past 80 characters and otherwise chopped wherever the limit landed. The same run's TAM note credited its company count to "US Census County Business Patterns and BLS data," which Claude had never been given. The fix truncates on the last sentence end or, failing that, the last whole word, and the prompt now forbids naming a source Claude didn't receive. Comparing the two runs also surfaced something worth keeping: on identical data, Claude's company count moved from 900 to 2,000. That variance is exactly why the count is labeled rough and why no dollar math is left to the model.

A Real ICP, From Real Deals

The strongest signal in the data turned out to be an exclusion, not a target: Retail won 1 of 6 deals (z = −2.96, the only statistically significant result), and Legal won 5 of 11 (directional). Insurance won 10 of 11 but only clears "weak," and company size and revenue showed no meaningful separation at all. Here's Claude's unedited ICP summary from the final run:

Fortavault's strongest wins cluster in Insurance. The clearest predictors of losing are Retail (significant negative signal) and Legal (directional negative signal). Company size and revenue band show no meaningful separation across the deal set and should not be used to qualify or disqualify prospects at this time. Target mid-to-large Insurance firms; actively deprioritize Retail and Legal verticals.

One honest nit: "mid-to-large" in the last sentence reaches slightly past the evidence Claude was given, since size didn't predict anything. The criteria logged to the Data Table carry no size filter.

Live Run

The ICP & TAM Definition Engine workflow graph in n8n
The live workflow graph in n8n — real Salesforce deals and live Clay results feed a deterministic evidence step, Claude drafts only from what holds up, then the ICP logs to a Data Table and posts to Slack.
The real Clay table with 29 account domains enriched live
The real Clay table after the live run — 24 “Company Not Found,” one invalid domain, and four confident matches that were all the wrong company.
The real Slack post from a live ICP & TAM Definition Engine run
Both real Slack posts, before and after the fix — the first run’s data-honesty line ends mid-word (“so industry class…”) and its TAM rests on a 900-company count; the second is complete, with the same win-rate evidence and a 2,000-company count from identical data.

Impact (measured from live runs)

z = −2.96
the one statistically significant finding in 87 real deals was who not to sell to (Retail, 1 of 6 won) — size and revenue predicted nothing
4 / 4
confident Clay matches rejected as the wrong company before they could skew the size analysis — including a 40,628-person retailer
900 → 2,000
Claude's company-count estimate across two runs on identical data — the reason the TAM is labeled rough and its dollar math is done in code

The Lead Grading Engine

~4 min read

Every weekday, open HubSpot leads get an A–D grade from two independent scores — fit, checked against the evidence-based ICP from the previous build, and engagement, counted only from what the prospect actually did — with a one-line Claude rationale written straight onto the HubSpot contact and a Slack digest of the leads worth working.

n8n Cloud · HubSpot API (App Token) · Salesforce (OAuth2) · Clay · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Most lead scores make one of two mistakes. They grade on fit alone, so a huge enterprise account that has never answered an email sits at the top of the queue, or they grade on engagement alone, so a tiny poor-fit company that opens everything looks like a hot lead. Worse, the score is usually a single opaque number: a rep can see that a lead is a 74 but not why, so they either ignore it or trust it blindly.

A director of revenue operations on LinkedIn described what he finds when he audits scoring models: points assigned in a room by marketing, and then “Sales immediately ignores it.” A whitepaper download, he points out, “just means they wanted the PDF.”

A B2B marketing consultancy that studies why sales teams distrust scoring sets the bar plainly: if a rep can’t explain the score in ten seconds, adoption stalls. It also warns that blending fit and intent into one number hides whether a lead is the right company or just the right moment. That is why this build scores fit and engagement separately and explains every grade in writing.

The Build

Each weekday morning the workflow pulls every real HubSpot contact that isn't already a customer — 8 open leads — and scores two things separately. Fit comes from the ICP Definitions Data Table written by the previous build in this series, so it's checked against win rates computed from 87 real closed deals rather than a guess: an ICP include (Insurance) scores 90, a known industry with no signal either way scores 60, an ICP exclusion (Retail, Legal) scores 15, and no industry on record scores 35. The industry itself is looked up in order — HubSpot's company record, then the matching Salesforce Account, then a stored Clay enrichment result (run in Clay and kept in a Data Table, since Clay has no API on this plan) that has to pass the same wrong-company guardrail as the ICP build — and every grade records which system it came from.

Engagement is computed from each contact's real HubSpot activity through the Engagements API, and it deliberately counts only what the prospect did: an inbound email reply is worth 25, a meeting 35, a call 20, plus form fills, clicks, opens and page views, at full weight for 30 days and half weight to 90. Outbound emails we sent are shown but never scored — sending more email shouldn't make a lead look warmer. The two scores combine into a simple 2×2 in code: A is high fit and engaged, B is the right account but quiet (pull the outreach lever), C is engaged but fit is weak or unverified (qualify before investing), D is neither. Claude only writes the one-line reason; the grade is already decided and it's told never to change it. Grade and rationale are written to two custom properties on the HubSpot contact, every grade is logged for a change history, and Slack gets a digest of new or changed A/B leads.

Weekday run: open HubSpot leads + companies, Salesforce industries, stored Clay results, latest ICP run → Fit vs. evidence-based ICP (industry from HubSpot → Salesforce → guarded Clay) → Engagement from real HubSpot activity — prospect-side only
2×2 rule in code: A / B / C / D → Claude writes a one-line rationale, never the grade → Grade + rationale on the HubSpot contact, history logged, A/B digest to Slack

Real vs. Simulated

The contacts, companies, industries, ICP criteria, Clay lookups, grade math, Claude rationales, HubSpot property writes and the Slack digest are all real. One piece had to be seeded: prospect engagement. This free-trial HubSpot portal has never sent a marketing email, so every lead showed zero opens, clicks, page views and form fills, and the only activity on record was outbound email created in an earlier build — exactly the kind of activity this grader refuses to count. So nine inbound activities (email replies, two meetings and a call, backdated 1–12 days) were created for four leads through HubSpot's own Engagements API, after the scoring weights were already fixed. They're genuine HubSpot records — HubSpot's own AI contact summary picked them up (see the screenshot below) — but they were written for this demo, and they're disclosed as such. The two HubSpot sample contacts' August meetings and calls are HubSpot's own demo data, not ours.

Clay was run live on the three lead companies it hadn't seen before. Two fictional demo domains came back Company Not Found; the third, hubspot.com, came back as HubSpot itself with 12,967 employees and passed the name-and-industry guardrail — the first Clay match accepted anywhere in this series.

A Real HubSpot Limit: The Token Couldn't Create Properties

Writing the grade back needs two custom contact properties, and the first attempt to create them through the API returned a 403: MISSING_SCOPES, because the app token behind the n8n credential doesn't have crm.schemas.contacts.write. The same token can read and update contacts but not change their schema. Rather than widen the token's permissions for a one-time setup step, the two properties — Fortavault Lead Grade (a dropdown with A–D as its internal values) and Fortavault Grade Rationale — were created once in HubSpot's settings UI, and the workflow only ever writes values to them. Reading activity back surfaced another real scope boundary: HubSpot redacts email bodies without the sales-email-read scope. That never mattered here, since the grader only reads each activity's type and timestamp.

A Real Wording Bug: “Solid Fit”

Before anything was written to HubSpot, the workflow ran once with its write, log and Slack steps disabled. The grades came out exactly as the rule intended, but Claude described HubSpot's own record — Software Development, a neutral fit of 60 with no win-rate signal either way — as a "solid fit." That's the kind of small overstatement a rep would take at face value. The prompt now spells out that a neutral fit must be called neutral, never solid, good or strong, and the live run's rationales say exactly that.

Real Grades, Real Rationales

The live run graded 8 leads 1 A, 3 B, 2 C, 2 D. The two C's show why the middle cases need different wording: one is engaged but in a vertical the ICP excludes, the other is engaged but nobody knows its industry yet. Claude's unedited rationales, exactly as written to HubSpot:

A: strong fit (Insurance is an ICP include); high engagement—meeting 1d ago and two recent inbound emails; work now. C: poor fit (Legal Services is an ICP exclusion); actively engaging—email 2d ago and call 4d ago; qualify fit before investing. C: unknown fit (no industry on record); actively engaging—email 8d ago and meeting 5d ago; qualify fit before investing. B: neutral fit (Financial Services, not ICP-excluded); low engagement—one inbound email 12d ago; pull the outreach lever.

Live Run

The Lead Grading Engine workflow graph in n8n
The live workflow graph in n8n — signals gathered from HubSpot, Salesforce, Clay and the ICP table, a deterministic grade, Claude's rationale, then write-back, history and the Slack digest.
A HubSpot contact record showing the Fortavault Lead Grade and Rationale properties
The grade where reps actually work — Renata Voss's real HubSpot record showing Fortavault Lead Grade A and the rationale, alongside HubSpot's own AI summary of the same activity.
The real Slack digest from a live Lead Grading Engine run
The real Slack digest — the grade distribution plus every new A/B lead with its fit and engagement scores and one-line reason.
The real Clay table with HubSpot matched and two demo companies not found
The live Clay run — hubspot.com resolves to HubSpot (12,967 employees), the first match in this series to pass the wrong-company guardrail; both demo domains are honestly not found.

Impact (measured from live runs)

1A · 3B · 2C · 2D
8 real HubSpot leads graded, each with the reason on its contact record — not an opaque score
18 → 0 pts
outbound emails on record that the grader deliberately ignored — the lead with the most touches (5) still grades D
3 systems
fit resolved from HubSpot, Salesforce, or a guarded Clay match — and when none of them knows, the lead is marked unknown instead of guessed

Scoring Anonymous Accounts Before Anyone Fills Out a Form

~4 min read

Real Clay research on real target accounts gets checked against HubSpot and Salesforce, scored by Claude for in-market likelihood, and posted to Slack only when an account is genuinely still dark.

n8n Cloud · Clay (Claygent) · HubSpot API (Service Key) · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.5) · Slack API · n8n Data Tables

The Problem

Most of the accounts worth selling to never touch a tracked channel before they're already deep into evaluating a purchase. Nobody filled out a form, nobody booked a demo, nobody signed up for a trial — so HubSpot has no contact and Salesforce has no opportunity, even though the account is actively researching, hiring for the exact roles that predict this purchase, and quietly building a shortlist. That's the "dark funnel": real buying activity that's completely invisible to a CRM built to track inbound. Sales has no way to know these accounts exist without someone manually researching a target list, and manual research doesn't scale past a handful of accounts a week.

An AI strategist on LinkedIn put the shift bluntly: “Buyers have already educated themselves in the dark funnel,” so reps are now “in the business of validation.”

The research backs this up. A B2B intent-data vendor’s 2024 global buyer study found buyers are nearly 70% of the way through their purchase before they engage a seller, and that buyers make the first contact more than 80% of the time. An analyst firm’s 2025 survey of 632 B2B buyers found 61% would prefer a buying experience with no rep at all.

The Build

Same honesty constraint as the Champion Job-Change build: Clay's free-trial plan has no webhook or API automation, so there's no way for Clay to call back into n8n on its own. Rather than fake that, the workflow is split in two around the real boundary. Workflow A seeds a list of real target accounts (Alloy, Marqeta, Vouch Insurance, Hippo Insurance, Cedar, Included Health, Clio, and Ironclad — not placeholders; Claygent needs real companies to find anything real) and posts a Slack prompt per account asking a rep to run Claygent for funding, hiring, and review-site signals, then submit the findings through an n8n form.

Workflow B triggers on that form submission and does the part that actually has to be automated to be trustworthy. Before anything gets scored, it checks whether the account is genuinely pre-funnel — a real HubSpot company search by domain, and a real Salesforce SOQL query for that account with a nested subquery for any open opportunity. If either system already has a match, the account is logged as disqualified and the workflow stops there: no wasted Claude call, no Slack noise for an account sales already knows about. Only when both checks come back clean does Claude score the account's in-market likelihood from 0-100, grounded specifically in the Clay research signals rather than generic ICP fit. A score of 70+ posts a real nomination to Slack; every outcome, scored or disqualified, is logged to an n8n Data Table for a full audit trail.

Slack prompts a rep per seed account → Rep runs real Claygent research in Clay → Findings submitted via n8n form → Real HubSpot + Salesforce pre-funnel check → Claude scores in-market likelihood → 70+ → Slack nomination + logged

Scoring Prompt

Same Fortavault ICP context as the other builds, with a narrow job: score the account against the actual research signals, not against optimism.

You are scoring an anonymous, pre-funnel target account for Fortavault, a data security / compliance vendor. Fortavault's ICP skews toward mid-market and enterprise companies in regulated, data-heavy industries (financial services, healthcare, and SaaS handling sensitive customer data) - companies who need to prove compliance posture, not just companies who might buy security software generically. Account: {{ accountName }} ({{ domain }}) Research signals from Clay/Claygent: - Funding: {{ funding }} - Hiring: {{ hiring }} - Review-site mentions: {{ reviewMentions }} Score this account's in-market likelihood from 0-100. Ground the score in the specific signals above, not generic optimism - an account with no real signals should score low even if it superficially fits the ICP. Return ONLY valid JSON: {"score": 0-100 integer, "reasoning": "2-3 sentences citing the specific signal(s) driving the score", "keySignals": "one-line summary"}

Two Real Scored Accounts

Both of these are real outputs from live runs (one excerpted where marked) — real Claygent research, submitted through the actual form, checked against the real Trailhead Salesforce org and a real HubSpot portal, and scored by Claude with no hint about what to look for beyond the raw signals:

Marqeta (marqeta.com) — Score: 72/100 Signals: no funding round in the last 12 months (last raise was a 2020 Series E); actively hiring a Senior Security Engineer - Cloud Identity, a Senior Technology Auditor, and a Risk and Compliance Manager; no G2/Capterra review mentions evaluation, but a Lumos customer-story page confirms Marqeta evaluated and selected an identity-governance solution. Claude's reasoning: "Marqeta is a card-issuing platform in financial services (core ICP fit) with active hiring for Senior Security Engineer, Senior Technology Auditor, and Risk and Compliance Manager roles, indicating investment in security and compliance infrastructure. The Lumos customer story confirms recent evaluation and purchase of identity governance tooling, demonstrating active buying behavior in adjacent compliance/security categories."
Hippo Insurance (hippo.com) — Score: 72/100 Signals: no funding round in the last 12 months (last raise was a 2019 Series D); actively hiring two Chief Information Security Officer roles plus an Enterprise Compliance Director and two other compliance positions; no G2/Capterra review mentions evaluation, but a CyberArk customer-story page confirms Hippo selected CyberArk for identity governance tied to SOX and governance reporting. Claude's reasoning: "Hippo is actively hiring two CISOs and multiple compliance-focused roles... The CyberArk case study confirms recent tooling evaluation and purchase for identity governance tied to SOX compliance and governance reporting, demonstrating both budget allocation and active compliance posture improvement. As an insurance company, Hippo operates in a heavily regulated industry with stringent data-protection requirements."

G2 and Capterra Aren't Buyer Intent — and the Real Signal Came From Somewhere Else

The original design called the third research signal "review-site mentions" of an account evaluating security or compliance tooling. Running real research against Clio, Marqeta, and Hippo exposed that framing as imprecise, and it's worth being upfront about rather than quietly fixing in the write-up. Public G2 and Capterra reviews are opinions from people who already use the product being reviewed, about that product — not a place someone announces they're shopping for something else. Claygent's open-web search never found a review that said "we're evaluating a compliance tool." What it found instead, for both accounts above, was a competitor's own customer case-study page — Lumos for Marqeta, CyberArk for Hippo — confirming a real, recent identity-governance purchase. That's a genuinely useful signal; it just isn't the one the field name implied.

The product that actually captures "is this account researching a software category right now" is G2 Buyer Intent (Capterra, Software Advice, and GetApp were folded into G2 after its acquisition of them from Gartner). It tracks account-level browsing behavior on G2's own site — who's viewing a category page, comparing vendors, reading competitor profiles — and sells that as a paid, licensed data feed. It isn't visible through public search, and no amount of open-web research, Claygent included, can see it.

Where This Is Honestly Limited

Two constraints shaped what actually got built here, and both are worth naming instead of glossing over. First, the same one as the Champion Job-Change build: Clay's free tier has no webhook or API layer, so the intended fully-automated loop — n8n pushes accounts into Clay, Claygent researches them, Clay calls back on its own — isn't possible on this plan. What's built instead is the most honest version achievable: real Claygent research, real HubSpot/Salesforce/Claude/ Slack automation for everything downstream of that lookup, and a manual hand-off in between. Second, without licensed access to G2 Buyer Intent, the "review mentions" signal is open-web inference rather than a real intent feed — useful when it surfaces something like the Lumos or CyberArk case studies above, but not a substitute for actual account-level browsing data.

With full Clay API/webhook access, Workflow A and B collapse back into one fully automated loop with zero human touch, and the seed list stops being a small hand-picked batch of eight — it could run nightly against a much larger, continuously refreshed target list. With G2 Buyer Intent access, the review-mentions signal becomes a real structured feed (which categories an account is researching, page-view volume, competitor-comparison views) instead of open-web guesswork, strong enough to weight more heavily in Claude's prompt than it currently does. It also changes what starts the workflow in the first place: instead of scoring a list someone curated by hand, an intent spike on a relevant category could be the trigger — nominating accounts because they just started researching compliance software, not because they happened to be on a seed list. That's the same real-time-detection idea Day 17's Intent Signal Monitor applies elsewhere in the sprint, showing up here too.

Live Run

The real Clay table with Claygent research on all eight seed accounts
The real Clay table behind Workflow A's prompts — Claygent's funding, security-hiring, and review-site research on all eight seed accounts, the raw material Workflow B's form submissions are built from.
Workflow A: Dark Funnel Illuminator - Nominate Accounts, workflow graph in n8n
Workflow A in n8n — seeds the real target accounts and prompts a rep in Slack to run Claygent research on each one.
Workflow B: Dark Funnel Illuminator - Score and Notify, workflow graph in n8n
Workflow B in n8n — form-triggered HubSpot + Salesforce pre-funnel check, Claude scoring, Slack nomination, and Data Table logging.
Real Slack nominations for Marqeta and Hippo Insurance posted by the workflow
Real nominations posted to Slack from the live runs above — Marqeta and Hippo Insurance, both scored 72/100 and confirmed clean against HubSpot and Salesforce.

Impact (measured from live runs)

2 of 2
real Clay-researched accounts scored genuinely in-market
72/100
Claude's score for both, independently grounded in different signals
0
wasted Claude calls — both accounts cleared a real HubSpot + Salesforce check first

The Rejection Reason Recalibrator

~4 min read

Sales rejects a third of MQLs and the scoring model never hears why. This build reads every rejection note, codes the reason with the rep’s own words, checks “already a customer” against Salesforce, and simulates weight changes that drop the bad leads without losing a single good one.

n8n Cloud · Salesforce API · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Lead scores lose credibility one false positive at a time. A marketing-operations consultancy describes the cycle: reps see high-scoring leads go nowhere, then ignore the queue and work their own sources. A sales-and-marketing alignment guide puts numbers on the gap. Reps reject 20 to 40% of MQLs, but fewer than half of teams have standard rejection reasons, so the reasons that are written down sit in free-text notes nobody analyzes. The scoring model keeps rewarding the same behavior that produced the rejects.

The Build

Once a month, n8n re-scores every MQL from the last 60 days with the current model. Each point rule (senior title, pricing page, webinar, ebook, industry, size, email opens) is a row in a table, so the model is data, not code. Claude reads each rejection note and assigns one reason code, quoting the rep’s words. Code keeps the reason only if the quote is in the note, and checks any “existing customer” claim against Closed Won accounts in Salesforce.

Then code runs the simulation. It tries lowering each rule in 5-point steps and keeps the change that pushes the most rejected leads below the MQL line. A change is allowed only if every accepted lead still qualifies, and up to three changes are chained. Reasons that weights can’t fix, such as students, competitors and current customers, become rule recommendations instead.

Monthly: scoring model, recent MQLs, Salesforce customers → Code: re-score, simulate weight changes
Claude: rejection reason (quoted) → Code: verify, confirm customers in Salesforce → Recommendation to Slack + log

Real vs. Simulated

The customer check is real: Thornbury Financial is a Closed Won account in Salesforce. The scoring model, the 23 MQLs and the reps’ notes are seeded; 11 were rejected and 12 accepted. The seed has an answer key of eleven reason codes. One decoy note just says “no.” and has to stay Unclear rather than be given a reason. The Lead Grading Engine earlier in this series scores real HubSpot contacts; this build is the feedback loop that model was missing.

A Real Limit, Stated in the Output

The headline result is strong: acceptance goes from 52% to 92%. But it is measured on the same 23 leads the changes were fitted to, and MQL volume drops from 23 to 13. So the post doesn’t apply anything. It proposes the changes, shows the volume trade-off, and says the sample is small. It is also explicit that one rejected lead, an existing customer, can’t be fixed by weights at all and needs a suppression rule.

Real Results

23 MQLs in the last 60 days; sales rejected 11 (48%). MQL threshold 60 points. Why sales said no: Student or researcher 2 · Wrong persona 2 · Consultant 1 · Competitor 1 · Too small 1 · No budget 1 · Existing customer 1 · Bad contact data 1 · Unclear 1 What scored the rejected leads: Ebook download (+20): 10 of 11 rejected vs 2 of 12 accepted 3+ email opens (+10): 10 of 11 rejected vs 2 of 12 accepted Proposed weight changes (simulated on these 23 MQLs) • Ebook download: +20 → +5. 9 rejected leads fall below 60; no accepted lead is lost • 3+ email opens: +10 → +5. 1 rejected lead falls below 60; no accepted lead is lost Result: 10 of 11 rejected leads stop qualifying; all 12 accepted still qualify. Acceptance 52% → 92%. Existing customer (1): suppress Closed Won accounts and route to CS. Confirmed in Salesforce: Thornbury Financial.

Excerpts from the live post. All eleven reasons matched the answer key, and the “no.” decoy stayed Unclear.

Live Run

The Rejection Reason Recalibrator workflow graph in n8n
The live workflow graph in n8n: the scoring model, recent MQLs and Salesforce customers load and code simulates weight changes; Claude codes each rejection note, code verifies; the recommendation posts to Slack and is logged.
The real Rejection Reason Recalibrator post in Slack
The real recommendation: why sales said no in the reps’ words, which rules scored the rejected leads, two weight changes with no accepted lead lost, and the rules weights can’t fix.

Impact (measured from live runs)

11 of 11
rejection notes coded to the seeded answer key, with the no-reason decoy left Unclear
10 of 11
rejected leads would stop qualifying under the proposed weights, with all 12 accepted leads kept
52% → 92%
simulated sales acceptance, shown alongside the volume trade-off (23 → 13 MQLs)

Outbound & Prospecting

The Intent Signal Monitor

~5 min read

Every week, a watchlist of real target accounts is re-researched on the web through Clay — funding, open security roles, compliance events — scored in code, compared with last week, and only the accounts that actually moved reach Slack, each with a one-line Claude “why now.” Shown here as a two-week backtest.

n8n Cloud · Clay (Claygent web research) · HubSpot API (App Token) · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

The dark-funnel build earlier in this series found accounts that look like buyers before they ever talk to sales. Finding them once is the easy part. The hard part is noticing when one of them starts moving: a new security hire, a fresh funding round, a new CISO. A static list goes stale in a week, and a rep who re-checks eight companies by hand every Monday stops doing it by the third Monday. What matters isn't how interesting an account is. It's whether something changed since the last time anyone looked.

A demand-generation leader on LinkedIn put a number on the window: a single intent spike lasts 30 to 45 days, and “most programs do not have fast enough follow-up to close that window.”

Timing is the whole game. The same global buyer study cited in the dark-funnel build found that 81% of buyers already have a preferred vendor by the time they first contact one. A signal noticed a month late is usually noticed after the shortlist is set.

The Build

The watchlist is eight real companies carried over from that build: Marqeta, Hippo and Alloy from its nominations, plus Vouch, Cedar, Included Health, Clio and Ironclad from its seed list. Each week a Clay table re-researches every account with Claygent, Clay's web research agent, and the results are loaded into a research-snapshot Data Table that the workflow reads. Clay has no API on this plan, so that hand-off is a manual step, and an account with no snapshot for the run date is marked as not researched rather than scored on stale data. It returns structured fields rather than prose: the latest funding date and round, a count of security, privacy or compliance roles posted in the last 30 days, a count of compliance or security events in the last 90, and a dated evidence line with a source link for each.

n8n scores each account in code on a fixed scale: funding within 180 days is worth 30 and within a year 15, each open security role is worth 8 (up to five), and each compliance event 10 (up to three). It then compares the score with the account's previous run in a history table. Before anything is counted, a Claude step at temperature 0 labels every dated evidence line. It says whether the line is a security job posting, a compliance or security event, funding, or none of these. It also says whether the line is about the company itself, and whether it's the same posting or event as a line in last week's research. Claude only labels; the counting and points all happen in code. An account that gained at least one new evidence-backed signal since last week is accelerating. The same run searches HubSpot for each account's domain and asks Salesforce for open opportunities. An account with an open opp graduates off the watchlist, because at that point it belongs to a rep, not a monitor. Only accelerating or graduated accounts go on. Claude writes one sentence per account naming the specific new evidence and an outreach angle, but never the score, and Slack gets a digest. A week with no movement posts nothing.

Weekly run (or a backtest date): watchlist + Claygent research snapshots + last week's history → HubSpot domain search + Salesforce open opps for context and graduation → Claude labels each evidence line: role, event, funding or other; first-party; repeat of last week
Score in code from relevant lines only, then compare with last run: accelerating, steady, cooling, or graduated → History logged + watchlist updated → Movers only: Claude writes the “why now,” digest to Slack

Real vs. Simulated

The watchlist companies, the web research, the evidence and its sources, the scores, the HubSpot and Salesforce checks, Claude's notes and the Slack post are all real. The simulated part is the calendar. A weekly monitor needs two weeks to show anything, so this is a backtest. The same Claygent research ran live today against two cutoffs, as of 16 September and as of 30 September, and the workflow was run once for each date through its Backtest Run form. The first run set every account's baseline and, as designed, posted nothing. The second compared against it.

One caveat matters. The cutoff is enforced by the research prompt, which tells Claygent to count only evidence dated on or before the as-of date. It is not a snapshot of the web as it looked on 16 September, so a page edited since then could still leak through. Every evidence line carries its own date, and the scoring re-checks those dates in code. None of the eight companies exists in this demo HubSpot or has a Salesforce opportunity. That's the honest state of a list of outside accounts, so the graduation path is wired up but was never triggered in the backtest.

A Real Claygent Bug: Counts With Nothing Behind Them

Claygent returns a count and a list of evidence, and the two don't always agree. For Hippo as of 30 September it reported one compliance event but listed only a 2020 funding round. The one line of evidence behind that count was six years out of window. So the scoring doesn't trust counts on their own. A role or event scores only if a dated evidence line inside its window backs it, and the breakdown logged for every account says what was dropped. Hippo's phantom event scored zero and never reached Slack.

A Real Claygent Bug: The Same Research, Two Different Answers

The two runs disagreed about facts that don't change. As of 16 September Claygent reported Clio's latest funding as a November 2025 Series G and missed its January 2026 $900M Series F, which it found on the 30th. As of the 30th it lost Clio's July CISO appointment, which it had found two weeks earlier and which was still inside the 90-day window. Scored naively, Clio moved only +6 and read as steady, even though it had just posted two new security analyst roles. The fix is in code: evidence is now sticky. The monitor keeps the latest funding date seen in any snapshot, and events found last week stay counted until they age out of their window. With that fix Clio went from 25 to 41 and led the digest. That's what a weekly monitor has to get right: the score should move because the company changed, not because the research did.

A Real Bug: Dated Isn't the Same as Relevant

The first version of this monitor alerted on four accounts, and the weakest was Vouch. Its compliance “event” was a Vouch blog post explaining SOC 2 to its customers for cyber-insurance underwriting, not Vouch pursuing SOC 2 itself. Its “new” security role was the same Staff Infrastructure & Security Engineer posting the 16 September research had already seen in July, now relisted. Both lines carried proper dates, so a date check let them through, and Claude's why-now note repeated the misreading in Slack.

The fix is the relevance check described above. Claude labels each line, and code scores only lines that are about the company itself, fall inside their window, and aren't a repeat of something last week's research already saw. Every dropped line is written to the history table with the reason, and the why-now writer now sees only the evidence that actually scored. Both Vouch backtest runs were re-run under the new rules. Vouch went from a +8 alert to steady at 0, while Clio, Marqeta and Alloy kept their alerts on the same research. The label step also caught Alloy's 16 September “GTM Systems” posting as not a security role, which Claygent had already handled correctly, and Included Health's privacy-policy update as not an event.

Real “Why Now” Notes

After the fix, the 30 September run flagged three of the eight accounts, and Ironclad cooled after its only security posting came down. Claude's unedited notes, exactly as posted:

Clio (25 → 41): New CISO George Totev appointed Jul 2026 + 2 security analyst roles posted in Sep signal a maturing security program—pitch Fortavault as the data protection layer to support their buildout. Marqeta (0 → 8): A Senior Security Engineer – IAM role posted Sep 22 hints at identity and access expansion; engage now to position Fortavault alongside their IAM initiative. Alloy (0 → 8): A Senior Cloud Security Engineer role posted late Sep signals cloud security investment; reach out to explore how Fortavault can complement their growing cloud data protection needs.

Live Run

The Intent Signal Monitor workflow graph in n8n
The live workflow graph in n8n: a weekly schedule and a backtest form feed the same pipeline. It loads the watchlist, research and history, checks HubSpot and Salesforce, scores in code, then logs history and alerts only on movers.
The real Slack digest from the 30 September backtest run
The real Slack digest from the 30 September run after the relevance fix: three accounts moved, each with its score change, Claude's “why now” and its HubSpot and Salesforce status. The rest are listed as steady or cooling.
The Clay table with 16 Claygent research rows and Clio's cell details
The live Clay research: 8 accounts × 2 cutoffs, with Clio's 30 September result open. It shows the dated evidence lines, Claygent's reasoning and the structured fields n8n scores.

Impact (measured from live runs)

3 of 8
watchlist accounts surfaced in week two, each backed by dated, sourced, first-party evidence; the other five stayed quiet in Slack
+6 → +16
Clio's move once evidence was made sticky. Research drift had been hiding the strongest signal on the list
2 of 3
of Vouch's evidence lines dropped by the relevance check (a customer-facing blog post and a relisted job), taking a false alert out of Slack

Turning Buying Signals Into Outreach

~3 min read

A rep drops a buying signal in Slack; Claude drafts two ready-to-send outbound sequences in seconds, then turns an approval into real Gmail drafts.

n8n Cloud · Slack API · Anthropic Claude (Sonnet 4.6) · Gmail API · n8n Data Tables

The Problem

Reps see buying signals constantly — a funding round, an acquisition, a leadership change, a security incident at a target account — but turning a signal into a genuinely differentiated outbound sequence takes more time than most reps have in the moment. So the signal gets a LinkedIn like instead of a sequence, and the window passes.

A revenue-systems founder on LinkedIn described a client’s quarter: 1,100 outbound messages, 11 replies, two of them “no thanks.” His verdict on first-name personalization: “A first name proves you have a database.”

A CRM vendor’s survey of sales professionals found reps spend only 28% of their week actually selling, so there is rarely time to research a trigger and write to it. Generic outreach isn’t a safe fallback either: an analyst firm’s 2025 survey of B2B buyers found that most actively avoid suppliers who send them irrelevant outreach.

The Build

An AI agent lives in a Slack channel. A rep @mentions it with a plain-language signal — "Paramount just bought Warner Bros." — and Claude classifies the signal type, then drafts two complete, genuinely different 3-touch outbound email sequences: Angle A leads with risk/urgency framing, Angle B leads with a consultative/relationship framing. Both post back into the Slack thread within seconds, grounded in a real company context (below) so the copy references actual products and competitive positioning instead of generic filler.

From there it's an actual review loop, not a one-shot generation. The rep can reply in-thread with a plain instruction — "make angle B shorter" — and the agent edits just that angle using per-thread conversation memory, then reposts only what changed instead of re-flooding the thread with both angles again. When a rep reacts with ✅ on the angle they want, the workflow logs the approval, confirms it in-thread, and splits that angle's three touches into three separate Gmail drafts — each with its own real subject line and no leftover Slack instructions — ready to review and send. Every draft, edit, and approval is logged to an n8n Data Table for an audit trail, and a shared error-handling workflow alerts Slack and logs any node failure automatically.

Rep @mentions signal in Slack → Claude classifies + drafts Angle A & B → Posted to thread for review → Reply to refine (optional) → ✅ to approve → Logged + 3 Gmail drafts created

Company Context

Every draft is grounded in a fictional company I built specifically for this project — Fortavault, Inc., a data protection and security platform — so the agent has real products, industries, and competitors to reason about instead of writing in a vacuum.

Products

  • Fortavault Backup Cloud — cloud backup & disaster recovery
  • Fortavault Shield — ransomware detection, isolation, one-click rollback
  • Fortavault Access — zero-trust endpoint access control
  • Fortavault Insights — compliance & audit reporting (HIPAA, SOC 2, GLBA)

Industries served

Financial Services Healthcare Legal Manufacturing Higher Education Retail/E-commerce Insurance

Competitors & how Fortavault wins

  • Veyron Data (backup/DR) — faster to recover, simpler SaaS-data setup
  • Ashcombe Systems (ransomware detection point solution) — Fortavault pairs detection with backup for one-click recovery
  • Cyphertide (zero-trust access) — better suited for regulated industries needing audit-ready logs
  • Northgate Cloud Security (broad platform incumbent) — more focused roadmap, faster implementation
  • Ridgeline Compliance (compliance reporting point tool) — Fortavault Insights is natively integrated with backup/security data

Live Run

The Signal-to-Sequence Translator workflow graph in n8n
The live workflow graph in n8n — dual-angle drafting, reply-to-refine gating, human-in-the-loop approval, and per-touch Gmail draft creation.
Angle A, risk/urgency framing, posted to the Slack thread Angle B, consultative/relationship framing, posted to the Slack thread
A real signal, drafted live: two distinct outbound angles posted back to the rep's Slack thread for review.
Three Gmail drafts created automatically from one approved angle
On approval, each touch becomes its own ready-to-send Gmail draft — real subject line, no leftover Slack instructions.

Impact (measured from live runs)

~15 sec
signal → two drafted angles
3
ready-to-send Gmail drafts per approval
0
manual research or copy-paste steps

Finding Your Champions When They Change Jobs

~3 min read

A rep confirms a past champion's new employer, Claude pulls their deal history from Salesforce and drafts a re-engagement angle, and a Slack approval turns it into a new Salesforce Opportunity.

n8n Cloud · Clay (Claygent) · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API (interactive approvals) · n8n Data Tables

The Problem

A champion who bought from you doesn't stop being a champion when they change jobs — but nobody tracks that. The rep who closed them moves on to new pipeline, the contact record goes stale in Salesforce, and a warm relationship with someone who already knows the product's value just evaporates instead of turning into a new deal at their new company.

A business development rep on LinkedIn described the best lead of his week, one he didn’t source: “A former user changed jobs and brought us with him.”

A job-change-tracking vendor’s analysis of more than 5,000 opportunities found that deals involving a former champion were, by its own measure, more than twice as likely to close and about 54% larger. The same vendor found 91% of former champions didn’t come back on their own, even three months into the new job. The value is there, but only if someone goes and gets it.

The Build

This one is honest about where the automation boundary actually sits. Clay is genuinely useful here — Claygent can research a contact's current employer far better than I could script by hand — but Clay's free tier doesn't include webhook or HTTP API access, so there's no way to have Clay call back into n8n automatically. Rather than fake that part, I built the real boundary into the workflow: a rep runs an actual Claygent lookup in Clay's UI on a champion from the roster, then submits what it finds through an n8n form. Everything from that submission onward is fully live and automated.

The form hand-off triggers a lookup against a Champion Roster Data Table, and a check for whether the submitted company actually differs from the champion's last known employer. If it does, n8n queries Salesforce for that champion's real deal history at their old company, and Claude drafts two things grounded in that history: a private rationale for the rep on why this contact is worth pursuing again, and a re-engagement opener referencing their specific prior products and the reason to talk now. That goes to Slack as an interactive approval — create the opportunity, or skip it. Approving it creates a real Salesforce Account and Opportunity for the champion's new company, with Claude's drafted angle written into the Opportunity description. Every outcome, approved or declined, is logged to a Data Table, and a separate Recheck Reminder workflow can post a daily 7am Slack nudge for each champion on the roster to go run the next Clay lookup, since nothing here can check automatically (it's switched off between test runs).

Rep runs a real Clay lookup → Result submitted via n8n form → Job change detected against roster → Salesforce deal history pulled → Claude drafts rationale + re-engagement angle → Slack approval → new Account/Opportunity + logged

Rationale Drafter System Prompt

Same Fortavault context as above, with a different job: decide whether a champion is worth pursuing at their new company, and draft the opener a rep could actually send.

You are a champion-tracking assistant for Fortavault, Inc., a fictional data protection and security platform (cloud backup, ransomware recovery, zero-trust access, and compliance reporting). Products: Fortavault Backup Cloud, Fortavault Shield, Fortavault Access, Fortavault Insights. Key competitors: Veyron Data, Ashcombe Systems, Cyphertide, Northgate Cloud Security, Ridgeline Compliance. A contact who was previously a champion or closed-won buyer at one company has just changed jobs to a new company, detected via a real Clay lookup (not simulated). Your job is to assess whether it's worth pursuing them at their new company and draft a specific re-engagement angle grounded in their history with Fortavault. Write rationale as 1-2 sentences explaining why this is worth pursuing now - private, for the rep only. Write reengagementAngle as a 2-3 sentence opener a rep could paste into an email or LinkedIn message, referencing their prior experience with Fortavault by name and connecting it to a specific reason to talk now at the new company, grounded in real Fortavault products/positioning where relevant. Respond with a JSON object with exactly two fields: rationale (string) and reengagementAngle (string).

A Real Drafted Email

This is the actual reengagementAngle Claude wrote during a live run, unedited, after a real Clay lookup found that the test champion (my own profile, carrying seeded Meridian Financial Group deal history) had moved to Acronis:

Hi Adam — congrats on the move to Acronis! I noticed you championed Fortavault Shield and Backup Cloud at Meridian after that ransomware near-miss, and then expanded into Fortavault Insights for SOC 2 reporting — so you know better than most what a mature data protection stack looks like from the inside. Given that you're now at a company where backup, recovery, and compliance are central to the business, I'd love to reconnect and hear how you're thinking about those same challenges in your new GTM role — whether there's a fit or not, your perspective would be genuinely valuable.

Where This Is Honestly Limited

Clay's free tier has no webhook or API automation, which means this workflow cannot continuously monitor champions for job changes on its own — that requires Clay's paid Growth plan. What's built instead is the most honest version achievable on a free trial: real Claygent research, real Salesforce and Claude and Slack automation for everything downstream of that lookup, and a scheduled Slack reminder that nudges a rep to go run the next check manually rather than pretending a free tier can do something it can't. One more thing worth saying plainly: Fortavault's contacts are fictional, so Clay has no real job history to find for them. The roster's test champion is therefore my own profile. The move to Acronis is a real Clay result; the Meridian Financial Group deal history behind it ($107K across two Closed Won deals) is seeded demo data in Salesforce.

Live Run

The Champion Job-Change Radar workflow graph in n8n
The live workflow graph in n8n — form hand-off from a manual Clay lookup, job-change detection, Salesforce deal history, Claude drafting, Slack approval, and Salesforce/Data Table logging on the approve and decline branches.
A real Champion job-change approval message posted to Slack, with Claude's drafted rationale and re-engagement angle
A real flagged champion from a live run — Claude's rationale and drafted re-engagement opener, waiting on a rep's approve/skip.
The new Salesforce Opportunity created after approval, with Claude's drafted angle in the description field
The real Salesforce Opportunity created on approval — new Account, Qualification stage, 90-day close date, and Claude's drafted angle written straight into the description.

Impact (measured from live runs)

1 of 1
real job-change lookups correctly detected and routed
$107K
prior deal history pulled into the drafted rationale
0
manual Salesforce data entry after Slack approval

Bringing Dead Deals Back to Life

~3 min read

A daily scan flags old lost deals worth a second shot, drafts the re-engagement pitch, and waits for a rep's Slack approval before reopening anything.

n8n Cloud · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API (interactive approvals) · n8n Data Tables

The Problem

Closed Lost opportunities pile up in Salesforce and get forgotten — even the ones that were lost for reasons that don't hold up six months later. A budget freeze thaws. A champion who left gets replaced by someone inheriting the exact same problem. Nobody has time to manually comb through the Closed Lost list and guess which dead deals are actually worth a second look, so they just stay dead.

On LinkedIn, a GTM leader passed along an SDR’s rule of thumb for consistent pipeline: Closed-Lost “doesn’t usually mean no, it means not now.”

Many of those losses were never a real no. A sales-research firm’s analysis of 2.5 million recorded sales conversations attributed 40 to 60% of lost deals to customer indecision rather than to a competitor. Indecision is exactly the kind of loss that changes when the timing does.

The Build

A daily scheduled scan queries Salesforce for every Closed Lost opportunity. Claude reviews each one against its stated loss reason and how much time has passed, deciding whether it's worth re-engaging — deliberately instructed to be selective, since most closed-lost deals shouldn't be resurrected. For anything flagged worth resurrecting, Claude drafts a short re-engagement angle grounded in real Fortavault products and competitive positioning, then the workflow sends an interactive Slack approval message for that one deal — reopen it, or skip it.

On approval, the opportunity is reopened in Salesforce (moved back to Qualification, close date pushed out 90 days), a high-priority follow-up task is created with the drafted angle as the task description, and every decision — approved, declined, or skipped — is logged to an n8n Data Table for a full audit trail. When a run flags more than one deal at once, each gets its own independent Slack approval cycle in sequence rather than being bundled into a single wait — a real bug I hit and fixed mid-build, after the first multi-deal run silently dropped the second approval.

Daily Salesforce scan → Claude assesses each Closed Lost opp → Flagged deals looped one at a time → Slack approval per deal → Reopened + follow-up task created → Logged to Data Table

Assessor System Prompt

Same Fortavault context as above, with a different job: be skeptical by default, and only surface deals with a genuine, time-sensitive reason to revisit.

You are a deal-resurrection assessor for Fortavault, Inc., a fictional data protection and security platform (cloud backup, ransomware recovery, zero-trust access, and compliance reporting). Products: Fortavault Backup Cloud, Fortavault Shield (ransomware detection + one-click rollback), Fortavault Access (zero-trust), Fortavault Insights (compliance reporting). Key competitors: Veyron Data, Ashcombe Systems, Cyphertide, Northgate Cloud Security, Ridgeline Compliance. You review Closed Lost opportunities and decide whether it is worth re-engaging the account now. Be selective - most closed-lost deals should NOT be resurrected. Only flag ones where the stated loss reason plausibly could have changed given how much time has passed (e.g. a budget freeze may have thawed, a point-in-time staffing gap may be resolved), or where the deal size clearly justifies a second look. If worth resurrecting, draft a short reengagementAngle: 2-3 sentences a rep could paste into an email or LinkedIn message, referencing the original context and a specific reason to revisit now, grounded in real Fortavault products and competitive positioning where relevant. Respond with a JSON object with exactly three fields: worthResurrecting (boolean), rationale (a 1-2 sentence explanation for the rep, private - not sent externally), and reengagementAngle (the drafted opener text, or an empty string if worthResurrecting is false).

Live Run

The Dead Deal Necromancer workflow graph in n8n
The live workflow graph in n8n — Salesforce scan, selective AI assessment, one-at-a-time Slack approval loop, and Salesforce/Data Table logging on every branch.
Two dead-deal resurrection approval messages posted to Slack
Two real flagged deals from a live run — each with the deal amount, original close date, Claude's why-now rationale, and a drafted re-engagement opener, waiting on a rep's approve/skip.

Impact (measured from live runs)

5
Closed Lost opps assessed per run
2 of 5
correctly flagged worth resurrecting
$110K
pipeline flagged for re-engagement across the two deals

Sales Enablement

The Battlecard That Updates Itself

~4 min read

A weekly scan cross-references simulated competitor signals against real Salesforce Closed Lost deals, has Claude draft the battlecard update, and only logs it once a human approves it in Slack.

n8n Cloud · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Battlecards rot the moment they're written. A rep loses a deal to a named competitor, the loss reason gets typed into a CRM field, and then nothing happens — the positioning doc a different rep reads before their next call still says whatever it said last quarter. Nobody's job is to notice that a competitor just changed pricing, or that the same competitor has quietly shown up in three real losses in a row. The update only happens when someone remembers to go looking, which is to say rarely.

A founding product marketer on LinkedIn described spending three weeks on a battlecard, then checking the analytics six months later: “It had exactly 3 views. 2 of them were mine.”

A competitive-intelligence vendor’s 2024 industry survey found 58% of CI professionals struggle to keep battlecards and content up to date. Another vendor’s review of real battlecards found only 43% include talk tracks and only 19% include proof points. Stale and thin is a hard combination for a rep to trust on a live call.

The Build

Fortavault's five competitors (Veyron Data, Ashcombe Systems, Cyphertide, Northgate Cloud Security, Ridgeline Compliance) are fictional, so there's no real pricing page or funding announcement to scrape — a mock signal feed stands in for that: one simulated pricing, review-sentiment, funding, positioning, or layoff signal per competitor, each with a fixed weight. What's real is everything downstream of it. A weekly scheduled run pulls every Closed Lost opportunity out of Salesforce, and a Code node matches each one's loss-reason notes against the five competitor names, tallying real loss counts and real dollar totals per competitor. Each real loss adds 3 points to that competitor's mock signal weight to give an urgency score (the dollar totals go to Claude as context, not into the score), and whichever competitor scores highest — not whichever the workflow author feels like — is the one that gets its battlecard section rewritten this cycle.

Only the top-scoring competitor's signal, real loss summary, and current battlecard text get handed to Claude, which drafts a revised positioning paragraph and objection-handling paragraph grounded specifically in the real losses it was given — explicitly instructed not to invent a loss pattern that isn't in the data. The draft posts to Slack as an approval request, and the battlecard only actually updates — written to a Data Table that's the system of record for the current positioning — if a human clicks Approve. Skip it, and nothing changes; the current text stands until the next cycle finds a better reason to touch it.

Weekly Salesforce scan → Code node: match losses to competitors + score urgency → Claude drafts the battlecard update → Posted to Slack for approval → Approved → logged to Data Table

Real vs. Simulated

The competitor signal feed is deliberately mocked — there's nothing real to scrape for a fictional company's fictional rivals. The grounding is real: the Salesforce query pulls actual Closed Lost opportunities, and the real count of losses naming each competitor in their loss-reason notes is what decides which competitor's battlecard gets touched and how urgently, not an assumption baked into the workflow.

A Real Salesforce Limit I Hit Mid-Build

The original plan was to filter the SOQL query itself — pull only Closed Lost opportunities whose Description mentions one of the five competitor names, right in the WHERE clause. Salesforce rejected it: Description is a long text area field, and those can't be used in a WHERE or LIKE filter at all — a real SOQL restriction, not a permissions issue. The fix was to stop trying to filter server-side: the query now pulls the 200 most recent Closed Lost opportunities with no competitor filter, and the Code node does the competitor-name matching client-side with a plain substring check against Description. The same shape as the Funnel Leak and Event ROI builds' workarounds — when Salesforce won't let you filter on a field, pull broader and filter after.

Battlecard Update Drafter — System Prompt

This is the exact system prompt sent to Claude for the drafting step, unedited from the live workflow. An early version left the output format unconstrained and Claude wrote multi-paragraph, markdown-heavy copy that blew past Slack's block character limit (see below) — this version explicitly locks down length, tone, and structure (on the live run below Claude still overshot the 500-character cap by a few words, so the Slack message also trims each field at 500 characters as a backstop):

You are a competitive intelligence assistant for Fortavault, Inc., a fictional data protection and security platform (cloud backup, ransomware recovery, zero-trust access, compliance reporting). Products: Fortavault Backup Cloud, Fortavault Shield (ransomware detection plus one-click rollback), Fortavault Access (zero-trust), Fortavault Insights (compliance reporting). Key competitors: Veyron Data, Ashcombe Systems, Cyphertide, Northgate Cloud Security, Ridgeline Compliance. You are given a simulated competitive signal (pricing, review sentiment, funding, or layoffs) for one named competitor, plus real Salesforce Closed Lost opportunities whose loss-reason notes actually name that competitor. Revise the positioning paragraph and the objection-handling paragraph for this competitor so a rep reading it before a call understands what changed and why it matters, grounded specifically in the real losses given (cite the pattern in them, do not invent details not provided) and the simulated signal. If there are zero real losses for this competitor, say so explicitly rather than inventing one, and let the urgency rationale reflect that the update is signal-driven only. Write updatedPositioning and updatedObjectionHandling as plain, concise prose with no markdown formatting, no headers, no bullet lists, and no bold text - a rep needs to scan this in seconds, not read an essay. Each of those two fields must be at most 500 characters and 2-3 sentences. Keep urgencyRationale to one plain sentence, at most 220 characters. Respond with a JSON object with exactly three fields: updatedPositioning, updatedObjectionHandling, and urgencyRationale.

Battlecard Update Drafter — User Prompt Template

Built from the Code node's output, so every number in it is real: the competitor name, the signal, and the actual loss count and dollar total pulled from Salesforce that cycle.

A competitive signal has been detected for Fortavault against {{ $json.competitorName }}. Signal type: {{ $json.signalType }} Signal detail: {{ $json.signalDetail }} Real Salesforce Closed Lost opportunities naming this competitor: {{ $json.realLossCount }} (total ${{ $json.realLossTotalAmount }}) {{ $json.realLossSummary }} Current battlecard positioning: {{ $json.previousPositioning }} Current objection handling: {{ $json.previousObjectionHandling }} Urgency score: {{ $json.urgencyScore }} ({{ $json.urgencyLabel }}) All competitor scores this cycle: {{ $json.allScoresSummary }} Draft the updated battlecard section for this competitor.

A Real Slack Limit I Hit Mid-Build

The first live run's approval post failed outright with an invalid_blocks error — Slack's Block Kit caps a single section's text at roughly 3,000 characters, and an unconstrained draft from Claude (headers, bold, numbered lists, several paragraphs) blew past it. Fixed two ways: tightened the system prompt above to mandate plain prose under 500 characters per field, and added a defensive .slice(0, 500) / .slice(0, 220) directly in the Slack message expression as a backstop regardless of whether the model actually complies.

A Real Run

This is the actual draft from a live run, unedited. Out of all five competitors, Northgate Cloud Security scored highest — urgency 12, against Ashcombe Systems at 11, Veyron Data at 8, Cyphertide at 5, and Ridgeline Compliance at 1 with zero real losses — driven by 3 real Closed Lost opportunities naming Northgate, totaling $171,775:

Northgate now sells a formal Platform Consolidation tier priced to replace three or more point solutions, and three recent losses totaling $171,775 confirm prospects in retail and legal are buying it. Counter by reframing consolidation risk: a bundled tier that spans backup, detection, and compliance cannot match the recovery-time guarantees of Fortavault Shield or the audit-ready depth of Fortavault Insights. Fortavault is the consolidation play for buyers who cannot afford a gap when ransomware hits or an auditor asks. When a prospect cites one vendor simplicity, do not just concede the appeal — name the trade-off directly: Northgate's consolidation tier is priced for breadth, which means shallower ransomware rollback and thinner compliance reporting. Ask what their recovery time objective is and whether their auditors accept summary-level reports, then show Shield's one-click rollback benchmark and an Insights audit export side by side to make the depth gap concrete. Why now: Three confirmed losses on the identical consolidation objection plus Northgate's new formal pricing tier make this the highest-priority battlecard update this cycle.

A Gap Found in Review: Approvals Weren't Read Back

The first version logged every approved rewrite but never read that log again: each week's draft started from the original hard-coded battlecard text, so an approval didn't change what the next cycle worked from, and the title overstated it. A review of this write-up caught the gap. The workflow now reads the Battlecard Update Log before scoring and uses the latest approved positioning and objection handling for each competitor as its current text. A test run confirmed the next Northgate draft now starts from the version approved on August 31, and the approval message says where the current text came from. The next scheduled Wednesday run did the same for real: its approval request reads “Current text came from: approved update logged 2026-08-31.”

Live Run

The Competitive Battlecard Auto-Updater workflow graph in n8n
The live workflow graph in n8n — weekly Salesforce scan, the read-back of approved updates from the Battlecard Update Log, the urgency-scoring Code node, the Battlecard Update Drafter agent with its Anthropic model and structured output parser, the Slack approval gate, and the branch to Data Table logging or skip.
The real Battlecard Update approval post in Slack
The real Slack approval post from the run above — Northgate Cloud Security's updated positioning and objection handling, the urgency rationale, and the Approve Update / Skip buttons.
A scheduled Battlecard run starting from the previously approved Northgate text
A later scheduled run after the fix: the Northgate draft now builds on the version approved on August 31, and the message says so. The positioning field is still trimmed at 500 characters as a backstop.

Impact (measured from live runs)

12
urgency score for the winning competitor (High)
3 deals
real Closed Lost opportunities grounding the update, $171,775 total
1 click
human approval standing between every draft and the system of record

The Slack Deal Room Concierge

~3 min read

When a real Salesforce deal crosses into Negotiation/Review, n8n spins up a dedicated Slack channel with live deal context — and when it closes, Claude summarizes the room's actual activity before archiving it and logging the outcome.

n8n Cloud · Salesforce (OAuth2) · Slack API · Anthropic Claude (Sonnet 4.6) · n8n Data Tables

The Problem

Deal-specific Slack channels are useful right up until they aren't: someone spins one up by hand once a deal gets serious, names it whatever felt right that day, and forgets to archive it when the deal closes. Six months later the workspace is full of stale #big-deal-copy channels nobody remembers the outcome of, and the context that actually mattered — why it closed, what almost killed it — just evaporates along with the channel instead of getting captured anywhere.

A growth executive on LinkedIn described what usually happens instead: teams log a lost deal with a dropdown, write “price” or “timing,” and move on. “No learning. No improvement.”

The lessons are the expensive part to lose. A win-loss research firm’s 2025 industry survey found only 39% of companies run an ongoing, cross-functional win-loss program, so most never systematically capture why deals closed or died. A digital- sales-room vendor’s survey found the most common complaint about deal rooms was reps not keeping them updated.

The Build

Two independent scheduled polls, tied together by one Salesforce opportunity ID. The first checks hourly for opportunities that have reached Negotiation/Review and aren't already tracked in a Deal Room Registry Data Table — the registry is both the dedup guard, so a deal already in flight doesn't get a second channel next hour, and the audit trail the brief asked for. A new deal gets a channel name built from the account and opportunity ID, a real Slack channel created for it, and a deal-context message posted with the amount, stage, target close date, and next step pulled straight from Salesforce.

The second poll runs hourly, at half past the hour, against every row the registry still has marked open, re-checking that opportunity's live Salesforce status. The moment one comes back closed, n8n pulls that channel's real Slack message history, hands it to a Claude agent with structured output to write a plain-English recap of what actually happened in the room, archives the channel for real, posts the recap to a shared team channel, and updates the registry row with the outcome and summary.

Hourly Salesforce poll: stage = Negotiation/Review → Dedup against Deal Room Registry → Create Slack channel + invite → Post real deal context → Log to registry
Hourly poll (:30): open rooms in registry → Re-check Salesforce status → Closed? → fetch real channel history → Claude summarizes it → Archive channel + post recap + update registry

Real vs. Simulated

Every step that touches Salesforce or Slack is real: real opportunity data, a real channel created and later really archived, a real Claude summary grounded in the real message history of that specific channel. The one deliberate simplification is who gets invited — a production version would pull the deal's AE, SE, and manager from Salesforce Owner/role data and invite all of them for real. Fortavault doesn't have distinct real reps behind these seeded opportunities, so the workflow invites only its own owner for real and names the rest as simulated directly in the message it posts into the channel, rather than quietly faking additional invites. For this demo the room-creation query is also scoped to the two seeded deal-room accounts, so the third seeded deal (Cordwainer, still at Proposal) was outside the query rather than screened out by the stage filter.

A Real n8n Bug: Flat, Not Nested, Slack API Response

The channel-creation step returns Slack's API response completely flat — { id, name, ... } — not nested under a .channel key the way a couple of other Slack resources are. I wrote all three downstream references (the invite step, the deal-context post, and the registry log row) pointing at .channel.id, which silently evaluated to undefined every time. Slack rejected the invite call with invalid_arguments, the context message posted to whatever undefined coerced to, and the registry logged an empty channel ID — three broken values traced back to one wrong assumption about the response shape, fixed once I actually inspected the raw node output instead of trusting my memory of it. (Two real channels had already been created against this bug before it was caught; rather than risk a Slack name_taken error by recreating them, I patched each one's remaining steps against its already-existing channel ID and backfilled its registry row by hand.)

A Real n8n Bug: Salesforce's Boolean Rejected by Strict Type Validation

The close-detection IF node checks the opportunity's IsClosed field against Salesforce — a field that comes back as a genuine JSON boolean. With the IF node's default strict type validation, n8n still threw Wrong type: '' is a string but was expecting a boolean, because the boolean operator's unused right-hand comparison value defaults to an empty string, and strict mode wouldn't reconcile that default against the operator's declared type. Switching that one condition to loose type validation fixed it outright — a reminder that n8n's strict mode can trip over its own placeholder defaults, not just genuinely mismatched data.

A Real Close, Summarized by Claude

This is the unedited output from a live run: the Halberd Insurance Partners deal really closed Won in Salesforce, and Claude wrote this recap from the real Slack message history of its deal room before the channel was archived:

Fortavault Shield closed won with Halberd Insurance Partners at $98,000 after a clean security review and procurement sign-off. The deal room opened with the opportunity in Negotiation/Review stage, with the key outstanding item being security review sign-off from Halberd's IT team. That review came back clean with no blockers, clearing the path to the final hurdle: procurement approval. Procurement signed off shortly after, and the deal was closed out as Won at $98,000. The room saw no open discussion or back-and-forth — activity was limited to automated stage updates tracking the deal's straightforward progression to close.

Live Run

The Slack Deal Room Concierge workflow graph in n8n, both scheduled polls
The live workflow graph in n8n — the hourly room-creation poll on top, the hourly close-detection poll (offset to :30) with the Claude summarizer agent underneath.
The real Slack deal room channel opened for Northwind Freight Co
A real deal room the workflow created — #deal-northwind-freight-co-xp3aaj, with the real Salesforce deal context the bot posted on open.

Impact (measured from live runs)

$98,000
real Closed Won deal auto-archived with a Claude-drafted room recap
2
real Slack deal rooms created live from real Salesforce opportunities
2 / 2
seeded Negotiation/Review deals got a scoped private room with live deal context

The Deal-Moment Playbook

~5 min read

Instead of a content portal reps have to search, the right asset comes to them when something happens on a deal: it moves to a new stage, a competitor shows up in the notes, or it sits past the stall line. Code picks the asset, Claude writes one line on why it fits, and every delivery is logged so the next build can measure what works.

n8n Cloud · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

The most common complaint about sales enablement isn't that the content is bad. It's that nobody uses it. Industry surveys put unused marketing content at around two thirds, and one survey of revenue leaders found reps spending two to five hours a week just looking for the right file. Reading through what enablement and sales leaders post on LinkedIn, the same diagnosis keeps coming up from a different angle. One post argued that teams don't need more assets, they need the right one at the moment it matters. Another warned that a rep who can't find a case study in seconds while live with a buyer will pitch from memory. An enablement leader with three decades in the field put the fix most precisely: guidance works when “the trigger is clear and observable,” the guidance fits that moment, and the rep never has to leave their workflow to act on it.

The Build

This build takes that literally. Every hour on weekdays, n8n reads the open opportunities in Salesforce and looks for three observable moments. A stage change is caught by comparing each deal's stage with the last run's snapshot; a deal seen for the first time is only recorded, so turning the workflow on doesn't flood Slack. A competitor mention is a named rival in the deal's description or next step. A stall is a deal that has sat in its stage past twice the median for that stage, the same stall line the Pipeline Forecast Engine uses. Deals whose close date passed more than 180 days ago are left out, which drops the org's old Trailhead sample deals.

Each moment is matched to a content library in code. The moment type has to fit, the stage has to fit (battlecards fit any stage), and industry-specific assets only match their own industry. The score is simple: 5 for the right competitor, 3 for the stage, 3 for the industry, and the top two assets go out. Where nothing fits as well as it should, the code records a content gap: an industry with no asset of its own at that stage, or an account with no industry on record, so only generic content can match. Claude gets the picks only after the code has made them, and writes one sentence per pick on why it fits this deal right now and how to open with it. Each deal-moment is sent once, and every delivery is logged.

Weekday hourly: open Salesforce deals + last run's stage snapshot + delivery log → Detect moments in code: stage entered, competitor named, stalled past 2× median → Match assets by moment, stage, industry and competitor; record content gaps
Claude writes one line per pick, never chooses → One Slack digest, grouped by deal → Every delivery logged; stage snapshot updated

Real vs. Simulated

The deals, stages, amounts, industries and deal notes are live Salesforce data, and the moments in both runs below were detected from them. The content library is seeded: 19 Fortavault assets (battlecards, case studies, a pricing guide, a close-plan template and so on), each tagged with the stages, industries, competitor and moment types it suits. Fortavault is a fictional company, so there is no real library to read. The stall lines come from the seeded stage history behind the Pipeline Forecast Engine. To show the stage-change trigger working end to end, I moved one seeded deal, Pemberton University, from Proposal/Negotiation to Negotiation/Review in Salesforce between the two runs. In production each rep would get their own deals in a direct message; this org has one real user, so the digest goes to a shared channel.

Real Results

The first live run found 7 current Fortavault deals and recorded their stages. It caught 6 moments on 5 of them and sent 7 assets. Northfield Regional Bank's notes name Veyron Data, because that deal was lost to Veyron before the Dead Deals build reopened it, so the Veyron battlecard went out. Five deals were past their stall lines. One example from the digest, exactly as posted:

Fortavault Shield + Insights - Northfield Regional Bank · Banking · $62K · Qualification ⚔ Veyron Data named in the deal notes → Battlecard: Veyron Data (battlecard) With Veyron Data in the notes, use this battlecard with an IT Director audience to concede Veyron's lower sticker price, then shift the conversation to recovery speed—Shield's minute-level rollback versus Veyron's hours of downtime. ⏳ 54d in Qualification (stall line 42d) → Stalled-Deal Re-engagement Email Kit (email kit) At 54 days—12 past the stall line—use this email kit to re-engage the champion at Northfield Regional Bank by leading with a recent banking industry incident or a Fortavault development, not a generic check-in. 🧩 Content gaps for enablement: No Banking asset for Qualification; No Healthcare asset for Qualification; Account has no industry in Salesforce, so only generic assets can match; No Transportation asset for Negotiation.

After Pemberton moved stages, the next run caught exactly one new moment. The other six were already sent and weren't repeated. Pemberton is a higher-education account entering negotiation, so it got the Higher Ed budget-cycle pricing guide (stage and industry match) and the security questionnaire and DPA pack.

A Real Wording Bug: A CFO Nobody Had Met

The first run, with Slack and logging switched off, told the rep to “bring this calculator to Castleton Freight Co.'s CFO.” Nothing in Salesforce says Castleton has a CFO involved. “CFO” was the asset's intended audience, and Claude turned it into a person on the deal. The prompt now treats the persona as an audience only, and the live line reads “share this calculator with a finance audience if a CFO is involved.”

Live Run

The Deal-Moment Playbook workflow graph in n8n
The live workflow graph in n8n: deals, content, stage history, the last stage snapshot and the delivery log load first; code detects moments and picks assets; Claude explains each pick; the digest posts, deliveries are logged and the stage snapshot is updated.
The first live Deal-Moment Playbook digest in Slack
The first live digest: 6 moments on 5 real deals, the asset picked for each with Claude's one-line why, and the content gaps the library couldn't cover.
The second run catching Pemberton University's move into Negotiation/Review
The next run after Pemberton University moved into Negotiation/Review: one new moment, the Higher Ed pricing guide and the security pack, and nothing from the first run repeated.

Impact (measured from live runs)

0 searches
reps never open a content portal: the asset arrives in Slack when the deal moment happens
7 moments
caught across 6 real deals in two live runs: a competitor mention, five stalls and a stage change
4 gaps
content gaps surfaced for enablement on the first run, instead of reps quietly improvising

The Content-to-Revenue Tracker

~5 min read

Every month, the Deal-Moment Playbook's delivery log is joined to real Salesforce win/loss outcomes. Each asset is compared with deals that hit the same moment without it, so content isn't credited or blamed for where in the funnel it gets sent. The result is a keep/review list, the biggest content gaps, and an honest answer on what can't be measured yet.

n8n Cloud · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

The second complaint that follows enablement teams around is that they can't prove anything works. Revenue leaders in one end-of-year survey said they track content effectiveness poorly or not at all. On LinkedIn, the frustration is blunter. One post claimed a third of enablement budgets are at risk because the return can't be shown, a vendor's figure, so treat it loosely. Another described most playbooks as “an internal museum: comprehensive, polished, and ignored.” The usual answer is a dashboard of views and downloads, which says what got opened, not whether it helped close anything.

The Build

Once a month, n8n joins every delivery the Deal-Moment Playbook has logged to the real won/lost outcome of each closed deal in Salesforce. The obvious comparison, win rate with an asset versus the overall win rate, is wrong in a predictable way. Content sent at negotiation only ever reaches deals that survived that far, so it looks like a winner. Content sent to stalled deals looks like a loser, because stalled deals lose more no matter what anyone sends.

So the code compares like with like. For every closed deal that received an asset, the expected win chance is the win rate of deals that hit the same moment without it: reached the same stage, or stalled in it, and shared the same industry or competitor when the asset is specific to one. Expected and actual wins are summed across those deals and tested for significance. An asset is only called out if the gap clears p < 0.05 with at least five deals behind it. The same pass lists assets nobody has been sent in 90 days, assets nobody has reviewed in six months, and the industries where deal moments keep finding no content of their own. Claude writes a short note on the finished numbers, and every run is logged.

Monthly: delivery log + closed Salesforce deals + stage history + content library → Per asset in code: actual wins vs. wins expected from deals at the same moment without it → Verdict, unused and stale flags, content gaps by industry
Claude writes the note, never the numbers → Table + review list + gaps to Slack → Per-asset snapshot logged

Real vs. Simulated

The 87 closed deals, their won/lost outcomes (61 won, a 70% baseline), their industries and the competitors named in their notes are real Salesforce data, and the analysis runs live on them. The Playbook only started logging this week, so a one-off setup workflow seeded the delivery history. It replayed the Playbook's own matching rules over the seeded stage history behind the forecast build: each stage a deal entered, each stall past the line and each competitor in its real notes got the asset the Playbook would have sent. That produced 551 seeded deliveries alongside the live ones. No outcome was planted. Which deal received what depends only on how far it got, how long it sat, its real industry and its real notes. Even so, the verdicts below demonstrate the method on seeded history rather than prove which Fortavault content works.

Real Results: What Can and Can't Be Measured

The live run's verdicts, excerpted from the Slack post:

Asset 90d deals won vs matched verdict FV-15 Mutual Close Plan Template 17 57 97% 98% vs 100% no measurable difference FV-13 Cost-of-Downtime ROI Calcul… 2 35 91% 97% vs 85% no measurable difference FV-14 Security Questionnaire and … 14 63 97% – no comparison group FV-16 Stalled-Deal Re-engagement … 5 12 25% – no comparison group FV-02 Ransomware Recovery Benchma… 3 75 81% – no comparison group FV-11 Higher Ed Budget-Cycle Pric… 2 3 67% – too thin Review list: unused in 90 days: FV-04, FV-05, FV-06, FV-07, FV-08, FV-09, FV-12, FV-17, FV-19 Not reviewed in 180+ days: FV-06, FV-07, FV-11, FV-19 Biggest content gaps: Manufacturing (30 moments), Energy (27), Insurance (24), Legal (23)

The most useful finding is the one most content reports never make. Nine of the 19 assets have no comparison group: a rules-based playbook sends them to every deal that hits their moment, so there is nobody left to compare against. The security questionnaire shows a 97% win rate, but every deal that reached negotiation got it. That number says nothing about the asset. Measuring them would mean holding a share of eligible deals out or rotating between two assets, which is the natural next step for the Playbook. The two assets that could be measured show no significant difference. The ROI calculator's 97% against an expected 85% (z = 1.71) is the closest thing to a signal, and it falls short.

A Real Analysis Bug: The Stall Kit Looked Like a Failure

The first version compared every asset with deals that merely reached the same stage. On the test run it flagged the stalled-deal email kit as underperforming, 25% won against 79% expected, at z = −4.61, the most confident verdict in the report. It was wrong. The kit only goes to stalled deals, and stalled deals lose more whatever is sent to them. Measuring the stall itself, not the content, would have had enablement retire a perfectly reasonable asset. The comparison now matches the moment, not just the stage: stall content is measured only against other stalled deals. With that fix, the kit correctly shows “no comparison group,” since every stalled deal got it. A separate problem surfaced on the first live attempt. Claude's note came back in the wrong format and the run stopped, so the note step now retries automatically.

Live Run

The Content-to-Revenue Tracker workflow graph in n8n
The live workflow graph in n8n: outcomes, stage history, the content library and the delivery log load; code computes every verdict; Claude writes the note; the review posts to Slack and a per-asset snapshot is logged.
The real monthly Content-to-Revenue review in Slack
The real monthly review: Claude's short note, the per-asset table against moment-matched baselines, the review list, the biggest content gaps, and the seeded-history caveat.

Impact (measured from live runs)

1 false verdict
caught before it shipped: the stall kit's z = −4.61 “failure” was the stall, not the content
9 of 19
assets honestly reported as unmeasurable under rules-based delivery, instead of given flattering win rates
9 + 4
assets unused in 90 days and assets overdue for review, each named on the monthly list

The Ramp Diagnostic

~4 min read

When new hires seem slow to ramp, the usual response is more coaching or a new onboarding module. This build asks first where in the funnel new reps actually fall behind tenured ones. It tests each stage for significance, and only names a stage when the gap is real.

n8n Cloud · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Most companies take three to six months to get a new rep productive, and many take longer. Research cited across the enablement world says sellers forget most of their training within a week. So when ramp looks slow, the instinct is to add something: more call coaching, another module. One Head of Revenue Enablement told a story on LinkedIn about exactly that request. Sales leaders asked for more live coaching because new hires were ramping slower. Her team looked at the data first and found the reps weren't losing deals so much as advancing ones that were never going to close. The fix was better discovery training, not more coaching. Her takeaway: “Enablement's job isn't to react.” This build is that diagnosis step, automated.

The Build

Once a month, n8n splits closed deals into those owned by a rep in their first 180 days and those owned by tenured reps. For each stage, it counts how many deals that reached the stage moved on to the next stage, or to a win from negotiation, and compares the two cohorts with a two-proportion z-test. It also compares median days in stage. A stage is called out only if new hires convert significantly less (p < 0.05) with at least five deals on each side; anything thinner is labeled too thin rather than guessed at. The code also finds the largest directional gap and lists the Playbook content that exists for that stage. If a gap is ever real, the first question is whether new hires are getting and using what's already there.

Claude writes three things from the finished numbers: the diagnosis, what leadership should and shouldn't do with it, and the caveat. The prompt is explicit that a non-significant gap must be called non-significant, and that prescribing a fix on noise is the failure this report exists to prevent.

Monthly: rep roster + deal owners + stage history + content library → Per stage in code: new-hire vs. tenured conversion, z-test, median days → Flag a stage only if significant; otherwise name the largest gap as not significant
Claude: diagnosis, what not to do yet, caveat → Stage table + note to Slack → Per-stage snapshot logged

Real vs. Simulated

The won/lost outcomes of the 87 closed deals are real Salesforce data. The stage paths come from the same seeded stage history as the forecast build. The reps are seeded, because this Salesforce org has exactly one real user. The roster has three tenured account executives and six hires staggered about every five months, a realistic shape for a growing team. Each closed deal was assigned an owner at random from the reps who had started by the time it opened, with a fixed seed so the result can be reproduced. Random assignment is deliberate. It means no cohort effect was planted, so any gap the diagnostic finds in this data is chance by construction. That makes this run a test of the thing that matters most: whether the diagnostic stays quiet when there's nothing there.

Real Results: Nothing to Fix, and It Says So

87 closed deals: new hires won 12/15 (80%), tenured 49/72 (68%), z = 0.92. Stage new hires tenured z median days verdict Qualification 15/15 100% 62/72 86% 1.53 20 vs 22 no significant difference Discovery 14/15 93% 55/62 89% 0.53 27 vs 33.5 no significant difference Proposal 12/14 86% 51/55 93% -0.83 26.5 vs 24 no significant difference Negotiation 12/12 100% 49/51 96% 0.7 21 vs 16 no significant difference No stage shows a statistically significant gap between new hires and tenured reps this cycle. The largest directional difference appears at Proposal, where new hires converted at 85.7% versus tenured reps at 92.7%, but this gap is not significant and could easily reflect normal variation across 87 closed deals. Before prescribing a fix: With nothing reaching significance, prescribing a fix—more call coaching, new onboarding modules—would be acting on noise. A larger closed-deal volume over the next one to two quarters would give the next read more statistical power and a more reliable signal.

That's the live note, unedited. A seven-point gap at Proposal is exactly what tends to start an onboarding project. Here it's correctly reported as noise.

A Real Seeding Bug: A Team Too Small to Test

The first seed added only three new hires. Their 180-day windows covered just three closed deals between them, so every stage came back “too thin”. That was the right answer for that data, and a useless one for a diagnostic. Real teams hire continuously, so the roster was re-seeded with six hires staggered across the period, giving 15 deals inside a ramp window and enough volume for every stage test to run. The same check is worth keeping in production. If a team has too few ramping reps to measure, the report says so instead of producing a percentage. The second test run also caught Claude naming an internal field (“flaggedStages is empty”) in the note. The prompt now keeps the prose free of field names.

Live Run

The Ramp Diagnostic workflow graph in n8n
The live workflow graph in n8n: roster, deal owners, stage history and content load; code runs the per-stage tests; Claude writes the diagnosis; the note posts to Slack and a per-stage snapshot is logged.
The real Ramp Diagnostic post in Slack
The real monthly post: the stage-by-stage table, no significant gap, the largest directional gap labeled as noise, and the instruction not to prescribe a fix yet.

Impact (measured from live runs)

0 false alarms
on randomly assigned deals, where any gap is chance by design: the diagnostic stayed quiet
4 stages
tested separately, so a real gap would point at a specific moment rather than “ramp” in general
7 pts
the Proposal gap that would usually start an onboarding project, correctly reported as not significant

The Stale Content Auditor

~4 min read

Product facts change faster than sales content gets reviewed. Every week, this build checks each asset in the enablement library against the current product, pricing and battlecard facts. It quotes every outdated claim word for word and marks the asset for update once a person approves.

n8n Cloud · Anthropic Claude (Sonnet 4.6) · Slack API (approval) · n8n Data Tables

The Problem

One of the most repeated complaints about enablement on LinkedIn is about content, not training. A sales leader put it bluntly: the playbook is out of date before a rep ever opens it. Pricing models change, a certification lands, a competitor launches a new tier, and the battlecard and the one-pager keep saying the old thing. Reps notice, stop trusting the library, and write their own material, which drifts further. The usual fix is a quarterly content review. By the time it happens, the wrong number has already gone out in a dozen emails.

The Build

The source of truth is a small Messaging & Product Facts table. Each fact has its current statement, the statement it replaced and the date it changed (rollback speed, pricing model, certifications, audit coverage, single sign-on, retention). The latest approved positioning from the Battlecard Auto-Updater counts as a fact for that competitor's assets. Once a week, code pairs every asset in the Deal-Moment Playbook library with every current fact. Claude reads each asset's full text and reports only claims the current fact contradicts, with the exact words from the asset. Code then checks every finding before anyone sees it. The quote must appear word for word in that asset, and the fact must be one code gave Claude for that asset. Anything else is dropped and counted.

The verified findings go to Slack as one approval message. It lists what is true now, then each asset with its outdated quotes. On approval, the assets are marked needs update with the exact claims to fix attached, and every finding is logged either way. Nothing is rewritten or archived automatically. The flag is also used downstream: the Micro-Coaching build holds back any asset marked needs update instead of sending it to a rep.

Weekly: content library + product facts + approved battlecards → Code pairs every asset with every current fact → Claude: outdated claims, quoted from the asset
Code: quote must match word for word, fact must be in scope → Slack approval → Assets marked needs update + every finding logged

Real vs. Simulated

Fortavault is a fictional company, so the 19 asset texts and the product facts are seeded. They are the same library the other Sales Enablement builds use. The seed has a written answer key: 11 outdated claims across 8 assets. It also has decoys, assets that mention the same topics with the current fact (“under 5 minutes”, “90 days”, “ISO 27001 certificate”), which must not be flagged. The Claude calls, the verification, the Slack approval and the library update are all live.

A Real Design Bug: A Review Date Isn't Proof

The first version only checked facts that changed after an asset's last review date. That seemed efficient: if someone reviewed it after the change, it should be current. The test run found 10 of the 11 claims and missed one. The Ridgeline Compliance battlecard was reviewed in March, after single sign-on support changed in February, and it still said Okta and Azure AD only. The reviewer had missed it, so the date filter missed it too. The auditor now checks every asset against every fact (115 pairs, still one Claude call) and labels this case explicitly: reviewed after this changed; missed. The rerun found 11 of 11 with no false flags.

The first live run also failed to post at all. The approval message was about 3,300 characters, over Slack's per-block limit. It now states each current fact once and lists one line per outdated quote (about 2,550 characters), with a guard that trims at a line break and points to the log if a future run is longer.

Live Run

The Stale Content Auditor workflow graph in n8n
The live workflow graph in n8n: library, facts and battlecards load; Claude finds outdated claims and code verifies each quote; the Slack approval decides; assets are marked and every finding is logged.
The real Stale Content Audit approval and result in Slack
The real approval: what is true now, then 11 outdated claims in 8 assets, each quoted from the asset. After “Mark for update”, the 8 assets were marked needs update with their claims attached.

Impact (measured from live runs)

11 of 11
seeded outdated claims found, with 0 false flags on the decoy assets
8 assets
marked needs update in one approval, each with the exact sentence to fix
1 missed review
caught that a date-based check would have skipped: reviewed after the change, still wrong

Stage-Triggered Micro-Coaching

~4 min read

Onboarding is front-loaded, but a new rep needs the Negotiation playbook the day their first deal reaches Negotiation. This build catches that moment and sends the rep a two-minute brief with current assets only. It asks one check question in Slack, grades the answer against a rubric, and quotes the rep's own words for every point it credits.

n8n Cloud · Salesforce API · Anthropic Claude (Sonnet 4.6) · Slack API (send and wait) · n8n Data Tables

The Problem

“Enablement isn't an event, it's a system” is one of the most repeated lines in LinkedIn posts about enablement, and usually a complaint about bootcamps. New hires get every stage of the sales process in their first two weeks. By the time their first deal reaches Negotiation, a month or two later, most of it is gone. The other half of the complaint, from frontline managers, is time. They know reps need reinforcement at exactly these moments, but with eight reps and a forecast call nobody checks whether a new rep knows what “done” means at the stage they just entered.

The Build

During business hours, n8n reads open Salesforce opportunities and compares each deal's stage with the last snapshot. Code decides who gets coached. The rep must be in their first 180 days. The deal must have moved forward into a new stage; first sightings are a baseline and backward moves are skipped. And the rep must not have been coached on that stage before. Tenured reps and repeat stages are counted and skipped. The stage's exit criteria, check question and rubric come from a Stage Playbooks table. Its assets come from the Deal-Moment Playbook library, filtered by stage and industry. Anything the Stale Content Auditor marked needs update is held back and named as held back.

Claude writes only the brief paragraph: what the stage is for, what done looks like on this deal, and which of the listed assets to use first. Code builds the rest of the Slack message from the tables and ends it with the check question. The workflow then waits for the rep's typed answer. A second Claude call grades the answer against the rubric and must quote the words that cover each point. Code credits a point only if that quote appears word for word in the answer. The feedback is built from the rubric too: credited points with the rep's own words, missed points with the asset that covers them. Every check is logged, so a manager can see which stages new hires struggle with without sitting in on calls.

Business hours: open Salesforce deals vs. last stage snapshot → Code: ramping rep, forward move, stage not yet coached → Stage playbook + current assets (stale ones held back)
Claude: two-minute brief → Slack: brief + check question, waits for the answer → Claude grades; code verifies each quote and scores → Feedback to Slack + coaching log

Real vs. Simulated

The deals, stages and stage change are real Salesforce data. The rep is seeded: this org has one real user, so the new hire, Nina Brooks (start date 14 September), was added to the same seeded roster the Ramp Diagnostic uses and given one open deal. The stage playbooks and rubrics are seeded for the fictional Fortavault. For the demo, the Cordwainer Legal Group deal was moved from Proposal to Negotiation in Salesforce through the API, then moved back afterwards. The answer was typed in Slack by me, playing Nina, and written to cover three of the four rubric points.

Real Results

Nina Brooks · Negotiation check on Cordwainer Legal Group: 3 of 4 (passes) ✓ Names who signs: "The managing partner signs" ✓ Lists the remaining steps with an owner or a date: "we need legal redlines and procurement sign-off, targeting signature by Oct 30" ✓ Will not discount without getting something back: "I'll only move on price in exchange for a two-year term" Before the next call • Plans to start security review now, in parallel with redlines → FV-14 Security Questionnaire and DPA Pack

The grade matched the answer's design exactly: three points credited with the rep's own words, and the one point the answer skipped sent to the asset that covers it. The brief also held back the Executive Business Case One-Pager. The Stale Content Auditor had flagged it ten minutes earlier for still quoting per-seat pricing.

A Real Bug: Moving Backwards Isn't a New Stage

Moving the demo deal back to Proposal exposed a gap. The detector only asked whether the stage had changed, so a deal sliding back from Negotiation to Proposal would have sent Nina a “first deal into Proposal” brief. Deals slip backwards all the time, and coaching a rep on a stage they already passed is noise. Code now compares stage order and counts backward moves separately. The rerun after the revert posted nothing, which was correct. The test run also showed the CRM notes contained text describing seed data. Claude ignored it, and the brief prompt now says to ignore such notes explicitly.

Live Run

The Stage-Triggered Micro-Coaching workflow graph in n8n
The live workflow graph in n8n: deals, reps, playbooks and content load; code detects first-time stage entries; Claude writes the brief and Slack asks the question; Claude grades, code verifies and scores; feedback posts and the check is logged.
The real coaching brief in Slack
The real brief on day 23 of Nina's ramp: what done means in Negotiation, three current assets, one held back by the Stale Content Auditor, and the check question.
The real graded feedback in Slack
The graded answer: 3 of 4, each credited point quoted from the answer, and the missed point linked to the security pack.

Impact (measured from live runs)

Day 23
of ramp: coaching arrived the moment the deal entered the stage, not in week one
3 of 4
rubric points credited, each backed by a word-for-word quote from the rep's answer
1 stale asset
held back automatically because the Stale Content Auditor had flagged it

The Message Drift Monitor

~4 min read

Messaging gets launched once and then drifts, one email at a time. Every week, this build reads reps' outbound emails against the messaging guide. It shows managers who is quoting outdated facts, who is making claims they shouldn't, and which pillars the team never uses, with every finding quoted word for word.

n8n Cloud · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

The scripted-versus-freestyle argument comes up constantly in LinkedIn threads about sales messaging. Full scripts make reps sound robotic; no guidance at all means every rep pitches a different product. As one sales leader put it, “Somewhere in the middle is the sweet spot.” That middle is a short messaging guide: a few pillars to lead with, the current facts, and a handful of things never to say. The trouble is that nobody can see whether reps actually follow it. Managers read a few emails when something goes wrong. The old pricing model or a promised roadmap feature goes out unnoticed until a customer quotes it back in a negotiation.

The Build

The guide lives in the same Messaging & Product Facts table as the Stale Content Auditor. It has six current facts (each with the outdated version it replaced), four messaging pillars and three prohibited claims: no absolute guarantees, no roadmap commitments, no discount above 15% without deal desk. Once a week, code collects the last 14 days of outbound email. Claude labels each claim in each email as an outdated fact, a prohibited claim or a pillar used, and returns the exact words. Claude never sees which rep wrote what. The prompt sets the edge cases: a sentence that states an outdated fact counts only as that fact, not as a pillar, and a discount at or below the limit is fine.

Code does the rest. A label counts only if its quote appears word for word in that email and its code exists in the guide. Code then tallies drift per rep, counts which pillars each rep and the team use, and builds the manager digest. Reps are ranked by issues, with a fix list that pairs each quote with what is true now or the rule it breaks. Every finding is logged, so a rep's drift can be tracked week over week.

Weekly: messaging guide + last 14 days of outbound email → Claude: outdated facts, prohibited claims, pillars used, each quoted
Code: verify quotes, score drift per rep, pillar coverage → Manager digest to Slack → Every finding logged

Real vs. Simulated

There is no real sales team sending email from this org, so the 12 outbound emails are seeded, three each from four reps. They are written to cover the range a manager would see: one rep fully on message, one mostly fine with a single old fact, one quoting five outdated facts, and one making all three prohibited claims. Each email carries an answer key: 9 issues and 9 pillar uses. There are also six decoys that use current facts or an allowed discount (“per protected TB”, “SAML or OIDC”, “90 days”, a 10% multi-year price) and must not be flagged. The digest scores the checker against that key on every run. That only works because the emails are seeded, and the digest says so. The classification, verification, scoring, Slack post and log are all live.

Real Results

12 outbound emails from 4 reps checked against 6 current facts, 4 pillars and 3 rules. Dana Whitfield · 3 emails · 5 outdated · pillars P4 (1 of 4) Tomas Rivera · 3 emails · 3 prohibited · pillars P1 (1 of 4) Priya Shah · 3 emails · 1 outdated · pillars P1 P2 P3 (3 of 4) Marcus Webb · 3 emails · on message · pillars P1 P2 P3 P4 (4 of 4) ⛔ Tomas (T3): "I can do 25% off the first year." Rule: Never offer a discount above 15% without deal desk approval. Dana (D1): "Backup Cloud is priced per user seat" Now: Backup Cloud is priced per protected TB with a 10 TB minimum; per-user-seat pricing was retired. Checker vs seeded answer key: 9 of 9 issues found, 0 false flags; 9 of 9 pillar uses, 0 extra.

An excerpt from the live digest. The test run and the live run both matched the answer key exactly, and none of the six decoys was flagged. One fix came from reading the first digest rather than the numbers. Three pillars were tied for least used, and the code named only the first. It now lists every pillar in a tie.

Live Run

The Message Drift Monitor workflow graph in n8n
The live workflow graph in n8n: the guide and the last 14 days of outbound load; Claude labels claims and code verifies and scores them; the digest posts to Slack and every finding is logged.
The real Message Drift Monitor digest in Slack
The real weekly digest: reps ranked by drift, a fix list with each quote and the current fact or rule, team pillar coverage, and the checker's score against the seeded key.

Impact (measured from live runs)

9 of 9
seeded off-message claims found (outdated facts and prohibited claims), in both the test and live runs
0 of 6
decoys flagged: current facts and an allowed discount were left alone
1 of 4
pillars used by the two drifting reps, versus 4 of 4 for the on-message rep

Marketing Measurement

The Multi-Touch Attribution Tracker

~5 min read

Every week, each Closed Won deal's touch history is run through three attribution models side by side: first-touch, last-touch and linear. The models are computed in code so their differences come from the data, and Claude's Slack note focuses on where they disagree, which is usually the most useful part.

n8n Cloud · Salesforce (OAuth2) · HubSpot API (App Token) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

An earlier build in this series tied one kind of event to revenue after the fact: which trade shows produced which deals. Marketing teams eventually ask the broader version of that question. Across every touch a buyer had before the deal closed, which channels actually contributed? Most answers pick one model and report its number. First-touch credits whatever started the conversation. Last-touch credits whatever happened to come right before the signature. Each one quietly defunds the channels the other one favors, and nobody sees the trade-off because only one number is ever on the slide.

A sales-operations CEO on LinkedIn watched a team prepare to cut content because a dashboard credited it with 3% of pipeline, even though most buyers had read it before sales ever heard their name. His summary: “Single-touch attribution is a comforting lie.”

The trade-off is widely felt even if it’s rarely shown. A research firm’s 2024 survey of 282 US marketers found 78% rely on last-click attribution, while only about one in five believe it reflects a channel’s real long-term impact. This build puts the models side by side so the gap is visible instead of buried.

The Build

Each week n8n pulls every Closed Won opportunity from Salesforce for the trailing twelve months, along with each deal's touch timeline in date order. A Code node applies three models to the same sequences. First-touch gives all of a deal's revenue to its earliest touch, last-touch gives it all to the latest touch before close, and linear splits it evenly across every touch. The results are rolled up by channel and by campaign. For each channel the code also computes the spread, the largest gap between its shares under the three models, and a simple pattern label. A channel whose last-touch share runs 10+ points above its first-touch share closes deals; the reverse opens them; anything else is consistent.

Claude gets the finished numbers and is told to write about where the models agree and disagree, not to restate each winner. It may describe a channel only by the pattern the code assigned. The Slack post leads with the three leaders and a side-by-side table, then the note. Every run's channel numbers are logged to an Attribution Snapshots table, so shifts in the mix show up over time. A live HubSpot check also runs every week and reports how many contacts have any tracked digital touches at all.

Weekly run: Closed Won deals from Salesforce + each deal's touch timeline + HubSpot touch coverage → First-touch, last-touch and linear over the same sequences, in code → Per channel: three shares, spread, opens / closes / consistent
Claude writes where the models agree and disagree, never the numbers → Leaders + side-by-side table + note to Slack → Channel numbers logged for the trend

Real vs. Simulated

The 41 Closed Won deals in the period, their amounts and close dates ($2.14M in total), the three models, the roll-ups, Claude's note and the Slack post are all real. So are the seven event touches: for the seven deals the earlier event-ROI build tied to trade shows, the touch is that build's recorded event and badge-scan date. Everything else in the touch timeline is seeded, and the reason is a real finding. The live HubSpot check reports that 0 of the portal's 11 contacts have a single tracked page view, form fill, email open or click. None of the won deals has a contact linked to it in Salesforce. And HubSpot can't backdate page views or form fills to before a deal closed. There is no real digital touch history to attribute, and the build says so in every post.

So a one-off setup workflow generated a touch sequence for each real won deal with a fixed rule: 2 to 6 touches spread over the 30 to 150 days before its real close date, with a fixed random seed so the 254 rows can be reproduced. The channel at each position is drawn from position-based weights. Paid search, organic search and content are likelier first; email nurture and webinars in the middle; a demo request last. That rule is the honest caveat for everything below. The opener and closer patterns the models find were built into the seed, so this run demonstrates the method rather than discovering which Fortavault channels work. The engine is the real part. Once HubSpot tracking is in place, it reads real timelines instead.

Real Results: Where the Models Disagree

Share of $2.14M in attributed revenue under each model, from the live run:

Channel First Last Linear Spread Email Nurture 0% 21.6% 23.2% 23.2 closes deals Webinar 3% 12.1% 18.8% 15.8 consistent Paid Search 27.6% 8.1% 12.9% 19.5 opens deals Organic Search 18.6% 11% 12.4% 7.6 consistent Content Download 24.6% 0% 11.9% 24.6 opens deals Demo Request 0% 34.2% 9.7% 34.2 closes deals Event 17.6% 0% 5.7% 17.6 opens deals Referral 8.5% 13% 5.4% 7.6 consistent

Every model crowns a different winner: paid search under first-touch, demo requests under last-touch, email nurture under linear. That's the point of running them side by side. Claude's unedited note, exactly as posted:

All three models agree that Organic Search and Referral contribute consistently, holding similar shares across first-touch, linear, and last-touch. The sharpest disagreements center on Demo Request (0% first-touch, 34.2% last-touch, 9.7% linear) and Content Download (24.6% first-touch, 0% last-touch) — spreads of 34.2 and 24.6 points respectively — confirming Demo Request closes deals others open while Content Download opens deals it never closes; Paid Search (27.6% first-touch, 8.1% last-touch) reinforces that opener pattern. A budget built on last-touch alone would over-reward closers and defund the openers feeding the pipeline; linear attribution suggests a more balanced allocation is warranted. The touch timeline is seeded (except the 7 Day 7 event touches), so the pattern reflects how the seed was built and is a demonstration of the method, not a finding; HubSpot currently tracks no digital touches for these 11 contacts.

A Real Wording Bug: Roles the Data Never Assigned

The first run, with Slack and logging switched off, read well, but Claude described organic search as a “mid-funnel” contributor. Nothing in the data says where in the funnel a channel sits. The code only labels channels as opening deals, closing deals or contributing consistently. A reader would take “mid-funnel” as a finding. The prompt now limits Claude to the pattern the code assigned, and the live note calls organic search “consistent.” The same test run caught $2.14M printing as “$2137K,” and the post now formats millions properly.

Live Run

The Multi-Touch Attribution Tracker workflow graph in n8n
The live workflow graph in n8n: deals, touch timelines and HubSpot coverage are loaded, three models are computed in code, Claude writes the disagreement note, then it's posted to Slack and logged.
The real Slack attribution post from a live run
The real Slack post: three different leaders, the side-by-side table with spreads and patterns, Claude's note on the disagreement, and the seeding and HubSpot-coverage caveats in the footer.

Impact (measured from live runs)

3 models → 3 winners
paid search, demo requests and email nurture each lead under a different model, on the same $2.14M
34.2 pts
the widest gap between models (demo requests), the budget decision a single-model report hides
0 of 11
HubSpot contacts with any tracked digital touch, a real tracking gap the tracker reports every week instead of hiding

Retroactively Tying Event Leads to Revenue

~3 min read

A weekly scan matches Closed Won Salesforce deals back to the trade-show badge scan that started them, computing true time-to-close and per-event ROI instead of a same-day guess.

n8n Cloud · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Event ROI almost always gets measured on the day the booth closes — badge scans collected, leads entered, a same-day estimate built on pipeline that hasn't actually gone anywhere yet. That number is fiction. The real payoff, if there is one, shows up months later when a badge scan either turns into a Closed Won deal or quietly dies, and by then nobody's still connecting that revenue back to the event that started it. So budget gets allocated on vibes and booth-traffic counts instead of on which events actually produced closed revenue.

A B2B market-intelligence founder’s roundup of field- marketing posts on LinkedIn summed up the practitioner view: “Same-week pipeline is just a faster badge scan,” while the real signal is the conversations still happening thirty days later.

An analyst firm’s 2024 survey of B2B tech marketers found 57% rank demonstrating event ROI as very important, and noted that event teams frequently struggle to prove their value. An event-platform vendor’s survey found the most-tracked event metrics are registrations and opportunities created, and one in five marketers can’t tie events to revenue at all.

The Build

This one stays deliberately single-system — Salesforce and Slack only, in the tradition of Days 5, 9, and 13 — because the whole point is retroactive, not real-time: a scheduled scan looks backward at deals that have already closed and reconnects them to where they started. Three mock events were seeded into Salesforce (SecureOps Summit 2025, CloudGuard Conference 2025, DataProtect World 2026), each with a badge-scan date and a handful of resulting Opportunities — some Closed Won anywhere from seven weeks to nine months later, plus a couple of Closed Lost and one still-open deal for realism, since a badge scan converting every time would be its own kind of fake.

A weekly scan pulls every Closed Won opportunity tied to those seeded accounts, and a Code node does the actual math deterministically: it parses the event name and badge-scan date back out, computes real days-to-close per deal, and rolls that up per event — deal count, total revenue, average/min/max time-to-close, and ROI against that event's cost. Only after the numbers are computed does Claude get involved, and only to do what a spreadsheet can't: compare the three events directly, explain whether speed-to-close or deal size is actually driving the ROI difference, and recommend where to put next quarter's event budget. The full breakdown posts to Slack, and every event's stats and Claude's per-event insight get logged to a Data Table for a trend line across future events.

Weekly Salesforce scan → Match Closed Won deals back to their badge scan → Code node: time-to-close + ROI per event → Claude compares events + recommends budget shift → Logged to Data Table → Posted to Slack

A Real Salesforce Limit I Hit Mid-Build

The plan was to tag event-sourced opportunities with Lead Source: Trade Show, the standard Salesforce value for exactly this case. This Trailhead Playground's Opportunity LeadSource picklist turned out to be restricted to just five values — Other, Partner Referral, Phone Inquiry, Purchased List, Web — with no Trade Show or Event option, and no standard field for a badge-scan date at all. Rather than force a write that Salesforce would reject, the workflow sets LeadSource: Other and encodes the real event name and badge-scan date as structured text in the Description field (Event Source: SecureOps Summit 2025 | Badge Scan Date: 2025-11-04), then parses it back out with a regex in the Code node. The same pattern the Funnel Leak build used for loss-reason notes, applied here because the platform's actual constraints, not the original plan, are what the build has to work around.

Time-to-Close + ROI Calculation

The core of the Code node, unedited from the live workflow — this is what turns a badge-scan date and a close date into a real, per-event ROI number:

const m = desc.match(/Event Source:\s*(.+?)\s*\|\s*Badge Scan Date:\s*(\d{4}-\d{2}-\d{2})/); if (!m) continue; const eventName = m[1].trim(); const badgeScanDate = m[2].trim(); const daysToClose = Math.round((new Date(opp.CloseDate).getTime() - new Date(badgeScanDate).getTime()) / 86400000); ... const roiPct = Math.round(((e.totalRevenue - e.cost) / e.cost) * 1000) / 10;

ROI Storyteller System Prompt

Same Fortavault context as the other builds, with a narrow job: compare the events on their real numbers and turn that into a budget recommendation, not a restatement of the stats.

You are a GTM analytics assistant for Fortavault, Inc., a fictional data protection and security platform (cloud backup, ransomware recovery, zero-trust access, compliance reporting). Products: Fortavault Backup Cloud, Fortavault Shield, Fortavault Access, Fortavault Insights. You are given real, computed Salesforce data tying event badge-scan leads to revenue realized months later - this is retroactive event ROI, not a same-day estimate. Read the numbers for a real pattern - do not guess generically. Respond with a JSON object with exactly three fields: headline (one sentence), narrative (4-6 sentences comparing the events and ending in a concrete recommendation for where to invest event budget next), and eventInsights (an array of objects, each with eventName and insight, exactly one entry per event listed, insight being one specific sentence grounded in that event's actual numbers).

A Real Run

This is the actual output from a live run, unedited — seven Closed Won deals across three events, with time-to-close ranging from 48 days to 271 days after the original badge scan:

SecureOps Summit 2025 delivered the highest ROI at 805.6% by landing three large, long-cycle enterprise deals — making it Fortavault's clearest case for doubling down on premium, security-focused events despite their slow payback windows. SecureOps Summit 2025 was the standout performer not because it closed fast, but because it attracted the right buyers: a municipal government, a fleet operator, and an insurance group, all of whom eventually committed to deals averaging over $54,000 each. That deal quality — not volume or speed — is what drove its 805.6% ROI on just an $18,000 investment, even though the sales cycle stretched to an average of 200 days. CloudGuard Conference 2025 sits in the middle of the pack: it cost less ($12,000), closed faster (avg 124 days), and still produced a strong 537.5% ROI, suggesting it attracts buyers who are further along in their evaluation — Wexford Legal Group closed in just 77 days, the joint-fastest deal across all three events. DataProtect World 2026, despite being the most expensive event at $25,000 and closing deals the fastest (avg 66 days), produced the weakest ROI at 186%, because the deal sizes were smaller — Callisto Financial Partners came in at only $19,500, dragging the average down even though Ferrowyck Manufacturing's $52,000 Shield deal was competitive. The pattern is clear: speed-to-close does not predict ROI; deal size does, and SecureOps-style events that draw regulated-industry and enterprise buyers consistently generate larger commitments. The concrete recommendation is to increase budget allocation toward SecureOps Summit 2025 and events like it, while scrutinizing DataProtect World's audience quality before renewing at the same spend level — faster closes mean little if the average contract value can't justify the booth cost.

One factual slip survives in that output: Claude calls Wexford Legal Group's 77 days the joint-fastest deal, but DataProtect World's fastest deal closed in 48. The per-event numbers the workflow computes are right; the narration got one comparison wrong, which is exactly why the ROI math lives in code and Claude only explains it.

Live Run

The Event ROI Time Machine workflow graph in n8n
The live workflow graph in n8n — weekly Salesforce scan, the time-to-close/ROI Code node, Claude's cross-event comparison, the merge back into per-event rows, Data Table logging, and the Slack post.
The real Event ROI Time Machine summary posted to Slack
The real Slack post from the run above — Claude's headline and narrative, plus the full per-event ROI breakdown computed by the Code node.

Impact (measured from live runs)

7
Closed Won deals retroactively tied back to their event
48–271 days
real spread of badge-scan-to-close time across events
465.5%
blended ROI: $311K revenue vs $55K event cost

The GTM Experiment Registry

~3 min read

Any team registers a GTM experiment through an n8n form — hypothesis, success metric, control/treatment definitions, a ship/kill threshold, an end date — a daily check finds the ones past their end date, pulls real Salesforce or HubSpot data depending on where the experiment lives, and Claude narrates a deterministic ship/kill/iterate verdict straight to a Slack digest before anyone has to remember to look.

n8n Cloud · Salesforce (OAuth2) · HubSpot (App Token) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

GTM and RevOps teams run small experiments constantly — a new proposal format, a landing-page change, a different follow-up cadence — but almost none of them get a clean, forced verdict. Nobody owns the end date, nobody goes back to actually check the metric against a threshold, and "did it work" either never gets asked or gets answered from memory weeks later. An experiment without something forcing a close-out just quietly becomes a permanent practice, whether or not it ever helped.

A lifecycle marketing manager on LinkedIn described an email test where version A “won” 5.8% to 4.2% and still couldn’t be called the winner, because the sample was about a third of what it needed. Her fix: “The solution comes before the test starts.”

A 2025 trade-publication survey of more than 1,000 brand marketers found only about a third run controlled experiments, and just 39% measure whether their work delivers business outcomes. Even disciplined programs mostly end without a clear win: an experimentation vendor’s analysis of 127,000 experiments found only 12% produced a statistically significant win on their primary metric. That is exactly why each test here gets a forced verdict instead of a slow fade into habit.

The Build

A form (Register a GTM Experiment) is the intake: experiment name, hypothesis, the metric that decides success, which system that metric lives in (Salesforce, HubSpot, or Clay), a plain-language control and treatment group definition, a minimum percentage-point lift required to ship, and an end date. Every submission is logged as a new row in a real n8n Data Table — the registry — and a confirmation posts to Slack immediately so the team that registered it has a record of what they signed up to be judged by.

A second trigger, a schedule that checks daily, is the actual auto-sunset: it reads every registry row still marked active whose end date has passed, then processes them one at a time through a batch loop so each experiment's data stays isolated from the next. A Switch node reads the experiment's own metricSource field and routes to one of three branches — Salesforce, HubSpot, or Clay — the same source-routing shape this series has used since Clay and HubSpot joined the toolkit mid-sprint, except this time a single runtime input, not a hardcoded branch, decides which system an entire experiment's logic pulls from. The Salesforce and HubSpot branches pull the real underlying records and compute a control-vs-treatment metric in a Code node (the Clay branch is a placeholder that returns no metric, so its verdict is always inconclusive), all three branches fan into one Merge node, and a deterministic Code node computes the lift and a ship/kill/iterate/inconclusive verdict against the experiment's own threshold — a rule, not a language model. That verdict, plus the real numbers behind it, goes to a Claude Sonnet 4.6 agent with a structured-output parser whose only job is to narrate the already-decided verdict in plain English and flag sample-size caveats; the system prompt is explicit that it must never override the rule, and the registry row and Slack digest record the rule's verdict itself rather than Claude's restatement of it. (An earlier version saved Claude's copy; a review caught it, and the rule's own verdict is now what gets stored and posted.) The registry row is marked closed with the real metrics and verdict, and a Slack digest goes out — then the loop moves to the next due experiment.

Form intake: name, hypothesis, success metric, metric source, control/treatment definitions, threshold, end date → Logged to a real n8n Data Table as the registry → Confirmation posted to Slack
Daily check: registry rows past their end date, processed one at a time → Switch routes by real metric source → Salesforce or HubSpot query computes control vs. treatment → Deterministic verdict, Claude narration, Slack digest, row closed, loop continues

Real vs. Simulated

The form intake, the Data Table registry, the daily schedule check, the real Salesforce SOQL queries and HubSpot contact fetches, the Switch-based routing, the deterministic lift/verdict computation, Claude's narration, and both Slack posts are all real, and both experiments run in this build were driven all the way through by that live logic, not mocked. The one seeded piece is the control/treatment group assignment: this Trailhead-scale org has no pre-existing GTM experiments sitting in it, so a one-time utility workflow tagged 12 real closed Salesforce Opportunities (6 Control / 6 Treatment, by appending a disclosed ExperimentGroup: ... marker to each record's real Description field) and 10 real HubSpot contacts (5 / 5, via the same marker appended to the real message property) before the main workflow ever ran. From that point forward the main workflow has no way to tell a seeded record from an organic one — it just reads the marker and computes off whatever it finds, which is why the actual win-rate and progression-rate numbers below came out unequal and unflattering rather than clean. The Clay branch is wired into the same Switch but is only a placeholder that returns no metric and an inconclusive verdict: Clay still has no webhook or API on this plan (the same constraint noted on the Champion Job-Change, Anonymous Accounts and Intent Signal builds), so a Clay-sourced experiment would need a rep to submit real Claygent findings through a form, the same workaround used on those days.

A Real Salesforce Query Limit Hit Mid-Build

The first version of the Salesforce branch tried to filter server-side: SELECT Id, Name, StageName, IsWon, IsClosed, Description FROM Opportunity WHERE Description LIKE '%ExperimentGroup%...'. It failed on the real API with a 400: field 'Description' can not be filtered in a query call — Salesforce doesn't allow a long text area field like Description to appear in a SOQL WHERE clause at all, seeded marker or not. The fix pulls the 40 most recently closed Opportunities with no Description filter (the same query the seeding workflow already used) and lets the existing Code node match the Control/Treatment marker client-side with a plain string search — which was already how the HubSpot branch worked, so the real constraint ended up making both branches consistent instead of clever.

Live Run

The GTM Experiment Registry workflow graph in n8n
The live workflow graph in n8n — a form-driven registry feeding a daily batch loop that routes by real metric source (Salesforce, HubSpot, or Clay), computes a deterministic verdict, and lets Claude narrate it before closing the row out and posting to Slack.
The real Slack digest from a live GTM Experiment Registry run, closing out two real experiments
The real Slack digest from the live run — two real experiments, each closed with its own genuine control-vs-treatment numbers and an honest KILL recommendation on both.

Impact (measured from live runs)

2 / 2
real experiments registered through the same form and auto-closed by the same daily check — one sourced from Salesforce, one from HubSpot, no code changes between them
-16.7pp & 0pp
real computed lift on each experiment against its own threshold — both genuinely missed +10pp, so both got an honest KILL instead of a flattering one
3-way / 2 exercised
Switch branches built for Salesforce, HubSpot, and Clay at registration time; Clay's real but unexercised this run since it still has no API (same as Days 3, 6, 17)

The Self-Reported Attribution Reconciler

~4 min read

Software attribution credits the last click; buyers remember the podcast or the colleague. This build reads every “How did you hear about us?” answer, joins it to the real Salesforce opportunity, and shows pipeline by channel twice: as the tracking saw it and as the buyers said it.

n8n Cloud · Salesforce API · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Software attribution sees where buyers clicked, not where they first heard of you. One B2B demand-gen firm tested this on 620 conversions. Software credited web search with 78% of them; buyers credited search only 12% of the time and named peers, podcasts and communities instead. Meanwhile, the free-text answer to “How did you hear about us?” sits in a field nobody reads, or gets dumped into “Other”. AI assistants like ChatGPT are a newer discovery path that lands there too. Budgets keep flowing to the channel that collected the click.

The Build

Every Monday, n8n takes each demo request from the last 90 days and joins it to its opportunity in Salesforce, which supplies the real amount and stage. Code maps the UTM source and medium to the same channel names buyers use, so the two can be compared. Claude reads each free-text answer and assigns one channel. It has to quote the buyer’s words that name the source. If a buyer names two sources, the one where they first heard of us wins. An answer with no source (“website”, “don’t remember”) is marked Unclear, never guessed. Code keeps a channel only if the quote is word for word in the answer. It then totals pipeline by channel both ways and lists the biggest disagreements.

Weekly: demo answers + UTMs, Salesforce opportunities → Code: software channel, real pipeline
Claude: buyer channel, quoted → Code: verify quote, total both ways → Gap report to Slack + every answer logged

Real vs. Simulated

The opportunities, amounts and stages are real Salesforce records. The demo answers and UTM values are seeded, because this org has no form tool. There are 20 answers with an answer key, including two judgment calls:

  • “looked you up on Google after my counterpart recommended you” counts as Peer referral, because the referral came first.
  • “website” counts as Unclear, because it names a destination, not a source.

A Real Test-Design Bug: The Prompt Gave Away the Answer

My first draft of Claude’s instructions explained the “first source wins” rule with an example: “looked you up on Google after a friend recommended you.” That was almost word for word the hardest answer in the test set, so Claude would have passed by copying the example rather than applying the rule. I caught it before the test run and removed the example, so the rule had to stand on its own. It held: the Northfield answer was classified as Peer referral, and the quote code kept was the referral, not the search.

Real Results

20 demo requests, $1,082K of open and won pipeline. Software and buyer agree on 5 of 20. Channel Software says Buyers say Search $677K (12) $123K (2) Peer referral $0K (0) $224K (4) Direct (no source) $206K (4) $0K (0) Podcast $0K (0) $192K (3) Event $41K (1) $137K (2) AI assistant $0K (0) $78K (2) Northwind Freight Co ($145K): software Search (google / cpc) · buyer Podcast: "Risky Business podcast"

Excerpts from the live report, which matched the answer key on all 20 answers. Software credited search with $677K of pipeline; buyers credited it with $123K. Six channels that buyers named were invisible to tracking, worth $641K together.

Live Run

The Self-Reported Attribution Reconciler workflow graph in n8n
The live workflow graph in n8n: demo answers and Salesforce opportunities load and code maps the software channel; Claude reads each answer, code verifies and totals pipeline both ways; the report posts to Slack and every answer is logged.
The real attribution gap report in Slack
The real report: pipeline by channel as software and buyers saw it, the channels tracking cannot see, and the biggest disagreements quoted in the buyer’s words.

Impact (measured from live runs)

20 of 20
answers classified to the seeded answer key, with both judgment-call decoys right
$554K
gap between the search pipeline software credits and what buyers credit to search
$641K
of pipeline from channels tracking cannot see: peers, podcasts, AI assistants, communities, partners, reviews

Customer & Retention

The Renewal Health Storyteller

~3 min read

A weekly scan finds real Salesforce accounts nearing renewal, pulls their real HubSpot engagement history, layers in simulated support and stakeholder signals, and has Claude write a plain-English "why this account is at risk" narrative — posted to Slack with a matching Gmail draft ready to send.

n8n Cloud · Salesforce (OAuth2) · HubSpot API · Anthropic Claude (Sonnet 4.6) · Gmail API · Slack API · n8n Data Tables

The Problem

A renewal dashboard that just says "renews in 16 days, health score: 62" doesn't tell a rep anything they can act on. It doesn't say whether the risk is that nobody at the account is opening emails, that support tickets are piling up, or that the champion who signed the deal quietly left. Without the actual story behind the number, every renewal gets the same generic check-in email regardless of what's really going on — or worse, gets no attention until it's already too late to fix.

A customer success leader on LinkedIn opened with a story every CS team knows: “Every metric was green but the customer churned anyway.” His conclusion: “Green dashboards create false confidence.”

Teams don’t fully trust the number either. A customer- success vendor’s 2025 report found CS teams rate the accuracy of their own health scores at about 6 out of 10, and 27% named data accuracy as their biggest blocker. A score the team only half trusts won’t get acted on without the story behind it.

The Build

Every Monday at 8am, the workflow pulls every real Closed Won opportunity out of Salesforce, groups them by account, and for each account finds the anniversary of its earliest closed deal — the actual renewal date. Any account whose renewal falls within the next 60 days becomes a candidate, carrying its real contract value and full real deal history. Separately, it pulls every real contact currently in HubSpot, once, with their actual tracked engagement properties (page views, email opens, email clicks, last-touch timestamps), and matches them to each candidate account by company name.

That real engagement read is then combined with simulated support and stakeholder-turnover signals — standing in for ticketing and org-chart systems Fortavault doesn't actually have connected — and handed to a Claude agent with structured output. The agent is instructed to write a specific, evidence-grounded narrative rather than a vague "engagement has dropped," and to explicitly flag which claims in its own narrative rest on real data versus simulated data. The result gets posted to Slack, turned into a real Gmail draft addressed to the actual deal owner, and logged to a Renewal Health Data Table for audit history.

Weekly scan: real Closed Won Opportunities → Compute renewal anniversary per account (next 60 days) → Fetch real HubSpot contacts + engagement props → Merge real engagement + simulated support/turnover
Claude writes risk narrative (structured output) → Post to Slack → Draft Gmail email to deal owner → Log to Renewal Health Data Table

Real vs. Simulated

The renewal math is entirely real: real Salesforce Closed Won opportunities, real close dates, a real computed anniversary, and real combined contract value. The HubSpot engagement read is also entirely real — and it turned up something worth being honest about rather than papering over: this is a fresh HubSpot trial with no real marketing-email history yet, so every one of the three flagged accounts came back with zero tracked page views, zero opens, and zero clicks. Rather than fabricate a plausible-looking "engagement declined 42%" number, the workflow reports the real, verified absence of engagement as exactly what it is — itself a legitimate signal — and the agent's prompt keeps that framed as REAL throughout. The support-ticket volume and stakeholder-turnover details are the deliberately simulated half, standing in for a support desk and an HR/org-chart feed Fortavault doesn't actually have wired up; every Slack post and Data Table row keeps the two labeled separately instead of blending them into one confident-sounding score.

A Real n8n Bug: HubSpot's Silent Credential Mismatch

Pulling HubSpot contacts failed on the first attempt with Node does not have any credentials set for "hubspotApi" — even though the node was correctly wired to the HubSpot App Token credential. The cause: HubSpot's node has an authentication parameter that defaults to apiKey, and it silently expects a matching credential type rather than inferring one from whatever credential is actually attached. The credential I'd attached was real and correctly configured; the node just never looked at it, because it was still checking for a different authentication mode entirely. Setting authentication: "appToken" explicitly on the node fixed it outright — caught by pulling the raw execution error with full node data rather than trusting the high-level failure message.

A Real Account, a Real Narrative

Meridian Financial Group is the one fully organic account in this run — a genuine Closed Won Salesforce opportunity, not something seeded for this build, with its renewal landing 6 days out. Its real HubSpot contact is Adam Giuriceo; the champion's job title in its narrative comes from the simulated turnover signal, not from HubSpot. Here's Claude's unedited narrative, grounded in that account's real engagement read plus its simulated support and turnover signals:

Meridian Financial Group holds a $107,000 combined contract across Fortavault Shield, Backup Cloud, and a February 2026 Insights expansion, with renewal due September 12, 2026 — six days away. The risk here is not ambiguous: according to REAL data pulled directly from the connected HubSpot account, there is only one contact on file (Adam Giuriceo), that contact has zero tracked website page views, zero marketing email opens, zero clicks, and no recorded CRM touch timestamp whatsoever — meaning we have no evidence of any human engagement with Fortavault's digital presence at any point in the system's history. This is a significant red flag at this stage of the renewal cycle, as a $107,000 account six days out should show some form of active dialogue or at minimum inbound signal. On the support side, SIMULATED data (no support system is currently connected) suggests a single minor SSO configuration ticket in the last 90 days, resolved in under four hours with no recurring issues — which, if accurate, would indicate a technically stable deployment, but this cannot be verified. Similarly, SIMULATED stakeholder data suggests the original IT Operations Director champion is still in place and no turnover has occurred, which would be a stabilizing factor — but again, this is unverified mock data and should not be treated as confirmed. The combination of a verified engagement blackout (REAL) and an unverified-but-potentially-stable operational picture (SIMULATED) means the true renewal risk hinges entirely on whether a relationship conversation is happening offline and outside of HubSpot — and right now, there is no evidence that it is.

Live Run

The Renewal Health Storyteller workflow graph in n8n
The live workflow graph in n8n — Salesforce renewal math into real HubSpot engagement into the Claude storyteller agent, fanning out to Slack, Gmail, and the Data Table log.
Real Slack posts from a live run of the Renewal Health Storyteller, one per at-risk account
The real Slack output from a live run — Meridian Financial Group, Palisade Underwriting Group, and Brambleworth Legal Partners, each with Claude's full real-vs-simulated risk narrative and a note that a matching Gmail draft is created for the owner (the draft step runs right after the Slack post).

Impact (measured from live runs)

$210,500
real combined contract value flagged for renewal risk in one run
3
real Gmail drafts created, one per at-risk account owner, with Claude's narrative pre-written
0
fabricated engagement numbers — real zero-engagement was reported as real zero, not smoothed over

Support Triage That Knows Who's Asking

~3 min read

An inbound support email gets read by Claude, matched to the right Salesforce account, and either escalated, routed, or quietly queued depending on who sent it and how urgent it actually is.

n8n Cloud · Gmail API · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Most support triage treats every inbound ticket the same way: same queue, same SLA clock, same Slack noise, regardless of whether it's a trivial question from a small account or a fleet-wide outage at an enterprise customer mid-renewal. That flattening cuts both ways — teams either over-alert on things that don't matter, or bury a genuinely urgent ticket from a top account in the same pile as a "how do I export this" question.

A VP of Customer Success on LinkedIn described the split between support and customer success: “Each team has half the story. Neither can afford to operate with half the truth.”

The cost of getting it wrong is high. A customer-service software vendor’s research reports that more than half of consumers will switch to a competitor after a single bad experience, and that 70% expect whoever helps them to already have the full context of their situation. Treating every ticket the same throws that context away.

The Build

There's no live customer support inbox connected for this sprint, so the trigger is a scoped Gmail watch that only fires on test emails carrying a demo subject tag — a stand-in for a real support alias. Everything after that runs live: a real Salesforce lookup, a real Claude call, a real Case, a real Slack message. When a matching email lands, a Code node parses out the sender's stated email and the message body, then Salesforce is queried for a matching Contact. If one exists, the linked Account's AnnualRevenue determines a customer tier — Enterprise, Mid-Market, or SMB — computed from real seeded Salesforce data, not a hardcoded label.

Claude reads the email and classifies it on two axes: category (Security Incident, Technical Issue, Billing/Account, or Feature Request/General) and priority (Urgent/High/Normal/Low), grounded in Fortavault's product line so it can tell a real outage report from a feature ask. A routing step then combines category, tier, and Claude's priority into the routing decision: a Security Incident always escalates immediately regardless of tier; an Enterprise account with an urgent issue gets a 1-hour SLA and an @here Slack ping; a low-priority ticket from a small account gets a 2-business-day SLA and no Slack ping at all — it's logged and queued, not dropped. Every ticket gets a real Salesforce Case created either way, and every decision is logged to a Data Table for an audit trail of what got escalated, what got queued, and why.

Support email received → Salesforce tier lookup → Claude classifies category & priority → Routing rules set SLA + escalation → Salesforce Case created → Slack alert or silent log

Routing Logic

Category, tier, and priority don't just stack — they interact:

Security Incident → always High priority, always @here in Slack, 15-minute SLA, regardless of customer tier. Enterprise + Urgent/High → High priority, @here in Slack, 1-hour SLA. Enterprise + Normal/Low → Medium priority, Slack-notified (no @here), 4-hour SLA. Mid-Market + Urgent/High → High priority, Slack-notified, 4-hour SLA. Mid-Market + Normal/Low → Medium priority, Slack-notified, 1-business-day SLA. SMB (or no CRM match) + Urgent/High → High priority, Slack-notified, 4-hour SLA. SMB (or no CRM match) + Normal/Low → Low priority, no Slack ping, 2-business-day SLA — queued and logged, not dropped. A Salesforce Case is created on every path. The only thing that changes is the SLA, the priority written to the Case, and whether Slack gets pinged.

A Bug Found in Review: Only the First Email Got a Case

A later review of this build caught a real gap. The Gmail trigger can pick up as many as five matching emails in one check, but two of the Code nodes only read the first item they were handed, so if several tickets arrived together, only the first became a Salesforce Case. The fix matches every parsed email to its own Salesforce contact by address and runs the routing rules once per email. A test with two emails in a single check (one from an Enterprise contact, one from an unknown sender) produced two separately routed Cases: Enterprise Support with a one-hour SLA and an @here ping, and a quiet Self-Serve queue entry.

Live Run

The Support Triage Concierge workflow graph in n8n
The live workflow graph in n8n — Gmail trigger, Salesforce tier lookup, Claude classification, combined routing logic, Case creation, and the Slack/silent-queue branch.
An @here Slack alert for an urgent Enterprise-tier support case
A real run: an Enterprise account reporting two nights of failed backups with no recovery point — classified Urgent, routed to a 1-hour SLA, and posted with an @here ping.
The Salesforce Case created from the triaged support email, with full case detail layout
The real Salesforce Case created from that same run, with the AI's category, priority, and rationale written into the description.

Impact (measured from live runs)

2 of 2
real tickets routed to the correct tier and SLA
1 hr vs 2 days
SLA spread between Enterprise/urgent and SMB/low routing
0
tickets silently dropped — every ticket gets a Salesforce Case

The Handoff Promise Ledger

~4 min read

Customer Success inherits whatever sales promised, usually without being told what that was. Every new Closed Won deal gets a handoff brief built from the AE's notes. Every commitment made during the sale goes into a ledger with an owner team and a due date, and anything late is flagged in Slack before the customer has to chase it.

n8n Cloud · Salesforce API · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

On LinkedIn, customer success people describe churn as starting at the handoff, not at the renewal. A RevOps leader described CS teams left to reverse-engineer what was promised from Slack messages and CRM notes. A rep who has worked as both AE and CSM described the deal that closes on a “we'll figure it out later,” then asked, “Guess who's ‘later’?” The commitments are real: a pilot within 30 days, a custom export by a certain date, free training seats. They live in the AE's notes and in the customer's memory, and only the customer is keeping track. The Pipeline Debt Ledger catches risky promises while a deal is still open. This build picks them up at signature and follows them until they are delivered.

The Build

Every weekday morning, n8n pulls Closed Won deals from Salesforce and skips any that already have a handoff. For each new deal, Claude reads the AE's notes and returns why the customer bought, who's who and where each person stands, the success metrics, every promise made during the sale, and the red flags a CSM should know. Each item comes with the exact words from the notes. Code then checks everything before CS sees it:

  • Every quote must appear word for word in the notes.
  • Every stakeholder must be a named person who appears in the notes.
  • Each promise gets an owner team from a fixed list.
  • Due dates are computed in code from the close date. A “30 days” or an “October 1” only counts if that number or month is in the promise's own quote.
  • A promise that commits to an unreleased feature is marked as a roadmap commitment that needs product sign-off.

The brief posts to Slack and every promise goes into the Promise Ledger. Each morning the same workflow reads the ledger and posts what is overdue and what is due within seven days. It posts nothing when nothing is due. Owners mark promises delivered in the ledger, which removes them from the alert.

Weekday: Closed Won deals in Salesforce without a handoff → Claude: why they bought, who's who, metrics, promises, red flags, each quoted
Code: verify quotes and names, compute due dates → Handoff brief to Slack + promises into the ledger → Daily: overdue and due-soon promises to Slack

Real vs. Simulated

The deals are real Salesforce Closed Won opportunities. The three customers, Harrowgate Logistics, Larchmont Community Bank and Brightwater Dental Group, are seeded for the fictional Fortavault, as are the AE notes in their description fields. The notes come with a written answer key: 7 promises, 4 of them with dates, one roadmap commitment, and one deal whose only commitment is “standard onboarding”, which must not count as a promise. The org already held 27 Closed Won deals from earlier builds, all closed before September, with one-line seed notes. The ledger has a go-live date of September 1, so those would need a separate backfill rather than flooding Slack with empty briefs.

Real Results

Handoff: Harrowgate Logistics ($96,000, closed 2026-09-03, 34 days ago) Who's who: Renata Ruiz (COO, economic buyer) · Mark Ellison (IT Director, champion) · Priya Nair (CISO, skeptic) Promised during the sale (4), each now logged with an owner: • Live rollback drill within 30 days of signing → Professional Services, due 2026-10-03 already 4 days overdue • Custom SOC 2 evidence export by October 1 → Professional Services, due 2026-10-01 already 6 days overdue • Two seats of advanced admin training at no cost → Training, no date • Performance testing during onboarding → Professional Services, no date

The extraction matched the answer key: all 7 promises, all 4 due dates computed correctly, and the DORA template promised to Larchmont “by the end of November” flagged as a roadmap commitment. Brightwater's “standard onboarding only” produced no promises. The point of the build shows up on the first run: two of Harrowgate's commitments were already overdue, a month after signing, and nothing in the CRM said so. The second run skipped all three deals as already handed off and posted the overdue alert from the ledger.

Real Bugs Found in Testing

The first test run failed on the output format. n8n infers the schema from an example, so the example's empty due date made a real date invalid. The parser now uses an explicit schema where both due fields can be empty. The next run listed “Internal audit lead” as a stakeholder, because those words are in the notes. A stakeholder now has to be a named person: the notes mention that role only to say nobody has engaged them yet. It stays in the brief as a red flag instead.

Live Run

The Handoff Promise Ledger workflow graph in n8n
The live workflow graph in n8n: Closed Won deals, past handoffs and the ledger load; one branch alerts on due promises; the other has Claude build each handoff, code verify it, and posts the brief and logs every promise.
The real Harrowgate handoff brief in Slack
The real handoff brief: why they bought, who's who, success metrics, four promises with owners and due dates (two already overdue), and the red flags, each quoted from the AE's notes.
The real overdue promise alert in Slack
The next run's ledger alert: 7 open promises, 2 overdue, 3 with no date for their owners to set.

Impact (measured from live runs)

7 of 7
seeded promises captured, each quoted from the AE notes and given an owner team
2 overdue
commitments surfaced on day one that nothing in the CRM was tracking
1 roadmap promise
flagged for product sign-off before the customer's end-of-November date

The Goal Drift Detector

~4 min read

Health scores measure whether customers use the product, not whether they still want what they bought it for. Every week, this build checks each customer's success plan against what has changed since it was last reviewed. It flags green accounts whose goals have quietly moved, with the customer's own words as evidence.

n8n Cloud · Salesforce API · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

A VP of Customer Success on LinkedIn described a “surprise” churn. The account was six figures, had 85% adoption and had been rated strong green for over a year, and it was 30 days from leaving. A new VP at the customer had changed the mandate from market expansion to operating margin. The CSM was still reporting on the goal agreed 14 months earlier. Her conclusion: “Green is a lagging indicator.” Her fix was a regular reset that asks whether leadership still cares about the original goals and what the sponsor now needs to show their boss. Other CS leaders said the same thing in different words. Churn is rarely a surprise; the signs are in staffing changes, in what the customer says on calls, and in which parts of the product they stop using.

The Build

Once a week, n8n loads every success plan and checks it against Salesforce. Only accounts with Closed Won deals are reviewed, and their Closed Won value is used to order the list. For each account, code gathers only what happened since the plan was last reviewed: meeting and email notes, contact changes, and monthly usage of the feature tied to the plan's goal. Claude reads the notes and answers one question: has someone at the customer said their priority is now different from the goal they bought for? It must quote the words that show it. Reaffirming the goal, mentioning a small extra interest, explaining a temporary dip or changing staff does not count.

Code scores the drift from three independent signals:

  • A stated change of priority (2 points), counted only if Claude's quote appears word for word in a note.
  • An executive joining or leaving (1 point).
  • Usage of the goal's feature dropping 30% or more (1 point), comparing the last two months with the three before.

An account is flagged at 2 points. One signal on its own is not drift. The Slack review puts green-but-drifting accounts first, then accounts already marked at risk, then names the accounts with no drift. It ends with the questions to re-ask the customer.

Weekly: Salesforce customers + success plans + notes, contacts and usage since last review → Claude: has the stated priority changed? quote it
Code: verify quote, add exec changes and goal usage drop, score → Green-but-drifting review to Slack → Every account logged

Real vs. Simulated

The six customers and their Closed Won values are real Salesforce records from earlier builds. The success plans, health scores, touchpoint notes, contact changes and usage are seeded, because this org has no CS platform or product telemetry. The seed has an answer key: three accounts should be flagged and three should not. Two of the three quiet ones are deliberate decoys. At Thornbury, usage of the goal's feature dropped 37%, but the CISO explains it is the yearly year-end freeze and the goal still stands. At Fernhollow, a new contact joined, but as an administrator, not an executive.

Real Results

Green but drifting (2): the score says healthy, the customer is talking about something else Harborstone Insurance (health green, plan last reviewed 211 days ago) · drift 4 Bought for: Cut audit evidence preparation from six weeks to under two weeks... Now saying (2026-08-27): "every tool now has to show a cost saving, not a compliance benefit" Ines Varga, CFO, joined 2026-08-01 audit reports -42% Already at risk, and the goal has moved too (1): Cinderbrook Health Partners · drift 4 No drift (3): Fernhollow Health Systems · Ashworth & Cole LLP · Thornbury Financial (1 signal only: goal usage drop)

An excerpt from the live review. Both runs matched the answer key, 6 of 6. Harborstone is the LinkedIn story almost exactly: green, with a new CFO whose mandate has moved from compliance to cost. Brackenridge is drift in a positive direction: a new VP of Operations is opening three plants and wants a setup she can copy to each one. That is not a churn risk but an expansion conversation, and the success plan still needs rewriting. Thornbury stayed quiet. Its 37% usage drop alone would have turned a pure usage health score yellow.

Live Run

The Goal Drift Detector workflow graph in n8n
The live workflow graph in n8n: Salesforce customers, success plans, notes, contacts and usage load; Claude reads stated priorities and code verifies and scores; the review posts to Slack and every account is logged.
The real Goal Drift review in Slack
The real weekly review: two green accounts drifting, one at-risk account whose goal also moved, three with no drift, and the questions to re-ask the customer.

Impact (measured from live runs)

6 of 6
accounts classified as the seeded answer key expected, in both the test and live runs
2 green
accounts flagged as drifting while their health score still said healthy
0 false alarms
on the decoys: a seasonal usage dip and a new non-executive contact

The Expansion Signal Router

~4 min read

Expansion signals rarely get a "no". More often they get noticed by everyone and owned by no one. This build detects them from capacity, new-team usage and what customers say on calls, gives each one exactly one owner and a deadline, and checks Salesforce to see whether it became pipeline. Anything that didn't is escalated.

n8n Cloud · Salesforce API · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

A post-sales founder on LinkedIn told the story of a $250K expansion signal that surfaced in March. A second team had started using the product, the champion mentioned budget, and the CSM put it in the QBR deck. Everyone agreed it was real. Then the quarter got busy: the CSM had 40 other accounts, the account manager had a renewal on fire, and nobody was assigned. In June it was still sitting in the deck. His summary: “It was seen by everyone and owned by no one.” Other posts made the same point about net revenue retention. Growth stalls not because signals are missing, but because nothing turns a signal into an owner, a date and an opportunity.

The Build

Every weekday, n8n looks for three kinds of signal on accounts that are Closed Won customers in Salesforce. Two are pure data and are detected in code:

  • An account using 90% or more of the seats or terabytes it licenses.
  • A team that started using a product in the last 45 days.

The third comes from what customers say. Claude reads the last 60 days of meeting and email notes for a concrete plan or ask: new sites, a new team, a pricing question, budget approved for more. A vague “may look at it next year” doesn't count, and Claude's quote is checked word for word against the note.

Code then routes each new signal to exactly one person: the CSM for a capacity true-up, the account manager for anything new. Each signal gets a one-week deadline. Every run also checks the open signals against Salesforce. A new opportunity for the same product on that account, created after the signal was raised, marks it as pipeline; a signal past its deadline with no opportunity is escalated. The router also reads the Goal Drift Detector's log. A signal on an account whose goals have shifted carries a warning to check what the customer wants before pitching.

Weekday: Salesforce customers + capacity, team usage, notes, signal log → Code: capacity 90%+, new team · Claude: stated intent, quoted
Code: one owner, one-week deadline, match to Salesforce opportunities by product → Slack: new, escalated, became pipeline → Signal log updated

Real vs. Simulated

The customers, their Closed Won values and the opportunities are real Salesforce records. The capacity, team activity, account teams and notes are seeded, with an answer key: five real signals across four accounts, plus decoys that should be ignored. The decoys are a firm that “may look at document backup next year”, a customer at 69% of its seats, and teams that have used the product for over a year. One signal is seeded as already sitting in the log since a June QBR: Harborstone wanted to add its claims system to Insights the next quarter, and nobody acted on it. To demonstrate conversion, I created the opportunity an account manager would have created: a real Backup Cloud opportunity for Fernhollow's two newly acquired clinics.

Real Results

New signals (5), each with one owner: • Fernhollow Health Systems · Asked for more: quote to add two newly acquired clinics to Backup Cloud, budget approved → Sam Okafor (Account Manager), due 2026-10-14 • Fernhollow Health Systems · Near capacity: Backup Cloud at 97% of licensed protected TB → Marcus Webb (CSM) • Harborstone Insurance · New team on Insights: Claims Operations (7 active users since 2026-09-15) → Elena Cho also flagged by the Goal Drift Detector; check the goal before pitching Past deadline, no opportunity (1) • Harborstone Insurance · Wants to add the claims system to Insights coverage next quarter raised 2026-06-04 (125 days ago), owner Elena Cho, 118 days past due. Became pipeline (2), next run • Fernhollow Health Systems · Near capacity → Fortavault Backup Cloud - Fernhollow Health Systems (acquired clinics) • Fernhollow Health Systems · Asked for more → same opportunity

Excerpts from the live runs. All five seeded signals were found and the decoys were ignored. Harborstone shows the problem the build exists to fix. The claims team the customer mentioned in June is now using the product anyway, which shows up as a new signal, while the original request sat unowned for four months.

A Real Bug: Any Opportunity Isn't the Right Opportunity

The first test run marked Harborstone's June signal as “became pipeline”. A Shield deal had been created on the account after June, and the matching rule only checked the account and the date. That signal was about Insights. Counting any new deal on the account would let renewals and unrelated cross-sells quietly close out signals nobody worked. Signals now carry their product, and only an opportunity for that product converts them. The rerun correctly escalated Harborstone.

Live Run

The Expansion Signal Router workflow graph in n8n
The live workflow graph in n8n: Salesforce customers and opportunities, capacity, team activity, notes and logs load; code detects data signals and Claude reads stated intent; code routes, tracks and escalates; the digest posts and the signal log is updated.
The real Expansion Signal Router digest in Slack
The first live digest: five new signals with one owner and a due date each, and the June signal escalated at 118 days past due.
The next Expansion Signal Router digest showing signals that became pipeline
The next run, after the Fernhollow opportunity was created in Salesforce: both Fernhollow signals marked as pipeline, Harborstone still escalated.

Impact (measured from live runs)

5 of 5
seeded expansion signals found, each with exactly one owner and a due date; decoys ignored
118 days
past due: the unowned June signal, surfaced and escalated instead of left in a QBR deck
2 → pipeline
signals matched to a real Salesforce opportunity for the same product

The Time-to-Value Watch

~4 min read

Churn usually starts as a stalled implementation, months before it shows up in revenue. This build measures every new customer against their product's onboarding plan from the day the deal closed. It flags anyone stuck at the day-30 or day-60 checkpoint, with the blocker in the customer's own words.

n8n Cloud · Salesforce API · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

A customer success executive on LinkedIn wrote that churn rarely comes as a surprise, because the warning signs are there months earlier. The strongest ones, in that post's words, aren't commercial (renewal delays, escalations, complaints) but operational: stalled implementation, slow adoption progress, unclear ownership. By the time a renewal looks risky, the real problem has usually existed for quite a while. In most companies, nobody is looking at onboarding milestones against a plan. Each milestone slips by a week and is explained away, until the customer reaches day 90 having never seen the thing they bought it for.

The Build

Every weekday, n8n takes each account in onboarding and starts the clock at its most recent Closed Won date in Salesforce. Each product has an onboarding plan with target days: kickoff by day 7, deployment by day 21, the first-value milestone by day 30 (the first successful rollback test, or the first connected dashboard), and full rollout by day 60. Code marks every milestone that is due and not done as late. It then applies the checkpoint rule:

  • At day 30 or day 60, an account is stalled if that checkpoint's first-value milestone is missing, or if any milestone is a week or more late.
  • Before day 30, a week-late milestone puts the account on watch.

For accounts that are behind, Claude reads the notes since the deal closed. It reports the blocker only if a note states it, with the exact words, which code checks. If no note explains the delay, the digest says so and tells the CSM to ask. The watch also reads the Promise Ledger, so a stalled account shows any promise from the sale that is also overdue.

Weekday: Salesforce close dates + onboarding plans, milestones, promises, notes → Code: late milestones, day-30 / day-60 checkpoint rule
Claude: the stated blocker, quoted (or none) → Code: verify quote, attach overdue promises → Watch to Slack + every account logged

Real vs. Simulated

The accounts and their close dates and Closed Won values are real Salesforce records, including the three deals handed off in the Promise Ledger build. The onboarding plans, completed milestones and onboarding notes are seeded, because this org has no implementation tracker. The seed has an answer key: three accounts stalled (one at day 60, two at day 30, one of them with no explanation in any note) and three on track. One of the on-track accounts, Larchmont, has a milestone two days late, which is too small to raise an alarm before day 30.

Real Results

Stalled at a checkpoint (3), before any revenue signal has moved day 30 checkpoint Harrowgate Logistics · Shield · day 35 · 1 of 5 milestones done • Agents deployed on in-scope servers: due 2026-09-24, 14 days late • First rollback test passed (first value): due 2026-10-03, 5 days late Blocker (2026-09-26): "Mark said Priya Nair has not approved installing agents on the dispatch servers until the performance test is done, and nobody has scheduled the test yet." Also overdue from the sale: Live rollback drill (5 days); Custom SOC 2 evidence export (7 days) day 30 checkpoint Solstice Underwriters · Shield · day 52 · First rollback test passed: 22 days late Blocker: nothing in the notes explains it; the CSM should ask this week On track (3): Halberd Insurance Partners · Larchmont Community Bank · Brightwater Dental Group

Excerpts from the live watch, which matched the answer key. The Harrowgate result connects three builds. The handoff brief flagged the CISO as skeptical about agents on the dispatch servers, and the performance test promised during the sale was never given a date. Now that same approval is blocking deployment, and two promises from the sale are overdue. Each piece was in the data a month ago; what was missing was something that put them side by side.

Live Run

The Time-to-Value Watch workflow graph in n8n
The live workflow graph in n8n: Salesforce close dates, onboarding plans, milestones, the Promise Ledger and notes load; code checks milestones; Claude finds the stated blocker and code verifies it; the watch posts to Slack and every account is logged.
The real Time-to-Value Watch in Slack
The real watch: three accounts stalled at their checkpoint, each with late milestones and the blocker in the customer's words (or a prompt to ask), and three on track with their next milestone.

Impact (measured from live runs)

3 stalled
implementations flagged at their day-30 or day-60 checkpoint, matching the seeded answer key
2 of 3
blockers found in the notes and quoted; the third left blank and handed to the CSM, not guessed
22 days
the longest-missed first-value milestone, surfaced before any revenue signal moved

The Feedback Loop Closer

~4 min read

Customers stop giving feedback when it disappears into a black hole. This build pulls feature requests from support tickets and CSM notes, groups the same need across customers who describe it differently, and ranks requests by revenue for product. When a release ships, it names exactly who asked for it and who should tell them.

n8n Cloud · Salesforce API · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

“That feedback shouldn't disappear into a black hole” is the complaint in one CSM's LinkedIn post. A customer success leader went further: customers churn when their ideas go into a black hole and they never see what happens next. The failure has two halves. On the way in, the same request arrives as a support ticket from one customer and a passing comment on a call with another. Nobody can see that three accounts want the same thing, or how much revenue sits behind it. On the way out, when the feature finally ships, nobody remembers who asked. The customers who would most appreciate it hear about it in a newsletter, if at all.

The Build

Once a week, n8n gathers the feature-request tickets from the Support Triage log (dropping duplicate tickets created from the same email), the last 90 days of customer notes, the requests already in the ledger, and any release shipped in the last 30 days. Claude does two things in one call:

  • It pulls out each real request and names the underlying need as a short theme. It reuses existing themes, so different customers asking for the same thing in different words land together. Bug reports, fixes, pricing questions and general updates are skipped.
  • It says which themes each new release actually delivers, quoting the release notes.

Code checks every request quote against its ticket or note and every release quote against the release notes. It counts an account once per theme and ranks open themes by the Salesforce Closed Won value of the accounts asking. When a release delivers a theme, code marks those requests shipped and lists each customer who asked, quoting their original words. Each one is routed to their CSM, or to the support ticket when they have no CSM.

Weekly: support tickets + customer notes + request ledger + recent releases → Claude: requests and themes, release matches, each quoted
Code: verify quotes, one per account per theme, rank by Closed Won value → Slack: who to tell about what shipped + open requests for product → Request ledger updated

Real vs. Simulated

One request is real: a support email asking for a CSV export of the Insights dashboard, triaged live by the Support Triage build in August. It was logged twice, because one email was polled twice, and the dedupe here counts it once. The customer notes and the two releases are seeded, with an answer key:

  • Seven requests across four needs. Three customers ask for spreadsheet export in different words: a support ticket, a GRC-tool import, and an examiner portal that only accepts CSV or Excel.
  • A bug report that was already fixed, which must not count.
  • A Backup Cloud speed release that resolves nothing.

Customer values come from real Salesforce Closed Won deals.

Real Results

Shipped: tell the customers who asked Insights 4.8: spreadsheet exports (INS-4.8, 2026-10-06) delivers Dashboard CSV Export • Marrow Creative Co → no CSM: reply on the support ticket. They asked (2026-08-14, support ticket) • Harborstone Insurance → CSM Priya Shah. They asked (2026-09-30): "Glenn asked for a CSV export of the audit dashboard so his team can load it into their GRC tool instead of retyping it from the PDF." • Thornbury Financial → CSM Dana Whitfield. They asked (2026-09-16): "Lena needs the access review evidence as a spreadsheet, because the examiner's portal only accepts CSV or Excel uploads." Open requests for product, by revenue asking (3 themes) 1. Scheduled Report Delivery · $259K Closed Won · 2 accounts: Fernhollow Health Systems, Cinderbrook Health Partners 2. Multi-Site Consolidated Dashboard · $187K Closed Won · 1 account: Brackenridge Manufacturing 3. Trusted Network MFA Bypass · $134K Closed Won · 1 account: Ashworth & Cole LLP 20 new tickets and notes read; 7 new requests; 1 duplicate ticket(s) of the same email ignored.

Excerpt from the live digest, which matched the answer key: all 7 requests found in 20 sources, and the fixed bug skipped. The spreadsheet theme brings together three customers who never used the same words, one of whom never said “CSV”. The Backup Cloud release correctly closes nothing. Scheduled reports ranks first among open requests because two healthcare accounts with $259K of Closed Won value both run reports by hand every week.

Live Run

The Feedback Loop Closer workflow graph in n8n
The live workflow graph in n8n: Salesforce values, support tickets, notes, the request ledger, releases and account teams load; Claude reads requests and matches releases; code verifies, ranks and closes the loop; the digest posts and the ledger is updated.
The real Feedback Loop Closer digest in Slack
The real weekly digest: the shipped export release with the three customers who asked and who tells each one, then the open requests ranked by revenue.

Impact (measured from live runs)

7 of 7
seeded requests found in 20 tickets and notes; the already-fixed bug report skipped
3 customers
told about the release they asked for, each quoted in their own words and routed to an owner
$259K
of Closed Won value behind the top open request, so product sees what the ask is worth

The Single-Thread Risk Radar

~4 min read

Most renewals hang on one person. This build counts the people we actually still talk to at every account renewing in the next six months, catches the departures nobody logged, and names who to bring in, in the customer’s own words.

n8n Cloud · Salesforce API · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Customer success managers with a big book of accounts end up talking to whoever answers fastest. That person becomes the whole relationship. One customer success platform’s write-up on the problem puts it plainly: the risk stays hidden until something breaks, because few teams track how many people at an account are actually engaged. When the champion leaves, there can be as little as 60 to 90 days before the renewal decision, and the replacement has no history with you. A practitioner guide on multi-threading makes the same point from the sales side: if one contact was your only thread, the deal resets to zero.

The Build

Every Monday, n8n takes each account renewing in the next 180 days. It pulls the account’s Closed Won value from Salesforce and every call, meeting and email on file. Code counts the threads: named people at the customer who joined at least one touchpoint in the last 90 days and have not left, according to the contact-change feed.

  • No thread left: nobody active, or the only active contact is on their way out.
  • Single-threaded: one active contact.
  • Covered: two or more.

Claude reads the last six months of notes for two things code can’t see. The first is departures nobody logged: an active contact who is leaving, changing role or handing us off. The second is named people at the customer we have never met, such as a deputy or whoever now signs off on spend. Code keeps a finding only if the quote is word for word in a note and actually names that person.

Weekly: renewals, Salesforce Closed Won value, touchpoints, contact changes → Code: count threads per account
Claude: unlogged departures, people to bring in (quoted) → Code: verify quote and name, tier and rank → Radar to Slack + every account logged

Real vs. Simulated

The accounts and their Closed Won values are real Salesforce records. The renewal dates, touchpoint notes and contact changes are seeded, because this org has no customer success tool. Several notes were reused from earlier builds in this series. The seed has an answer key: one account with no thread left, one whose only contact is handing off, one single-threaded, three covered, and one renewing outside the window. Two notes are decoys: one mentions a predecessor and one a retired IT lead. Both are departures, but neither is a current contact.

A Real Design Choice: The Feed and the Notes Disagree

Cinderbrook’s only contact sent an automatic reply on October 2, which on paper is a fresh touchpoint. The contact-change feed already showed he left on September 30, so code drops him before counting. That leaves Cinderbrook with no thread at all. Ashworth & Cole is the opposite case. Nothing in the feed says Rachel is leaving, but a note says she will hand IT and vendor decisions to a director the firm hasn’t hired yet. Neither source alone gets both accounts right. Counting needs the feed; catching the departure before it happens needs the notes.

Real Results

At risk (3) no thread left Cinderbrook Health Partners · renews 2026-12-15 (64 days) · $82K Closed Won Active in the last 90 days: nobody · Left the company: Daniel Osei (2026-09-30) Bring in Helen Achebe (CFO): "please contact Helen Achebe, CFO, who now signs off on all software spend." no thread left Ashworth & Cole LLP · renews 2026-12-31 (80 days) · $134K Closed Won Rachel Moss is moving on: "Rachel told us she becomes managing partner in January and will hand IT and vendor decisions to a new operations director the firm has not hired yet." Bring in Tom Kessler (IT manager) single-threaded Thornbury Financial · renews 2027-03-31 (170 days) · $183K Closed Won Bring in Omar Haddad (deputy) Covered (3): Brackenridge · Harborstone · Fernhollow (2 threads each)

Excerpts from the live radar, which matched the answer key on every account. Both decoys were ignored, and no finding was dropped for a bad quote. Three accounts worth $399K of Closed Won value came back with one thread or none.

Live Run

The Single-Thread Risk Radar workflow graph in n8n
The live workflow graph in n8n: renewals, Salesforce value and contacts, touchpoints and contact changes load and code counts threads; Claude finds departures and people to bring in, code verifies; the radar posts to Slack and every account is logged.
The real Single-Thread Risk Radar in Slack
The real radar: two accounts with no thread left, one single-threaded, each with who to bring in and the note that names them.

Impact (measured from live runs)

3 of 6
accounts renewing in six months found with one thread or none, matching the seeded answer key
$399K
of Closed Won value sitting on one relationship or none
0 of 2
decoy departures flagged; a predecessor and a retired IT lead were correctly ignored

Marketing Ops & Data Quality

Fixing MAP-CRM Discrepancies

~3 min read

A daily sentinel catches contacts whose HubSpot lifecycle stage disagrees with Salesforce reality, drafts a plain-English explanation with Claude, and waits for a Slack approval before touching HubSpot.

n8n Cloud · HubSpot API (Service Key) · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API (interactive approvals) · n8n Data Tables

The Problem

The marketing automation platform and the CRM drift out of sync constantly, in both directions. A contact stays "Lead" in HubSpot for weeks after Sales closes the deal in Salesforce, so they keep getting top-of-funnel nurture emails they've already outgrown. Or a contact gets marked "Customer" in HubSpot off some internal note or a deal that later fell through, with no actual Closed Won opportunity backing it up in Salesforce. Either way, lifecycle reporting quietly goes wrong and nobody notices until a QBR number doesn't add up.

A revenue-operations consultant on LinkedIn described a client with about 19,000 sync errors between HubSpot and Salesforce, “growing by thousands every week,” with lifecycle stages overwritten in the wrong direction and not a single alert.

A CRM vendor’s 2026 survey of about 4,500 marketing leaders found only 56% have complete access to sales data, with siloed systems and poor data quality named as the top barriers. A lifecycle stage that disagrees between HubSpot and Salesforce is that silo at the level of a single contact.

The Build

A daily scheduled scan pulls every HubSpot contact, then for each one queries Salesforce with a single SOQL call — an Account lookup matched by email domain, with a nested subquery pulling that account's Opportunities in one round trip instead of two. A Code node runs the actual comparison deterministically rather than leaving it to the LLM: it checks for a real Closed Won opportunity against the contact's current HubSpot stage and flags one of two mismatch types — HubSpot behind (any stage short of Customer despite a Closed Won deal) or HubSpot ahead (Customer with no Closed Won opportunity, including the case where there's no opportunity on the account at all).

Flagged contacts are processed one at a time through a batch loop — after a real bug where a run with two discrepancies only sent a Slack approval for the first contact and silently dropped the second when the execution completed. Fixed by wrapping the approval step in a one-item-at-a-time loop with an explicit loop-back after every outcome, approved or skipped, so each contact gets its own Claude explanation and its own interactive Slack message before the next one is even drafted. Approving a fix writes the corrected lifecycle stage to HubSpot and logs the previous stage, the corrected stage, the reason, and the matched Salesforce account to a Data Table for a full audit trail.

Daily HubSpot pull → Salesforce lookup per contact → Deterministic mismatch check → One discrepancy at a time → Claude drafts the explanation → Slack approval → HubSpot corrected + logged

Draft Discrepancy Explanation Prompt

Same Fortavault context as the other builds, with a narrow job: turn a raw stage/reason mismatch into something a RevOps teammate can approve in Slack without having to decode field names.

You are a RevOps data-quality assistant for Fortavault, Inc., a fictional data protection and security platform (cloud backup, ransomware recovery, zero-trust access, compliance reporting). You review discrepancies between HubSpot lifecycle stages and Salesforce deal reality (surfaced by an automated sentinel) and write a short, specific, plain-English explanation for the team reviewing the flag in Slack. Be concrete and reference the actual facts given - never invent details not provided. A HubSpot lifecycle stage looks out of sync with Salesforce reality for Fortavault, Inc. (a fictional data protection and security platform). Contact: {{ firstName }} {{ lastName }} ({{ email }}) Company: {{ companyName }} (matched Salesforce account: {{ sfAccountName }}) Current HubSpot lifecycle stage: {{ hsLifecycleStage }} Proposed corrected stage: {{ expectedStage }} Salesforce facts: {{ reason }} Write a short (2-3 sentence) plain-English explanation for a Slack message aimed at the RevOps/marketing ops team, stating what is wrong and why the proposed stage is correct. Do not repeat the raw field names verbatim like a report - write it like a colleague flagging the issue.

A Real HubSpot API Limit I Hit Mid-Build

The first live run fixed one contact correctly but silently failed on the other — same code, same approval, same "success" response from HubSpot, but the property never actually changed. Chasing it down led to a genuine HubSpot platform limit: the API refuses to move a contact's lifecycle stage backward (Customer → Opportunity, say), full stop, on every write path — the legacy contacts API and the v3 CRM API alike. It doesn't error. It returns HTTP 200 and just doesn't apply the change, which is worse, because a Slack approval shows "done" over a record that never moved. I only caught it by re-reading the contact fresh from HubSpot after the fact instead of trusting the node's own response — which is now standard practice for me on anything that writes.

The fix, confirmed with a raw API call before touching the workflow: clear the property to blank in one PATCH call, then set the corrected stage in a second PATCH call. HubSpot allows any value once the field has no current stage to protect. The two HTTP Request nodes below replaced what had been a single HubSpot node upsert, and both stage directions — Lead → Customer and Customer → Opportunity — now apply for real, verified against a fresh HubSpot read after every approval.

Live Run

The Fixing MAP-CRM Discrepancies workflow graph in n8n
The live workflow graph in n8n — HubSpot pull, Salesforce match, deterministic comparison, one-at-a-time Slack approval loop, and the two-call HubSpot fix (Clear Lifecycle Stage → Update Lifecycle Stage) before logging.
Two real lifecycle-stage mismatch approval messages posted to Slack
Two real mismatches from the same live run, each with its own approval — a Customer with no backing opportunity, and a Lead sitting on a Closed Won deal.

Impact (measured from live runs)

2 of 2
real discrepancies flagged and corrected in one run
Both directions
Lead→Customer and Customer→Opportunity both applied for real
0
manual HubSpot edits after Slack approval

The Campaign Fatigue Firewall

~3 min read

A daily scan computes each contact's real HubSpot touch frequency against a configurable cap, cross-checks the matching Salesforce opportunity's stage before suppressing anyone, then has Claude draft the suppression or override rationale and posts a digest to Slack.

n8n Cloud · HubSpot API · Salesforce (OAuth2) · Anthropic Claude (Sonnet 4.6) · Slack API · n8n Data Tables

The Problem

Touch-frequency capping usually runs on a mock touch log or a rule buried in a sequence tool's own settings, disconnected from what a contact is actually experiencing across every channel at once. Cap too loosely and a contact gets buried under five emails in two weeks; cap too bluntly and the automation itself starts doing harm — muting a contact the moment they cross a generic frequency threshold, even if they're mid-negotiation on a real deal that depends on staying responsive. A frequency cap that can't tell the difference between a cold contact and someone about to sign is a guardrail that creates a new problem while it's solving the old one.

A CRM consultant on LinkedIn described the version every buyer notices: a rep is in a live deal while an outbound sequence keeps emailing the same company’s CFO. “They think nobody in your company talks to each other. They’re right.”

Over-touching has a measurable cost. In an email platform’s survey of 6,000 consumers in five countries, 68% said receiving too many messages is the top reason they unsubscribe from marketing emails and texts. Once they leave, the channel is gone for good, including for the deal that needed it.

The Build

A daily scan pulls every real contact from this HubSpot account (11 total) and keeps only the 8 that are actual Fortavault demo contacts, filtering out HubSpot's own two built-in sample contacts and one personal test contact by a real email endsWith 'demo.io' check. For each of those 8, the workflow hits HubSpot's real Engagements v1 API for that contact's actual engagement history and counts how many touches fall inside a configurable rolling window — a 3-touch cap over 14 days, set once in a Config node so the threshold can change without touching any downstream logic. Three contacts came back over cap; the other five were left alone entirely, with no Slack noise and no log row, the same "only surface what matters" pattern used elsewhere in this series.

For just those three, the workflow pulls every real open Salesforce Opportunity and matches each contact to one by company-name substring — the same honest workaround used elsewhere in this series, since there's no shared account ID linking HubSpot contacts to Salesforce records in this stack. One match came back: an actual open Opportunity for the same company as an over-cap contact, sitting past Qualification (in Proposal/Negotiation). That contact gets kept in active outreach instead of muted. The other two had no matching open deal, so they get suppressed. Claude then drafts a one-to-two sentence, numbers-only explanation for each of the three — why it's suppressed, or why the deal-stage override kept it active — using a structured-output parser so the result is always a clean { explanation: string }. Every decision is logged to a Data Table and included in a single compact Slack digest; nothing about a contact under cap ever reaches either.

Daily scan: real HubSpot contacts, filtered to real Fortavault demo contacts → Pull each contact's real engagement history, compute touches in a 14-day window → Keep only contacts over the configured cap (3)
Match over-cap contacts to real open Salesforce Opportunities by company name → Open deal past Qualification found → override, keep active. No match → suppress → Claude drafts grounded explanation (structured output) → Log every decision to a Data Table + post digest to Slack

Real vs. Simulated

The contacts, the cap math, the Salesforce Opportunity data, the company-name cross-reference, and Claude's explanations are all real. The one piece that had to be manufactured was the touch history itself: this trial HubSpot account started with zero engagement records on any contact, so there was no rolling window to compute against. Rather than fake that history as a mock array n8n alone would see, real backdated engagement records were created through HubSpot's own Engagements v1 REST API — genuine, persisted records with real timestamps 1 to 12 days in the past, retrievable the same way authentic outreach history would be. Reading them back surfaced a real, honestly-reportable HubSpot behavior: every engagement's email body comes back as "The content of this email has been redacted. To include it in the response, your app must require the sales-email-read scope" — a genuine scope restriction on this app token. It never mattered here, since the workflow only ever reads each engagement's timestamp and never its content, but it's the kind of real API behavior worth reporting rather than quietly working around unmentioned.

A Real Salesforce Limit I Hit Mid-Build

The first attempt at pulling Opportunities used resource: 'search', operation: 'query' with a plain SOQL statement. It returned zero rows — not a bad query, confirmed by trying several valid SOQL variants against the same object on a throwaway exploration workflow, every one of them empty despite plenty of real, pre-existing Opportunities already sitting in this org from earlier builds in this series. Switching to resource: 'opportunity', operation: 'getAll' with an explicit options.fields list worked immediately and returned full real data. A related server-side filter, conditionsUi set to IsClosed = false, also didn't visibly narrow the result set when tested the same way — so rather than trust a server-side condition that may or may not be applying, the fix fetches every Opportunity (returnAll: true, no conditions) and filters IsClosed === false client-side inside the Match And Decide code node, which works regardless of what's actually causing the server-side filter to misbehave.

A Real Flag, a Real Override

Priya Nandan at Brightpath Analytics crossed the cap with 4 touches in 14 days against a limit of 3, and no open Salesforce Opportunity exists for her company — here's Claude's unedited explanation:

All active campaigns and sequences should suppress Priya Nandan at Brightpath Analytics because she has received 4 touches in the last 14 days, exceeding the 3-touch cap, and there is no open Salesforce opportunity to justify a deal-stage override. Without a late-stage deal in play, continued outreach is not warranted and she should remain suppressed until the touch window resets.

Marcus Ionescu at Castleton Freight Co. crossed the same cap harder — 5 touches against 3 — but a real open Opportunity, Castleton Freight Co. – Fleet Rollout, sitting at $62,000 in the Proposal/Negotiation stage, kept him in active outreach instead:

Marcus Ionescu at Castleton Freight Co. has received 5 touches in the last 14 days, exceeding the cap of 3, but the deal-stage override kept him in active outreach due to the open Salesforce opportunity 'Castleton Freight Co. - Fleet Rollout,' which is currently in the Proposal/Negotiation stage. Suppressing contact at this critical late-stage deal moment would risk disrupting an active negotiation, justifying the continued engagement despite the cap breach.

Live Run

The Campaign Fatigue Firewall workflow graph in n8n
The live workflow graph in n8n — real HubSpot touch history and real Salesforce opportunity stage feeding a single suppress-or-override decision per contact, drafted by Claude, then logged and posted to Slack side by side.
The real Slack digest from a live Campaign Fatigue Firewall run, showing three flagged contacts
The real Slack digest from the live run — two suppressions and one deal-stage override, each line built from real data rather than raw Claude prose.

Impact (measured from live runs)

8 / 11
real HubSpot contacts checked against a real 3-touch/14-day cap, after filtering out sample and personal test contacts
3 / 8
contacts flagged over cap — 2 suppressed, 1 kept active by a genuine open-deal override
$62,000
real open Salesforce Opportunity (Proposal/Negotiation stage) that kept an over-cap contact from being silently muted

How This Would Actually Pause Sends

Right now the workflow's only real-world effects are the Data Table row and the Slack line — nothing here touches sequence enrollment, so a "suppressed" contact keeps receiving whatever they're already enrolled in until a person acts on that log or Slack post. Making a suppress decision actually stop future touches doesn't need a new integration, just one more real step: right after Match And Decide flags a contact as decision === 'suppress', a HubSpot node with resource: 'contact_list', operation: 'add' can add that contact to a real static list (something like "Fatigue-Suppressed") using the exact same hubspotAppToken credential already wired into every other HubSpot node here. From there, suppression becomes a one-time config change inside HubSpot itself — every sequence and marketing email in the account gets that list added to its exclusion rules — rather than more n8n logic per contact.

One honest wrinkle: HubSpot's public API has a real, documented endpoint to enroll a contact in a sequence (POST /automation/v4/sequences/enrollments), but no published endpoint to unenroll one — HubSpot's own model treats unenrollment as something that happens through a contact's reply, a booked meeting, or a sequence's own automatic-unenrollment rule, not a directly callable API. A suppression list is the actual lever available for a workflow like this to pull; reaching into a live sequence and force-unenrolling a specific contact isn't something the public API exposes today.

The Duplicate Contact Consolidator

~5 min read

Finds Salesforce records that share an email: duplicate Contacts, and open Leads that already have a Contact. It proposes one survivor per person and asks for approval in Slack. It then runs Salesforce's real merge and lead conversion through Apex, pushes the clean record to HubSpot, and re-checks both systems for exactly one record per email.

n8n Cloud · Salesforce (OAuth2 + Apex REST + Tooling API) · HubSpot API (App Token) · Slack API (send-and-wait approval) · n8n Data Tables

The Problem

Duplicates are the quiet tax on every other automation in this series. When the same buyer exists as two Salesforce Contacts, or as a Contact plus a forgotten open Lead, activity gets split between records. Scores read half the history, and reps work whichever record they clicked into first. The tempting fix is “copy the fields over, then delete the extra record.” That fix is dangerous. Every opportunity role, case, task and note attached to the deleted record goes with it unless each one is moved over by hand first.

A revenue-operations analyst on LinkedIn described the everyday version: “The same lead exists 3 times under different email formats. One rep is working it. Two others don’t know.”

A data-quality vendor’s 2025 survey of 602 CRM users found 37% had lost revenue as a direct result of poor data quality, and 76% said less than half of their CRM data is accurate and complete. The same vendor’s earlier report cites a finding that the average contact database is more than a quarter duplicates.

The Build

Each week n8n reads every Salesforce Contact and open Lead that has an email, plus everything attached to them: opportunity roles, cases, tasks and events. Code groups the Contacts by email and picks one survivor per group. The rule, decided deliberately for this build, is that the record with the most attached history wins, with ties going to the most recently modified. Before merging, any blank field on the survivor (phone, title, mobile) is filled from the duplicate, because a merge keeps the survivor's values. Separately, any open Lead whose email already belongs to a Contact is queued for conversion onto that Contact rather than becoming a new one.

Nothing changes without a person. The full plan goes to Slack as an approval request: every record side by side, which one survives and why, and what will be filled. The workflow then pauses until someone clicks Approve or Decline. On approval it makes the changes:

  • Merges use Salesforce's native Database.merge, the same operation as the Merge Contacts button, which moves everything attached to the duplicate onto the survivor.
  • Conversions use Database.convertLead onto the existing Contact, with no new Contact and no opportunity created.
  • Each surviving record is upserted into HubSpot by email.

Finally, both systems are queried again, and each email must come back with exactly one Salesforce Contact, zero open Leads and one HubSpot contact. Every action and check is written to a Dedupe Audit Log. If verification fails, Slack gets a red alert instead of a green summary.

Weekly scan: Contacts + open Leads + opportunity roles, cases, tasks, events → Plan in code: survivor = most history; gap-fill; Lead–Contact matches → Slack approval request, and the workflow waits
Approved: gap-fill, Database.merge, Database.convertLead via Apex REST → Upsert the surviving records into HubSpot by email → Re-check both systems, audit log, green summary or red alert in Slack

Why Apex, and How It Got There

Salesforce's merge is only reachable from Apex. The standard REST API that n8n's Salesforce node uses can update and delete records, but it can't merge them. Merging is what moves the attached records over, and that is what makes it safe to run against real opportunities and cases. So this build adds a small Apex REST endpoint, DuplicateMergeService, which takes a survivor and up to two duplicates and calls Database.merge. The original plan had that class pasted into Salesforce Setup by hand. Instead, n8n deployed it through Salesforce's Tooling API with the same OAuth credential every other build uses, then confirmed it compiled and was Active before anything ran. That works because this is a developer org. A production org would deploy Apex through a sandbox and change set with test coverage, and the write-up doesn't pretend otherwise.

Real vs. Simulated

One duplicate pair was seeded to give the merge something to do. Two Contacts named Jordan Ellis share an email at a real account, Harborstone Insurance. The older record has the history: a Decision Maker role on Harborstone's real won deal and two tasks. The newer one has a single task and was edited more recently. A “most recently modified wins” rule would have kept the empty record. The activity rule keeps the right one.

The Lead–Contact cases weren't seeded; they were already in the org. Two of Salesforce's own sample Leads, Pat Stumuller and Andy Young, share emails with existing Contacts. Both have the status “Closed – Converted,” yet Salesforce reports them as never converted. That's a stale status that hides two open duplicate Leads from anyone filtering on it. Everything after that point is real: the merge, the conversions, the HubSpot records and the verification counts.

A Real Salesforce Bug: The Conversion Endpoint That Wasn't There

The design called for lead conversion through Salesforce's REST “convertLead” action. On the first live run the merge went through, but both conversions came back with a 404: Invalid Action Type: convertLead. No such action exists in this org, so lead conversion, like merging, is effectively Apex-only. The workflow did what it was built to do. A failed call doesn't stop the run; it's logged, and verification then found one open Lead still sitting on each of those emails. Slack got a red “verification FAILED” alert rather than a false success. The fix was a second small Apex endpoint, LeadConvertService, built on Salesforce's own lead-conversion call against the existing Contact. It was deployed the same way, and on the next approved run both conversions went through and every check came back green.

Before and After

[email protected] before Salesforce: 2 Contacts HubSpot: 0 after Salesforce: 1 Contact HubSpot: 1 [email protected] before Salesforce: 1 Contact + 1 open Lead HubSpot: 0 after Salesforce: 1 Contact, 0 open Leads HubSpot: 1 [email protected] before Salesforce: 1 Contact + 1 open Lead HubSpot: 0 after Salesforce: 1 Contact, 0 open Leads HubSpot: 1 Surviving Jordan Ellis after the merge: tasks Discovery call; Security questionnaire returned; Inbound email: renewal pricing question (moved from the duplicate) role Decision Maker on Harborstone's won deal (kept) phone +1 617 555 0142 (filled from the duplicate before merging)

HubSpot is the lighter half on purpose. HubSpot already enforces one contact per email, so true same-email HubSpot duplicates are rare, and this build doesn't try to manufacture one. It's really Salesforce dedupe plus a HubSpot sync: the surviving Salesforce record is the source of truth, and HubSpot is upserted to match.

Live Run

The Duplicate Contact Consolidator workflow graph in n8n
The live workflow graph in n8n: load records and history, plan in code, wait for Slack approval, merge and convert through Apex, sync HubSpot, then verify both systems and report.
The Slack approval request for the merge
The real approval request: both Jordan Ellis records side by side, why the older one survives even though the other was edited more recently, the gap-fill, and the two stale Leads, with Approve and Decline buttons.
The red verification-failed alert from the first run
The first run's red alert: the merge succeeded, both REST conversions returned 404, and verification still found an open Lead on each email. Below it, the second run's approval request after the Apex fix.
The green verified result after the fix
After the Apex lead-conversion fix: both conversions succeed and every email verifies at one Salesforce Contact, zero open Leads and one HubSpot contact.

Impact (measured from live runs)

3 of 3
emails verified at exactly one Salesforce Contact, zero open Leads and one HubSpot contact across the two live runs
0 records lost
every task and the opportunity role on the merged duplicate moved to the survivor, rather than being deleted with it
1 false success avoided
the 404 on lead conversion surfaced as a red alert from verification, not a green message that wasn't true

The Lead Black-Hole Finder

~4 min read

Leads die quietly: owned by a rep who left, waiting on someone on leave, or untouched past the first-call deadline. This build sweeps every open Salesforce lead each morning, separates the truly stuck from the deliberately parked, and moves the stuck ones after a human approves in Slack.

n8n Cloud · Salesforce API (read + Task create) · Anthropic Claude (Sonnet 4.6) · Slack API (send-and-wait approval) · n8n Data Tables

The Problem

Routing gets built once and then drifts. One data-operations vendor lists the ways leads end up in “black holes”: still owned by people who left, sitting in queues for months, or piled on one rep while another has room. It cites the familiar finding that following up within 30 minutes converts far better than waiting. Another vendor’s guide on reassignment describes the same pattern from the rep side. When an owner goes inactive, follow-ups are missed, notes get lost and the buyer drifts to a competitor. Nobody notices, because no report lists what isn’t happening.

The Build

Every weekday morning, n8n reads every open lead in Salesforce, who owns it and the rep roster. Code applies four rules, in order:

  • Owner left the company: reassign.
  • Owner on leave and no touch for 7+ days: reassign.
  • “Open – Not Contacted” more than 2 business days after assignment: nudge the owner.
  • Working but no touch for 21+ days: stale.

Stale isn’t always lost. Sometimes the buyer asked for a call in January. Claude reads the last note on each stale lead and reports a follow-up date only if the note states one, with the exact words. Code keeps the date only if the quote is in the note and the date is still ahead. Those leads are marked parked and left alone. Reassignments go to the active rep in the lead’s region with the most room. Nothing moves until a person clicks approve in Slack; then each move is logged as a task on the lead in Salesforce.

Weekdays: open Salesforce leads, owners, rep roster → Code: four black-hole rules
Claude: buyer-set follow-up date (quoted) → Code: verify, parked vs going cold, pick new owner
Approve in Slack → Move leads + Salesforce task on each + log

Real vs. Simulated

The 15 open leads are real Salesforce records, including their real status, company and location. This developer org has only one human user, so lead owners, the rep roster and the activity notes are a seeded overlay. One rep has left, one is on leave, and a new hire has an empty book. The Salesforce tasks written after approval are real. The seed has an answer key: four to reassign, one to nudge, two going cold, two parked on purpose and six healthy. One decoy note asks for a follow-up “after the migration in August”, a date that has already passed.

A Real Date Bug, Caught Before It Shipped

The first draft of Claude’s date rule said to read a month-only date as the first of the month, and to roll the year forward if that fell before the last touch. For “after the migration in August”, last touched on August 28, that means August 1, 2027. A dead lead would have been parked for another year. The rule now uses the last day of the month and the first such date on or after the last touch: August 31, 2026, which has passed, so the lead correctly shows as going cold.

Real Results

Reassign (4): approving moves these leads and logs a task on each lead in Salesforce • Phyllis Cotton, CFO at Abbott Insurance: Jonah Pryce left on 2026-09-19; never touched → Grace Lin • Mike Braund, VP Technology at Metropolitan Health Services: Jonah Pryce left; never touched → Grace Lin • Patricia Feager, CEO at International Shipping Co.: Jonah Pryce left; last touch 2026-09-16 → Grace Lin • Shelly Brownell, SVP Technology at Western Telecommunications: Ellie Novak on leave until 2026-11-02 → Kim Tran Nudge the owner (1): Jeff Glimpse, not contacted after 4 business days (SLA is 2) Going cold (2): Kathy Snyder ("Left a voicemail, no reply.") · Kristen Akin (follow-up date 2026-08-31 has passed) Parked on purpose (2): Brenda Mcclure ("call back after their budget is set on November 3") Betty Bair ("she asked for a check-in on January 12") ✅ Reassigned 4 leads. A task explaining each move is logged on the lead in Salesforce.

Excerpts from the live run, which matched the answer key on all 15 leads. The approval was clicked in Slack, the four leads moved, and four real tasks were written to their Salesforce records.

Live Run

The Lead Black-Hole Finder workflow graph in n8n
The live workflow graph in n8n: open Salesforce leads, owners and the roster load and code finds black holes; Claude reads stale leads’ notes, code verifies and proposes owners; a person approves in Slack; leads move and a task is logged on each in Salesforce.
The Lead Black-Hole Finder approval request in Slack
The real approval request: four leads to reassign with the reason and new owner, one SLA miss, two going cold and two parked on purpose with the buyer’s words.
The Lead Black-Hole Finder result in Slack
After approval: four leads reassigned, each with a task in Salesforce explaining the move.

Impact (measured from live runs)

4 leads
rescued from a departed or on-leave owner and moved after one click in Slack
2 of 4
stale leads correctly left alone because the buyer set a future date, quoted from the note
15 of 15
open leads sorted to the seeded answer key, including the past-date decoy

The UTM Naming Enforcer

~4 min read

“LinkedIn”, “li” and “linkedin ” are one channel that reports count three times. This build checks every new touch’s tags against the naming plan, fixes the obvious ones itself, has Claude propose matches only from the allowed list, learns each approved match, and names the links that keep producing bad tags.

n8n Cloud · Anthropic Claude (Sonnet 4.6) · Slack API (send-and-wait approval) · n8n Data Tables

The Problem

Campaign tags drift the moment more than one person builds links. Guides on UTM governance describe the same failure: inconsistent capitals, spaces and abbreviations split one channel into several rows, so reports undercount the real thing and ops spends time every month cleaning data by hand. Cleanup after the fact also fixes the symptom and not the cause. The same badly tagged ad or email link keeps sending bad tags until someone finds it and corrects it.

A digital-analytics consultant on LinkedIn sees the same split constantly: “facebook vs Facebook vs meta.” The consultant’s summary: “Most companies do not have a traffic problem. They have a UTM problem.”

The cleanup is not a small tax. A marketing-data vendor’s survey of 713 marketers found about a fifth of their data- related time goes to cleaning data.

The Build

Every weekday, n8n checks the source, medium and campaign of each new touch against a taxonomy table of allowed values and known aliases. Each value goes through four steps, in order:

  • Exact match: clean.
  • Matches once lower-cased and trimmed, or a known alias: fixed automatically.
  • Anything else: goes to Claude, which may only propose a value already on the allowed list, or none. A new channel or a campaign that isn’t in the plan must stay unmatched, never be forced. Code rejects any suggestion that isn’t an allowed value.
  • Missing: flagged.

Claude’s matches need a click in Slack. Once approved, they are applied and saved to the taxonomy as aliases, so the same tag fixes itself next time without Claude. The post also groups every problem by link ID, so whoever owns that ad or email can fix the link itself.

Weekdays: taxonomy + new touches → Code: clean, auto-fix, or ask
Claude: match to an allowed value or none → Code: allowed values only, group by link
Approve in Slack → Write clean tags + save new aliases

Real vs. Simulated

The touches, tags and taxonomy are seeded, because this org has no web analytics or ad platform connected. The writes are real: the clean tags and the learned aliases land in n8n Data Tables. The seed has 20 touches with an answer key. Four are clean, five need only capitals, spaces or a known alias fixed, and nine need a match:

  • “newsleter”
  • “Google Ads”
  • “g2crowd”
  • three campaign names written as prose

Two are decoys that must stay unmatched: a “black-friday-promo” campaign that isn’t in the plan, and “chatgpt.com” as a source. That one is a real channel, but not one the taxonomy has a value for yet.

A Real Slack Problem: Reasons Taking Up the Room

In the test run Claude explained each match in a full sentence, such as “Same campaign described with spaces and no date prefix or bucket segment…”. Six of those pushed the approval message close to Slack’s length limit, and the reasons were taking up space that the useful part of the message needs. That useful part is the list of links to fix, which is what stops the problem coming back. Each reason is now capped at ten words. The post lists the eight links with the most bad touches and gives the total, here 12.

Real Results

20 new touches checked. 4 clean, 5 fixed automatically, 9 need your approval, 2 need an owner. Proposed matches (approve to apply them and remember each as an alias) • campaign "q4 ransomware readiness" → 2026-q4_shield_ransomware-readiness • campaign "audit_season_2026" → 2026-q4_insights_audit-season • source "google ads" → google · source "newsleter" → newsletter · source "g2crowd" → g2 • campaign "hipaa-restore-webinar" → 2026-q4_backup_hipaa-restore No match, needs an owner • T14 (BF-01): campaign "black-friday-promo" is not in the plan • T15 (AI-01): source "chatgpt.com" is not in the plan; campaign is missing ✅ Approved. 18 of 20 touches now carry clean tags; 6 new aliases saved to the taxonomy.

Excerpts from the live run, which matched the answer key on all 20 touches. Both decoys stayed unmatched rather than being forced into the nearest allowed value.

Live Run

The UTM Naming Enforcer workflow graph in n8n
The live workflow graph in n8n: the taxonomy and new touches load and code checks every tag; Claude matches unknown tags to the allowed list, code verifies and builds the fixes; a person approves in Slack; clean tags are written and new aliases saved.
The UTM Naming Enforcer approval request and result in Slack
The real approval request: proposed matches, the two tags with no match and the links to fix at the source. Below it, the result after approval: 18 of 20 touches clean and six aliases learned.

Impact (measured from live runs)

18 of 20
touches carrying clean tags after one approval; the 2 left over are genuinely new and need an owner
6 aliases
learned from approved matches, so the same bad tags fix themselves without Claude next time
12 links
identified as the source of bad tags, the busiest listed in the post, so each can be fixed where it was built