List
Read live records straight from the HubSpot API.
Send HubSpot campaigns, companies and contact lists to any warehouse, lake or AI app.
Source
HubSpot

Overview
The Airbyte HubSpot connector extracts data from HubSpot and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 37 streams you can select per connection.
Land 37 HubSpot tables in 50+ destinations on a schedule you control.
Read, create, update and delete HubSpot records at runtime through typed entity actions.
Query synced HubSpot data with filters, sorting and semantic search, without spending HubSpot API rate limits.
Pull only the records that changed since the last run instead of reloading everything.
37 streams
| Sync modes | FullIncr. |
|---|
| Sync modes | FullIncr. |
|---|
| Sync modes | FullIncr. |
|---|
| Sync modes | FullIncr. |
|---|
| Sync modes | FullIncr. |
|---|
| Sync modes | FullIncr. |
|---|
Setup
First, navigate to the HubSpot source connector page on Airbyte's website.
Click on the "Add Source" button to begin the process of adding your HubSpot credentials.
Enter a name for your HubSpot source connector and click on the "Next" button.
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.
Next, select the HubSpot objects you want to replicate. You can choose from contacts, companies, deals, and more.
Once you have selected the objects you want to replicate, click on the "Test" button to ensure that your credentials are working properly.
If the test is successful, click on the "Create Source" button to finalize the process.
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.
| Field | Type | Description |
|---|---|---|
| credentials* | object | Choose how to authenticate to HubSpot. |
| association_streams | array | Not documented. |
| companies_property_history_properties | array | Optional list of property internal names whose history to sync for the companies_property_history stream. If empty or not set, history for all properties is synced. See HubSpot's default companies properties for the internal names. |
| contacts_property_history_properties | array | Optional list of property internal names whose history to sync for the contacts_property_history stream. If empty or not set, history for all properties is synced. See HubSpot's default contacts properties for the internal names. |
| custom_object_association_streams | array | Not documented. |
| deals_property_history_properties | array | Optional list of property internal names whose history to sync for the deals_property_history stream. If empty or not set, history for all properties is synced. See HubSpot's default deals properties for the internal names. |
| enable_experimental_streams | boolean | If enabled then experimental streams become available for sync. |
| lookback_window | integer | How far back (in minutes) to re-fetch records during incremental syncs for CRM Search streams (e.g. contacts, companies, deals, tickets). Set this if you notice missing records in CRM Search streams to recover data that may be delayed by the HubSpot API. Does not affect property history streams. |
8 actions
Read live records straight from the HubSpot API.
Write a new record back into HubSpot.
Fetch a single record by ID.
Patch fields on an existing record.
Search HubSpot records by query.
Query synced data with filters and sorting, with no API rate limits.
Natural-language search across synced HubSpot records.
Remove a record.
Full parameter-level details live in the HubSpot entity reference.
Hybrid deployment
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
Your environment
Airbyte control plane
Use cases
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
FAQ
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.
37 streams, including Campaigns, Companies, Contact Lists, Contacts, Deal Pipelines, Deal Splits, Deals (including Contact associations), Deals Archived (including Contact associations) and more.
Yes. The HubSpot connector supports incremental sync on selected streams, and full refresh on every stream.
Run the HubSpot connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.
Didn't find your answer? Talk to sales
Free 14-day trial. One connection powers your scheduled syncs and your live HubSpot actions.