I'm looking at how to get a deal to move automatically between deal stages based on estimated deal closing date. This would be for licence renewal deals, so for example I'd set an estimated deal closing date of 1st December 2026 and deal stages of 'Active', '3 months to renewal', '1 month to renewal' and 'Renewal OverDue'. Then would like the deal to automatically move from 'Active' to 3 months to renewal' on 1st September and then to '1 month to renewal' on 1st November. I can then put in a workflow to trigger emails when the deal moves.
Nov 20, 20251:22 AM - edited Nov 20, 20251:24 AM
Guide | Platinum Partner
Hi @arrcle Yes, this is possible using HubSpot workflows.
Create Date-Based Workflows You will need multiple workflows, each set to trigger when the deal reaches a specific date relative to the Estimated Close Date.
Example Setup Workflow 1 – Move Deal to “3 Months to Renewal”
Enrollment Trigger: Deal property → Estimated Close Date → is known, AND estimated close date Is less than 90 days from now
Action: Set deal stage = 3 Months to Renewal
Workflow 2 – Move Deal to “1 Month to Renewal”
Enrollment Trigger: Deal property → Estimated Close Date → is known, AND estimated close date is less than 30 days from now
Action: Set deal stage = 1 Month to Renewal
Workflow 3 – Move Deal to “Renewal Overdue”
Enrollment Trigger: Estimated Close Date → is in the past
Action: Set deal stage = Renewal Overdue
Once the deal stages update automatically, you can add:
Your setup works nicely with HubSpot’s native workflows. Deals can move through those renewal stages automatically as long as the estimated close date is accurate.
The only thing to watch is where that close date comes from. If another tool updates it or if renewals are synced from a billing system, the workflow timing can drift without you noticing. When renewal data lives across several systems, Stacksync keeps the deal fields aligned in real time so these date-driven stage changes fire exactly when they should. Hope this helps.
Did my answer help? Please mark it as a solution to help others find it too.
Ruben Burdin HubSpot Advisor Founder @ Stacksync Real-Time Data Sync between any CRM and Database
@SanjayKumar thanks for your help. Itried the suggested and everything seems to be correct but the deals are not moving between the stages automatically? Snip below of the 'trigger'
If you are still seeing this behavior, I would recommend connecting with HubSpot Technical Support, as Support is included in your subscription and they will be able to provide real-time assistance for this matter, including hopping on a screenshare if necessary.
I hope that you'll get sorted soon! Bérangère
Loop Marketing is a new four-stage approach that combines AI efficiency and human authenticity to drive growth.
Your setup works nicely with HubSpot’s native workflows. Deals can move through those renewal stages automatically as long as the estimated close date is accurate.
The only thing to watch is where that close date comes from. If another tool updates it or if renewals are synced from a billing system, the workflow timing can drift without you noticing. When renewal data lives across several systems, Stacksync keeps the deal fields aligned in real time so these date-driven stage changes fire exactly when they should. Hope this helps.
Did my answer help? Please mark it as a solution to help others find it too.
Ruben Burdin HubSpot Advisor Founder @ Stacksync Real-Time Data Sync between any CRM and Database
Nov 20, 20251:22 AM - edited Nov 20, 20251:24 AM
Guide | Platinum Partner
Hi @arrcle Yes, this is possible using HubSpot workflows.
Create Date-Based Workflows You will need multiple workflows, each set to trigger when the deal reaches a specific date relative to the Estimated Close Date.
Example Setup Workflow 1 – Move Deal to “3 Months to Renewal”
Enrollment Trigger: Deal property → Estimated Close Date → is known, AND estimated close date Is less than 90 days from now
Action: Set deal stage = 3 Months to Renewal
Workflow 2 – Move Deal to “1 Month to Renewal”
Enrollment Trigger: Deal property → Estimated Close Date → is known, AND estimated close date is less than 30 days from now
Action: Set deal stage = 1 Month to Renewal
Workflow 3 – Move Deal to “Renewal Overdue”
Enrollment Trigger: Estimated Close Date → is in the past
Action: Set deal stage = Renewal Overdue
Once the deal stages update automatically, you can add: