Release Status Released Availability Premium
Status Page HubSpot Status Page Default Historical Sync 30 days
Whitelist Tables/Columns Supported/Unsupported Default Replication Frequency 30 minutes
Full Table Endpoints 1 Incremental Endpoints 11
Destination Incompatibilities None

Connecting HubSpot

Connecting your HubSpot data to Stitch is a four-step process:

  1. Add HubSpot as a Stitch data source
  2. Define the Historical Sync
  3. Define the Replication Frequency
  4. Authorize Stitch to access HubSpot

Prerequisites

Administrator permissions in HubSpot are required to complete the setup. This will ensure that Stitch is able to access and replicate all the data in your HubSpot account.

If you’re using the HubSpot Sales product, Sales Administrator permissions are required.

Before beginning the setup process, verify that the user setting up the integration in Stitch has these permissions.

More information about HubSpot user roles and permissions can be found in their documentation.

Add HubSpot as a Stitch Data Source

  1. On the Stitch Dashboard page, click the Add an Integration button.
  2. Click the HubSpot icon.

  3. Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Stitch HubSpot” would create a schema called stitch_hubspot in the data warehouse. This schema is where all the tables for this integration will be stored.

Define the Historical Sync

The Sync Historical Data setting will define the starting date for your HubSpot integration. This means that:

  • For tables using Incremental Replication, data equal to or newer than this date will be replicated to your data warehouse.
  • For tables using Full Table Replication, all data - including records that are older, equal to, or newer than this date - will be replicated to your data warehouse.

Change this setting if you want to sync data beyond HubSpot’s default setting of 30 days. For a detailed look at historical syncs, check out the Syncing Historical SaaS Data article.

Define the Replication Frequency

The Replication Frequency controls how often Stitch will attempt to replicate data from your HubSpot integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.

Before setting the Replication Frequency, note that the more often HubSpot is set to replicate, the higher the number of replicated rows.

Additionally, the number of rows Stitch replicates is impacted by:

  • The Replication Methods used by this integration’s tables. Refer to the Schema section for info on how specifc tables are replicated.

To help prevent overages, we recommend setting the integration to replicate less frequently. For example: every 6 hours instead of every 30 minutes.

After selecting a Replication Frequency, click Save Integration.

Authorize Stitch to Access HubSpot

  1. Next, you’ll be prompted to sign into your HubSpot account if you aren’t already.
  2. After you log into HubSpot, a screen with a list of your HubSpot accounts will display. Click the account you want to connect to Stitch.

    Note that we will only ever read your data. Stitch will never modify or delete any data in your HubSpot account.

  3. After the authorization process is successfully completed, you’ll be directed back to Stitch.
  4. Click All Done.

HubSpot’s Intial Sync

After you finish setting up HubSpot, you might see its Sync Status show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial sync for the integration. This may take some time to complete.


HubSpot Schema

Custom HubSpot Field Replication

Custom object properties, or fields, are supported by Stitch’s HubSpot integration. Stitch will query the properties list for each object and, if custom fields are available through HubSpot’s API, replicate them to your destination.

Included Tables

Note that these tables won't automatically be created in your data warehouse. You must set them to sync in the Integration Details page first.

Stitch's HubSpot integration includes these tables:


campaigns

Replication Method: Full Table
Primary Key: id
Contains Nested Structures?: Yes

The campaigns table contains info about the campaigns in your HubSpot account.

Table Info & Attributes

campaigns & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

campaigns Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • id

  • appId

  • appName

  • contentId

  • counters__delivered

  • counters__open

  • counters__processed

  • counters__sent

  • name

  • numIncluded

  • numQueued

  • subType

  • subject

  • type

companies

Replication Method: Incremental
Primary Key: companyid
Contains Nested Structures?: No

The companies table contains info about companies your contacts belong to.

Note: when this table is synced, the hubspot_contacts_by_company table will also be automatically synced and created in your data warehouse.

Table Info & Attributes

companies Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • Company ID (companyid)

  • portalid

  • isdeleted

contacts

Replication Method: Incremental
Primary Key: canonical-vid
Contains Nested Structures?: Yes

The contacts table contains info about individual contacts in HubSpot.

Table Info & Attributes

contacts & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

contacts Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • canonical-vid

  • vid

  • merged-vids*

  • portal-id

  • is-contact

  • profile-token

  • profile-url

  • identity-profiles*

  • list-memberships*

  • form-submission*

  • merge-audits*

contact_lists

Replication Method: Incremental
Primary Key: listId
Contains Nested Structures?: Yes

The contact_lists table contains info about the contact lists in your HubSpot account.

Table Info & Attributes

contact_lists & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

