What This Workflow Does
This automation solves the common problem of stale deals cluttering your HubSpot pipeline. When deals go cold without proper follow-up or closure, they distort your sales forecasting and waste your team's time. The workflow automatically identifies deals with no activity for 21+ days, updates their status to Closed Lost in HubSpot, collects feedback from prospects via Gmail, and notifies your sales team in Slack.
By automating this process, you maintain an accurate sales pipeline while capturing valuable insights about why deals were lost. Sales reps save hours previously spent manually reviewing and closing old deals, allowing them to focus on active opportunities.
How It Works
1. Identify inactive HubSpot deals
The workflow queries your HubSpot account for deals that haven't been updated in 21 days (configurable). It filters based on deal stage and last activity date to ensure only truly inactive deals are selected.
2. Send feedback request emails
For each identified deal, the system sends a personalized email to the prospect through Gmail. The email politely asks for feedback about why the deal didn't progress, with optional multiple-choice options for easy response.
3. Update deal status in HubSpot
The workflow then updates each inactive deal's status to Closed Lost in HubSpot. It can optionally add notes about the closure reason if feedback was received from the prospect.
4. Notify team in Slack
Finally, the system posts a summary of closed deals to a designated Slack channel. The notification includes key details like deal value, company name, and any collected feedback for team visibility.
Who This Is For
This workflow benefits sales teams using HubSpot who want to:
- Maintain a clean, accurate sales pipeline
- Capture lost deal insights systematically
- Reduce manual CRM maintenance work
- Improve sales forecasting accuracy
- Increase team visibility into deal outcomes
Pro tip: Combine this with a monthly review of collected feedback to identify patterns in lost deals that can inform sales training and process improvements.
What You'll Need
- An active HubSpot Sales Hub account
- Gmail or Google Workspace account
- Slack workspace with appropriate channel access
- n8n instance or account (self-hosted or cloud)
- API credentials for all three services
Quick Setup Guide
- Download the JSON template file
- Import into your n8n instance
- Configure HubSpot, Gmail, and Slack API connections
- Set your inactivity threshold (default: 21 days)
- Customize the feedback email template if desired
- Test with a small set of deals first
- Schedule to run daily or weekly
Key Benefits
Save 3-5 hours per rep weekly by eliminating manual deal cleanup. Automation handles the repetitive work while your team focuses on selling.
Improve forecasting accuracy by maintaining a pipeline that reflects actual active opportunities rather than stale deals.
Capture valuable lost deal insights systematically through automated feedback requests that get 2-3x higher response rates than manual asks.
Enhance team visibility with automatic Slack notifications that keep everyone informed without additional reporting work.
Scale your sales process consistently as your team grows, ensuring deal hygiene standards are maintained automatically.