HubSpot to BigQuery

Each of these CDPs lists a connector that reads from HubSpot and one that sends data to BigQuery. A route is a possible path, not a tested one: what travels depends on each connector, so check the documentation links.

• AMAmperity

  Reads from HubSpot

  HubSpot → Amperity

  Source. Pulls contact lists, profiles, email preferences and campaign activity from HubSpot into Amperity, with Fivetran as the connector.

  Docs ↗

  Sends to BigQuery

  Amperity → BigQuery

  Google BigQuery (destination). Gets Amperity data into Google BigQuery by sending Parquet or CSV files to cloud storage first, then loading them for analysis.

  Docs ↗

  Amperity ⇄ BigQuery

  Google BigQuery (Amperity Bridge). Shares data both ways between Amperity and Google BigQuery through Amperity Bridge, using BigQuery sharing exchanges rather than file exports.

  Docs ↗
• BLBlueConic

  Reads from HubSpot

  BlueConic ⇄ HubSpot

  Imports and exports BlueConic profiles and groups with HubSpot contacts, companies, deals and custom objects in batches, plus real-time profile syncs set off by property changes.

  Docs ↗

  Sends to BigQuery

  BlueConic ⇄ BigQuery

  Imports BigQuery tables into BlueConic profiles and timeline events and exports profile and timeline data to BigQuery tables, replacing or partitioning a table on each batch run.

  Docs ↗
• CLCleverTap

  Reads from HubSpot

  HubSpot → CleverTap

  Creates or updates CleverTap profiles and uploads events from HubSpot contacts and contact activity using Zapier, to start personalized CleverTap campaigns.

  Docs ↗

  Sends to BigQuery

  CleverTap → BigQuery

  Export. Exports CleverTap data to Google BigQuery through Google Cloud Storage on a schedule, for analysis and reporting alongside other business data.

  Docs ↗
• IOInsider One

  Reads from HubSpot

  HubSpot → Insider One

  Pulls HubSpot contacts into Insider One on a cron schedule over OAuth and the CRM v3 REST API, syncing all contacts incrementally or one chosen contact as profiles and events.

  Docs ↗

  Sends to BigQuery

  Insider One → BigQuery

  Export. Gets Insider One events, their parameters and chosen user attributes into BigQuery by exporting CSV files to your Google Cloud Storage bucket for your own pipeline to load.

  Docs ↗
• KLKlaviyo

  Reads from HubSpot

  Klaviyo ⇄ HubSpot

  Syncs HubSpot contacts, lifecycle stages, owners and deals into Klaviyo through KAV Labs, and logs Klaviyo opens, clicks and unsubscribes on the HubSpot timeline.

  Docs ↗

  Sends to BigQuery

  Klaviyo → BigQuery

  Sends Klaviyo profile data, event data or both into BigQuery, and can skip events coming from integrations that BigQuery already receives.

  Docs ↗
• LYLytics

  Reads from HubSpot

  Lytics ⇄ HubSpot

  Keeps HubSpot contact lists and properties up to date with Lytics audiences in real time and imports HubSpot contacts and email events into Lytics.

  Docs ↗

  Sends to BigQuery

  Lytics ⇄ BigQuery

  Imports BigQuery tables into Lytics and exports user profiles, events, audience changes and definitions, metrics and system events from Lytics to BigQuery tables.

  Docs ↗
• SDSalesforce Data 360

  Reads from HubSpot

  HubSpot → Salesforce

  Brings HubSpot contacts, companies, deals, tickets, lists and forms into Data 360 in batches or through Zero Copy query federation (beta).

  Docs ↗

  Sends to BigQuery

  Salesforce ⇄ BigQuery

  Google BigQuery. Connects Data 360 and Google BigQuery through Zero Copy, querying BigQuery tables in place and sharing Data 360 data back to BigQuery.

  Docs ↗
• SESegment

  Reads from HubSpot

  HubSpot → Segment

  Source. Pulls HubSpot objects into Segment on a schedule for syncing to a warehouse.

  Docs ↗

  Sends to BigQuery

  Segment → BigQuery

  Loads Segment event data into BigQuery on a schedule as a storage destination, ready for SQL analysis.

  Docs ↗
• TETealium

  Reads from HubSpot

  HubSpot → Tealium

  Workflow webhook data source. Posts HubSpot contact records to Tealium from a Trigger a webhook action in HubSpot workflows, available on Marketing or Sales Professional and Enterprise plans.

  Docs ↗

  Sends to BigQuery

  Tealium → BigQuery

  Google BigQuery. Appends records (singly or batched), sends full event, visitor and log data and runs custom statements in Google BigQuery from AudienceStream or EventStream.

  Docs ↗
