Connectors

/

HubSpot

Data replication

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
HubSpot

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.

Specifications

What to know before you sync HubSpot

  • Support levelCertified
  • Available onCloud, Self-Managed Enterprise
  • Connector version6.8.0
  • Release stageGenerally available

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

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

  • Engagements Emails

  • Engagements Meetings

  • Engagements Notes

  • Engagements Tasks

  • Forms

  • Form Submissions

  • Goals

  • Leads

  • List Memberships

  • Line Items

  • Marketing Emails

  • Owners

  • Owners Archived

  • Users

  • Products

  • Properties

  • Contacts Property History

  • Companies Property History

  • Deals Property History

  • Subscription Changes

  • Tickets

  • Ticket Pipelines

  • Workflows

  • Account Details

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

    • Recommended

    OAuth

  • 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

Update the deal stage to 'closedwon' for a specific deal

Create a new company called 'Acme Corp' with domain acme.com

Create a support ticket with subject 'Login issue' and priority HIGH

Update the contact email for a specific contact

Associate contact 123 with deal 456

Link a contact to a company in HubSpot

Set contact 123 as the Primary contact for company 456

List all associations for contact 123 to companies

Remove an association between a contact and a deal

Add a note to contact 12345 saying 'Discussed pricing options'

List recent notes in my CRM

Get the details of a specific note

Delete a note from HubSpot

Log a call with contact 12345 about pricing discussion

List recent calls in my CRM

Create an email record for outreach to a contact

List recent emails in my CRM

Schedule a meeting with a contact for next Tuesday

List recent meetings in my CRM

Create a follow-up task for a deal

List tasks in my CRM

Show me all deals from Acme Corp this quarter

What are the top 5 most valuable deals in my pipeline right now?

Search for contacts in the marketing department at HubSpot

Give me an overview of my sales team's deals in the last 30 days

Identify the most active companies in our CRM this month

Compare the number of deals closed by different sales representatives

Find all tickets related to a specific product issue and summarize their status

Explore

Related connectors

HumanitixMarketing AnalyticsStandard Sources cloudself-managed-enterprise
InstagramMarketing AnalyticsCertified Sources cloudself-managed-enterprise
IterableMarketing AnalyticsStandard Sources cloudself-managed-enterprise
JotformMarketing AnalyticsStandard Sources cloudself-managed-enterprise
KlaviyoMarketing AnalyticsCertified Sources cloudself-managed-enterprise
LemlistMarketing AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

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

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.

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.

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.

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.

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.

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.

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.

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