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. 

HubSpot updates
73 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.

Occasional 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

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