[Early-stage Idea/Feedback Welcome] Would a Visual Formula Language for HubSpot Workflows Be Useful

Apps Third-Party Apps
1

Hi everyone :waving_hand:

I’m in the very early stages of exploring an idea and would love to hear what the community thinks.

I’m working on a visual formula language — similar to Excel in syntax, with a Blockly-style interface — that could be integrated into HubSpot workflows via a custom action.

The goal is to let users write and evaluate complex dynamic expressions based on CRM properties, with support for:

  • Conditional logic (e.g., IF, SWITCH)
  • Arithmetic & date calculations
  • String manipulation
  • Error handling (like TRY/CATCH)
  • Custom business rules (e.g., commercial rounding)

All of this would be visual, so ops and marketing users could build logic without coding.

:magnifying_glass_tilted_left: Example: Compute price with country-based VAT and commercial rounding

COMMERCIALROUND(
 d:base_price * SWITCH(
 s:country; 
 d:default_rate; 
 [
 {"FR": 1.20};
 {"DE": 1.19};
 {"US": 1.00}
 ]
 );
 [
 {0; 10; NEAREST; TO_10_CENTS; 0.1};
 {10; 100; CEIL; TO_99_CENTS; 0.2}
 ]
)

This evaluates the price with:

  • A VAT rate based on the customer’s country
  • Then applies tiered commercial rounding rules

No need for multiple workflows, hardcoded property values, or custom code.

:light_bulb: Why I think it could be valuable:

  • Bring more logic and reusability inside workflows
  • Reduce reliance on complex branches or custom-coded solutions
  • Use cases: pricing models, lead scoring, thresholds, conditions, formatting, Date calculation…

Would something like this be helpful in your HubSpot setup?
Have you ever wanted to express logic that just isn’t possible with native tools?

I’d love your feedback :folded_hands:

2

Hi @DBRAHIM!

This sounds like a fantastic idea and something that could be incredibly useful for many HubSpot users!

Thanks for sharing!

Diana