Active deals health check agent

Sends a weekly HubSpot deal health update, ranks deals and enables the sales team.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Create an agent that sends a weekly {{HubSpot}} active deals report to {{Gmail}} and {{Slack}} with deal size, last communication, likelihood percent, and next activity date, grouped into Green Yellow Red, flags any deal past its close date as Red, and prompts you to either update the close date or mark it closed lost with a reason.

Click to interact

Why you need it

Active deals often look fine in the pipeline but can quietly stall. Close dates slip, last contact gets older, and no one notices until it is too late. This agent gives you a simple weekly view of deal health. It pulls active deals from HubSpot, summarizes key info like deal size, last communication, close likelihood, and next activity date, then ranks each one as Green, Yellow, or Red. Any deal with a past close date is flagged as Red and the agent prompts you to either move the close date forward or convert it to Closed Lost with a reason. You get a clear picture of where to focus and a gentle push to keep your pipeline honest.

What you need in Vellum

  • HubSpot integration with access to deals
  • Fields for deal amount, last activity date, close probability, next activity date, close date, and stage
  • Logic that assigns Green, Yellow, or Red based on recency, next steps, and close date
  • A check that flags deals with past close dates as Red
  • A step that prompts the user to move the close date or mark the deal as Closed Lost with a reason
  • An output channel for the weekly update such as Slack, email, or Notion
  • A weekly schedule trigger to run the agent and send the summary
Created By
Nico Finelli
Last Updated
December 4, 2025
Categories
AI Agents
Chatbot / Assistant
Data extraction
Tools

Discover more agents

Review my roadmap based on team capacity
Detect declining usage trends ahead of renewals
Track team progress without standup meetings
Help me write SEO optimized articles
Flag suspicious Stripe transactions in Slack
Automate KYC checks and send reports to Slack
Summarize my clients’ portfolios weekly
Review my contracts and generate risk summaries
Highlight NDA deviations and send alert to Slack
Review DPAs or privacy policies for compliance
Run review when new prior auth packets arrive
Review claims for compliance and errors
sucCCESS STORIES

Hear it from our customers

We know the power of AI, but how do we make it secure and ensure that we're not compromising privacy and security while still providing value? Vellum has been a big part of accelerating that experimentation part, allowing us to validate that a feature is high-impact and feasible.
Pratik Bhat
ai Product manager
We sped up AI development by 50 percent and decoupled updates from releases with Vellum. This allowed us to fix errors instantly without worrying about infrastructure uptime or costs.
Jordan Nemrow
Co-Founder & CTO @ Woflow
Vellum helped us quickly evaluate prompt designs and workflows, saving us hours of development. This gave us the confidence to launch our virtual assistant in 14 U.S. markets.
Sebi Lozano
Sr. Product Manager @ Redfin

FAQ

How does the agent rank deals Green, Yellow, or Red?

It looks at fields like last communication date, next activity date, close date, and close probability. Green deals are on track with recent activity and future steps, Yellow deals show some risk such as older activity or weak next steps, and Red deals are stalled or past their close date.

Which deals are included in the weekly update?

The agent pulls deals from HubSpot that are in an active stage, not Closed Won and not Closed Lost. You can refine this filter by pipeline, owner, or minimum deal size if you want a tighter focus.

What happens with deals that have a past close date?

Any deal with a close date in the past is flagged as Red. The agent then prompts you to either move the close date to a realistic new date or convert the deal to Closed Lost and add a loss reason.

Where does the weekly summary get sent?

You can configure the agent to send the summary to Slack, email, Notion, or another channel. Many teams send a short list of Green, Yellow, and Red deals to a shared Slack channel and a more detailed view to the deal owners.

Can I customize the rules for deal health?

Yes. You can adjust how many days count as stale, what probability thresholds you consider risky, and which fields should influence Green, Yellow, or Red. You can also change how often the agent runs if you want more than a weekly update.