How to flag HubSpot deals with missing close dates or amounts and Slack the rep

Why enforce deal data quality?

Garbage pipeline data leads to garbage forecasts. When reps skip fields like close date or deal amount, managers can't forecast accurately, and pipeline reviews waste time filling in basics instead of discussing strategy.

In a typical 50-deal pipeline, 20-30% of deals are missing at least one critical field — close date, amount, or next step. That's 10-15 deals where your forecast is literally guessing. A CRO looking at a $3M pipeline may be seeing $2M of real data and $1M of blanks that default to $0, making the forecast useless for board reporting.

HubSpot's required properties feature helps, but only at stage gates. Deals created via API, imported from CSV, or created before the rule was added slip through. A daily Slack nudge catches everything the stage gates miss.

How it works

Every approach in this guide follows the same pattern:

1. Trigger on a daily schedule (before the team starts their day)
2. Search for active deals missing each required field using HubSpot's NOT_HAS_PROPERTY filter
3. Deduplicate results across field searches (a deal missing both close date and amount shows up in both)
4. Group deals by owner so each rep gets one consolidated message
5. DM each rep in Slack with their incomplete deals, direct HubSpot links, and which fields to fill in

What you'll need

Which approach should I use?

• n8n (recommended) if you want a single visual workflow with Code node handling the deduplication and grouping. Free self-hosted or $24/mo cloud.
• Zapier if your team already uses Zapier. Requires the Professional plan ($30/mo) for Webhooks and Code. Works well but the Code step output limitations make per-owner DMs more complex.
• Make if your team already uses Make. The HTTP modules handle the HubSpot API directly, and a Code module handles grouping. Fits the free plan at typical volumes.
• Code + Cron if you want zero ongoing cost and full control. Best for teams with a developer who can maintain the script.
• Claude Code if you want on-demand audits — before pipeline reviews, after data imports, or alongside your regular schedule. The agent adapts to ad hoc requests like "check just deals in the Proposal stage."

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