Expansion Revenue Detector
AI monitors Stripe payment patterns, scores expansion potential across 5 signal categories, and routes upsell and at-risk briefs to Pipedrive automatically.
AI monitors Stripe payment and subscription data, scores expansion potential across 5 signal categories, and routes upsell/at-risk briefs to Pipedrive automatically. 24-node swarm. $0.020/event — single LLM call. This came from a CS leader who discovered expansion opportunities only when customers asked for upgrades. We built a detector that identifies expansion signals — usage growth, feature requests, team size changes — before the customer raises their hand.
Last updated March 8, 2026
RevOps teams manage increasingly complex revenue stacks — multiple CRMs, billing systems, and data warehouses — with manual reconciliation consuming 20-30 hours per week. Automated revenue intelligence consolidates signals from Stripe, HubSpot, Salesforce, and Pipedrive into a single operational view.
Four Agents. Five Signals. Expansion Revenue Detected Automatically.
Step 1 — The Researcher
Code Only
Enriches invoice.paid webhook data with Stripe subscription, customer, and payment history. Computes MRR delta arithmetically — zero LLM cost.
Step 2 — The Analyst
Tier 1 Reasoning
What does The Analyst actually decide? Scores expansion potential across 5 signal categories: MRR Growth, Plan Ceiling, Payment Loyalty, Usage Plateau, Downgrade Risk. Single LLM call.
Step 3 — The Router
IF Logic
This step exists because raw data alone is not enough. Routes based on confidence threshold. High confidence → Pipedrive Activity for immediate action. Low confidence → Note for human review. DOWNGRADE_RISK always creates an at-risk Activity.
Step 4 — The Syncer
CRM Write
Without this step, upstream analysis sits idle. Writes to Pipedrive: creates Person (if new), creates or updates Deal, adds Activity (upsell/at-risk) or Note (retention/monitor). Non-blocking — pipeline never stalls on CRM errors.We tried three providers for $0.016 savings per lead. Three API keys, three billing accounts — the customer friction was not worth it.
That's the full pipeline. Here's what it intentionally does NOT do — and why those boundaries exist.
What It Does NOT Do
Does not connect to your billing system beyond Stripe — no Chargebee, Recurly, or custom billing integration
Does not predict future churn — it scores current expansion signals from payment patterns, not predictive modeling
Does not modify Stripe subscriptions — it reads payment data and writes intelligence to Pipedrive only
Does not replace your CS platform — it detects expansion opportunities and routes briefs for human follow-up
With those boundaries clear, here's everything that ships when you purchase.
The Complete Customer Success Bundle
8 files.
The technical specifications below are ITP-measured, not estimated.
Tested. Measured. Documented.
Every metric is Independent Test Protocol (ITP)-measured. The Expansion Revenue Detector processes Stripe webhook events at $0.020/event with a single LLM call.
Workflow Nodes
24 specialized n8n nodes
Blueprint Quality Standard
BQS v2 — 12/12 PASS
Agent Roles
4 (Researcher, Analyst, Router, Syncer)
Required Credentials
Stripe API + Anthropic API + Pipedrive API
Bundle Contents
9 files
Cost per Event
$0.020 (ITP-measured blended average)
ITP Milestones
ERD-01 through ERD-07 + U-01 through U-06 — 14/14 PASS
Score Consistency
Variance 0 across 3 runs (threshold <= 1.0)
n8n Compatibility
Self-hosted
Tested on n8n v2.7.5, March 2026
Expansion Revenue Detector v1.0.0 — Technical Reference━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━Pipeline: Stripe Webhook → Researcher (Code) → Analyst (Opus 4.6) → Router (IF) → Syncer (Pipedrive)Topology: 4-agent swarm, single LLM call, confidence-gated routingSignals: MRR_GROWTH | PLAN_CEILING | PAYMENT_LOYALTY | USAGE_PLATEAU | DOWNGRADE_RISKRouting: High confidence → Activity | Low confidence → Note | DOWNGRADE_RISK → always ActivityNode Count: 24 (Webhook 1, HTTP 11, Code 9, IF 2, Dead Letter 1)LLM: Claude Opus 4.6, temperature 0.1, max_tokens 1500Cost: $0.020/event blended | $0.000 invalid/rejectedITP: 20/20 (100%) — ERD-01 through ERD-07, U-01 through U-06BQS: 12/12 PASSConsistency: Variance 0 across 3 runs (threshold ≤ 1.0)
What You'll Need
Platform
n8n 2.11.2+
Est. Monthly API Cost
$1–5/month
Credentials Required
- ▪Anthropic API
- ▪Stripe API
- ▪Pipedrive API
Services
- ▪Stripe account
- ▪Pipedrive CRM
Setup Track
Quick Start
~15 min
All credentials live, n8n running
Full Setup
1–2 hrs
Needs API config + tables
From Scratch
2–4 hrs
No n8n, no credentials
Expansion Revenue Detector v1.0.0
$199
one-time purchase
What you get:
- ✓ITP-tested 24-node n8n workflow — import and deploy
- ✓Stripe webhook integration — fires on every invoice.paid event
- ✓5-signal expansion scoring with confidence thresholds
- ✓Automatic Pipedrive Person, Deal, Activity, and Note creation
- ✓Asymmetric risk logic — DOWNGRADE_RISK always escalates
- ✓Code-only Researcher — MRR delta computed without LLM cost
- ✓Full ITP test results with 20 scenarios and cost analysis
- ✓BQS-certified (12/12 PASS)
Frequently Asked Questions
What Stripe events does this workflow process?+
It triggers on invoice.paid events via Stripe webhook. Every successful payment fires the pipeline — subscription renewals, upgrades, downgrades, and one-time charges are all analyzed.
What are the 5 signal categories?+
MRR Growth (revenue increasing), Plan Ceiling (approaching plan limits), Payment Loyalty (consistent long-term payer), Usage Plateau (flat or declining engagement), and Downgrade Risk (signals of potential churn or downgrade).
How does the confidence-gated routing work?+
The Analyst outputs a confidence score (0-1). High confidence signals get a Pipedrive Activity for immediate action. Low confidence signals get a Note for human review.
Why is the Researcher code-only with no LLM call?+
MRR delta, payment history, and subscription metadata are numerical/structured data. The Researcher computes these arithmetically using n8n Code nodes — no reasoning needed, so zero LLM cost on data enrichment.
How much does each event cost to process?+
ITP-measured: $0.020 per event blended average. Only one LLM call (the Analyst) per event. Invalid or rejected webhooks cost $0.000.
What gets written to Pipedrive?+
Person (created if new), Deal (created or updated with expansion score), Activity (for high-confidence upsell or any DOWNGRADE_RISK), and Note (for low-confidence signals requiring human review).
What happens if Pipedrive is temporarily unavailable?+
The Syncer uses non-blocking writes. CRM errors are caught and logged to the Dead Letter node. The pipeline never stalls — webhook response is always returned.
Do I need to modify my Stripe setup?+
You need to add a webhook endpoint pointing to your n8n instance and enable the invoice.paid event. The README includes step-by-step Stripe webhook configuration.
Can I customize the signal thresholds?+
Yes. The Analyst system prompt includes the scoring rubric for all 5 signals. You can adjust confidence thresholds and scoring criteria to match your business model.
What n8n version is required?+
Tested on n8n self-hosted. The workflow uses standard HTTP Request, Code, and IF nodes — no community nodes required.
Related Blueprints
Deal Intelligence Agent
Stop reviewing CRM updates. Let AI flag what matters.
Post-Call Deal Updater
Transform sales call transcripts into structured deal intelligence, CRM updates, and follow-up tasks — automatically.
RevOps Forecast Intelligence Agent
AI pulls your entire HubSpot pipeline every week, computes coverage ratio and deal velocity, and delivers a forecast brief with risks, focus areas, and rep leaderboard — to Notion and Slack.
Customer Onboarding Intelligence Agent
Deal closes. AI builds the onboarding brief before CS picks up the phone.