Data Destination - HubSpot
  • 07 Dec 2022
  • Dark
  • PDF

Data Destination - HubSpot

  • Dark
  • PDF

Article Summary


This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.


This is the help page for setting up data transfer to HubSpot.

Supported Protocols

  • Data Transfer (Embulk)


  • Only one object can be transferred.

Setting items

STEP1 Basic settings

HubSpot connection informationYes-From the connection information registered in advance, select the one that has the necessary permissions for this transfer setting.
Only connection information created with OAuth 2.0 as the authentication method can be selected.
For more information on how to set up connection information, see Connection information in HubSpot.
Update toYes-
  • object
  • subscription
Object TypeYes-Specify the name of the object where the report data is stored.
  • contact
  • company
  • deal
  • product
  • ticket
  • line_item
  • quote
  • subscription
Transfer ModeYesUPSERTSpecify the method by which data is transferred to the object.
  • UPSERT: UPSERT data to an object.
UPSERT keyYeshs_object_idEnter when you select UPSERT in transfer mode.
Enter the name of the property that you want to treat as a merge key (primary key) with unique values.
Note that the default values arehs_object_id properties with unique values set by HubSpot.
Object Type: About Subscription

If you select subscription as the object type, the transfer is performed in UPSERT. Also, the UPSERT key isemail automatically specified as andsubscription_id .
For more information, see Renewing your subscription below.

If you want to set a property to the UPSERT key

hs_object_id, or any other property of the contact objectemail if you want to set it as a UPSERT key, you'll need to do so in HubSpot beforehand. The following describes the configuration procedure.

  1. Log in to HubSpot and click your HubSpot account
  2. At the top right of the screen, click the settings icon in the red frame.
  3. Click Properties
  4. Select the object and click the property you want to use as the UPSERT key
  5. Click the Rules tab
  6. For this property, enable Require non-duplicate values and click Save

Renew your subscription

Usage API


All of the following columns must be included in the transferred data:

Columndescriptionsample value
subscription_idSubscription ID
Learn how to find your subscription ID.
is_subscribedSubscription StatusMake sure it is set to boolean typein STEP2 of trocco.
  • true: Subscribe
  • false: Unsubscribe

How to find your subscription ID

  1. In HubSpot, select Settings→ Data Management→ Properties.
  2. Select "Export all properties" at the top right of the properties screen and click "Export" in the modal to download the Excel/CSV file.
  3. Find items starting with in the "CONTACT" sheet hs_email_optout_of the Excel/CSV file.
  4. hs_email_optout_111111, where is the subscription ID.


  • If you have unsubscribed, you will not be able to subscribe to Trocco. Update from the top of the HubSpot screen.
  • Updating with the same subscription status will result in an error.
    • Example: Unsubscribing to unsubscribe will result in an error.

Was this article helpful?