Small Business Stack

Create a Follow-Up Task When a HubSpot Deal Sits in One Stage Too Long

How do I make HubSpot create a follow-up task when a deal has been stuck in one pipeline stage for too many days?

Build a deal-based workflow in Automation > Workflows. Enroll deals in your pipeline whose Date entered current stage is more than 7 days ago and whose stage is not closed, then add a Create task action assigned to the deal owner. Workflows and stage calculated properties need a Professional or Enterprise subscription.

What you need

  • A HubSpot Professional or Enterprise subscription that includes workflows
  • Permission to create and publish workflows
  • A deal pipeline where each open deal has an owner

How this script runs

  1. Pick the stage limit in days
  2. Create a deal-based workflow from scratch
  3. Enroll on Date entered current stage and open stages
  4. Add a Create task action for the deal owner
  5. Decide on re-enrollment, then review and turn on

A deal that sits in “Proposal sent” for three weeks usually means nobody followed up. HubSpot can catch that for you. A deal-based workflow enrolls any open deal whose Date entered current stage is more than a set number of days ago, then creates a task for the deal owner. The owner sees the task in their queue and either moves the deal or closes it out. You need a Professional or Enterprise subscription for this, because both workflows and the stage timing properties sit at those tiers.

Which HubSpot plan and properties make a stage-age workflow possible?

HubSpot’s create workflows article lists workflows as available with Professional or Enterprise editions of Marketing, Sales, Service, Data, Smart CRM and Revenue Hub. Starter plans do not include them.

The timing comes from stage calculated properties. HubSpot fills these in automatically as deals move through a pipeline. The names you will see include:

Property What it records Good trigger for a stuck deal?
Date entered current stage When the deal entered the stage it is in now Yes
Time in current stage How long the deal has been in its current stage Yes
Date entered [stage name] When the deal entered one specific stage Only for a single-stage workflow
Latest time in [stage name] Time spent the last time the deal was in that stage No
Cumulative time in [stage name] Total time across every visit to that stage No

The last two rows matter more than they look. HubSpot’s article says records are not enrolled based on Cumulative time or Latest time in a stage while they are still in that stage. A deal stuck in a stage right now is exactly the deal you want to catch, so those properties will miss it. The article recommends Date entered current stage or Time in current stage instead, and gives the same use case as its example: a workflow that creates a task for the deal owner when a deal’s Date entered Contract Sent is more than 7 days ago.

This template uses Date entered current stage because a relative date filter (“more than 7 days ago”) is easy to read and easy to change. HubSpot’s page does not state the unit Time in current stage is measured in, so if you prefer that property, check the units in your own portal before you set a number.

What does the workflow spec look like, step by step?

Treat the block below as a build sheet. HubSpot workflows are built in the editor, not imported from text, so you follow the lines in order. Values in angle brackets are yours to fill in.

Workflow name:   Stalled deal follow-up - <pipeline name>
Object type:     Deal
Created from:    Automation > Workflows > Create workflow > From scratch

ENROLLMENT TRIGGER (filter-based, all conditions must be true)
  1. Pipeline                     is any of     <your sales pipeline>
  2. Deal stage                   is none of    <Closed won>, <Closed lost>
  3. Date entered current stage   is more than  7 days ago
  4. Deal owner                   is known

RE-ENROLLMENT
  Off for the first version (see the re-enrollment section)

ACTION 1: Create task
  Title:        Follow up: deal has been in this stage for over 7 days
  Assigned to:  the deal owner (choose the owner option your editor offers)
  Due date:     a short window, such as 1 business day after creation
  Notes:        Check the next step. Move the deal, close it, or log why it is waiting.
  Associated:   the enrolled deal

REVIEW
  Review and publish > Turn on workflow

To start, go to Automation, then Workflows, click Create workflow and choose From scratch. That path comes from HubSpot’s create workflows article. Choose Deal as the object type while you set up enrollment, then add the conditions. Add the Create task action with the plus icon in the editor. HubSpot’s list of workflow actions describes Create task as automatically creating new tasks; you configure its details in the panel.

