We use a solution that uses free code on the internet to pull data out of Hubspot via the api into multiple gsheet workbooks. We then connect Data Studio to the gsheets. It was a bit tricky to set up, but we really like it. You need to have some scripting skills to use the Google app script and then edit it to your requirments. But once it’s done you can set it to update ever 15 minutes and it runs our company dash board perfectly, with other KPI’s from Adwords, Google Analytics all on the same page.