How do I add or reconnect a Hubspot account to my DataDear account?

Learn how to add or reconnect your accounts in Hubspot to DataDear from the Dashboard or directly from Excel.

You need to add companies to DataDear to start using the Excel toolbar. You may add your companies via any one of these options:

:information_source: The DataDear account owner can add, edit or remove organisations to DataDear.

Connect a Hubspot company from the Dashboard

  1. Login to DataDear web Dashboard using your email and password.

  2. Click on the Organisations tab in the menu.

  3. Click on the Connect to Hubspot . This will open your browser on Hubspot’s login page where you are required to login to your Hubspot account (or if you are already logged you will be automatically redirected) to access the Choose Application screen in Hubspot.

  4. Hubspot will show a confirmation screen - choose Connect App to continue.

  5. Hubspot will securely authorise the selected company. You will then be automatically redirected to the DataDear Web Dashboard > Organisations.

  6. You will now see the connected company. You may also assign a Friendly Name, a Client Code or an Office Location using the Edit button next to the company.

  7. Success! You are now ready to use this company from Excel using DataDear.

Connect a Hubspot company from Excel

If you have already installed the DataDear add-in you may add the Hubspot company directly from Excel.

  1. Open Excel, click on the DataDear tab and login using your email and password.

  2. Click on the Add icon and select Hubspot Organisation from the menu. The button will be disabled (greyed out) for normal users.
    image

  3. Click on the Connect to Hubspot . This will open your browser on Hubspot’s login page where you are required to login to your Hubspot account (or if you are already logged you will be automatically redirected) to access the Choose Application screen in Hubspot.

  4. Hubspot will show a confirmation screen - choose Connect App to continue.

  5. Hubspot will securely authorise the selected company. You will then be automatically redirected to the DataDear Web Dashboard > Organisations.

  6. You will now see the connected company. You may also assign a Friendly Name, a Client Code or an Office Location using the Edit button next to the company.

  7. Return to the Excel and press the OK button to refresh the list of companies in DataDear. (If this window was closed earlier in the process, you will need to logout and log back in to refresh the list of companies.)
    image

  8. The Account drop-down list will show the company you have just added. The Friendly Name assigned to this company will visible in this list. By default, the Hub ID used in Hubspot will be used.

  9. Success! You are now ready to use this company from Excel using DataDear.

Additional Notes

  • You may add as many Hubspot companies as required … even from multiple accounts.

  • You cannot add the same Hubspot companies to different DataDear accounts - you will need to add the company to your account and then share this with your users within DataDear. This is a security limitation of the API.

:information_source: If you are experiencing problems with a connected company, this could be resolved by repeating the connection process and reconnecting the company. When carrying out such a task, there is no need to delete the company. All statistics and related data will be retained.