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.
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. 21-node swarm. $0.073/run avg. Lowest monthly cost in the ForgeWorkflows lineup. This came from a CFO who received three different pipeline numbers from three different reports. We built a forecast agent that reconciles CRM data, historical patterns, and rep input into a single source of truth.
Last updated March 9, 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. Full Pipeline Ingestion. Weekly Forecast Brief.
Step 1 — The Fetcher
Code Only
Pulls all open deals from HubSpot via API, fetches owner data, assembles pipeline snapshot. Computes weighted coverage ratio, deal velocity scores, and flags stalled deals by stage duration benchmarks. Zero LLM cost.
Step 2 — The Analyst
Tier 1 Reasoning
What does The Analyst actually decide? Receives enriched pipeline data. Generates 3-scenario forecast (low/mid/high), identifies top risks, defines focus areas, ranks reps by weighted pipeline + velocity score. Chain-of-thought enforced. the primary reasoning model.
Step 3 — The Formatter
Code Only
This step exists because raw data alone is not enough. Converts analyst output into dual delivery format. Builds a 7-section Notion page (Pipeline Health, Forecast Range, Coverage Analysis, Top Risks, Focus Areas, Rep Leaderboard, Deal Table) and a condensed Slack Block Kit summary. Zero LLM cost.
Step 4 — The Syncer
HTTP
Without this step, upstream analysis sits idle. Delivers the full brief to Notion and the condensed summary to Slack simultaneously. Non-blocking: if either delivery fails, the other still completes. Pipeline intelligence is never lost.7 of 20 ITP fixtures had wrong expected values because they used simplified math instead of the pipeline's actual weighted formula.
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 replace HubSpot forecasting — it provides weekly intelligence briefs, not real-time pipeline management
Does not work with CRMs other than HubSpot — no Salesforce, Pipedrive, or Close integration
Does not paginate beyond 200 deals — v1.0 limitation, cursor pagination planned for v1.1
Does not provide historical trend analysis — each run is a point-in-time snapshot, not a comparison to prior weeks
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 RevOps Forecast Intelligence Agent processes your entire HubSpot pipeline at $0.073/run with a single the primary reasoning model call.
Workflow Nodes
21 specialized n8n nodes
Tested on n8n v2.7.5, March 2026
RevOps Forecast Intelligence Agent v1.0.0 — Technical Reference━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━Pipeline: Schedule Trigger → Configuration Loader → ITP Check → HubSpot Owner Fetcher → HubSpot Deal Fetcher → Pipeline Assembler → Empty Pipeline Gate → Pipeline Enricher → Analyst Prompt Constructor → The Analyst (Opus 4.6) → Analyst Response Parser → Formatter → Notion Page Creator + Slack Message Sender → Success LoggerTopology: Scheduled weekly, full pipeline ingestion, single LLM call, dual delivery (Notion + Slack)Coverage Health: STRONG (≥3.0) | ADEQUATE (≥2.0) | AT_RISK (≥1.0) | CRITICAL (<1.0)Forecast Confidence: HIGH | MEDIUM | LOW (based on pipeline health + deal count + stage distribution)Brief Sections: Pipeline Health | Forecast Range | Coverage Analysis | Top Risks | Focus Areas | Rep Leaderboard | Deal TableNode Count: 21 (Schedule 1, Webhook 1, Code 9, IF 2, HTTP Request 4, Respond 2, Filter 1, Set 1)LLM: Claude Opus 4.6 (Analyst, single call per pipeline)Cost: $0.073/run avg | $0.056 (2 deals) to $0.101 (22 deals) | $0.002/marginal dealITP: 20/20 (100%) — R01 through R20, 14/14 milestonesBQS: 12/12 PASSMax Deals: 200 per run (v1.0 limitation, cursor pagination planned for v1.1)
What You'll Need
Platform
n8n 2.11.2+
Est. Monthly API Cost
Under $1/month
Credentials Required
- ▪Anthropic API
- ▪HubSpot API
- ▪Notion API
- ▪Slack Bot Token
Services
- ▪HubSpot CRM (Sales Hub)
- ▪Notion workspace
- ▪Slack workspace
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
RevOps Forecast Intelligence Agent v1.0.0
$297
one-time purchase
What you get:
- ✓ITP-tested 21-node n8n workflow — import and deploy
- ✓Full HubSpot pipeline ingestion — pulls every open deal, no manual export
- ✓Weighted coverage ratio with STRONG / ADEQUATE / AT_RISK / CRITICAL thresholds
- ✓Deal velocity scoring — flags stalled deals by stage duration benchmarks
- ✓3-scenario forecast (low / mid / high) with confidence rating
- ✓Rep leaderboard ranked by weighted pipeline + velocity score
- ✓Dual delivery: 7-section Notion brief + condensed Slack Block Kit summary
- ✓$0.073/run average — $0.29/month at weekly cadence
- ✓Full ITP test results with 20 fixtures and 14/14 milestones
- ✓BQS-certified (12/12 PASS)
Frequently Asked Questions
How does the weekly pipeline pull work?+
The workflow runs on a configurable schedule (default: Monday 7:00 AM). It fetches all open deals from your HubSpot pipeline via API, pulls deal owner data, and assembles a complete pipeline snapshot. No manual export or spreadsheet required.
What is the coverage ratio and how is it computed?+
Weighted coverage ratio = sum(deal amount × probability) / quarterly quota. Thresholds: STRONG (≥3.0×), ADEQUATE (≥2.0×), AT_RISK (≥1.0×), CRITICAL (<1.0×). This tells you whether your pipeline has enough weighted value to hit quota.
What does the forecast brief contain?+
Seven sections: Pipeline Health (coverage ratio, deal count, total value), Forecast Range (low/mid/high scenarios with confidence), Coverage Analysis (stage distribution, probability weighting), Top Risks (stalled deals, concentration risk), Focus Areas (recommended actions), Rep Leaderboard (ranked by pipeline + velocity), and Deal Table (every open deal with status).
How much does each run cost?+
ITP-measured: $0.073/run average across 20 test fixtures. Range: $0.056 (2 deals) to $0.101 (22 deals). At weekly cadence, that is approximately $0.29/month — the lowest monthly cost in the ForgeWorkflows lineup.
What happens when the pipeline is empty?+
The Empty Pipeline Gate detects zero open deals and skips the LLM call entirely. Cost: $0.00. No Notion page or Slack message is created.
Can I customize the stage benchmarks and quota?+
Yes. The Configuration Loader node has three configurable parameters: pipeline_id (which HubSpot pipeline to analyze), quarterly_quota (your revenue target), and stage_benchmarks (days expected per stage, used for velocity scoring). All are editable in the n8n node.
Does it work with pipelines larger than 200 deals?+
v1.0 fetches a single page of HubSpot deals (limit 200). If your pipeline has more than 200 active deals, only the first 200 are analyzed. Full cursor pagination is planned for v1.1.
Why dual delivery (Notion + Slack)?+
Notion receives the full 7-section brief for deep review and historical reference. Slack receives a condensed Block Kit summary for quick scanning. Both deliveries are non-blocking — if one fails, the other still completes.
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.
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.
Customer Onboarding Intelligence Agent
Deal closes. AI builds the onboarding brief before CS picks up the phone.