Skip to main content
Gainsight Inc.

HubSpot Connector

IMPORTANT NOTE: Gainsight is upgrading Connectors 2.0 with Horizon Experience. This article applies to tenants which have been upgraded to the Horizon Experience for Connectors 2.0. If you are using Connectors 2.0 with the previous version, you can find the documentation here.

This article explains how to create a connection from Gainsight to HubSpot, create a data job, configure Job or Job chains in Gainsight. Most importantly, you can learn about Out of the Box (OOB) Jobs and Job Chain provided by Gainsight in the HubSpot Integration.

Currently Gainsight allows you to sync data from the following HubSpot objects into the Gainsight standard and custom objects:

  • Company
  • Contact
  • Owner
  • Deal
  • Ticket

You can sync data from the HubSpot objects, Company, Contact, and Owner to Gainsight objects, Company, Company Person, and User respectively through Gainsight’s OOB Job configurations. If you want to sync data from any other HubSpot object to a Gainsight object, you must configure a new custom job configuration.

To learn more about Gainsight objects, refer to the Gainsight Data Management in the Additional Resource section at the end of this article.

Note: This document provides general guidance on creating a Connection, configuration of OOB jobs, and setting up custom Jobs because the use case of each job is different and needs unique configuration. For detailed information on creating any Job, refer to the Configuration of Connectors in the Additional Resource section at the end of this article.

Overview

HubSpot is an inbound marketing software platform that helps companies attract visitors, convert leads, and close customers. HubSpot offers a full stack of software for marketing, sales, and customer service, with a completely free CRM at its core.

Gainsight integration with HubSpot allows you to sync data from HubSpot CRM to Gainsight. The following table lists the equivalent Gainsight Objects to which data can be synced from HubSpot.

HubSpot Object Gainsight Object
Company Company
Owner Users
Contact Person and Company Person
Any HubSpot Object Custom Object

To configure the HubSpot connection, you must execute four tasks. These tasks are shown below:

  1. Create and Authorize Connection: Create Connection establishes a connection between Gainsight and HubSpot. Authorizing Connection task authorizes Gainsight to access data from your HubSpot org. To learn more about this process, refer to the Create Connection section.
  2. (Optional) Modify OOB jobs: This task allows admins to modify the out of the box configurations for OOB jobs. To learn more about this process, refer to the Out of the Box Jobs section.
  3. Create Data sync jobs: This task allows admins to create new data sync jobs per requirement. To learn more about this process, refer to the Create a Custom Job section.

Create Connection

A connection is a link between a Gainsight org and a specific HubSpot org. HubSpot Connection allows you to create a connection to the specific HubSpot org. After you establish a connection to the HubSpot org, you can authorize the connection and start syncing data from HubSpot to Gainsight through either OOB jobs or custom jobs

Create and Authorize Connection

This section explains how to create a connection to HubSpot from Gainsight. You must use the HubSpot login credentials and establish a connection to Gainsight. You can create only one connection, but you can create multiple data jobs in this connection, as required.

To create a connection with HubSpot:

  1. Navigate to Administration > Connectors 2.0 > Connections.
  2. Click Create Connection. Create Connection dialog appears.

Hubspot1.png

  1. Select HubSpot in the Connector dropdown list.

Hubspot2a.png

  1. Enter a Name for the connection.
  2. Click Authorize to validate the connection. The HubSpot Authorization window appears.

Hubspot3.png

  1. Complete authorization by entering the required HubSpot org credentials and click Accept in the confirmation dialog.
    Note: You can also autenticate your HubSpot Account with either Google or SSO (Single Sign On), as required.
  2. Select the required HubSpot Account that you want to integrate with. (If you have multiple accounts in HubSpot).
    Note: If you have already stored your HubSpot credentials in your browser, you are directly prompted to select the HubSpot Account that you want to authorize to.

IMPORTANT: You can create only a single connection in HubSpot Connector. A connection can be associated with a HubSpot org. If your data resides in multiple HubSpot orgs, you must first delete an existing connection (after you sync the data) and then create a new connection.

Context Menu Options

