!! Some HubSpot fields require "Content" scope permission which can be only granted by HubSpot Super Admin users. If you have any other user level in HubSpot, read this article first: I don't get any results for certain fields in my HubSpot query !!
- Install Supermetrics for Google Sheets with these instructions: First steps (getting Supermetrics Sidebar in to your Google Sheets)
- Choose "HubSpot" datasource from the list:
- Click "Start" on the new window that opens:
- Login with your HubSpot credentials:
- Choose which account you want to use:
- If you have sufficient permissions, click "Grant access":
- If you see this screen, ask your HubSpot subscription administrator to grant you higher permissions:
- If you have sufficient permissions, click "Grant access":
- After completing the authentication, you're ready to start building your dashboard.
Data refresh
A HubSpot account can contain a very large amount of data. To improve performance, Supermetrics caches this data, which means that it might take some time to complete the import when you first connect Supermetrics to HubSpot.
The initial import could take days, depending on the size of the account. Once it’s completed, HubSpot will import data once per day. This means you’ll need to wait for the next daily import to finish if you’re looking for data — on deals or contacts, for example — that’s been modified since the last import.