HubSpot Lifecycle Stage Audit Agent

Weekly AI funnel health audit that detects lifecycle stage bottlenecks, regression anomalies, skip patterns, and orphan contacts in your HubSpot CRM — with prioritized fix-it recommendations.

Automated weekly audit of your HubSpot lifecycle stage progression. Analyzes contacts across 5 funnel health dimensions: stage bottlenecks (contacts stuck >2x expected), regression anomalies (backward movement), skip patterns (jumped stages), orphan contacts (stage/deal mismatch), and funnel shape health (actual vs expected distribution). Delivers a comprehensive Notion funnel health brief and a Slack digest with the top 3 prioritized fix-it actions. Built on Anthropic Sonnet 4.6 with AGGREGATE analysis pattern.

triggerSchedule01FetcherHubSpot API02Assembler5 Dimensions03AnalystFunnel Health04FormatterBrief + DigestNotionHealth BriefSlackFix-It Actions

Four Agents. Weekly Funnel Health Audit. Zero Manual Review.

The Fetcher

Step 1The Fetcher

Code-only

Retrieves paginated contacts from HubSpot with lifecycle stage data, stage timestamps, and deal associations using the CRM v3 Search API.

The Assembler

Step 2The Assembler

Code-only

Computes funnel health metrics across 5 dimensions: stage bottlenecks (contacts stuck >2x expected), regression anomalies (backward movement), skip patterns (jumped stages), orphan contacts (stage/deal mismatch), and funnel shape health (actual vs expected distribution).

The Analyst

Step 3The Analyst

Classification

Performs AGGREGATE funnel health analysis. Identifies root causes, severity rankings, and patterns across all 5 dimensions. Generates the top 3 prioritized fix-it actions with expected impact and affected contact counts.

The Formatter

Step 4The Formatter

Creative

Generates a comprehensive Notion funnel health brief with per-dimension scores and action items. Generates a Slack digest with the overall health score and top 3 fix-it actions.

What It Does NOT Do

×

Does not audit lead scoring accuracy — use HubSpot Contact Scoring Auditor (#40) for scoring model assessment

×

Does not provide cross-functional GTM alignment — use Weekly GTM Alignment Brief (#44) for team-level reporting

×

Does not analyze marketing email performance — use HubSpot Marketing Email Intelligence (#53) for campaign metrics

×

Does not score individual contacts — this is an aggregate funnel-level audit

×

Does not provide real-time alerts — weekly batch analysis runs on a Monday schedule

×

Does not work with non-HubSpot CRMs — this is HubSpot-specific

The Complete Customer Success Bundle

6 files.

hubspot_lifecycle_stage_audit_agent_v1_0_0.jsonMain workflow (24 nodes)
hubspot_lifecycle_stage_audit_agent_scheduler_v1_0_0.jsonScheduler workflow (3 nodes)
README.md10-minute setup guide
docs/TDD.mdTechnical Design Document
system_prompts/analyst_system_prompt.mdAnalyst prompt reference
system_prompts/formatter_system_prompt.mdFormatter prompt reference

Tested. Measured. Documented.

Weekly 5-dimension funnel health audit with stage bottleneck detection, regression analysis, and dual-channel delivery (Notion brief + Slack digest with fix-it actions).

HubSpot Lifecycle Stage Audit Agent v1.0.0───────────────────────────────────────────────Nodes            24 (main) + 3 (scheduler)Agents           4 (Fetcher, Assembler, Analyst, Formatter)LLM Calls        2 per run (Analyst + Formatter)Model            Sonnet 4.6 (SINGLE-MODEL)Trigger          Schedule (weekly Mon 9:00 UTC) + WebhookPattern          AGGREGATE (weekly batch)Tool A           HubSpot (OAuth2) — contacts with lifecycle stage data and timestampsTool B           Notion (httpHeaderAuth) — funnel health briefTool C           Slack (httpHeaderAuth) — digest with top 3 fix-it actionsITP              8 variations, 14 milestonesBQS              12/12 PASSCost             $0.03–$0.10 per run

What You'll Need

Platform

n8n 2.7.5+

Est. Monthly API Cost

~$0.03-0.10 per weekly run. 4 runs/month ~$0.12-0.40/month.

Credentials Required

  • Anthropic API
  • HubSpot OAuth2 (hubSpotOAuth2Api type)
  • Notion (httpHeaderAuth Bearer)
  • Slack (Bot Token, httpHeaderAuth Bearer)

Services

  • HubSpot CRM (free tier or higher)
  • Anthropic API key
  • Notion workspace
  • Slack workspace (Bot Token with chat:write)

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

HubSpot Lifecycle Stage Audit Agent v1.0.0

$199

one-time purchase

What you get:

  • 24-node main workflow + 3-node scheduler
  • Weekly 5-dimension Funnel Health Score for your entire HubSpot CRM
  • Stage bottleneck detection (contacts stuck >2x expected duration)
  • Regression anomaly detection (backward lifecycle movement)
  • Skip pattern identification (contacts jumping stages)
  • Orphan contact flagging (stage/deal mismatches)
  • Funnel shape health scoring (actual vs expected distribution)
  • Notion funnel health brief with per-dimension breakdown
  • Slack digest with top 3 prioritized fix-it actions
  • Configurable stage durations, lookback window, and bottleneck sensitivity
  • Full technical documentation + system prompts

Frequently Asked Questions

What funnel health dimensions does it score?+

Five dimensions, each weighted 20%: stage bottlenecks (contacts stuck longer than expected), regression anomalies (backward movement like SQL to MQL), skip patterns (jumped stages like Subscriber to SQL), orphan contacts (stage/deal mismatches like Opportunity with no deal), and funnel shape health (how actual distribution compares to expected). Each dimension scores 1-10.

What lifecycle stages does it analyze?+

The expected progression is Subscriber, Lead, MQL, SQL, Opportunity, Customer. The agent uses HubSpot lifecycle stage timestamps to compute how long contacts spend in each stage and detect anomalies. You can customize expected durations per stage.

How does bottleneck detection work?+

The Assembler compares actual average days per stage against your configured expected days. When the average exceeds the expected duration multiplied by the BOTTLENECK_MULTIPLIER (default 2.0x), it flags a bottleneck. For example, if MQL expected duration is 30 days and average is 65 days (>60), it is flagged.

How does it differ from HubSpot Contact Scoring Auditor?+

HCSA (#40) audits lead scoring accuracy — confusion matrices, score distributions, segment-level precision. This product audits lifecycle stage progression flow — bottlenecks, regressions, skips, orphans, and funnel shape. Different HubSpot data, different analysis focus.

Can I customize the expected stage durations?+

Yes. Set EXPECTED_DAYS_PER_STAGE as a JSON object in the scheduler Build Payload node. Default: subscriber 14 days, lead 21 days, MQL 30 days, SQL 14 days, opportunity 45 days. Adjust to match your typical sales cycle.

Does it use web scraping?+

No. All data comes from the HubSpot CRM v3 API (contacts search with lifecycle stage properties). No web scraping, no page parsing.

Is there a refund policy?+

All sales are final after download. Review the Blueprint Dependency Matrix and prerequisites before purchase. Questions? Contact support@forgeworkflows.com before buying. Full terms at forgeworkflows.com/legal.

Read the full guide →

Related Blueprints