Create a connector for Google DataStudio

You should create a connector for use with Google's DataStudio Application. This would help us create a more robust report for our users and we can leverage the statistics that HubSpot provides. Currently, other services like Databox can connect to HubSpot to pull statistics from a portal to create dashboards. I think opening this up to DataStudio will really help marketers and agencies with providing all the data they need. 

76 Replies
New Contributor

This would be a vital addition so we don't have to spend time finding or creating a solution to do this ourselves. I'm surprised HubSpot hasn't taken care of this already, but it should be near the top of the features list.

Regular Contributor

We would love this! The connectors that we can use now are soooo expensive. We need this badly.

Regular Contributor | Gold Partner

Any update on this would be super useful!

Status updated to: Not Currently Planned
HubSpot Product Team

Hi everyone,

I’m Collette, one of the product managers for HubSpot’s Strategic Integrations teams. After looking into Google Data Studio earlier this year, we decided not to go ahead with it right now.  This is not to say that this idea will never be developed, just that there are no plans to do so at this time. Please check the apps in our marketplace that do integrate with Google Data Studio right now https://ecosystem.hubspot.com/marketplace/apps/all-categories?eco_integrations=Google%20Data%20Studi...

New Contributor

YES PLEASE!

New Contributor

This would be amazing as it will make it easier to create and integrate with reports outside of hubspot

Occasional Contributor

Definitely agree with that! HubSpot's own reporting is not comprehensive enough. It's difficult to go beyond data summarization and reveal actionable insights.

New Contributor

This would help me out so much. Any idea when a community suggestion gets corporated into Hubspot planning?

Regular Contributor | Gold Partner

@Kimberley sadly is doesn't look like HubSpot intend to action this one according to this update. 

New Contributor

@FinallyMatt Oh thanks for sharing! That's too bad.. That means the only option is another paid subscription with a third party connector 😔

Regular Contributor | Gold Partner

@Kimberley Yeah we had the same issue. We've ended up resigning ourselves to the dashboards in HubSpot and linking to them in the DataStudio reports. Not ideal as the custom reporting tool is a little clunky, and the report builder is quite restrictive. But still, better than nothing!

Regular Contributor

yes please, that we be wonderful!

New Contributor

I will repear my previous comment due to the quantity of people who commented after myself.

 

Good news: I created a free HubSpot connector for Google Data Studio.

 

It's a MVP - but it does work. And it works without the need to replicate HubSpot data somewhere else.

 

It's good to see some comments above mentioning that HubSpot is considering implementing that feature but this feature request was done in 2017 and until now there is only one Google Form.

 

Guys, it took me just 1 day to validate the idea with ~100 lines of code and another one to create this MVP connecting with HubSpot API via an API key. Some stuff shouldn't be that complicated. I am a developer but a beginner on Google Data Studio and and in Google App Script. 

 

In any case, I created this connector as an Open Source project on GitHub.  For those of you who are willing to help the project by using it, giving feedback or even helping me coding it, your help is much appretiated!

 

If you are interested on the project, I ask to keep all the communication about this (unofficial) project on GitHub by using the "Issues" tab.

 

https://github.com/fabiopagoti/datastudio-hubspot-connector

 

This connector is not (yet) listed on the Data Studio community connectors marketplace so in order to use this MVP connector please use the following connector ID:

 

AKfycbxV7A6FNmaz_voWMAYXJWM0O01liulUSfJ85uxF7Gwe

 

(This connector ID will most likely not work on the future so please refer to the GitHub project for more details on how to install, use and contribute).

 

If you are interested in contributing to the project please submit an issue in GitHub.

Visitor

Hi all! As we kept running into the issue of connecting HubSpot data to our Google Data Studio reports ourselves, we have spent some resources developing a connector with a deep integration between HubSpot and Google Data Studio. This connector allows analyzing all your HubSpot data in Google Data Studio (concerning contacts, companies, deals, tickets, marketing,...). 📊

 

As we would like to make this connector available to all HubSpot users, we are currently looking for some companies who are willing to beta test the app. For those who do, we guarantee lifetime free access to the connector once it becomes publicly available 😊

 

If interested, feel free to send me a message or fill in this form✉️

Occasional Contributor

We would also appreciate this functionality

Visitor

It would be a big step for hubspot and help the community to work with custom dashboards. I recommend it!