HubSpot Connector

Ingest HubSpot CRM data into Snowflake with automated incremental sync. Sync contacts, companies, deals, tickets, marketing emails, and custom objects -- no code required.

SourceSilver

Start Free View Documentation

Why Supaflow

All connectors included

No per-connector fees. Every connector is available on every plan.

Pay for compute, not rows

Credit-based pricing. No per-row charges, no MAR surprises.

One platform

Ingestion, dbt Core transformation, reverse ETL, and orchestration in a single workspace.

Capabilities

OAuth Authentication

Connect via OAuth 2.0 browser-based flow. Select your HubSpot account during authorization. Requires Admin access to the HubSpot account.

CRM Object Extraction

Extracts standard CRM objects including contacts, companies, deals, tickets, and line items, plus any custom objects published in your HubSpot portal.

Automatic Schema Discovery

Discovers all available objects and their properties from your HubSpot account. Custom objects and custom properties are included automatically.

Incremental Sync

Tracks cursor positions per object so subsequent runs fetch only new and updated records. Reduces API consumption and sync duration.

Supported Objects

CRM Objects

Contacts

Individual people in your CRM with email, name, and custom properties.

Companies

Organizations associated with contacts and deals.

Deals

Sales opportunities tracked through pipeline stages.

Tickets

Customer support requests and service issues.

Line Items

Products or services associated with deals.

Marketing

Marketing Emails

Email campaigns and their performance data.

Forms

Form submissions and lead capture data.

Lists

Static and dynamic contact lists.

Custom Objects

Any custom object

All published custom objects in your HubSpot portal are discovered automatically.

How It Works

Authorize with HubSpot

Click Authorize to open the HubSpot OAuth flow. Log in with an Admin account and select the HubSpot account you want to sync.

Select account and connect

In the Choose an Account list, select the account you want to sync and click Connect. You will be redirected back to Supaflow.

Test and save

Click Test & Save to verify your connection. Supaflow discovers available objects and properties. Select the objects you want to replicate.

Use Cases

Marketing and sales analytics

Replicate contacts, companies, deals, and marketing emails into your warehouse to build cross-functional dashboards combining marketing attribution with sales pipeline data.

Customer lifecycle reporting

Combine ticket data with deal stages and contact history to track the full customer lifecycle from lead to support.

Custom object warehousing

Sync HubSpot custom objects into your warehouse for reporting that is not possible within HubSpot native reporting.

Frequently Asked Questions

What HubSpot permissions are required?

The connecting user must have Admin access to the HubSpot account. OAuth scopes are requested automatically during authorization.

Does Supaflow count against my HubSpot API limits?

Yes. Each sync consumes HubSpot API calls. You can check your API usage under HubSpot Settings > Account > Usage & Limits. Schedule syncs during off-peak hours if you are near your limit.

Why are some objects not appearing?

Verify that the connecting user has access to the objects, that custom objects are published, and that OAuth scopes include the necessary permissions. If scopes were added after the initial connection, reconnect to pick up the new scopes.

How often can I sync HubSpot data to Snowflake?

You can schedule syncs as frequently as every 15 minutes. Incremental sync fetches only records modified since the last run, so frequent syncs are efficient and stay within HubSpot API limits.

Does Supaflow support HubSpot custom objects?

Yes. All published custom objects in your HubSpot portal are discovered automatically during schema discovery. Custom properties on standard and custom objects are included.

Can I run the HubSpot pipeline natively inside Snowflake?

Yes. Supaflow runs as a Snowflake Native App using Snowpark Container Services. Your HubSpot data is extracted and loaded without leaving your Snowflake account. See our Snowflake Native ETL guide for details.

How does this compare to HubSpot native Snowflake Data Share?

HubSpot Data Share provides a read-only Snowflake share of standard CRM objects. Supaflow gives you full control: choose which objects and fields to sync, schedule incremental updates, load into your own database and schema, and include custom objects and marketing data that Data Share does not cover.

Related Resources

HubSpot Source DocumentationView docs Run natively inside SnowflakeRead post Getting Started GuideView docs

Need a connector we don't support yet?

Build one with AI-powered Connector Dev Skills.

Learn More About the Connector SDK

Load into any of these destinations

Salesforce

Snowflake

PostgreSQL

S3 Data Lake

Salesforce Marketing Cloud