Source connector

HubSpot connector

HubSpot integration for databases, warehouses and BI tools

Inbound CRM with marketing, sales, and service hubs. Datrise captures HubSpot CRM entities such as contacts, companies, deals, lifecycle stages, and engagement events, then lands normalized and typed models for warehouse reporting, attribution, and AI workflows.

The HubSpot CRM API v3 authenticates with OAuth 2.0, personal access token, incremental runs key on hs_lastmodifieddate (contacts also expose lastmodifieddate) queried via the CRM Search API, and HubSpot caps calls at Privately distributed apps: Free/Starter 100 requests/10s per app and 250,000/day per account; Professional 190/10s and 625,000/day; Enterprise 190/10s and 1,000,000/day (API Limit Increase add-on raises burst to 250/10s and adds up to 1,000,000/day, max two add-ons). Public OAuth (Marketplace) apps are fixed at 110 requests/10s per installing account. The CRM Search API is separately capped at 5 requests/second per account.

Of the 5 objects, 4 sync as upserts keyed on the primary key and 1 as append-only streams, so each incremental run moves only what changed since the last watermark. Every object lands in its own table (for example `hubspot_contacts`) with a schema derived from the HubSpot API rather than a flattened CSV, in any of the 43 supported destinations.

Datrise is in early access: pick a destination below to open the HubSpot pipeline page, and join the waitlist to get the HubSpot connector (CRM) with guided onboarding.

Incremental syncSchema-aware mapping43 destinations available

What HubSpot CRM data Datrise extracts

Each object lands in its own typed table. Sync mode is derived from the object: history-style objects append, everything else upserts.

Object	Landing table	Sync mode
contacts	hubspot_contacts	Upsert by primary key, incremental on updated-at
companies	hubspot_companies	Upsert by primary key, incremental on updated-at
deals	hubspot_deals	Upsert by primary key, incremental on updated-at
lifecycle stages	hubspot_lifecycle_stages	Upsert by primary key, incremental on updated-at
engagement events	hubspot_engagement_events	Append-only, incremental by timestamp

HubSpot CRM API: setup facts for the connector

Verified against the vendor documentation on 2026-09-02. Unknown values are left blank rather than guessed.

API	HubSpot CRM API v3
Authentication	OAuth 2.0, personal access token — Public/Marketplace apps use OAuth2 (short-lived access token plus refresh token); private apps instead use a static personal access (bearer) token.
Pagination	cursor — `after` cursor parameter with `paging.next.after` in the response; standard CRM object list endpoints return up to 100 records per page.
Rate limit	Privately distributed apps: Free/Starter 100 requests/10s per app and 250,000/day per account; Professional 190/10s and 625,000/day; Enterprise 190/10s and 1,000,000/day (API Limit Increase add-on raises burst to 250/10s and adds up to 1,000,000/day, max two add-ons). Public OAuth (Marketplace) apps are fixed at 110 requests/10s per installing account. The CRM Search API is separately capped at 5 requests/second per account.
Incremental cursor	hs_lastmodifieddate (contacts also expose lastmodifieddate) queried via the CRM Search API — Search for hs_lastmodifieddate greater than the last sync watermark to capture both new and edited records; association changes do not update this timestamp.
Webhooks	Yes — Webhooks API (Journal/Subscriptions v4, currently in beta)
Bulk export	Yes — CRM Exports API (POST /crm/v3/exports/export/async)
Deletes detectable	Yes — Soft-deleted records are flagged with an `archived: true` boolean and moved to the recycling bin rather than removed from the API.

Official API reference

What bites when replicating HubSpot CRM

The CRM Search API is capped at 5 requests per second per account and returns at most 10,000 total results per query, with an HTTP 400 past that offset.
Public OAuth (Marketplace) apps are hard-capped at 110 requests per 10 seconds per installing account regardless of the account's subscription tier or any API Limit Increase add-on.
Contacts still expose `lastmodifieddate` while most other CRM objects (deals, companies, tickets) rely on `hs_lastmodifieddate`, and association changes update neither timestamp.
The CRM Exports API's download URL, returned from GET /crm/v3/exports/export/async/tasks/{exportId}/status once the status is COMPLETE, expires 5 minutes after issuance.

Compare this against every other documented API

Popular destinations for HubSpot CRM

Choose a destination below to open the ready pipeline page.

A
Airtable
Relational spreadsheet destination for ops and go-to-market teams.
View pipeline
A
Amazon Athena
Serverless SQL over S3 data lake tables.
View pipeline
A
Amazon DynamoDB
Serverless key-value and document store on AWS.
View pipeline
A
Amazon QuickSight
AWS serverless BI with SPICE and embedded analytics.
View pipeline
A
Amazon Redshift
AWS petabyte-scale warehouse with Spectrum.
View pipeline
A
Amazon S3 Data Lake
Object storage landing zone for parquet and snapshots.
View pipeline
A
Apache Superset
Open-source BI for SQL exploration, charts, and dashboard publishing.
View pipeline
A
Azure Data Lake Storage
ADLS Gen2 object storage for analytics workloads.
View pipeline
A
Azure Synapse
Microsoft analytics workspace with SQL pools.
View pipeline

HubSpot CRM connector FAQ

What HubSpot data does the connector extract?: 5 objects: contacts, companies, deals, lifecycle stages and engagement events. Each lands in its own table with types preserved; history-style objects (1: engagement events) load as append-only streams.
Is the HubSpot integration incremental?: Yes. After the initial full load, every run reads only records changed since the last watermark (updated-at or event timestamp) and applies an upsert or an append depending on the object.
Where can I load HubSpot data?: Into 43 destinations: relational databases, cloud warehouses, data lakes, spreadsheets and BI tools. Each HubSpot → destination pair has its own page with the object-to-table mapping.

Related CRM sources

Other sources in the same category, each with its own connector page.

Early access

Launch your HubSpot CRM pipeline with guided onboarding

Join the waitlist to get priority access for HubSpot CRM integrations with guided setup, schema-aware mapping, and production-grade incremental sync.