You can log in the HubSpot Connector using an API key.

Prerequisites

Create an API key from your account settings in HubSpot. For more information, see Access your API key in the HubSpot Knowledge Base.

Procedure

1. In the Awesome Table add-on, select the HubSpot connector.
   
2. On the Connect to HubSpot screen, click Connect with an API key.
   
3. Paste your HubSpot API key and click Test & Save.
   

   The HubSpot Connector tests the API key, and if correct, you can type in your account name and save your account for future use.

4. Enter your account name and click Save account.
   

Result

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

HubSpot logins with an API key appear with the API label in the accounts menu.