Skip to content
Book a demoStart free
Connectors

Gorgias connector

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

Gorgias connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Gorgias 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 customer support data instead of moving it.

Sync your Gorgias tickets, messages, and customers into BigQuery with Kaivo to analyse support performance alongside the rest of your data.

CategoryCustomer Service
AuthenticationUsername and password
SetupSelf-service

Getting started with the Gorgias connector

Section titled “Getting started with the Gorgias connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Gorgias 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.

Connect with your Gorgias login. You provide:

Field Description
Password

When you set up the connector, you provide:

Field Description
Username
Domain name
Domain name given for Gorgias, found as your URL prefix for accessing your website

| | Start date |

Any data before this date will not be fetched.

|

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

account (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_datetime TIMESTAMP
current_subscription__plan STRING
current_subscription__start_datetime TIMESTAMP
current_subscription__status STRING
domain STRING
meta__analytics_group_id STRING
meta__company_domain STRING
meta__company_id STRING
meta__has_credit_card BOOL
status__status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • account__settings (40 columns)
  • account__settings__data__allowed_domains (4 columns)
  • account__settings__data__assignment_channels (4 columns)
  • account__settings__data__business_hours (6 columns)
  • account__settings__data__hidden_views (4 columns)
custom-fields (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_datetime TIMESTAMP
deactivated_datetime TIMESTAMP
definition__data_type STRING
definition__input_settings__input_type STRING
id INT64
label STRING
managed_type STRING
object_type STRING
priority FLOAT64
required BOOL
requirement_type STRING
updated_datetime TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • custom-fields__definition__input_settings__choices (4 columns)
customers (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
created_datetime TIMESTAMP
email STRING
firstname STRING
id INT64
lastname STRING
meta__name_set_via STRING
name STRING
updated_datetime TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
context STRING
created_datetime TIMESTAMP
data__type STRING
data__description STRING
data__account_id FLOAT64
data__assignee_user_id FLOAT64
data__code STRING
data__event_types STRING
data__id FLOAT64
data__name STRING
data__new_subject STRING
data__priority FLOAT64
data__triggering_event_type STRING
id INT64
object_id FLOAT64
object_type STRING
uri STRING
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • events__data__tags_added (4 columns)
integrations (139 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
application_id STRING
created_datetime TIMESTAMP
deactivated_datetime TIMESTAMP
decoration__avatar__company_logo_url STRING
decoration__avatar__image_type STRING
decoration__avatar__name_type STRING
decoration__avatar_team_picture_url STRING
decoration__avatar_type STRING
decoration__background_color_style STRING
decoration__conversation_color STRING
decoration__display_bot_label BOOL
decoration__introduction_text STRING
decoration__launcher__type STRING
decoration__launcher__label STRING
decoration__main_color STRING
decoration__main_font_family STRING
decoration__offline_introduction_text STRING
decoration__position__alignment STRING
decoration__position__offset_x FLOAT64
decoration__position__offset_y FLOAT64
decoration__use_main_color_outside_business_hours BOOL
http__form JSON
http__id FLOAT64
http__method STRING
http__request_content_type STRING
http__response_content_type STRING
http__triggers__ticket_created BOOL
http__triggers__ticket_message_created BOOL
http__triggers__ticket_self_unsnoozed BOOL
http__triggers__ticket_updated BOOL
http__url STRING
id INT64
managed BOOL
meta__about STRING
meta__address STRING
meta__app_id STRING
meta__can_be_onboarded BOOL
meta__category STRING
meta__currency STRING
meta__default_address_phone_matching_enabled BOOL
meta__email_forwarding_activated BOOL
meta__emoji STRING
meta__enable_gmail_sending BOOL
meta__enable_gmail_threading BOOL
meta__enable_outlook_sending BOOL
meta__failures FLOAT64
meta__history_sync__is_synchronized BOOL
meta__history_sync__oldest_syncable STRING
meta__history_sync__posts__is_synchronized BOOL
meta__history_sync__posts__nb_of_tickets_created FLOAT64
meta__history_sync__posts__oldest_time_synced STRING
meta__import_activated BOOL
meta__import_state__customers__is_over BOOL
meta__import_state__customers__oldest_created_at STRING
meta__import_state__enabled BOOL
meta__import_state__is_over BOOL
meta__import_state__products__is_over BOOL
meta__import_state__products__oldest_created_at STRING
meta__instagram__followers_count FLOAT64
meta__instagram__id STRING
meta__instagram__instagram_direct_message_allowed BOOL
meta__instagram__name STRING
meta__instagram__username STRING
meta__installation__visibility__match_conditions STRING
meta__installation__visibility__method STRING
meta__language STRING
meta__name STRING
meta__need_scope_update BOOL
meta__oauth__scope JSON
meta__oauth__status STRING
meta__one_click_installation_datetime TIMESTAMP
meta__one_click_installation_method STRING
meta__one_click_uninstallation_datetime TIMESTAMP
meta__outbound_verification_status__domain STRING
meta__outbound_verification_status__single_sender STRING
meta__outlook_user_id STRING
meta__page_id STRING
meta__phone_number_id FLOAT64
meta__picture__data__height FLOAT64
meta__picture__data__is_silhouette BOOL
meta__picture__data__url STRING
meta__picture__data__width FLOAT64
meta__preferences__auto_responder__enabled BOOL
meta__preferences__auto_responder__reply STRING
meta__preferences__control_ticket_volume BOOL
meta__preferences__display_campaigns_hidden_chat BOOL
meta__preferences__email_capture_enabled BOOL
meta__preferences__email_capture_enforcement STRING
meta__preferences__hide_on_mobile BOOL
meta__preferences__hide_outside_business_hours BOOL
meta__preferences__linked_email_integration FLOAT64
meta__preferences__live_chat_availability STRING
meta__preferences__privacy_policy_disclaimer_enabled BOOL
meta__preferences__send_chat_transcript BOOL
meta__preferred BOOL
meta__provider STRING
meta__roles STRING
meta__settings__import_history_enabled BOOL
meta__settings__instagram_ads_enabled BOOL
meta__settings__instagram_comments_enabled BOOL
meta__settings__instagram_direct_message_enabled BOOL
meta__settings__instagram_mentions_enabled BOOL
meta__settings__mentions_enabled BOOL
meta__settings__messenger_enabled BOOL
meta__settings__posts_enabled BOOL
meta__settings__recommendations_enabled BOOL
meta__shop_display_name STRING
meta__shop_domain STRING
meta__shop_id FLOAT64
meta__shop_integration_id FLOAT64
meta__shop_name STRING
meta__shop_phone STRING
meta__shop_plan STRING
meta__shop_type STRING
meta__signature__html STRING
meta__signature__text STRING
meta__store_name STRING
meta__subscription__expiration_datetime TIMESTAMP
meta__subscription__id STRING
meta__sync__datetime STRING
meta__sync__expiration STRING
meta__sync__history_id STRING
meta__sync_customer_notes BOOL
meta__sync_state__is_initialized BOOL
meta__sync_state__page FLOAT64
meta__use_gmail_categories BOOL
meta__use_new_creds_version BOOL
meta__uses_multi_currency BOOL
meta__verified BOOL
meta__wizard__status STRING
meta__wizard__step STRING
name STRING
updated_datetime TIMESTAMP
uri STRING
user__id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • integrations__meta__installation__visibility__conditions (6 columns)
  • integrations__meta__languages (5 columns)
  • integrations__meta__shopify_integration_ids (4 columns)
  • integrations__meta__webhooks (6 columns)
jobs (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_datetime TIMESTAMP
ended_datetime TIMESTAMP
id INT64
info__iteration_over BOOL
info__progress_count FLOAT64
info__progress_cursor STRING
params__end_datetime TIMESTAMP
params__start_datetime TIMESTAMP
params__updates__assignee_user__id FLOAT64
params__updates__assignee_user__name STRING
params__updates__status STRING
params__updates__trashed_datetime TIMESTAMP
params__view__type STRING
params__view__filters STRING
params__view__filters_ast__type STRING
params__view__filters_ast__loc__end__column FLOAT64
params__view__filters_ast__loc__end__line FLOAT64
params__view__filters_ast__loc__start__column FLOAT64
params__view__filters_ast__loc__start__line FLOAT64
params__view__filters_ast__source_type STRING
params__view__id FLOAT64
params__view__name STRING
params__view__order_by STRING
params__view__order_dir STRING
scheduled_datetime TIMESTAMP
started_datetime TIMESTAMP
status STRING
uri STRING
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • jobs__params__ticket_ids (4 columns)
  • jobs__params__view__filters_ast__body (36 columns)
  • jobs__params__view__filters_ast__body__expression__left__arguments (35 columns)
  • jobs__params__view__filters_ast__body__expression__right__arguments (23 columns)
macros (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_datetime TIMESTAMP
id INT64
intent STRING
language STRING
name STRING
updated_datetime TIMESTAMP
uri STRING
usage FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • macros__actions (24 columns)
  • macros__actions__arguments__headers (4 columns)
  • macros__actions__arguments__params (7 columns)
messages (137 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
body_html STRING
body_text STRING
channel STRING
created_datetime TIMESTAMP
external_id STRING
from_agent BOOL
headers__arc_authentication_results STRING
headers__arc_message_signature STRING
headers__arc_seal STRING
headers__accept_language STRING
headers__authentication_results STRING
headers__content_transfer_encoding STRING
headers__content_type STRING
headers__dkim_signature STRING
headers__date STRING
headers__delivered_to STRING
headers__from STRING
headers__in_reply_to STRING
headers__list_unsubscribe STRING
headers__list_unsubscribe_post STRING
headers__mime_version STRING
headers__message_id STRING
headers__message_id STRING
headers__mime_version STRING
headers__received STRING
headers__received_spf STRING
headers__references STRING
headers__reply_to STRING
headers__return_path STRING
headers__subject STRING
headers__thread_index STRING
headers__thread_topic STRING
headers__to STRING
headers__x_entity_id STRING
headers__x_forwarded_encrypted STRING
headers__x_forwarded_for STRING
headers__x_forwarded_to STRING
headers__x_gorgias_ticket_id STRING
headers__x_gm_features STRING
headers__x_gm_gg STRING
headers__x_gm_message_state STRING
headers__x_google_dkim_signature STRING
headers__x_google_original_from STRING
headers__x_google_smtp_source STRING
headers__x_kmail_account STRING
headers__x_kmail_message STRING
headers__x_kmail_ops STRING
headers__x_ms_exchange_cross_tenant_auth_as STRING
headers__x_ms_exchange_cross_tenant_auth_source STRING
headers__x_ms_exchange_cross_tenant_network_message_id STRING
headers__x_ms_exchange_cross_tenant_fromentityheader STRING
headers__x_ms_exchange_cross_tenant_id STRING
headers__x_ms_exchange_cross_tenant_originalarrivaltime STRING
headers__x_ms_exchange_cross_tenant_rms_persistedconsumerorg STRING
headers__x_ms_exchange_transport_cross_tenant_headers_stamped STRING
headers__x_ms_has_attach STRING
headers__x_ms_tnef_correlator STRING
headers__x_mailer STRING
headers__x_originator_org STRING
headers__x_received STRING
headers__x_report_abuse STRING
headers__x_sg_eid STRING
headers__x_sg_id STRING
headers__x_sonic_dkim_sign STRING
headers__x_sonic_id STRING
headers__x_sonic_mf STRING
headers__x_y_mail_osg STRING
headers__reply_to STRING
headers__x_microsoft_antispam STRING
headers__x_microsoft_antispam_message_info STRING
headers__x_ms_exchange_antispam_messagedata_0 STRING
headers__x_ms_exchange_antispam_messagedata_chunkcount STRING
headers__x_ms_exchange_messagesentrepresentingtype STRING
headers__x_ms_office365_filtering_correlation_id STRING
headers__x_ms_publictraffictype STRING
headers__x_ms_traffictypediagnostic STRING
id INT64
integration_id FLOAT64
is_retriable BOOL
message_id STRING
meta__is_echo BOOL
opened_datetime TIMESTAMP
public BOOL
receiver__email STRING
receiver__firstname STRING
receiver__id FLOAT64
receiver__lastname STRING
receiver__meta__location_info__calling_code STRING
receiver__meta__location_info__city STRING
receiver__meta__location_info__country_code STRING
receiver__meta__location_info__country_name STRING
receiver__meta__location_info__currency__code STRING
receiver__meta__location_info__ip STRING
receiver__meta__location_info__region STRING
receiver__meta__location_info__region_code STRING
receiver__meta__location_info__time_zone__abbr STRING
receiver__meta__location_info__time_zone__name STRING
receiver__meta__location_info__time_zone__offset STRING
receiver__meta__name_set_via STRING
receiver__meta__postscript_sid FLOAT64
receiver__name STRING
sender__email STRING
sender__firstname STRING
sender__id FLOAT64
sender__lastname STRING
sender__meta__location_info__calling_code STRING
sender__meta__location_info__city STRING
sender__meta__location_info__country_code STRING
sender__meta__location_info__country_name STRING
sender__meta__location_info__currency__code STRING
sender__meta__location_info__ip STRING
sender__meta__location_info__region STRING
sender__meta__location_info__region_code STRING
sender__meta__location_info__time_zone__abbr STRING
sender__meta__location_info__time_zone__name STRING
sender__meta__location_info__time_zone__offset STRING
sender__meta__name_set_via STRING
sender__meta__sso STRING
sender__name STRING
sent_datetime TIMESTAMP
source__type STRING
source__extra__aircall_call_id FLOAT64
source__extra__include_thread BOOL
source__extra__page_id STRING
source__extra__parent_id STRING
source__extra__permalink STRING
source__extra__post_id STRING
source__from__address STRING
source__from__name STRING
stripped_html STRING
stripped_text STRING
subject STRING
ticket_id FLOAT64
uri STRING
via STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • messages__actions (15 columns)
  • messages__attachments (8 columns)
  • messages__intents (5 columns)
  • messages__macros (4 columns)
  • messages__receiver__meta__location_info__languages (4 columns)
  • messages__sender__meta__location_info__languages (4 columns)
  • messages__source__bcc (4 columns)
  • messages__source__cc (4 columns)
  • messages__source__to (5 columns)
rules (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
code STRING
code_ast__type STRING
code_ast__loc__end__column FLOAT64
code_ast__loc__end__line FLOAT64
code_ast__loc__start__column FLOAT64
code_ast__loc__start__line FLOAT64
code_ast__source_type STRING
created_datetime TIMESTAMP
deactivated_datetime TIMESTAMP
event_types STRING
id INT64
name STRING
priority FLOAT64
settings__slug STRING
updated_datetime TIMESTAMP
uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • rules__code_ast__body (132 columns)
  • rules__code_ast__body__alternate__body (19 columns)
  • rules__code_ast__body__alternate__body__expression__arguments (10 columns)
  • rules__code_ast__body__alternate__body__expression__arguments__properties (25 columns)
  • rules__code_ast__body__consequent__body (81 columns)
  • rules__code_ast__body__consequent__body__consequent__body (19 columns)
  • rules__code_ast__body__consequent__body__consequent__body__expression__arguments (10 columns)
  • rules__code_ast__body__consequent__body__consequent__body__expression__arguments__properties (25 columns)
  • rules__code_ast__body__consequent__body__expression__arguments (10 columns)
  • rules__code_ast__body__consequent__body__expression__arguments__properties (25 columns)
  • rules__code_ast__body__consequent__body__test__arguments (72 columns)
  • rules__code_ast__body__consequent__body__test__arguments__elements (10 columns)
  • rules__code_ast__body__consequent__body__test__left__arguments (23 columns)
  • rules__code_ast__body__consequent__body__test__left__arguments__elements (10 columns)
  • rules__code_ast__body__consequent__body__test__left__left__arguments (23 columns)
  • rules__code_ast__body__consequent__body__test__left__right__arguments (23 columns)
  • rules__code_ast__body__consequent__body__test__right__arguments (36 columns)
  • rules__code_ast__body__consequent__body__test__right__arguments__elements (10 columns)
  • rules__code_ast__body__test__arguments (73 columns)
  • rules__code_ast__body__test__arguments__elements (10 columns)
  • rules__code_ast__body__test__left__arguments (73 columns)
  • rules__code_ast__body__test__left__arguments__elements (10 columns)
  • rules__code_ast__body__test__left__left__arguments (36 columns)
  • rules__code_ast__body__test__left__left__arguments__elements (10 columns)
  • rules__code_ast__body__test__left__left__left__left__left__arguments (23 columns)
  • rules__code_ast__body__test__left__left__left__left__right__arguments (23 columns)
  • rules__code_ast__body__test__left__left__left__right__arguments (36 columns)
  • rules__code_ast__body__test__left__left__left__right__arguments__elements (10 columns)
  • rules__code_ast__body__test__left__left__right__arguments (23 columns)
  • rules__code_ast__body__test__left__right__arguments (73 columns)
  • rules__code_ast__body__test__left__right__arguments__elements (10 columns)
  • rules__code_ast__body__test__right__arguments (73 columns)
  • rules__code_ast__body__test__right__arguments__elements (10 columns)
  • rules__settings__allow_list (4 columns)
  • rules__settings__block_list (4 columns)
satisfaction-surveys (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
body_text STRING
created_datetime TIMESTAMP
customer_id FLOAT64
id INT64
meta__postcall BOOL
score FLOAT64
scored_datetime TIMESTAMP
sent_datetime TIMESTAMP
should_send_datetime TIMESTAMP
ticket_id FLOAT64
uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_datetime TIMESTAMP
decoration__color STRING
id INT64
name STRING
uri STRING
usage FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teams (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_datetime TIMESTAMP
decoration__emoji__colons STRING
decoration__emoji__id STRING
decoration__emoji__name STRING
decoration__emoji__native STRING
decoration__emoji__unified STRING
id INT64
name STRING
uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • teams__decoration__emoji__emoticons (4 columns)
  • teams__members (9 columns)
tickets (47 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
assignee_user__email STRING
assignee_user__firstname STRING
assignee_user__id FLOAT64
assignee_user__lastname STRING
assignee_user__meta__name_set_via STRING
assignee_user__meta__sso STRING
assignee_user__name STRING
channel STRING
closed_datetime TIMESTAMP
created_datetime TIMESTAMP
customer__email STRING
customer__firstname STRING
customer__id FLOAT64
customer__lastname STRING
customer__meta__location_info__calling_code STRING
customer__meta__location_info__city STRING
customer__meta__location_info__country_code STRING
customer__meta__location_info__country_name STRING
customer__meta__location_info__currency__code STRING
customer__meta__location_info__ip STRING
customer__meta__location_info__region STRING
customer__meta__location_info__region_code STRING
customer__meta__location_info__time_zone__abbr STRING
customer__meta__location_info__time_zone__name STRING
customer__meta__location_info__time_zone__offset STRING
customer__meta__name_set_via STRING
customer__meta__postscript_sid FLOAT64
customer__name STRING
excerpt STRING
from_agent BOOL
id INT64
is_unread BOOL
language STRING
last_message_datetime TIMESTAMP
last_received_message_datetime TIMESTAMP
messages_count FLOAT64
opened_datetime TIMESTAMP
priority STRING
snooze_datetime TIMESTAMP
spam BOOL
status STRING
subject STRING
updated_datetime TIMESTAMP
uri STRING
via STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • tickets__customer__meta__location_info__languages (4 columns)
  • tickets__integrations (6 columns)
  • tickets__tags (6 columns)
users (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
created_datetime TIMESTAMP
email STRING
external_id STRING
firstname STRING
has_2fa_enabled BOOL
has_password BOOL
id INT64
language STRING
lastname STRING
meta__name_set_via STRING
meta__profile_picture_url STRING
meta__sso STRING
name STRING
role__name STRING
timezone STRING
updated_datetime TIMESTAMP
uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
views (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
category STRING
created_datetime TIMESTAMP
deactivated_datetime TIMESTAMP
decoration__emoji STRING
filters STRING
filters_ast__type STRING
filters_ast__loc__end__column FLOAT64
filters_ast__loc__end__line FLOAT64
filters_ast__loc__start__column FLOAT64
filters_ast__loc__start__line FLOAT64
filters_ast__source_type STRING
id INT64
name STRING
order_by STRING
order_dir STRING
section_id FLOAT64
slug STRING
uri STRING
visibility STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • views__fields (4 columns)
  • views__filters_ast__body (208 columns)
  • views__filters_ast__body__expression__arguments (36 columns)
  • views__filters_ast__body__expression__arguments__elements (10 columns)
  • views__filters_ast__body__expression__left__arguments (36 columns)
  • views__filters_ast__body__expression__left__arguments__elements (10 columns)
  • views__filters_ast__body__expression__left__left__arguments (36 columns)
  • views__filters_ast__body__expression__left__left__arguments__elements (10 columns)
  • views__filters_ast__body__expression__left__left__left__arguments (36 columns)
  • views__filters_ast__body__expression__left__left__left__arguments__elements (10 columns)
  • views__filters_ast__body__expression__left__left__left__left__arguments (36 columns)
  • views__filters_ast__body__expression__left__left__left__left__arguments__elements (10 columns)
  • views__filters_ast__body__expression__left__left__left__left__left__arguments (36 columns)
  • views__filters_ast__body__expression__left__left__left__left__left__arguments__elements (10 columns)
  • views__filters_ast__body__expression__left__left__left__left__left__left__left__left__left__arguments (33 columns)
  • views__filters_ast__body__expression__left__left__left__left__left__left__left__left__left__arguments__elements (10 columns)
  • views__filters_ast__body__expression__left__left__left__left__left__left__left__left__right__arguments (33 columns)
  • views__filters_ast__body__expression__left__left__left__left__left__left__left__right__arguments (23 columns)
  • views__filters_ast__body__expression__left__left__left__left__left__left__right__arguments (35 columns)
  • views__filters_ast__body__expression__left__left__left__left__left__right__arguments (35 columns)
  • views__filters_ast__body__expression__left__left__left__left__right__arguments (36 columns)
  • views__filters_ast__body__expression__left__left__left__right__arguments (36 columns)
  • views__filters_ast__body__expression__left__left__left__right__arguments__elements (10 columns)
  • views__filters_ast__body__expression__left__left__right__arguments (36 columns)
  • views__filters_ast__body__expression__left__left__right__arguments__elements (10 columns)
  • views__filters_ast__body__expression__left__right__arguments (36 columns)
  • views__filters_ast__body__expression__left__right__arguments__elements (10 columns)
  • views__filters_ast__body__expression__right__arguments (36 columns)
  • views__filters_ast__body__expression__right__arguments__elements (10 columns)
  • views__shared_with_teams (10 columns)
  • views__shared_with_teams__decoration__emoji__emoticons (4 columns)
  • views__shared_with_users (8 columns)
views_items (46 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
assignee_user__email STRING
assignee_user__firstname STRING
assignee_user__id FLOAT64
assignee_user__lastname STRING
assignee_user__name STRING
channel STRING
closed_datetime TIMESTAMP
created_datetime TIMESTAMP
customer__email STRING
customer__firstname STRING
customer__id FLOAT64
customer__lastname STRING
customer__meta__location_info__calling_code STRING
customer__meta__location_info__city STRING
customer__meta__location_info__country_code STRING
customer__meta__location_info__country_name STRING
customer__meta__location_info__currency__code STRING
customer__meta__location_info__ip STRING
customer__meta__location_info__region STRING
customer__meta__location_info__region_code STRING
customer__meta__location_info__time_zone__abbr STRING
customer__meta__location_info__time_zone__name STRING
customer__meta__location_info__time_zone__offset STRING
customer__meta__name_set_via STRING
customer__meta__postscript_sid FLOAT64
customer__name STRING
excerpt STRING
from_agent BOOL
id INT64
is_unread BOOL
language STRING
last_message_datetime TIMESTAMP
last_received_message_datetime TIMESTAMP
messages_count FLOAT64
opened_datetime TIMESTAMP
priority STRING
snooze_datetime TIMESTAMP
spam BOOL
status STRING
subject STRING
updated_datetime TIMESTAMP
uri STRING
via STRING
view_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • views_items__customer__meta__location_info__languages (4 columns)
  • views_items__integrations (6 columns)
  • views_items__tags (6 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Gorgias 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 Gorgias?

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

It depends on how much history is in your Gorgias 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 Gorgias’s schema changes?

Section titled “What happens when Gorgias’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 Gorgias, 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 Gorgias 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 Gorgias connector in Kaivo and all of its synced data is deleted with it.

Track tickets by channel, tag, and over time to monitor volume and trends.

Analyse messages to measure first response and resolution times.

Use satisfaction-surveys to track CSAT and find where the experience drops.

Join Gorgias tickets with order data in BigQuery to connect support to the customer journey.

Once Gorgias 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 Gorgias 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 Gorgias connector pricing and plan details.