How to Setup Hubspot Integration

This integration will allow you to connect with Hubspot and start collecting your marketing and sales data. It is a matter of minutes to send your Hubspot data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting Hubspot
  2. Set the Replication Frequency
  3. Load your Hubspot data into your data warehouse
  4. Hubspot expected Data Model and schema

Getting Started – Setup Hubspot integration at Blendo

1. To add this integration, go to Blendo dashboard. Click “Add a Source”

Setup Hubspot integration

2. In the new “Setup your Hubspot source” screen click on Connect with Hubspot.

Setup Hubspot integration

3. If you’re not already logged into your HubSpot account, you will be prompted to connect to your Hubspot credentials.

Setup Hubspot integration

4. Login to your Hubspot account.

5. In the next page you will see a list of your Hubspot accounts. Click on the one you want to connect to.

Setup Hubspot integration

6. At the next page see if everything is OK and click Validate & Save.

Setup Hubspot integration

7. Then you will return back to the home dashboard. Click on your new Hubspot data source.

Setup Hubspot integration

Load your Hubspot data into your data warehouse

Here is how to start loading your Hubspot data into your data warehouse:

Load Hubspot data into data warehouse

Expected Hubspot Data Model and Schema

Let’s see:

  1. How Blendo syncs Hubspot data
  2. The tables with Hubspot data that we create in your destination data warehouse

How Blendo syncs Hubspot data

Historical Data

When Blendo first connects to Hubspot Data source, will pull all your historical data.

Sync Schedule

Blendo syncs Hubspot data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your Hubspot data performs a full replication. Then your Hubspot data is replicated incrementally. There may be cases due to an APIs limitation an incremental sync is not possible. In that case a full sync is done. Please check the CSV for more details.

After you finish the integration with Hubspot, you might see its status as Importing from sourceExporting to the destination, or Completed.

What Hubspot data do I have available?

Blendo creates a table for an object in Hubspot API in your data warehouse and the object’s fields are its columns.

In the next array you will see a sample of the tables we replicate from Hubspot. If you want the full schema information please download the csv in the link below.

Download the Full Hubspot Schema Information >>

Hubspot ResourceBlendo Table NameDescription
Blog Authorsblogs_authorsThe table contains information about the blog authors
Blog Commentsblogs_commentsThe table contains information about the blog comments
Blog Postsblogs_postsThe table contains information about the blog posts
Blog Topicsblogs_topicsThe table contains information about the blog topics
BlogsblogsThe table contains information about the blog overall
CampaignscampaignsThe table contains information about the campaign’s data in HubSpot
CompaniescompaniesThe table contains information about the company data in HubSpot
Companies Contactscompanies_contactsThe table contains information about the contacts related to company in HubSpot
Contact Listscontacts_listsThe table contains information about Contact Lists in Hubspot. Contact Lists are used to segment contacts into groups.
Due to Hubspot’s API need to be fully synced each time. Read more.
ContactscontactsThis table contains information about Contacts. Contacts are the fundamental building block to HubSpot.
Contacts Identitiescontacts_identitiesThe table contains information about the contacts related to identities in HubSpot
Contacts in Listscontacts_in_listsThe table contains information about the Contacts and Lists data in HubSpot.
Due to Hubspot’s API need to be fully synced each timeRead more.
DealsdealsThe table contains information about the Deals in HubSpot
Deals Companiesdeals_companiesThe table contains information about the Deals related to Companies data in HubSpot
Deals Contactsdeals_contactsThe table contains information about the Deals related to Contacts data in HubSpot
Deals Dealsdeals_dealsThe table contains information about the Deals and related Deals data in HubSpot
KeywordskeywordsThis table contains information about Keywords in Hubspot
OwnersownersThis table contains information about Owners in Hubspot
WorkflowsworkflowsThis table contains information about Workflows. Workflows along with Contacts and emails, are the heart of Hubspot marketing automation.

Custom Fields

Blendo will create a column for any of your custom fields and will sync it accordignly.

Questions? Contact us!

in Connecting SaaS Data Sources