CRM Data Decay Detector
AI audits Pipedrive contacts on a weekly schedule, detecting data decay across 5 categories and routing prioritized remediation briefs to your CRM.
AI audits Pipedrive contact records for data staleness — outdated job titles, email risk, company mismatches, ghost contacts — and delivers a prioritized remediation brief. 19-node swarm. $0.024/record. Runs on schedule, no manual effort. We designed this after a data quality audit showed 23% of CRM records had at least one decayed field — old titles, defunct companies, bounced emails. The detector measures decay rate per field and prioritizes what to fix first.
Last updated March 8, 2026
CRM migrations and system integrations introduce data quality debt that compounds over months. Duplicate records, orphaned contacts, and inconsistent field mappings degrade every downstream workflow. Automated governance catches drift before it corrupts pipeline reporting.
One Auditor. Five Decay Categories. CRM Hygiene on Autopilot.
Step 1 — The Fetcher
Code Only
Pulls Pipedrive contacts sorted by last activity date. Filters to records stale beyond the configurable threshold (default 90 days). Zero LLM cost.
Step 2 — The Auditor
Tier 1 Reasoning
What does The Auditor actually decide? Scores each record across 5 decay categories: Title Staleness, Email Risk, Company Mismatch, Missing Critical Fields, and Ghost Contact. Single the primary reasoning model call per record.
Step 3 — The Router
IF Logic
Without this step, upstream analysis sits idle. Routes based on decay score and priority tier. HIGH → Pipedrive Activity (task to update). MEDIUM → Note for review. LOW → log only. Ghost Contact always escalates to HIGH.We price by pipeline complexity, not integration count. A $349 blueprint reflects 3x more prompt engineering than a $199 one.
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 automatically update or delete CRM records — it detects decay and creates remediation briefs for human follow-up
Does not work with CRMs other than Pipedrive — no HubSpot, Salesforce, or custom CRM integration
Does not verify contact data against external sources — it scores decay signals from existing CRM data patterns
Does not process real-time events — it runs on a schedule and audits records in batch
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 CRM Data Decay Detector audits stale Pipedrive contacts at $0.024/record with a single LLM call.
Workflow Nodes
19 specialized n8n nodes
Blueprint Quality Standard
BQS v2 — 12/12 PASS
Agent Architecture
1 (Auditor) + batch orchestration + Pipedrive sync
Required Credentials
Anthropic API + Pipedrive API
Bundle Contents
9 files
ITP Milestones
CDD-01 through CDD-08 + U-01 through U-06 — 14/14 PASS
Score Consistency
Variance 0 across 3 runs (threshold <= 2.0)
Cost per Record
$0.024 (ITP-measured blended average)
n8n Compatibility
Self-hosted
Tested on n8n v2.7.5, March 2026
CRM Data Decay Detector v1.0.0 — Technical Reference━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━Pipeline: Schedule Trigger → Fetcher (Pipedrive API) → Staleness Filter → SplitInBatches → Auditor (Opus 4.6) → Router (IF) → Syncer (Pipedrive)Topology: Batch pipeline, single LLM call per record, 3-tier routingCategories: GHOST_CONTACT (30%) | TITLE_STALENESS (20%) | EMAIL_RISK (20%) | MISSING_CRITICAL (15%) | COMPANY_MISMATCH (15%)Routing: HIGH → Activity | MEDIUM → Note | LOW → Log | GHOST → always ActivityNode Count: 19 (Schedule 1, HTTP 4, Code 8, IF 3, SplitInBatches 1, Dead Letter 1, ITP Bypass 1)LLM: Claude Opus 4.6, temperature 0.2, max_tokens 2048Cost: $0.024/record blended | ~$1.21/week for 50-record batchITP: 20/20 (100%) — CDD-01 through CDD-08, U-01 through U-06BQS: 12/12 PASSConsistency: Variance 0 across 3 runs (threshold ≤ 2.0)
What You'll Need
Platform
n8n 2.11.2+
Est. Monthly API Cost
$3–6/month
Credentials Required
- ▪Anthropic API
- ▪Pipedrive API
Services
- ▪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
CRM Data Decay Detector v1.0.0
$199
one-time purchase
What you get:
- ✓ITP-tested 19-node n8n workflow — import and deploy
- ✓Scheduled batch processing — runs weekly, zero manual effort
- ✓5-category decay scoring with weighted analysis
- ✓3-tier routing: Activity (HIGH), Note (MEDIUM), Log (LOW)
- ✓Ghost Contact override — always escalates regardless of score
- ✓Configurable batch size, staleness threshold, and schedule cadence
- ✓Full ITP test results with 20 fixtures and cost analysis
- ✓BQS-certified (12/12 PASS)
Frequently Asked Questions
How does the scheduled batch processing work?+
The workflow runs on a configurable schedule (default: weekly). It fetches Pipedrive contacts sorted by last activity date, filters those stale beyond your threshold (default 90 days), and processes them in batches. No manual trigger needed.
What are the 5 decay categories?+
Ghost Contact (inactive 365+ days, no deals), Title Staleness (outdated roles, "Former/Ex-" prefixes), Email Risk (consumer domains on B2B records, role-based addresses), Missing Critical Fields (no phone, title, or company), and Company Mismatch (acquisitions, rebrands, defunct companies).
How does the 3-tier routing work?+
HIGH decay records get a Pipedrive Activity (a task assigned to update the record). MEDIUM records get a Note for human review. LOW records are logged only — no CRM action needed.
Why is Ghost Contact treated differently?+
Ghost Contacts represent the highest-value cleanup targets — records with 365+ days of inactivity, zero deals, and minimal data. The asymmetric risk logic ensures these are always flagged for immediate action, never quietly logged.
How much does each record cost to process?+
ITP-measured: $0.024 per record blended average. A 50-record weekly batch costs approximately $1.21/week (~$5/month). Only one LLM call (the Auditor) per record.
What n8n timeout setting do I need?+
Set EXECUTIONS_TIMEOUT to 600 seconds minimum for the default 50-record batch. Each record takes 5-10 seconds for the LLM call plus CRM writes. The README includes exact configuration steps.
Can I customize the batch size and schedule?+
Yes. Batch size (default 50), staleness threshold (default 90 days), and schedule cadence (default weekly) are all configurable in the workflow. The README covers all tuning options.
What happens if a Pipedrive write fails mid-batch?+
CRM writes are non-blocking. Failed writes go to the Dead Letter Logger while the batch continues processing remaining records. No single record failure can stall the pipeline.
Is this the first batch-processing product in the lineup?+
Yes. All prior ForgeWorkflows products are event-triggered (webhooks or inbox triggers). CRM Data Decay Detector is the first scheduled batch workflow — it runs proactively rather than reacting to events.
What CRM does this work with?+
Pipedrive. The workflow reads contact records via the Pipedrive API and writes Activities and Notes back. It requires a Pipedrive API token with read/write access to persons, activities, and notes.
Related Blueprints
Workflow Migration Agent
Map every step. Score every risk. Migrate with a plan.
Contact Intelligence Agent
Automated CRM enrichment that researches, scores, and writes back to Pipedrive — zero manual lookup.
Inbound Lead Qualifier
Qualify inbound form leads with a 3-agent ILQ scoring pipeline — web research, 4-criteria scoring, and automatic Pipedrive routing.
Email Intent Classifier
AI reads inbound emails, scores buyer intent across 7 categories, and routes to Pipedrive — deals, activities, and notes created automatically.