HubSpot’s pages confirm that the Create task action exists and that its example task goes to the deal owner. They do not spell out every field in the task panel, such as the exact wording of the owner option or the due-date choices. Check those in your own editor and set them to the closest match. If there is no owner choice, a named user is a weaker fallback, since that person then has to route every task.

How do the sample deals behave against a 7-day limit?

Assume today is 16 November 2026 and the limit is 7 days. The deals and people are made up.

Deal Stage Date entered current stage Owner Enrolls? Why
DEMO-201 Avery Example renewal Proposal sent 2026-11-02 Riley Placeholder Yes 14 days in the stage
DEMO-202 Morgan Sample pilot Discovery 2026-11-13 Riley Placeholder No 3 days, under the limit
DEMO-203 Casey Demo upgrade Contract sent 2026-10-20 (none) No No owner, condition 4 fails
DEMO-204 Jordan Test order Closed won 2026-10-01 Morgan Sample No Closed stages are excluded
DEMO-205 Avery Example add-on Negotiation 2026-11-08 Morgan Sample Yes 8 days in the stage

DEMO-203 is the case people miss. It is the most stuck deal in the list, but without an owner the task has nowhere useful to go. Run a separate check for ownerless deals. Flagging CRM records missing an owner or next step shows one way to do it in a spreadsheet export.

Avoid a limit that lands right on a weekend or right on the boundary day. Whether a deal that entered exactly 7 days ago counts as “more than 7 days” depends on how HubSpot rounds the time, and its article does not say. If the exact boundary matters, choose 8 days, or test with one deal before relying on it.

Should a deal get a second task if it stalls again?

By default, HubSpot enrolls a record only the first time it meets the triggers. The re-enrollment article explains the details, and three of them affect this workflow:

  • Refinements by date or number on an enrollment trigger do not apply to re-enrollment. The “more than 7 days ago” part will not drive a second enrollment on its own.
  • A record will not re-enroll while it is still enrolled. It has to finish or leave the workflow first.
  • HubSpot does not recommend using today’s date as a re-enrollment trigger, because the record usually will not re-enroll unless the underlying property changes.

So leave re-enrollment off for the first version. Each deal gets one stalled-deal task, ever. If you later want a task each time a deal stalls in a new stage, look at re-enrolling on a change to Deal stage or Date entered current stage, then read the preview HubSpot shows before you turn it on. A deal that bounces between stages could otherwise collect a pile of tasks.

When is the simpler pipeline task, or no automation, a better fit?

Not every team needs a workflow. HubSpot’s deal pipeline automation has a Create and assign a task option on each stage, available on Sales Hub or Service Hub at Starter, Professional or Enterprise. That task is created when the deal enters the stage, not after it has waited there, so it suits “always do X on entry” steps rather than stalled-deal alerts.

Situation Better choice
You only have a Starter plan Pipeline stage task on entry, plus a weekly manual review
You want a task the moment a deal enters a stage Pipeline stage task
You want a task only after a deal has waited too long This workflow
Different stages need different limits One workflow per stage, using Date entered [stage name]
Your team is three people who review the pipeline every Monday A saved view sorted by stage date, no automation

A spreadsheet works as a stopgap too. Export open deals with their stage dates and use the no-recent-follow-up formula on the export. It will not create tasks, but it shows the same list. For more on keeping a small company’s tools tidy, see the small-business stack topic page.

Whichever route you take, build it on a copy or a single test deal first, and check the first few tasks it creates. A workflow that fires on every old open deal at once can fill an owner’s task list overnight, so consider turning it on when you have time to read what lands.

Sources

Free, from Producfy

Get the next guide before you need it

One email when a new guide or tool goes up: working formulas, queries and scripts for spreadsheets, SQL and the CRM and billing exports that end up in them. At most one a week.

Esc