contact_lists Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • listId

  • internalListId

  • parentId

  • metaData

  • dynamic

  • name

  • filters*

  • portalId

  • createdAt

  • updatedAt

  • readOnly

  • archived

  • deleteable

  • authorid

  • listType

hubspot_contacts_by_company

Replication Method: Incremental
Primary Key: contact-id : company-id
Contains Nested Structures?: No

The hubspot_contacts_by_company table contains contact and company ID pairs, allowing you to tie your HubSpot contacts to company info.

Note: to sync this table, you must set the companies table to sync. This table will then be automatically synced and created in your data warehouse. Records for this table will be replicated whenever the corresponding company is updated.

Table Info & Attributes

hubspot_contacts_by_company Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • contact-id

  • company-id

deals

Replication Method: Incremental
Primary Key: dealId : portalId
Contains Nested Structures?: Yes

The deals table contains info about all the deals in a HubSpot portal.

Table Info & Attributes

deals & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

deals Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • dealId

  • portalId

  • isDeleted

  • associations__associatedVids*

  • associations__comapnyIds*

  • associations__dealIds*

engagements

Replication Method: Incremental
Primary Key: id
Contains Nested Structures?: Yes

The engagements table contains info about all the engagements in a HubSpot portal.

Table Info & Attributes

engagements & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

engagements Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • id

  • portalId

  • active

  • createdAt

  • lastUpdated

  • ownerId

  • type

  • timestamp

  • associations__contactIds*

  • associations__companyIds*

  • associations__dealIds*

  • attachments*

  • metadata__body

  • metadata__from__email

  • metadata__from__firstName

  • metadata__from__lastName

  • metadata__to__email

  • metadata__cc__email

  • metadata__bcc__email

  • metadata__subject

  • metadata__html

  • metadata__text

  • metadata__status

  • metadata__forObjecttype

  • metadata__startTime

  • metadata__endTime

  • metadata__title

  • metadata__toNumber

  • metadata__fromNumber

  • metadata__externalID

  • metadata__durationMilliseconds

  • metadata__externalAccountId

  • metadata__recordingUrl

forms

Replication Method: Incremental
Primary Key: guid
Contains Nested Structures?: Yes

The forms table contains info about your HubSpot website forms.

Table Info & Attributes

forms & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

forms Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • guid

  • portalId

  • name

  • action

  • method

  • cssClass

  • redirect

  • submitText

  • followUpId

  • notifyRecipients

  • leadNurturingCampaignId

  • formFieldGroups*

  • createdAt

  • updatedAt

  • performableHtml

  • migratedFrom

  • ignoreCurrentValues

  • deletable

  • inlineMessage

  • tmsId

  • captchaEnabled

  • campaignGuid

  • cloneable

  • editable

  • formType

  • metaData*

keywords

Replication Method: Append-Only (Incremental)
Primary Key: keyword_guid
Contains Nested Structures?: No

The keywords table contains info about your HubSpot portal keywords.

Table Info & Attributes

keywords Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • keyword_guid

  • keyword

  • contacts

  • country

  • visits

  • created_at

  • leads

owners

Replication Method: Incremental
Primary Key: ownerId : portalId
Contains Nested Structures?: Yes

The owners table contains info about the owners that exist in your HubSpot portal.

Table Info & Attributes

owners & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

owners Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • ownerId

  • portalId

  • createdAt

  • type

  • firstName

  • lastName

  • email

  • signature

  • hasContactsAccess

  • updatedAt

  • remotelist*

subscription_changes

Replication Method: Incremental
Primary Key: recipient : timestamp : portalId
Contains Nested Structures?: Yes

The subscription_changes table contains info about changes made to subscriptions.

Table Info & Attributes

subscription_changes & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

subscription_changes Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • portalId

  • recipient

  • timestamp

  • changes*

workflows

Replication Method: Incremental
Primary Key: id
Contains Nested Structures?: Yes

The workflows table contains info about the workflows in your HubSpot portal.

Table Info & Attributes

workflows & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

workflows Attributes

While we try to include everything HubSpot has here, this may not be a full list of attributes. Refer to HubSpot's documentation for a full list and description of each attribute.

  • id

  • name

  • type

  • enabled

  • insertedAt

  • updatedAt

  • personaTagIds*

  • contactLisIds__active

  • contactListIds__enrolled

  • contactListIds__steps*


HubSpot Date & DateTime Values & UNIX Timestamps

HubSpot uses UNIX-formatted timestamps in milliseconds to store date and datetime data. Stitch doesn’t perform any transformation during the replication process, meaning these values won’t be converted to timestamps before they’re loaded into your destination.

To account for this, consider creating a user-defined function to perform the conversion or building views on top of the raw data.


Questions? Feedback?

Did this article help? If you have questions or feedback, please reach out to us.