• TATreasure AI

  Reads from HubSpot

  HubSpot → Treasure AI

  Import. Imports HubSpot contacts, companies, contact lists, email events, engagements, deals and other objects into Treasure Data over OAuth, now reading lists from HubSpot's v3 API.

  Docs ↗

  Sends to BigQuery

  Treasure AI → BigQuery

  Export v1. Writes Treasure Data job results into a BigQuery table that matches a predefined schema, in append, replace, replace backup or delete mode, with server-to-server API authentication.

  Docs ↗

  Treasure AI → BigQuery

  Export v2. Uploads large Treasure Data result sets to BigQuery as Parquet files through BigQuery load jobs, with append, replace, replace backup or truncate modes and JSON key or WIF sign-in.

  Docs ↗

  Treasure AI → BigQuery

  Open Catalog Access. Exposes Treasure Data's Iceberg tables to BigQuery as a federated dataset through BigQuery Omni, an experimental Open Catalog Access option that is not enabled by default.

  Docs ↗
• ZEZeotap

  Reads from HubSpot

  HubSpot → Zeotap

  Source. Imports HubSpot contacts or companies into Zeotap with a private app token, reading only the chosen fields and refreshing on a schedule with full or changes-only fetches.

  Docs ↗

  Sends to BigQuery

  Zeotap → BigQuery

  Analytics Hub. Shares Zeotap's unified profile store, with profile, consent, ID and campaign data, with your service accounts through a private BigQuery Analytics Hub listing you subscribe to.

  Docs ↗

  Zeotap → BigQuery

  Destination. Sends Zeotap segments with any identifiers and attributes into a BigQuery project, dataset and table, with a Google Cloud Storage bucket and folder also set up for the transfer.

  Docs ↗

Each of these CDPs lists a connector that reads from BigQuery and one that sends data to HubSpot.

• AEAdobe Experience Platform

  Reads from BigQuery

  BigQuery → Adobe

  Brings Google BigQuery table data into Experience Platform for Real-Time CDP Ultimate customers.

  Docs ↗

  Sends to HubSpot

  Adobe → HubSpot

  Destination. Sends Real-Time CDP audiences to HubSpot through its Contacts API, updating matching contacts and stamping each with a property holding the audience name.

  Docs ↗
• AMAmperity

  Reads from BigQuery

  Amperity ⇄ BigQuery

  Google BigQuery (Amperity Bridge). Shares data both ways between Amperity and Google BigQuery through Amperity Bridge, using BigQuery sharing exchanges rather than file exports.

  Docs ↗

  Sends to HubSpot

  Amperity → HubSpot

  Destination. Manages HubSpot contact lists from Amperity queries keyed on email, updating existing contacts and optionally creating new ones.

  Docs ↗
• BLBlueConic

  Reads from BigQuery

  BlueConic ⇄ BigQuery

  Imports BigQuery tables into BlueConic profiles and timeline events and exports profile and timeline data to BigQuery tables, replacing or partitioning a table on each batch run.

  Docs ↗

  Sends to HubSpot

  BlueConic ⇄ HubSpot

  Imports and exports BlueConic profiles and groups with HubSpot contacts, companies, deals and custom objects in batches, plus real-time profile syncs set off by property changes.

  Docs ↗
• BLBlueshift

  Reads from BigQuery

  BigQuery → Blueshift

  Import. Imports customer data, events, catalogs and recommendation feeds from BigQuery into Blueshift over a direct connection authenticated with a service account key.

  Docs ↗

  Sends to HubSpot

  Blueshift → HubSpot

  Creates HubSpot contacts from Blueshift campaign journeys through cloud app templates that call the HubSpot CRM API, and updates existing ones using a stored HubSpot contact ID.

  Docs ↗
• CACaliberMind

  Reads from BigQuery

  BigQuery → CaliberMind

  Ingests warehouse data loaded into a BigQuery dataset CaliberMind creates, or connects directly to your own BigQuery instance, with possible setup fees to map it into CaliberMind.

  Docs ↗

  Sends to HubSpot

  CaliberMind → HubSpot

  Activations. Syncs CaliberMind company and contact lists into HubSpot over OAuth with insert, update, upsert, delete or mirror strategies, on a manual, 15-minute, hourly, daily, weekly or cron schedule.

  Docs ↗
