Shopify to BigQuery

Each of these CDPs lists a connector that reads from Shopify 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 Shopify

  Shopify → Amperity

  Source. Pulls Shopify customers, orders, products and locations into Amperity through the GraphQL Admin API.

  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 ↗
• BLBloomreach

  Reads from Shopify

  Bloomreach ⇄ Shopify

  Syncs Shopify customers, consent, orders, products and storefront behavior into Bloomreach through Data hub with Loomi for Shopify, which also powers on-site search and recommendations.

  Docs ↗

  Sends to BigQuery

  Bloomreach → BigQuery

  Loomi BigQuery. Exports Bloomreach events every 6 hours and customer properties daily into a read-only Google BigQuery dataset through Loomi BigQuery, for custom SQL analysis and BI tools.

  Docs ↗
• BLBlueConic

  Reads from Shopify

  Shopify → BlueConic

  Imports Shopify customer data and order events into BlueConic profiles, timelines and a product store in batches, with a separate connection for each Shopify store.

  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 ↗
• BLBlueshift

  Reads from Shopify

  Blueshift ⇄ Shopify

  Syncs Shopify customers, orders, products and storefront events into Blueshift through the Blueshift Shopify app for US accounts, and can mark marketing unsubscribes on Shopify profiles.

  Docs ↗

  Sends to BigQuery

  Blueshift → BigQuery

  Export. Delivers Blueshift campaign activity to your BigQuery project as a linked dataset from an Analytics Hub listing, updated once a day, a feature your CSM may need to switch on.

  Docs ↗
• CHChord

  Reads from Shopify

  Shopify → Chord

  Store data. Connects a Shopify store as a Chord data source through a custom Chord Data Ingestor app with read access to orders, customers, products, inventory and fulfillments.

  Docs ↗

  Shopify → Chord

  Web pixel. Tracks Shopify storefront and checkout events in Chord with the @chordcommerce/analytics library and a custom web pixel added under Shopify's customer events settings.

  Docs ↗

  Shopify → Chord

  Webhooks. Turns Shopify webhooks for checkouts, orders, refunds and deletions into Chord server events through a Shopify webhook source that reads order details with an Admin API token.

  Docs ↗

  Sends to BigQuery

  Chord → BigQuery

  Writes data from Chord's CDP to a BigQuery dataset in a Google Cloud project, authenticated with a service account key given as JSON, a JSON string or a file path.

  Docs ↗
• CLCleverTap

  Reads from Shopify

  Shopify → CleverTap

  Brings Shopify customers, consents, orders, checkouts and fulfillments into CleverTap through the CleverTap app's webhooks and Web SDK app embed, with catalog sync and CSV backfills.

  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 Shopify

  Insider One ⇄ Shopify

  MindBehind chatbots. Connects a Shopify store to Insider One's MindBehind conversational platform with an Admin API token from a custom app, and can show the chatbot on the storefront through theme.liquid.

  Docs ↗

  Insider One ⇄ Shopify

  Store app. Installs the Insider One app in a Shopify store to add the Insider Tag and Object, sync customers and email or SMS consent both ways, and import orders, checkout events, products and metafields.

  Docs ↗

  Shopify → Insider One

  Custom pixel. Tracks completed Shopify purchases in Insider One with a custom web pixel added under Customer Events, since Shopify blocks the regular Insider tag on checkout pages.

  Docs ↗

  Shopify → Insider One

  Flow order events. Forwards extra Shopify order details, such as order metafields and status, to Insider One as custom events with a Shopify Flow workflow that sends an HTTP request.

  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 Shopify

  Klaviyo ⇄ Shopify

  Syncs Shopify customers, orders, deliveries and onsite activity into Klaviyo in real time over a two-way connection, for Shopify flow templates, product feeds and unique coupons.

  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 Shopify

  Shopify → Lytics

  Loads Shopify customers, orders and products into Lytics through the Shopify APIs for segmentation, affinities and product recommendations.

  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 ↗
• MPmParticle

  Reads from Shopify

  Shopify → mParticle

  Custom pixel. Logs Shopify storefront and checkout events to mParticle with a Shopify Custom Pixel, without editing your theme code.

  Docs ↗

  Shopify → mParticle

  Feed. Brings Shopify store events, such as orders, into mParticle through Shopify webhooks.

  Docs ↗

  Sends to BigQuery

  mParticle → BigQuery

  Audiences. Writes mParticle audience membership to tables in a BigQuery dataset in your Google Cloud project.

  Docs ↗

  mParticle → BigQuery

  Warehouse. Loads incoming mParticle data into a BigQuery dataset so you can query it directly with SQL.

  Docs ↗
• RURudderStack

  Reads from Shopify

  Shopify → RudderStack

  Captures Shopify storefront and order events in RudderStack for ecommerce analytics and activation in other tools.

  Docs ↗

  Sends to BigQuery

  RudderStack → BigQuery

  Stream. Inserts RudderStack track events into a BigQuery table in near real time through Google's streaming API, rather than in batches.

  Docs ↗

  RudderStack → BigQuery

  Warehouse. Loads RudderStack events into BigQuery in scheduled batches, using RudderStack's standard warehouse schema.

  Docs ↗
