Back to source list
hubspot
Official
Premium

HubSpot

The CloudQuery HubSpot plugin extracts HubSpot information and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v4.6.1

Type

Source

Platforms
Date Published

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Set up process #


brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync hubspot.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

HubSpot Source Plugin

The CloudQuery HubSpot plugin extracts HubSpot information and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more). It is based on the HubSpot API and the github.com/clarkmcc/go-hubspot library.

Authentication #

In Order for CloudQuery to sync resources from your HubSpot setup, you will need to authenticate with your HubSpot account. You will need to create a HubSpot Private App, and copy the App Token to the spec. If not specified HUBSPOT_APP_TOKEN environment variable will be used instead.
export HUBSPOT_APP_TOKEN=<your_app_token> # optional, if not using spec configuration

Configuration #

The following example sets up the HubSpot plugin, and connects it to a postgresql destination. Incremental syncing is enabled and will be saved to the cq_state_hubspot table.
kind: source
spec:
  name: "hubspot"
  path: cloudquery/hubspot
  registry: cloudquery
  version: "v4.6.1"
  destinations: ["postgresql"]
  backend_options:
    table_name: "cq_state_hubspot"
    connection: "@@plugins.postgresql.connection"
  tables:
    - "hubspot_crm_companies"
    - "hubspot_crm_contacts"
    - "hubspot_crm_deals"
    - "hubspot_crm_line_items"
    - "hubspot_crm_owners"
    - "hubspot_crm_pipelines"
    - "hubspot_crm_products"
    - "hubspot_crm_quotes"
    - "hubspot_crm_tickets"
  # Learn more about the configuration options at https://cql.ink/hubspot_source
  spec:
    app_token: "${HUBSPOT_APP_TOKEN}" # required, unless the HUBSPOT_APP_TOKEN environment variable is set
#    max_requests_per_second: 5 # optional, see https://developers.hubspot.com/docs/api/usage-details#rate-limits


Join our mailing list

Subscribe to our newsletter to make sure you don't miss any updates.

Legal

© 2024 CloudQuery, Inc. All rights reserved.

We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.