Back to source list
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
2. Create source and destination configs
Plugin configurationOverview #
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