- Airtable
- BigQuery
- Braze
- Calculated Property
- ClickHouse
- Close.io
- Customer.io
- dbt
- Google Sheets
- HubSpot
- Intercom
- Iterable
- Mailchimp
- Mailjet
- Marketo
- Mixpanel
- Mongo
- MySQL
- OneSignal
- Pipedrive
- Postgres
- Redshift
- Sailthru
- Salesforce
- SendGrid
- Snowflake
- SQLite
- Zendesk
HubSpot
Last Updated: 2022-02-21NPM: @grouparoo/hubspot
GitHub: @grouparoo/hubspot
Grouparoo's HubSpot Integration enables you to export users to HubSpot.
This guide will show you how to work with the HubSpot Integration to create a Destination to export your data.
Overview
HubSpot is a customer relationship management (CRM) tool. You can use HubSpot to manage marketing, sales, and customer service tasks. Grouparoo can help you to sync data from your warehouse to HubSpot easily and efficiently.
Destinations
Setup
To connect HubSpot to Grouparoo, you create an App to tell Grouparoo how to connect to HubSpot. This specifies the account used for any Destinations. There are two ways you can connect to your HubSpot data:
- With a HubSpot API Key
- With OAuth
Setup with API Key
In Grouparoo, you specify the options to connect to HubSpot and then test the connection before updating the App.
The app's options include:
App Option | Description |
HubSpot API Key (required) | HubSpot API Key. |
To find or create an API key for HubSpot, your HubSpot account must have Super Admin Permissions. Navigate to Settings > Integrations > API Key. Only one API key is allowed per HubSpot account and this key gives full developer access to make changes to the account via API. You will need to Show then Copy the API key from this page. There are also options for rotating out or deleting the key associated with your account.
For more information on options for keeping your API Key secure, visit our documentation on secrets.
Setup with OAuth
With OAuth, you will grant permissions to HubSpot with a user account and store a Refresh Token that will be used to generate requests. Click the "Request Token" button to start the process.
If the token becomes invalid, you can always return to the app page to re-request a new token.
HubSpot Export Contacts
This Destination enables you to sync your Grouparoo Records to Contacts in HubSpot.
Companies use Grouparoo to keep their HubSpot Contacts up-to-date in order to communicate with their customers and organize those customer contacts even further, in Lists.
To create a Destination, you make choices about what data to sync.
Sync Modes
A Destination’s sync mode determines what to update in a Destination. The following are supported by HubSpot:
- Sync: Add, update, and remove HubSpot Contacts as needed.This option looks for new records, changes to existing records, and deletions.
- Additive: Add and update HubSpot Contacts as needed, but do not remove anybody. This option looks for new Contacts to add to HubSpot and changes to existing HubSpot Contacts, but does not keep track of deletions.
- Enrich: Only update those Contacts that already exist in HubSpot. Do not add or remove Contacts. This option will only update existing Contacts in HubSpot.
Destination Options
Some types of Destinations require further clarification about how data should sync. In the case of HubSpot Export Contacts Destinations, there are no further Options to configure before moving on to mapping Record Data.
Record Data
Mapping Record Properties to HubSpot Contact Properties is the key to syncing data to HubSpot.
In HubSpot, Contact Properties can be used to store and organize all the different types of information you collect related to each Contact. This makes it possible to segment, track, and report on the performance of your HubSpot database.
Required Properties
The only Grouparoo Property that is required to map to HubSpot Contact Properties is email. Choose the Grouparoo Property that corresponds with the Contact’s email address.
- email: a Contact’s email address in HubSpot
Optional Properties
In addition to the required email property, HubSpot allows you to set many other Contact Properties. You can create custom HubSpot Contact Properties as needed. These are additional attributes you would create in your HubSpot account and they will be available in the Send Record Property dropdown menu on this screen. Any of these Contact Properties can be synced to from Grouparoo Properties.
Group Data
In addition to mapping Grouparoo Properties to HubSpot Lists, you can use Grouparoo Groups add HubSpot Contacts to Grouparoo defined lists.
This list-making process starts by selecting a group from the dropdown menu in the Send Group box. The HubSpot List name will default to the name of the Grouparoo Group you have selected, but you can edit the HubSpot List name as you want it to appear. Grouparoo will not affect Lists with different names that were created and applied directly through HubSpot.
HubSpot Lists can be used to organize and subdivide your audiences for targeted communications.
HubSpot Export Objects
This Destination enables you to sync your Grouparoo Records to Contacts in HubSpot. You can export Records as HubSpot Custom Objects (with an Enterprise HubSpot account) or HubSpot Standard Objects.
Companies use Grouparoo to keep their HubSpot Contacts up-to-date in order to communicate with their customers and organize those customer contacts even further, in Lists.
To create a Destination, you make choices about what data to sync.
Sync Modes
A Destination’s sync mode determines what to update in a Destination. The following are supported by HubSpot:
- Sync: Add, update, and remove HubSpot Contacts as needed.This option looks for new records, changes to existing records, and deletions.
- Additive: Add and update HubSpot Contacts as needed, but do not remove anybody. This option looks for new Contacts to add to HubSpot and changes to existing HubSpot Contacts, but does not keep track of deletions.
- Enrich: Only update those Contacts that already exist in HubSpot. Do not add or remove Contacts. This option will only update existing Contacts in HubSpot.
Destination Options
To further clarify how HubSpot should sync data, select how data should be synced. There are two required Options to configure this type of Destination.
Destination Option | Description |
Schema (required) | Which object in HubSpot represents a Grouparoo Record? |
Primary Key (required) | Which field in the Schema selected uniquely represents the Grouaproo Records? |
Record Data
Required Properties
The only Grouparoo Property that is required to map to HubSpot Contact Properties is email. Choose the Grouparoo Property that corresponds with the Contact’s email address.
- email: a Contact’s email address in HubSpot
Optional Properties
In addition to the required email property, HubSpot allows you to set many other Contact Properties. You can create custom HubSpot Contact Properties as needed. These are additional attributes you would create in your HubSpot account and they will be available in the Send Record Property dropdown menu on this screen. Any of these Contact Properties can be synced to from Grouparoo Properties.
Group Data
Some Destination types allow you to make use of Grouparoo Groups to apply tags or send to lists. When using HubSpot Export Object, this is not part of the configuration.
Notes
We strive to keep our documentation accurate, easy to use, and up to date. If you notice that something has changed or is not addressed in the process of setting up your Grouparoo connection with HubSpot
, please let us know by reaching out to help@grouparoo.com.
As always, if you need support using Grouparoo, reach out to community members in our Slack channel. We are always happy to help!
Join us on SlackHaving Problems?
If you are having trouble, visit the list of common issues or open a Github issue to get support.
- Airtable
- BigQuery
- Braze
- Calculated Property
- ClickHouse
- Close.io
- Customer.io
- dbt
- Google Sheets
- HubSpot
- Intercom
- Iterable
- Mailchimp
- Mailjet
- Marketo
- Mixpanel
- Mongo
- MySQL
- OneSignal
- Pipedrive
- Postgres
- Redshift
- Sailthru
- Salesforce
- SendGrid
- Snowflake
- SQLite
- Zendesk