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

DBRAHIM — Thu, 10 Apr 2025 23:32:58 GMT

Hi everyone 👋

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.

🔍 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.

💡 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 🙏

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

DianaGomez — Fri, 11 Apr 2025 11:42:32 GMT

Hi @DBRAHIM!

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

Thanks for sharing!

Diana

topic [Early-stage Idea/Feedback Welcome] Would a Visual Formula Language for HubSpot Workflows Be Useful in Third-Party Apps

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

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

💡 Why I think it could be valuable:

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