HubSpot Ideas


HubDB data in reports and workflows

Features like serverless functions to consume APIs and quering HubDB in Hubl makes hubspot a CMS to build more interactive applications quickly than just marketing websites. But we see one limitation in our use case where we are storing certain information in HubDB and need that information for marketing automation but its not accessible in workflows or in custom reports. Do you all think it would be nicer to have HubDB data made available in workflows and custom reports to create more customized experience for users?

34 Replies
Contributor | Elite Partner

I agree.  As a Marketing/Sales Operations professional, I see so much potential for using HubDB for operational uses, such as referencing a look-up table in automation for controlling certain data mappings -- one example would be using a HubDB table to define Sales Territory Assignments for routing workflows, rather than building this out in workflow branches that are harder to maintain and review.

Guide | Partner

This is an concept I'd very much like to see  - perhaps as an option related to Operations Hub. The feature I really want is to use a Workflow step to set a value in a property through a HubDB table lookup.


For example: Set Property B via lookup of Property A in specific HubDB table


Seems like a fairly straightforward idea doesn't it?

Participant | Diamond Partner

This would work great for us and for our clients - seems like a good direction to go forward with!


The worst mistake CRM users make is using custom properties to store data as then you end up with thousands of fields that are used by the system and don't benefit the user. This is where HubDB could come in, and remove the 'clutter of a thousand fields' but allowing users to store data in a relational data store and produce reports/workflows of the back of this.


I also agree with this. We are working on creating a community of trainers and we need to be able to expose their contact information on our website as we have more sign up. Right now we collect this information via form that fills contact properties, but since those cannot be placed on a public page we are using a HubDB table to fill in the information about our member trainers. That table must be manually updated when we have new trainers, and it would be nice to have a workflow fill in the table fields instead.


Sounds great to me.

In my use case, i want to activate a workflow, if a hubdb is updated.

So I manually edit the table fields, after I klick on update now, that would trigger a workflow, where an email (only personalized with name) to the custoumer is send, to ask them to login in the hubspot cms site. ( I integrate the hubdb table in a dynamic page)

I vote for this feature 😉


Contributor | Diamond Partner

On an adjacent note, I would love to be able to add/update rows with workflows as well. Currently we have a mini user portal where people can login and update their company profile. These companies each have entries in hubDB that create public facing profile pages. They are just venders that the main company works with, So we don't really want to give them access to hubspot, or any of the other dealers. Currently we are setting up automatic updates using the API and an additional server, however it would be nice to have it all contained in hubspot.

Contributor | Platinum Partner

This is a great idea and I just came across a use case for this today. What @SteveHTM said earlier in this thread:

Set Property B via lookup of Property A in specific HubDB table.


Please make HubDB data available in workflows and custom reports 😎


Yes please to this. So many use cases in our daily Hubspot operations could benefit from this.


Oh yes, that would be super useful!


That'd be amazing. I currently use Zapier for this, which works (some of the time) but I would much prefer a native solution.


+1 +1 +1 to all of this! The Google Sheet lookup function in Zapier would translate so well to HubDB!


This would make HubDB so valuable for us! 


This would be amazing and so helpful 

HubSpot Employee

Creating reports based on Hub DB would allow to provide a more customized experience for end users. Hope to see this implemented in the near future!

Member | Platinum Partner

This would be epic!

Right!? Its needed.

We absolutely need this. I'd love to have access to HubDB values for emails and landing pages. We have hudreds of thousands of users that may be connected to one company and we need to render those company properties in emails and landing pages. The problem is that there is a limitation on contact to company assocations (10K, I believe). Being able to link contacts to records in HubDB for emails, landing pages, workflows, setting properties, etc. would help us scale our use of Hubspot tremendously.


Commenting on this again a year on from doing the same in my last job. PLEASE let us have this functionality Hubspot - it would open up so many epic scaleable possibilities and solve loads of problems.


We host our member only "Resource Library" through HubDB and I am interested to be able to see which resources are most viewed/downloaded. Being able to track page views on a daily/weekly/monthly/annually basis would be something I expect could be easy to create since everything is hosted on our HubSpot URL already.