> For the complete documentation index, see [llms.txt](https://docs.erathos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.erathos.com/connectors/apis/hubspot.md).

# HubSpot

Find out how to connect HubSpot to your data warehouse effortlessly.

## Using the Erathos platform:

### Creating a data pipeline with HubSpot data

#### Connect to HubSpot

* Using Erathos click in **explore** **data sources** or in connectors on the left side menu (the second icon).

<figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-3846ac408784c3eb2dcee6a27f5e21de2ff2befb%2Fimage%20(38).png?alt=media" alt=""><figcaption></figcaption></figure>

* Select HubSpot connector and name your connection

<figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-349be89e2b856bbfbfcfe4a7c84406af1e23437b%2Fimage%20(39).png?alt=media" alt=""><figcaption></figcaption></figure>

When selecting HubSpot as a new connector on the Erathos platform, you will need to authorize the connection by simply logging into the HubSpot account associated with your browser.

Just click on '**Authorize integration**' as shown in the attachment below:

<figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-6519beb36223261a8efe41482b57304477fff60e%2Fimage%20(40).png?alt=media" alt=""><figcaption></figcaption></figure>

* Select the proper HubSpot account

<figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-91b37a1362aeab9c7aa2c1a7ab55967f34b51493%2Fimage%20(42).png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-16a1410a6a615c6605a3af3e9651b5fe0af4a99e%2Fimage%20(41).png?alt=media" alt=""><figcaption></figcaption></figure>

* Connect app

<figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-19a22b484b49170281ad10e5243d95412d97bed3%2Fimage%20(43).png?alt=media" alt=""><figcaption></figcaption></figure>

Don't forget to click on **Save and test** to advance to the next steps of the integration.

<figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-0737ce8b598348bf1895b88ab949233754deab9b%2Fimage%20(44).png?alt=media" alt=""><figcaption></figcaption></figure>

#### Manage Jobs

With this connection created you can seemlessly move your HubSpot data to your BigQuery, Redshift or Postgres data-warehouse.

* Click in manage jobs to select endpoints and schedule pipeline runs.
* Name your schema

  * Your schema name is where all the tables will be created (you won't be able to change this later)

  <figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-e05b0093113e63e8ff27ac597dd794544493ed9c%2Fimage%20(45).png?alt=media" alt=""><figcaption></figcaption></figure>
* Activate jobs
  * Select a [sync frequency](https://docs.erathos.com/platform/connections/sync-schedule#frequency)
  * Select a [sync type](https://docs.erathos.com/platform/connections/sync-types)
  * Select a [sync time](https://docs.erathos.com/platform/connections/sync-schedule#frequency)
* Select fields (optional)
  * Click "Open" beside the endpoint name to see all the fields available
  * If you don't to this, all the fields will be selected automatically.

<figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-81d81aefff83d40392dcafcf6de314b22a94bf2b%2FCaptura%20de%20Tela%202025-07-09%20a%CC%80s%2009.43.32.png?alt=media" alt=""><figcaption></figcaption></figure>

* All the tables in your data warehouse will be the same as the endpoint name

#### Create a destination

* Click in settings on the left side menu
* Go to destination in the workspace menu
* Select the chosen destination and fill the necessary information to connect
  * [BigQuery self hosted](https://docs.erathos.com/destinations/bigquery)
  * [BigQuery hosted by Erathos](/destinations/what-is-a-destination/bigquery/hosted-by-erathos.md) (in case that you don't have a data warehouse yet)
  * [Databricks](https://docs.erathos.com/destinations/databricks)
  * [PostgreSQL](https://docs.erathos.com/destinations/postgresql)
  * [Redshift](https://docs.erathos.com/destinations/redshift)
  * [S3 Iceberg](https://docs.erathos.com/destinations/s3-iceberg)

{% hint style="warning" %}
If you use 'bulk actions' to change properties in HubSpot, we recommend manually executing a Full Refresh afterward. The HubSpot API does not properly update the 'updated\_at' field when bulk actions are performed, which can lead to inconsistencies in the API response."
{% endhint %}

### Disconnect the app

* Login and click on the HubSpot connection

<figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-1a108914ade996b4f6fb0bc1ff8d0315fc13043b%2Fimage%20(46).png?alt=media" alt=""><figcaption></figcaption></figure>

* Go to the settings tab
* Delete connection

  <figure><img src="https://1678877911-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcoXXr5bUdZsSICKNKPP1%2Fuploads%2Fgit-blob-2af8ab4737e88a7ae8dd5118058ef74a1f89643d%2Fimage%20(47).png?alt=media" alt=""><figcaption></figcaption></figure>

**Note:** If you delete the connection you will still have access to the data in your destination, but it will not be up-to-date anymore.

* You can also uninstall the app in HubSpot, please check the "Uninstall an app" topic on the following documentation: [Uninstall an app](https://knowledge.hubspot.com/integrations/connect-apps-to-hubspot?_ga=2.94035293.1315053923.1752660941-1718272043.1752660941#uninstall-an-app)

## What endpoints can I access with the Erathos platform?

* communications
* deal\_history
* contacts\_tickets\_associations
* contacts\_deals\_associations
* feedback\_submissions
* line\_items
* products
* quotes
* goal\_targets
* calls
* emails
* meetings
* notes
* postal\_mail
* tasks
* owners
* deals\_pipelines
* tickets\_pipelines
* companies
* deals\_tickets\_associations
* deals
* contacts
* tickets
* companies\_tasks\_associations
* companies\_calls\_associations
* deals\_tasks\_associations
* deals\_calls\_associations
* companies\_contacts\_associations
* companies\_deals\_associations
* companies\_tickets\_associations
* contacts\_meetings\_associations
* contacts\_calls\_associations
* contacts\_emails\_associations
* contacts\_communications\_associations
* tickets\_meetings\_associations
* tickets\_calls\_associations
* tickets\_emails\_associations
* tickets\_communications\_associations
* analytics\_reports\_sources
* analytics\_reports\_sources\_breakdowns
* marketing\_emails
* form\_submission