# HubDB data in reports and workflows

**URL:** <https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733>\
**Category:** HubSpot Ideas\
**Tags:** design-manager\
**Created:** [August 28, 2020, 7:22am UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733 "2020-08-28T07:22:21Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![shivammishra](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/shivammishra/32/57633_2.png) [@shivammishra](https://community.hubspot.com/u/shivammishra)\
**Post date:** [August 28, 2020, 7:22am UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/1 "2020-08-28T07:22:21Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![chris\_p\_lukes](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chris_p_lukes/32/30597_2.png) [@chris\_p\_lukes](https://community.hubspot.com/u/chris_p_lukes)\
**Post date:** [January 19, 2021, 9:57pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/2 "2021-01-19T21:57:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![SteveHTM](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/stevehtm/32/22074_2.png) [@SteveHTM](https://community.hubspot.com/u/SteveHTM)\
**Post date:** [May 11, 2021, 10:29pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/3 "2021-05-11T22:29:03Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![yasiooy](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/yasiooy/32/25777_2.png) [@yasiooy](https://community.hubspot.com/u/yasiooy)\
**Post date:** [May 24, 2021, 5:10pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/4 "2021-05-24T17:10:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![roushan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/roushan/32/38114_2.png) [@roushan](https://community.hubspot.com/u/roushan)\
**Post date:** [May 25, 2021, 6:33pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/5 "2021-05-25T18:33:30Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jeremiahp](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jeremiahp/32/32521_2.png) [@jeremiahp](https://community.hubspot.com/u/jeremiahp)\
**Post date:** [June 7, 2021, 8:48pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/6 "2021-06-07T20:48:29Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![CarstenU](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/carstenu/32/89259_2.png) [@CarstenU](https://community.hubspot.com/u/CarstenU)\
**Post date:** [June 17, 2021, 1:40pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/7 "2021-06-17T13:40:10Z")

</div>

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 😉

---

<div class="post-metadata">

**Author:** ![Manobyte](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/manobyte/32/31851_2.png) [@Manobyte](https://community.hubspot.com/u/Manobyte)\
**Post date:** [July 26, 2021, 1:26pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/8 "2021-07-26T13:26:42Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![tcxen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tcxen/32/99782_2.png) [@tcxen](https://community.hubspot.com/u/tcxen)\
**Post date:** [September 15, 2021, 7:27am UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/9 "2021-09-15T07:27:43Z")

</div>

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 😎

---

<div class="post-metadata">

**Author:** ![tommitchell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tommitchell/32/44643_2.png) [@tommitchell](https://community.hubspot.com/u/tommitchell)\
**Post date:** [November 26, 2021, 1:44pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/10 "2021-11-26T13:44:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![fiberpunk](https://avatars.discourse-cdn.com/v4/letter/f/a87d85/32.png) [@fiberpunk](https://community.hubspot.com/u/fiberpunk)\
**Post date:** [February 5, 2022, 6:45pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/11 "2022-02-05T18:45:47Z")

</div>

Oh yes, that would be super useful!

---

<div class="post-metadata">

**Author:** ![enorberg](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/enorberg/32/36188_2.png) [@enorberg](https://community.hubspot.com/u/enorberg)\
**Post date:** [February 25, 2022, 2:29pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/12 "2022-02-25T14:29:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![laurabren](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/laurabren/32/10217_2.png) [@laurabren](https://community.hubspot.com/u/laurabren)\
**Post date:** [March 3, 2022, 7:14pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/13 "2022-03-03T19:14:08Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![chrisupton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chrisupton/32/25270_2.png) [@chrisupton](https://community.hubspot.com/u/chrisupton)\
**Post date:** [July 12, 2022, 4:02pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/14 "2022-07-12T16:02:13Z")

</div>

This would make HubDB so valuable for us!

---

<div class="post-metadata">

**Author:** ![04774](https://avatars.discourse-cdn.com/v4/letter/0/c0e974/32.png) [@04774](https://community.hubspot.com/u/04774)\
**Post date:** [July 12, 2022, 4:10pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/15 "2022-07-12T16:10:22Z")

</div>

This would be amazing and so helpful

---

<div class="post-metadata">

**Author:** ![PNavarrete](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pnavarrete/32/57275_2.png) [@PNavarrete](https://community.hubspot.com/u/PNavarrete)\
**Post date:** [July 29, 2022, 8:05pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/16 "2022-07-29T20:05:09Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![cleabig1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/cleabig1/32/82448_2.png) [@cleabig1](https://community.hubspot.com/u/cleabig1)\
**Post date:** [August 12, 2022, 11:01pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/17 "2022-08-12T23:01:24Z")

</div>

This would be epic!

---

<div class="post-metadata">

**Author:** ![chrisupton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chrisupton/32/25270_2.png) [@chrisupton](https://community.hubspot.com/u/chrisupton)\
**Post date:** [August 13, 2022, 1:36am UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/18 "2022-08-13T01:36:25Z")

</div>

Right!? Its needed.

---

<div class="post-metadata">

**Author:** ![SRKelly](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/srkelly/32/103093_2.png) [@SRKelly](https://community.hubspot.com/u/SRKelly)\
**Post date:** [September 27, 2022, 3:30pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/19 "2022-09-27T15:30:20Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![tmitch\_sona](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tmitch_sona/32/59778_2.png) [@tmitch\_sona](https://community.hubspot.com/u/tmitch_sona)\
**Post date:** [October 31, 2022, 7:52pm UTC](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733/20 "2022-10-31T19:52:37Z")

</div>

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.

[Next page](https://community.hubspot.com/t/hubdb-data-in-reports-and-workflows/24733.md?page=2)