• SDSalesforce Data 360

  Reads from Shopify

  Shopify → Salesforce

  Brings Shopify customers, orders, products, collections and abandoned checkouts 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 Shopify

  Shopify → Segment

  Shopify - Powered by Fueled. Sends Shopify - Powered by Fueled events into Segment as they happen, ready to route to other tools.

  Docs ↗

  Shopify → Segment

  By Littledata. Littledata's Shopify app adds Segment to a Shopify store and sends storefront and order events to Segment.

  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 Shopify

  Shopify → Tealium

  Installs Tealium iQ on Shopify stores with Tealium's Shopify app, tracking storefront and checkout events through pixels and collecting Shopify webhooks for orders, refunds and consent changes.

  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 Shopify

  Shopify → Treasure AI

  Import v1. Imports Shopify orders, customers, products, transactions, inventory and metafields into Treasure Data with the original Shopify connector, incrementally by created or updated time.

  Docs ↗

  Shopify → Treasure AI

  Import v2. Imports Shopify products, product variants and their metafields into Treasure Data through Shopify's GraphQL Admin API, replacing REST endpoints Shopify has deprecated.

  Docs ↗

  Shopify → Treasure AI

  Webhook streaming import. Receives Shopify webhook events, such as new checkouts, cart changes and customer updates, from a store into Treasure Data in real time through a streaming connector.

  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 ↗

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

• 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 Shopify

  Amperity → Shopify

  Destination. Tags Shopify customers who match an Amperity audience by email, removing the tag when they leave, so Shopify segments can use it.

  Docs ↗
• BLBloomreach

  Reads from BigQuery

  BigQuery → Bloomreach

  Import. Imports customers, events, catalogs and vouchers from Google BigQuery tables or SQL queries into Bloomreach with service-account credentials, and runs SQL Reports on BigQuery data in place.

  Docs ↗

  Sends to Shopify

  Bloomreach ⇄ Shopify

  Syncs Shopify customers, consent, orders, products and storefront behavior into Bloomreach through Data hub with Loomi for Shopify, which also powers on-site search and recommendations.

  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 Shopify

  Blueshift ⇄ Shopify

  Syncs Shopify customers, orders, products and storefront events into Blueshift through the Blueshift Shopify app for US accounts, and can mark marketing unsubscribes on Shopify profiles.

  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 Shopify

  Fivetran Activations → Shopify

  Syncs Shopify customers, orders, products, inventory and fulfillments from Fivetran Activations through an OAuth user, with setup currently arranged through Fivetran support.

  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 Shopify

  Hightouch → Shopify

  Syncs customers, products and discounts from your warehouse to Shopify.

  Docs ↗
• IOInsider One

  Reads from BigQuery

  BigQuery → Insider One

  Import. Imports user attributes and events from BigQuery tables or views into Insider One on a recurring schedule, mapping columns and using an update timestamp column for incremental syncs.

  Docs ↗

  Sends to Shopify

  Insider One ⇄ Shopify

  MindBehind chatbots. Connects a Shopify store to Insider One's MindBehind conversational platform with an Admin API token from a custom app, and can show the chatbot on the storefront through theme.liquid.

  Docs ↗

  Insider One ⇄ Shopify

  Store app. Installs the Insider One app in a Shopify store to add the Insider Tag and Object, sync customers and email or SMS consent both ways, and import orders, checkout events, products and metafields.

  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 Shopify

  Klaviyo ⇄ Shopify

  Syncs Shopify customers, orders, deliveries and onsite activity into Klaviyo in real time over a two-way connection, for Shopify flow templates, product feeds and unique coupons.

  Docs ↗
• SESAP Engagement Cloud

  Reads from BigQuery

  BigQuery → SAP Engagement Cloud

  Connects Google BigQuery tables and views to SAP Emarsys through a Relational Data connector, letting SQL segment templates and email tokens use the data in place.

  Docs ↗

  Sends to Shopify

  SAP Engagement Cloud ⇄ Shopify

  Syncs Shopify customers, events, products and orders into SAP Emarsys through its Shopify app, tracks site behavior with a web pixel and keeps SMS opt-in consent aligned both ways.

  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 Shopify

  Treasure AI → Shopify

  Metafield export v1. Exports metafield data from Treasure Data query results to Shopify resources with a store's Admin API credentials, matching the columns each resource requires.

  Docs ↗

  Treasure AI → Shopify

  Metafield export v2. Creates and updates metafields on Shopify resources such as products and media images from Treasure Data in batches through Shopify's GraphQL Admin API.

  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 Shopify

  Zeta Global ⇄ Shopify

  Streams Shopify customers, products and order events into Zeta with a read-only access token and Zeta's custom pixel, and creates Shopify customers from campaigns through Channel Manager.

  Docs ↗