Skip to content
Book a demoStart free
Connectors

Shippo connector

Set up the Shippo connector in Kaivo: authentication, configuration, the 6 BigQuery tables it syncs, and answers to common questions.

Shippo connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Shippo data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your e-commerce data instead of moving it.

Sync your Shippo shipping data into BigQuery with Kaivo to analyse shipments, carriers, and shipping cost.

CategoryE-commerce
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Shippo account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Shippo Token.

Field Description
Shippo Token
Your Shippo API (Live) token, generated in the Shippo dashboard under Settings → API.

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

Kaivo syncs 6 tables from Shippo into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

accounts (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING
first_name STRING
last_name STRING
object_created STRING
object_id STRING
object_updated STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
addresses (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address__address_line_1 STRING
address__address_line_2 STRING
address__address_type STRING
address__city_locality STRING
address__country_code STRING
address__email STRING
address__name STRING
address__organization STRING
address__phone STRING
address__postal_code STRING
address__state_province STRING
created_at STRING
id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
carrier_acounts (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata STRING
account_id STRING
active BOOL
carrier STRING
carrier_images___75 STRING
carrier_images___200 STRING
carrier_name STRING
is_shippo_account BOOL
object_id STRING
object_info__authentication__type STRING
object_owner STRING
parameters__expresslink_password STRING
parameters__is_commercial STRING
test BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_items (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
metadata STRING
eccn_ear99 STRING
hs_code STRING
mass_unit STRING
net_weight STRING
object_created STRING
object_id STRING
object_owner STRING
object_state STRING
object_updated STRING
origin_country STRING
quantity FLOAT64
sku_code STRING
tariff_number STRING
test BOOL
value_amount STRING
value_currency STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
parcels (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata STRING
distance_unit STRING
extra__cod__amount STRING
extra__cod__currency STRING
extra__cod__payment_method STRING
extra__insurance__amount STRING
extra__insurance__content STRING
extra__insurance__currency STRING
extra__insurance__provider STRING
extra__reference_1 STRING
extra__reference_2 STRING
height STRING
length STRING
mass_unit STRING
object_created STRING
object_id STRING
object_owner STRING
object_state STRING
object_updated STRING
test BOOL
weight STRING
width STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shipments (176 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata STRING
address_from__city STRING
address_from__company STRING
address_from__country STRING
address_from__email STRING
address_from__is_complete BOOL
address_from__is_residential BOOL
address_from__name STRING
address_from__object_id STRING
address_from__phone STRING
address_from__state STRING
address_from__street1 STRING
address_from__street2 STRING
address_from__street3 STRING
address_from__street_no STRING
address_from__test BOOL
address_from__validation_results__is_valid BOOL
address_from__zip STRING
address_return__city STRING
address_return__company STRING
address_return__country STRING
address_return__email STRING
address_return__is_complete BOOL
address_return__is_residential BOOL
address_return__name STRING
address_return__object_id STRING
address_return__phone STRING
address_return__state STRING
address_return__street1 STRING
address_return__street2 STRING
address_return__street3 STRING
address_return__street_no STRING
address_return__test BOOL
address_return__validation_results__is_valid BOOL
address_return__zip STRING
address_to__city STRING
address_to__company STRING
address_to__country STRING
address_to__email STRING
address_to__is_complete BOOL
address_to__name STRING
address_to__object_id STRING
address_to__phone STRING
address_to__state STRING
address_to__street1 STRING
address_to__street2 STRING
address_to__street3 STRING
address_to__street_no STRING
address_to__test BOOL
address_to__validation_results__is_valid BOOL
address_to__zip STRING
customs_declaration__metadata STRING
customs_declaration__address_importer STRING
customs_declaration__aes_itn STRING
customs_declaration__b13a_filing_option STRING
customs_declaration__b13a_number STRING
customs_declaration__certificate STRING
customs_declaration__certify BOOL
customs_declaration__certify_signer STRING
customs_declaration__commercial_invoice BOOL
customs_declaration__contents_explanation STRING
customs_declaration__contents_type STRING
customs_declaration__disclaimer STRING
customs_declaration__duties_payor__type STRING
customs_declaration__duties_payor__account STRING
customs_declaration__duties_payor__address__country STRING
customs_declaration__duties_payor__address__name STRING
customs_declaration__duties_payor__address__zip STRING
customs_declaration__duties_payor__object_created STRING
customs_declaration__duties_payor__object_updated STRING
customs_declaration__eel_pfc STRING
customs_declaration__exporter_identification__eori_number STRING
customs_declaration__exporter_identification__tax_id__type STRING
customs_declaration__exporter_identification__tax_id__number STRING
customs_declaration__exporter_reference STRING
customs_declaration__importer_reference STRING
customs_declaration__incoterm STRING
customs_declaration__invoice STRING
customs_declaration__is_vat_collected BOOL
customs_declaration__license STRING
customs_declaration__non_delivery_option STRING
customs_declaration__notes STRING
customs_declaration__object_created STRING
customs_declaration__object_id STRING
customs_declaration__object_owner STRING
customs_declaration__object_state STRING
customs_declaration__object_updated STRING
customs_declaration__test BOOL
extra__cod__amount STRING
extra__cod__currency STRING
extra__cod__payment_method STRING
extra__accounts_receivable_customer_account__prefix STRING
extra__accounts_receivable_customer_account__ref_sort FLOAT64
extra__accounts_receivable_customer_account__value STRING
extra__billing__type STRING
extra__billing__account STRING
extra__billing__country STRING
extra__billing__participation_code STRING
extra__billing__zip STRING
extra__bypass_address_validation BOOL
extra__carbon_neutral BOOL
extra__carrier_hub_id STRING
extra__carrier_hub_travel_time FLOAT64
extra__cod_number__prefix STRING
extra__cod_number__ref_sort FLOAT64
extra__cod_number__value STRING
extra__delivery_instructions STRING
extra__dept_number__prefix STRING
extra__dept_number__ref_sort FLOAT64
extra__dept_number__value STRING
extra__dry_ice__contains_dry_ice BOOL
extra__dry_ice__weight STRING
extra__fda_product_code__prefix STRING
extra__fda_product_code__ref_sort FLOAT64
extra__fda_product_code__value STRING
extra__fulfillment_center STRING
extra__insurance__amount STRING
extra__insurance__content STRING
extra__insurance__currency STRING
extra__insurance__provider STRING
extra__invoice_number__prefix STRING
extra__invoice_number__ref_sort FLOAT64
extra__invoice_number__value STRING
extra__is_return BOOL
extra__lasership_declared_value STRING
extra__manifest_number__prefix STRING
extra__manifest_number__ref_sort FLOAT64
extra__manifest_number__value STRING
extra__model_number__prefix STRING
extra__model_number__ref_sort FLOAT64
extra__model_number__value STRING
extra__part_number__prefix STRING
extra__part_number__ref_sort FLOAT64
extra__part_number__value STRING
extra__po_number__prefix STRING
extra__po_number__ref_sort FLOAT64
extra__po_number__value STRING
extra__preferred_delivery_timeframe STRING
extra__premium BOOL
extra__production_code__prefix STRING
extra__production_code__ref_sort FLOAT64
extra__production_code__value STRING
extra__purchase_request_number__prefix STRING
extra__purchase_request_number__ref_sort FLOAT64
extra__purchase_request_number__value STRING
extra__qr_code_requested BOOL
extra__reference_1 STRING
extra__reference_2 STRING
extra__request_retail_rates BOOL
extra__return_service_type STRING
extra__rma_number__prefix STRING
extra__rma_number__ref_sort FLOAT64
extra__rma_number__value STRING
extra__salesperson_number__prefix STRING
extra__salesperson_number__ref_sort FLOAT64
extra__salesperson_number__value STRING
extra__saturday_delivery BOOL
extra__serial_number__prefix STRING
extra__serial_number__ref_sort FLOAT64
extra__serial_number__value STRING
extra__signature_confirmation STRING
extra__store_number__prefix STRING
extra__store_number__ref_sort FLOAT64
extra__store_number__value STRING
extra__transaction_reference_number__prefix STRING
extra__transaction_reference_number__ref_sort FLOAT64
extra__transaction_reference_number__value STRING
object_created STRING
object_id STRING
object_owner STRING
object_updated STRING
shipment_date STRING
status STRING
test BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__address_from__validation_results__messages

Section titled “Subtable: shipments__address_from__validation_results__messages”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__address_return__validation_results__messages

Section titled “Subtable: shipments__address_return__validation_results__messages”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__address_to__validation_results__messages

Section titled “Subtable: shipments__address_to__validation_results__messages”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
code STRING
source STRING
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__customs_declaration__items

Section titled “Subtable: shipments__customs_declaration__items”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__extra__lasership_attrs

Section titled “Subtable: shipments__extra__lasership_attrs”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
code STRING
source STRING
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata STRING
distance_unit STRING
extra__cod__amount STRING
extra__cod__currency STRING
extra__cod__payment_method STRING
height STRING
length STRING
mass_unit STRING
object_created STRING
object_id STRING
object_owner STRING
object_state STRING
object_updated STRING
test BOOL
weight STRING
width STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Shippo supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Shippo?

Section titled “How long does the initial sync take for Shippo?”

It depends on how much history is in your Shippo account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Shippo’s schema changes?

Section titled “What happens when Shippo’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Shippo, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Shippo instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Shippo connector in Kaivo and all of its synced data is deleted with it.

Use shipments and parcels to track shipping spend and compare carrier rates over time.

Join carrier_acounts with shipments to compare delivery options.

Use addresses to analyse where shipments go.

Once Shippo data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Shippo data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Shippo connector pricing and plan details.