How to get started with HubSpot? (Google Sheets)

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

1. Install Supermetrics for Google Sheets with these instructions: First steps (getting Supermetrics Sidebar in to your Google Sheets)
2. Choose "HubSpot" datasource from the list:
   
3. Click "Start" on the new window that opens:
   
4. Login with your HubSpot credentials:
   
5. Choose which account you want to use:
   
   1. If you have sufficient permissions, click "Grant access":
      
   2. If you see this screen, ask your HubSpot subscription administrator to grant you higher permissions:
      
6. After completing the authentication, you're ready to start building your dashboard.

Useful links:

• How to create a reporting dashboard

• Tips & Tricks

• Can I Schedule My Reports to be Refreshed or Emailed at Specific Intervals?

• Can I See/Edit All of the Queries That I've Created?