Hi All - Great thread here. I wanted to also let you know Bedrock Data has a product (Fusion) that allows you to automatically feed your HubSpot data into an on-demand data warehouse, that can serve as an automated data source for Google Data Studio.
It’s a paid product, but we have a free trial account you can set up if you want to try it out for free.
To try it out:
1. Sign up for a free account at https://fusion.bedrockdata.com/app-user/sign-up
2. Authenticate your HubSpot to feed in your HubSpot tables
3. Follow these steps to feed into Google Data Studio https://help.bedrockdata.com/article/836-connect-google-data-studio