In the Connections tab, click the content menu to see the following options:

  • Edit Connection: You can use this option to modify the HubSpot connection details.
  • Re-Authorize Connection: You can use this option to re-validate the HubSpot connection. If you have changed the password of your HubSpot org, you can use this option to provide the new set of credentials.
  • Revoke Connection: You can use this option to revoke existing connection to your HubSpot instance. When you revoke your connection, Gainsight will not have permissions to access your HubSpot instance and hence data jobs cannot be executed.
  • Delete Connection: You can use this option to delete the HubSpot connection.

Context Menu.png

Out of the Box Jobs

After the HubSpot connection and authorization successfully completed, Gainsight provides OOB jobs in the Jobs page to sync important data such as Companies, Users and Contacts, which are required for the assessment of data in Gainsight. Following are the three OOB jobs and their mapping details:

  • Company Sync: This job syncs HubSpot Companies with Gainsight Companies.
  • Company Person Sync: This job syncs HubSpot Contacts with Gainsight Person and Company Person objects.
  • User Sync: This job syncs HubSpot Users with Gainsight.

Company Sync

This job imports data from the HubSpot Company object and inserts it into the Gainsight Company object. You can modify the dependent job, if required. This job is named Company Sync_ Connection name. (here Company Sync_HubSpot Connection). In the Company Sync OOB job, the following configuration are provided out of the box:

  • The HubSpot Company object is selected as the source object in the dataset preparation and the following source fields are selected.
  • Gainsight Company is selected as target object and the HubSpot source fields are mapped with the Gainsight target fields through the Add Destination configuration.

Direct Mappings

Following are the fields and their Direct Mapping in the Add to Destination:

HubSpot Company Fields Target Fields in Gainsight (Company)
companyId

HubSpot Account  ID_6574308 (Standard field)

Note: Include in identifiers check box is enabled.
Name Name

You can select any other mapping as the Upsert key or even have multiple mappings as Upsert keys, if required. It is mandatory to configure at least one mapping as an Upsert key.

There are no OOB derived mappings configured in the Hubspot connection. You can configure any custom derived mappings as required.

Company Person Sync

This job is named Company Person Sync_Connection name. (here Company Person Sync_HubSpot Connection), by default has a dependency on the Company Sync job. It imports data from the HubSpot Contact object and inserts it into the Gainsight Person and Company Person objects. In the Company Person Sync OOB job, the following configurations are provided out of the box:

  • The HubSpot Contact object is selected as the source object in the dataset preparation and the following source fields are selected.
  • Gainsight Person and Company Person are selected as target objects and the HubSpot source fields are mapped with the Gainsight target fields through the Add Destination configuration.

Direct Mappings

Following are the fields and their mapping in the Add to Destination:

HubSpot Contact Fields Target Fields in Gainsight (Person)
Email

Person :: Email

Note: Include in identifiers check box is enabled.
First Name Person :: First Name
Last Name Person :: Last Name
vid Hubspot Contact ID
Associated Company ID Hubspot Account ID

Upsert keys for the mapping between the HubSpot Contact object and the Gainsight Person object are determined by the Person Resolution Key configuration. Fields selected in the Person Resolution Key configuration must be selected as Upsert Keys in the Company Person Sync Job > Field Mappings section.

There can be one or multiple upsert keys used for the identification of people in Gainsight and you cannot edit them. For more information on the Person Resolution Key configuration, refer to the People Management in the Additional Resource section at the end of this article.

Derived mappings

The following table shows configurations for OOB derived mappings for the Company ID (GSID) field:

Fields Values
Target Field: Company ID (GSID)
Select Source Associated Company ID
Select Target Field Company ID
Source Object Company
MATCH BY SOURCE Associated Company ID
MATCH BY TARGET Hubspot Account ID
When Multiple Matches Occur Mark record with an error
When No Matches Are Found Reject Record

User Sync

This job syncs data from the HubSpot Owner object and inserts it into the Gainsight User object. This job is named as User Sync_ Connection name. (here User Sync_HubSpot Connection). In the User Sync OOB job, the following configuration are provided out of the box:

  • HubSpot Owner object is selected as the source object in the dataset preparation and the following source fields are selected.
  • Gainsight User is selected as target object and the HubSpot source fields are mapped with the Gainsight target fields through the Add Destination configuration.

