I recently discovered the workflow beta that allows access to associated data. This has the potential to make HubSpot workflows dramatically more powerful. Currently, related object data can be refined via association label or activity timing. It would be super if HubSpot added a data match refinement option. This could happen via a "whichever one we hit first" approach like a vlookup or - much more ideally - this option could be limited to those properties that are required to be unique. Here's an example use case. We're a software company. Sometimes, one contact has multiple software user accounts. This can happen for a couple of reasons I'll skip here. We store these user accounts on a custom object that is related to Contacts. In our case, we sometimes need to create a new company for one of these contact's user accounts. If we could say, "Create a new company under X, Y, Z conditions and use A,B,C data from the associated user account record to do that where the user account username property = contact property X", that would be hugely helpful. This is particularly true because subscription management solutions like Chargebee often require a company record to exist and our ERP prefers the customer data as a Company vs. a contact/individual. If we could refine this way, we could basically automate the entire company component here. I can think of lots of other possible use cases, too, where the ability to give a workflow access to move data from a related record based on a property match criteria would be extremely useful.
...read more