intermediate30 minutes3 min read

How to alert Slack when Pipedrive deals go stale with no activity

Find stale Pipedrive deals and alert reps in Slack. Compare Workflow Automation, n8n, and Claude Code approaches with setup steps and costs.

How to alert Slack when Pipedrive deals go stale with no activity

This recipe includes a downloadable n8n template and Claude Code skill.

Workflow

Daily schedule
Find stale deals
Any stale?
Yes
Slack alert per rep
No
No action

Why alert on stale deals?

Every sales pipeline accumulates zombie deals — opportunities that stopped moving weeks ago but nobody closes out. In a typical 100-deal pipeline, 15-25% are stale. That's potentially $500K-2M of phantom pipeline inflating forecasts, misleading leadership, and making quota attainment look better than it is.

The problem compounds because reps avoid closing their own deals (it hurts their numbers) and managers don't enforce it (manual pipeline review takes 30-60 minutes per week). Meanwhile, deals that could be revived with a timely follow-up slip further into oblivion.

Pipedrive has a built-in "rotting" indicator that marks deals visually when they exceed a per-stage inactivity period. But rotting is just a visual cue — it doesn't send Slack alerts, DM the deal owner, or trigger any automated follow-up. This recipe adds the teeth: a daily scan that finds stale deals and alerts each rep in Slack with the deal name, value, days stale, and a link to take action.

What you'll get
#sales-hygiene
Pipeline Botapp9:41 AM

⚠️ Stale Deal Alert

You have 3 deals with no activity in the last 30 days:

1. Meridian Health — Data Platform ($75,000) — 42 days stale

2. Contoso Ltd — Annual License ($28,000) — 35 days stale

3. Fabrikam Inc — Expansion ($15,000) — 31 days stale

Update these deals or close them to keep the pipeline accurate.

View your pipeline in Pipedrive →

How it works

Every approach follows the same pattern:

  1. Scan the pipeline on a schedule (daily or weekly) for open deals where the last activity is older than your threshold (e.g., 30 days)
  2. Group stale deals by owner so each rep gets one consolidated message
  3. Alert each rep in Slack with their stale deals, values, days stale, and direct links to the Pipedrive records

The approaches below differ in how they detect staleness. Pipedrive's native automation uses date fields (expected close date). n8n queries the API for deals with no recent activity. The Claude Code skill gives you conversational flexibility to ask about pipeline health.

What you'll need

Prerequisites
  • Pipedrive account on Growth plan or higher (required for Workflow Automations and API access)
  • Slack workspace with a bot added to your team's channels
  • A defined inactivity threshold (e.g., 30 days with no activity)

Which approach should I use?

  • n8n (Recommended) — daily scheduled workflow that queries the Pipedrive API for deals with no recent activity, groups them by owner, and sends each rep a consolidated Slack message. Handles custom thresholds per stage and true activity-based staleness detection. Self-hosted is free.
  • Pipedrive Workflow Automation — date-triggered automation that fires when expected close date passes. Simplest setup, zero external tools, but limited to date-based detection (not activity-based). Best for catching overdue deals, not true inactivity.
  • Claude Code — on-demand pipeline health checks. Ask Claude "show me all deals with no activity in 30 days" or "which reps have the most stale deals?" Best for weekly pipeline reviews and ad hoc analysis.

Choose your approach

Select an approach below to see the full step-by-step guide.

Compare approaches

Pipedrive Workflow Automation

low
Cost: $0 (included on Growth+)
Latency: scheduled
Code: none
Reliability: 24/7 cloud

n8n

medium
Cost: $0-24/mo
Latency: scheduled
Code: low
Reliability: 24/7 cloud

Claude Code

low
Cost: Usage-based
Latency: on-demand
Code: none
Reliability: On demand

Pipedrive Workflow Automation

low

Date-triggered automation on expected close date → Slack notification when deals become overdue

Cost: $0 (included on Growth+)View guide

n8n

medium

Daily schedule → Query Pipedrive API for stale deals → Summarize per rep → Slack alerts with deal details

Downloadable templateView guide

Claude Code

low

Guided Claude Code skill — ask Claude to find stale deals, analyze pipeline health, and alert reps conversationally

Downloadable skillView guide

Related Recipes

Frequently Asked Questions

Looking to scale your AI operations?

We build and optimize automation systems for mid-market businesses. Let's discuss the right approach for your team.