Direct Mappings

Following are the fields and their Direct Mapping in the Add to Destination:

   
firstName First Name
lastName Last Name
email

Username

Note: Include in Identifiers check box is selected
ownerId Avatar_HubspotConnection > Hubspot User Id

Upsert key is used to resolve incoming HubSpot owners with the existing Gainsight users. Based on the Upsert key selection, either new Gainsight users are created from the incoming HubSpot owners, or associated with the existing users.

This configuration is useful if new users that you are trying to sync through the HubSpot connector may have already been added to Gainsight either through Slack or User Management. If a matching record already exists in Gainsight, the incoming HubSpot user will automatically be associated with that user.

If there are multiple matching records found for the Upsert Key criteria, you can navigate to User Management > Avatars > HubSpot Avatar Type to manually associate to one user record. After user records are synced, if multiple records are found matching the upsert key criteria, an error file is generated that directs you to the User Management page to manually resolve to one record.

Following are few use cases to apply configuration for Upsert Key, but you can always configure Upsert Keys as required:

  • If a user is already added through Slack to Gainsight, you can sync HubSpot Users through HubSpot Connector with Email as an Upsert key.

  • If a user is already added through the User Management page (Manual or CSV), you can sync HubSpot Users through HubSpot Connector with Name or Email as Upsert key.

Create a Custom Job

From the Jobs page, you can create jobs to sync data from the specific HubSpot source objects (mentioned above) with Gainsight. You can create one dataset from one source object, to create a Job. For more information, refer to the Preparation of Connector Jobs in the Additional Resource section at the end of this article.

Note: (Optional) You can create multiple data jobs as required. If the data jobs in a connection are dependent on each other, create a Job chain in a sequence and configure the schedule for the Job Chain. For more information, refer to the Job Chain Page in the Additional Resource section at the end of this article.

Limitation: Gainsight does not support Merging two datasets together to create an output dataset.

Add Destination

You can add a destination to the output dataset to sync data from the source to the target Gainsight object. For more information on Add Destination, refer to the Preparation of Connector Jobs in the Additional Resource section at the end of this article.

Direct Mapping

In the Direct Mapping, you should map fields from the output dataset to the target Gainsight object in the field mappings. Data sync happens from the fields of the source system to the target fields of Gainsight, based on the configured field mappings. For more information on Direct Mapping, refer to the Preparation of Connector Jobs in the Additional Resource section at the end of this article.

Derived Mapping

This is optional and you must configure the derived mappings only if you want to populate values into the target fields of data type GSID. GSID values are populated from the same or another object through lookup.

In this stage, you can create Lookup mapping in a data sync job. You can have a lookup to the same object or another standard object and match up to six columns. Once the required matching is performed, you can fetch Gainsight IDs (GSIDs) from the lookup object into GSID data type fields. For more information on the derived mappings, refer to the , refer to the Preparation of Connector Jobs in the Additional Resource section at the end of this article.

IMPORTANT: To use Derived Mappings, your Target Object must have at least one field of data type GSID.

Configure Job

You can configure the schedule of a data job or Job chain as required. For more information, refer to the Configure Job or Job Chain Schedule in the Additional Resource section at the end of this article.

If you create a Job Chain by adding multiple Jobs in a sequence and add a schedule to the Job Chain, the schedule of the individual jobs is not honored.

Configure Job Chain

Gainsight offers an OOB Job Chain HUBSPOT_Company Person Sync for the OOB jobs. This job chain has the OOB jobs in the following sequence:

  1. Company Sync
  2. Company Person Sync

This Job Chain is provided as the Company Person Sync job has dependency on the Company Sync job. You can configure the schedule of this Job chain as required.

Job Chain.png

You can create a custom Job Chain on the OOB or custom jobs and schedule as required. For more information, refer to the Job Chain Page and Configure Job or Job Chain Schedule in the Additional Resource section at the end of this article.

Job Activities

You can view the Execution and Update Activities of all the data jobs in the Activity page. You can also download the error logs of the jobs from this page. For more information, refer to the Activity Page in the Additional Resource section at the end of this article.

  • Was this article helpful?