• DIDinMo

  Reads from BigQuery

  BigQuery → DinMo

  Connects a BigQuery project to DinMo through a Google Cloud service account, with DinMo datasets for segments, statistics and predictions and optional daily alerts on unusual billed usage.

  Docs ↗

  Sends to HubSpot

  DinMo → HubSpot

  Custom objects. Writes DinMo segment records into HubSpot custom CRM objects, updating existing records by ID and, in insert or upsert mode, creating new ones.

  Docs ↗

  DinMo → HubSpot

  Objects. Inserts or updates HubSpot contacts, companies, deals or products from DinMo segments, matched on an object ID or for contacts an external attribute, with new custom properties created.

  Docs ↗
• FAFivetran Activations

  Reads from BigQuery

  BigQuery → Fivetran Activations

  Source. Reads BigQuery tables and views for Fivetran Activations syncs through IAM roles for viewing data and running unload jobs, with an optional read-only mode.

  Docs ↗

  Sends to HubSpot

  Fivetran Activations → HubSpot

  Syncs HubSpot contacts, companies, deals, leads, tickets, custom objects, list memberships and behavioral events from Fivetran Activations over OAuth.

  Docs ↗
• HIHightouch

  Reads from BigQuery

  BigQuery → Hightouch

  Iceberg source. Reads Apache Iceberg tables managed in BigQuery as a Hightouch source.

  Docs ↗

  BigQuery → Hightouch

  Source. Connects BigQuery to Hightouch as a source, so SQL, dbt or table-based models built there can sync to any destination.

  Docs ↗

  Sends to HubSpot

  Hightouch → HubSpot

  CRM. Syncs warehouse data such as product usage and invoices into HubSpot contacts and companies, for upsell targeting and personalized email.

  Docs ↗

  Hightouch → HubSpot

  HubDB. Publishes warehouse data to HubSpot HubDB tables to keep website and landing page content current.

  Docs ↗
• KLKlaviyo

  Reads from BigQuery

  BigQuery → Klaviyo

  Data warehouse import. Syncs profile and event data from a BigQuery dataset into Klaviyo through a dedicated service account, with a Klaviyo Advanced KDP subscription.

  Docs ↗

  Sends to HubSpot

  Klaviyo ⇄ HubSpot

  Syncs HubSpot contacts, lifecycle stages, owners and deals into Klaviyo through KAV Labs, and logs Klaviyo opens, clicks and unsubscribes on the HubSpot timeline.

  Docs ↗
• LYLytics

  Reads from BigQuery

  Lytics ⇄ BigQuery

  Imports BigQuery tables into Lytics and exports user profiles, events, audience changes and definitions, metrics and system events from Lytics to BigQuery tables.

  Docs ↗

  Sends to HubSpot

  Lytics ⇄ HubSpot

  Keeps HubSpot contact lists and properties up to date with Lytics audiences in real time and imports HubSpot contacts and email events into Lytics.

  Docs ↗
• ODOdie

  Reads from BigQuery

  BigQuery → Odie

  Runs read-only SQL queries against BigQuery from Totango's Customer Data Hub, authenticating with an uploaded key for a service account given Viewer and BigQuery Data Viewer roles.

  Docs ↗

  Sends to HubSpot

  Odie ⇄ HubSpot

  Imports HubSpot companies, contacts, deals, tasks, notes and calls into Totango over OAuth, and sends Totango tasks and touchpoints back to HubSpot as engagements.

  Docs ↗
• RGRedpoint Global

  Reads from BigQuery

  Redpoint Global ⇄ BigQuery

  Data Management. Bulk loads Google BigQuery tables from Redpoint Data Management with application default credentials or a service account, mapping its data types to BigQuery types.

  Docs ↗

  Redpoint Global ⇄ BigQuery

  Interaction. Sets up the Simba ODBC driver for Google BigQuery in the Redpoint Interaction Docker image, so RPI can reach BigQuery through a configured data source.

  Docs ↗

  Sends to HubSpot

  Redpoint Global → HubSpot

  Creates and updates HubSpot CRM contact records by having Redpoint Data Management upload a mapped contact list file through a HubSpot private app token.

  Docs ↗
• RURudderStack

  Reads from BigQuery

  BigQuery → RudderStack

  Source. Syncs BigQuery tables or SQL models to downstream tools with RudderStack Reverse ETL, on a schedule or on demand.

  Docs ↗

  Sends to HubSpot

  RudderStack → HubSpot

  Creates and updates HubSpot contacts and custom behavioral events from RudderStack users and events, in cloud mode or on the web in device mode.

  Docs ↗
