To import data from HubSpot into Google Sheets, follow the steps below to log in to HubSpot with the Awesome Table add-on.

Procedure

1. In the Awesome Table add-on, select the HubSpot connector.
   
2. On the Connect to Google Photos screen, click Sign in to HubSpot.
   
3. Select your HubSpot account and click Choose Account.
   
4. Click Connect app.
   
   If your authorization is successful, Awesome Table shows the following message.
   

Result

The Select data drop-down shows the data you can import from HubSpot into Google Sheets.