Skip to main content

HubSpot

info

API Documentation: HubSpot API Documentation

High-Level Information:

The HubSpot API allows you to access and manage data related to your CRM and marketing activities. The integration focuses on pulling data for the following types of reports:

  1. CRM Reports: These reports provide detailed information about contacts, companies, deals, and tickets within your HubSpot CRM. This includes data such as contact properties, deal stages, and ticket statuses.
  2. Marketing Reports: These reports offer insights into your marketing activities, including email campaigns, landing pages, forms, and social media interactions.

Authentication​

To authenticate with HubSpot, use a HubSpot Private App access token.

  1. In HubSpot, go to Settings → Integrations → Private Apps.
  2. Create a private app (or open an existing one) and generate an Access token.
  3. Ensure the app has the required scopes for the data you plan to sync (at minimum, read access to the CRM objects you want to extract).
  4. In your connector configuration, paste the token as the Private App Token.

The connector validates credentials by making an authenticated request to the HubSpot API using the provided token.

Source Setup Guide​

Step 1​

banner in the Edit Source form to the left.

Step 2​

Follow the authentication flow (OAuth) in HubSpot's website to grant Extract the required permissions.

Step 3​

Confirm you can see your email and profile picture, and that the source is Connected.

Connection Setup Guide​

After you connect HubSpot to a destination, configure the connection run settings:

  • Connection Pull Schedule: How frequently Extract pulls data from HubSpot.
  • Backfill (Days): How far back in time to retrieve historical data on each run.
  • Destination-specific settings: Options such as Dataset Name or Target Schema (varies by destination).
  • Schema Migration Policy: How Extract handles schema changes coming from HubSpot.

Schema ERD​

Explore the interactive entity relationship diagram for Hubspot.

Open page

Data Streams​

campaign_asset​

Loading ....

campaign​

Loading ....

deal_pipeline_stages​

Loading ....

deal_pipeline​

Loading ....

form.schema_todo​

Loading ....

marketing_event.schema_todo​

Loading ....

owner_team​

Loading ....

owner​

Loading ....

Notes​

HubSpot Audiences destination support is not yet available. While credential validation for a HubSpot private app token may succeed, destination loading is still in development and will fail if you attempt to run it.