Skip to content
Integrations

Authenticate your apps for HubSpot data sync

Last updated: October 19, 2021

Applies to:

All products and plans

When using HubSpot sync to sync data between your external apps and HubSpot there may be additional authentication needed. 

Airtable

HubSpot sync requires your table in Airtable to have:

  • An Email field set to email format (only required when syncing contact records, not company records).
Airtable-email-field
  • A Last modified time field. It is recommended to give this field a recognizable name and to hide the field. In the Fields and Formatting tabs, keep the default field settings; All editable fields and Include a time field.
airtable-last-modified-time

Learn more about customizing your field types in Airtable.

Mindbody

To sync data between Mindbody and HubSpot, HubSpot sync requires access to your Client ID, username and password.

Please note: only the owner of the Mindbody account should authorize the syncing of data from Mindbody to HubSpot.

To sync with HubSpot, you will need to give HubSpot access to your site's data:

  • Navigate to your API integrations page and enter your owner credentials.
  • After entering the credentials you will see the error The email or password you entered is incorrect. Click the Go to staff sign-in link, and login using the owner credentials.
  • In the next screen, select your Mindbody account to connect to HubSpot.
  • Navigate back to your HubSpot account to finish setup.

SugarCRM

To sync HubSpot and SugarCRM, HubSpot requires your Sugar domain, username, password, consumer key and consumer secret. 

To find your consumer secret and key:

  • Login to your SugarCRM account.
  • Under Administration, navigate to OAuth Keys
  • Create a new OAuth key.
  • Create a Consumer Key name, for example "HubSpot".
  • Select a Consumer Key and Consumer Secret.
  • Ensure that the OAuth version is OAuth 2.0.
  • Click Save.
  • Under System Settings uncheck Validate user IP addresses
  • Install the HubSpot module through the Module Loader under Developer Tools.

Microsoft Business Central

To sync with HubSpot, you'll first need to upload and deploy the HubSpot extension in your Business Central account.

  • Log in to your Business Central account.
  • At the top of the page, click Setup & Extensions, then select Manage Upload extension.
  • Upload the HubSpot extension, which you can download here.
  • Click Deploy.

upload-hubspot-extension-ms-business-central

After you've uploaded the extension, you'll need to get your OData v4 URL to complete the setup in HubSpot.

  • In your Business Central account, click the search search icon at the top of the page.
  • Search for web services, then click on the Web Services link.
  • Create a new customer page:
    • Click on + New.
    • Select Page as the Object Type.
    • Enter 21 for the Object ID and Customer Card as the Object Name.
    • Enter a name for the page.
    • Select the Published checkbox.

ms-business-central-customer-page-configuration

  • After you've created the page, scroll to the right to locate the OData V4 URL column, then copy the URL to the clipboard.

copy-odata-v4-url-ms-business-central

  • Navigate back to your HubSpot account to paste your OData V4 URL in the dialog box to finish installing the integration.

Act! Premium

To connect your HubSpot and Act! Premium account, HubSpot requires the following:

  • Your Act! Premium domain, which is the beginning of the URL of your login page. For example, if your login page's domain is https://usp1-iis-13.hosted1.act.com, enter usp1-iis-13. 
  • Your database nameusername and password used to log in to your Act! Premium account.  
  • Your Customer Name. This is not required for self-hosted applications. For cloud-based applications, the customer name can be found in your login page URL after your domain.

data-sync-act-premium