• SESegment

  Reads from BigQuery

  BigQuery → Segment

  Data Graph. Gives Segment's Data Graph a BigQuery service account that reads entity tables for Linked Audiences and Linked Events and keeps checkpoints in its own dataset (in active development).

  Docs ↗

  BigQuery → Segment

  Reverse ETL source. Reads BigQuery tables through a service account so Segment Reverse ETL can sync query results onward, granted either broad predefined roles or a narrower custom role.

  Docs ↗

  Sends to HubSpot

  Segment → HubSpot

  Classic. Sends identify, track, page and group calls from Segment to HubSpot for analytics and CRM in cloud or device mode.

  Docs ↗

  Segment → HubSpot

  HubSpot Cloud Mode (Actions). Sends Segment data to HubSpot for CRM and analytics through Actions such as Send Custom Behavioral Event and Upsert Custom Object Record.

  Docs ↗

  Segment → HubSpot

  HubSpot Web (Actions). Sends Segment data to HubSpot for CRM and analytics through Actions such as Upsert Contact, Track Custom Behavioral Event and Track Page View.

  Docs ↗
• SDSimon Data

  Reads from BigQuery

  BigQuery → Simon Data

  Extracts data from Google BigQuery into Simon Data using a project name and service account JSON credentials that hold the Data Viewer, User and Job User roles.

  Docs ↗

  Sends to HubSpot

  Simon Data → HubSpot

  Connects Simon Data to HubSpot over OAuth to send transactional emails from HubSpot templates, enroll contacts in HubSpot workflows and keep HubSpot lists matched to Simon segments.

  Docs ↗
• TETealium

  Reads from BigQuery

  BigQuery → Tealium

  Google BigQuery (cloud data source). Imports a Google BigQuery table or view into Tealium attributes through a service account holding the Data Viewer and Job User roles, with STRUCT columns flattened through a view.

  Docs ↗

  Sends to HubSpot

  Tealium → HubSpot

  Client-side tag. Adds HubSpot's tracking code through Tealium iQ to record page views and tie visitors to HubSpot contacts for marketing and sales.

  Docs ↗

  Tealium → HubSpot

  Server-side connector. Creates and updates HubSpot contacts, in real time or batched, and adds them to or removes them from lists, from AudienceStream.

  Docs ↗
• TATreasure AI

  Reads from BigQuery

  BigQuery → Treasure AI

  Composable Audience Studio. Sets up Composable Audience Studio on BigQuery with a GCP service account key and a zero-copy catalog, so Treasure Data segments are built on BigQuery data without copying it.

  Docs ↗

  BigQuery → Treasure AI

  Import v1. Imports BigQuery tables or query results into Treasure Data with the original BigQuery connector, whose connections can also serve exports unless they use OAuth.

  Docs ↗

  BigQuery → Treasure AI

  Import v2. Imports BigQuery tables or query results into Treasure Data with version 2 of the connector, which signs in with a service account JSON key or Workload Identity Federation, not OAuth.

  Docs ↗

  BigQuery → Treasure AI

  Live Connect zero-copy. Queries BigQuery tables in place from Treasure Data's Trino engine as Live Connect zero-copy federated queries, with no ETL, after the feature is enabled for the account.

  Docs ↗

  Sends to HubSpot

  Treasure AI → HubSpot

  Export. Exports Treasure Data job results to HubSpot to create or update contacts and companies, update their properties in batches, or add contacts to lists.

  Docs ↗
• ZEZeotap

  Reads from BigQuery

  BigQuery → Zeotap

  Source. Connects Zeotap directly to data held in Google BigQuery and syncs it in as a source for building customer segments, personalized content and ad targeting.

  Docs ↗

  Sends to HubSpot

  Zeotap → HubSpot

  Destination. Creates HubSpot contacts from Zeotap profiles and adds their email addresses to HubSpot contact lists that mirror Zeotap audiences, after you connect your HubSpot account.

  Docs ↗
• ZGZeta Global

  Reads from BigQuery

  BigQuery → Zeta Global

  Connects Google BigQuery to Zeta with a service account key so marketers can segment on tables in place with Zero Copy Database Explorer or ingest data through Data Flows.

  Docs ↗

  Sends to HubSpot

  Zeta Global → HubSpot

  Syndicates Zeta customers into HubSpot through a Channel Manager channel following HubSpot's CRM contacts objects API, authenticated with OAuth tokens, when an Experience decides.

  Docs ↗