Hubspot analytics API (google sheets or data studio integartion)

[MarinaDorosh]

I would like to connect hubspot data with google data studio or google sheets. 

I it possible?

I did some research on our community forum and looks like this is possible via native APIs - here is the article I am referencing.

Thought it looks like this needs to be a custom integration - whereas you would build an API bridge between HubSpot and google data studio - and connect them together. For this, I would need to loop in a developer - that will reference this API documentation here - specifically the list API here. 

Does anybode have some guide how to that? Is it possible at all?

[johnelmer]

@MarinaDorosh @Willson I know this is an older thread, but we have made a new Google Data Studio integration for HubSpot available in the HubSpot App Marketplace. There are some key differences in this app compared to other integrations, such as unlimited users and data for a flat price. There is a 14-day free trial so you can make sure it will meet your needs. DM me with questions, or view the setup guide here.

[Willson]

Hi @MarinaDorosh 

Taking a look into our resources, i've found a couple of solutions that may assist if you're unfamiliar with how to use our APIs or require the assistance of a Development Team.

1. You can work with some HubSpot Agencies to help build out a custom integration that you're looking for. You can find our agency list who specialise in Custom Integrations here.
2. If instead, you're looking to use a pre-existing integration and don't mind a subscription fee, Integration Fox on our App Marketplace currently offer an integration to Google Sheets. 

I hope this helps!

[MarinaDorosh]

Willson, Thank you for this info! I would like to have free solution. Do you now cases when your clients hav build their custom solution with API?

[Willson]

Hi @MarinaDorosh 

Apologies for the delay! Unfortunately I am not familiar with any use-cases where a custom integration has been built out here using these external tools.

Thanks!