Log in the HubSpot Connector

You can use Awesome Table Connectors to export data from HubSpot to Google Sheets by logging in with the HubSpot connector.

Prerequisites

• You have Awesome Table Connectors installed on your account.
• You have created a Google Sheets spreadsheet and launched the Awesome Table Connectors add-on.

Method 1: Sign in with HubSpot

1. In the Awesome Table add-on Home screen, click Create new request.

   
   The list of available connectors is displayed.

2. Open the HubSpot connector.

   

3. On the Connect to Hubspot screen, click Sign in with HubSpot.

   

4. Select your HubSpot account and click Choose Account.

   

5. Click Connect app.

   
   Awesome Table informs you if your connection is successful.

You are now logged in with the HubSpot connector. The Select data drop-down shows the data you can import from Google Sheets.

What's next

You can now use Awesome Table Connectors to export data from HubSpot to Google Sheets.

Method 2: Connect with an API key

Some connectors allow you to log in with an API key within the Awesome Table add-on. With this method, you don't need an account and can sign in from the add-on.

Prerequisites

You have obtained the API key from the administration interface of the software you are connecting to. Only the account administrator can provide it.

1. In the Awesome Table add-on Home screen, click Create new request.

   
   The list of available connectors is displayed.
2. Open the HubSpot connector.

3. Select Connect with an API key.

   

4. Enter your API Key.

   

5. Click Test & Save.

6. Enter an Account name.

   

7. Click Save account.

   A message appears saying your authentication is successful.

You are now logged in with the connector, and you can start importing data.

What's next

You can now use Awesome Table Connectors to export data from HubSpot to Google Sheets.