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