Connectors

/

HubSpot

HubSpot

Marketing Analytics

Sync HubSpot data anywhere.

A platform focused on sales and inbound marketing, Hubspot helps businesses optimize their online marketing strategies for greater visibility to attract more visitors, collect leads, and convert prospects into customers. HubSpot provides a variety of essential services and strategies to move businesses forward, including social media and email marketing, website content management, search engine optimization, blogging, and analytics and reporting. Hubspot is an all-around solution for business teams to grow their customer base through effective marketing.

  • Certified
  • Generally available
  • 36 streams
  • 12 entities
  • Read & write
Sync HubSpot dataRead the docs
  • 36Streams
  • 12Entities
  • 8Actions
  • 50+Destinations
One connector

Everything HubSpot can do in Airbyte

  • Sync to your warehouse

    Land 36 HubSpot tables in 50+ destinations on a schedule you control.

  • Live entity actions

    Read, create, update and delete HubSpot records at runtime through typed entity actions.

  • Context store search

    Query synced HubSpot data with filters, sorting and semantic search, without spending HubSpot API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Available onCloud, Self-Managed Enterprise
  • Destinations50+ Airbyte connectors
  • Connector version6.8.0

Set up in 8 steps

  1. First, navigate to the HubSpot source connector page on Airbyte's website.
  2. Click on the "Add Source" button to begin the process of adding your HubSpot credentials.
  3. Enter a name for your HubSpot source connector and click on the "Next" button.
  4. You will be prompted to enter your HubSpot API key. To obtain your API key, log in to your HubSpot account and navigate to the "Settings" page. From there, click on "Integrations" and then "API key." Copy the API key and paste it into the Airbyte connector page.
  5. Next, select the HubSpot objects you want to replicate. You can choose from contacts, companies, deals, and more.
  6. Once you have selected the objects you want to replicate, click on the "Test" button to ensure that your credentials are working properly.
  7. If the test is successful, click on the "Create Source" button to finalize the process.
  8. Your HubSpot source connector is now set up and ready to use. You can begin replicating data from your HubSpot account to your destination of choice.
36 streams

Every table you can sync from HubSpot

  • Campaigns

  • Companies

  • Contact Lists

  • Contacts

  • Deal Pipelines

  • Deal Splits

  • Deals (including Contact associations)

  • Deals Archived (including Contact associations)

  • Email Events

  • Email Subscriptions

  • Engagements

  • Engagements Calls

8 actions

Supported HubSpot actions

  • List

    Read live records straight from the HubSpot API.

  • Create

    Write a new record back into HubSpot.

  • Get

    Fetch a single record by ID.

  • Update

    Patch fields on an existing record.

  • API Search

  • Context Store Search

    Query synced data with filters and sorting, with no API rate limits.

  • Semantic Search

    Natural-language search across synced HubSpot records.

  • Delete

    Remove a record.

Full parameter-level details live in the HubSpot entity reference.

Authentication

Authenticate HubSpot once

  • OAuth

    Recommended

  • Private App

Use cases

What teams build with HubSpot

  • List recent deals

  • List recent tickets

  • List companies in my CRM

  • List contacts in my CRM

  • Create a new contact with email john@example.com and name John Smith

  • Create a new deal called 'Enterprise License' with amount 50000

FAQ

Common questions

Do I need more than one HubSpot connection?

No. One HubSpot authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.

Do HubSpot entity actions need a sync to run first?

No. Entity actions read and write through the HubSpot API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.

What is ETL?

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

What data can you extract from HubSpot?

HubSpot's API provides access to a wide range of data categories, including:

1. Contacts: Information about individual contacts, including their name, email address, phone number, and company.

2. Companies: Information about companies, including their name, industry, and location.

3. Deals: Information about deals, including their stage, amount, and close date.

4. Tickets: Information about customer support tickets, including their status, priority, and owner.

5. Products: Information about products, including their name, price, and description.

6. Analytics: Data on website traffic, email performance, and other marketing metrics.

7. Workflows: Information about automated workflows, including their triggers, actions, and outcomes.

8. Forms: Information about forms, including their fields, submissions, and conversion rates.

9. Social media: Data on social media engagement, including likes, shares, and comments.

10. Integrations: Information about third-party integrations, including their status and configuration.

Overall, HubSpot's API provides access to a wide range of data categories that can be used to improve marketing, sales, and customer support efforts.

How do I transfer data from HubSpot?

1. First, navigate to the HubSpot source connector page on Airbyte's website.

2. Click on the "Add Source" button to begin the process of adding your HubSpot credentials.

3. Enter a name for your HubSpot source connector and click on the "Next" button.

4. You will be prompted to enter your HubSpot API key. To obtain your API key, log in to your HubSpot account and navigate to the "Settings" page. From there, click on "Integrations" and then "API key." Copy the API key and paste it into the Airbyte connector page.

5. Next, select the HubSpot objects you want to replicate. You can choose from contacts, companies, deals, and more.

6. Once you have selected the objects you want to replicate, click on the "Test" button to ensure that your credentials are working properly.

7. If the test is successful, click on the "Create Source" button to finalize the process.

8. Your HubSpot source connector is now set up and ready to use. You can begin replicating data from your HubSpot account to your destination of choice.

What are top ETL tools to transfer data from HubSpot?

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

What is ELT?

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

Difference between ETL and ELT?

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Explore
All connectors

Start moving HubSpot data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live HubSpot actions.

Try it freeTalk to sales