Skip to content
Book a demoStart free
Connectors

Gong connector

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

Gong connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Gong 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 marketing and sales data instead of moving it.

Sync your Gong call data into BigQuery with Kaivo to analyse sales conversations, scorecards, and rep performance alongside your pipeline.

CategoryMarketing & Sales
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Gong 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 Gong credentials. You provide:

Field Description
Gong Access Key
Your Gong API access key.

| | Gong Access Key Secret |

Your Gong API access key secret.

|

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 Gong into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

answeredScorecards (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
answered_scorecard_id STRING Unique identifier for the answered scorecard instance.
call_id STRING Unique identifier for the call associated with the answered scorecard.
call_start_time TIMESTAMP Timestamp indicating the start time of the call.
review_time TIMESTAMP Timestamp indicating when the review of the answered scorecard was completed.
reviewed_user_id STRING Unique identifier for the user whose performance was reviewed.
reviewer_user_id STRING Unique identifier for the user who performed the review.
scorecard_id STRING Unique identifier for the scorecard template used.
scorecard_name STRING Name or title of the scorecard template used.
visibility_type STRING Type indicating the visibility permissions for the answered scorecard.
_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.
answer_text STRING Text containing the answer given.
is_overall BOOL Boolean flag indicating if the answer is for an overall evaluation.
not_applicable BOOL Boolean flag indicating if the question is marked as not applicable.
question_id STRING Unique identifier for the question answered.
question_revision_id STRING Unique identifier for the revision of the question answered.
score INT64 Numeric score assigned to the answer.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
calls (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
calendar_event_id STRING Unique identifier for the calendar event associated with the call.
client_unique_id STRING Unique identifier for the client related to the call.
custom_data STRING Custom data associated with the call.
direction STRING Direction of the call (inbound/outbound).
duration INT64 Duration of the call in seconds.
id STRING Unique identifier for the call.
is_private BOOL Indicates if the call is private or not.
language STRING Language used in the call.
media STRING Media type used for communication (voice, video, etc.).
meeting_url STRING URL for accessing the meeting associated with the call.
primary_user_id STRING Unique identifier for the primary user involved in the call.
purpose STRING Purpose or topic of the call.
scheduled TIMESTAMP Scheduled date and time of the call.
scope STRING Scope or extent of the call.
sdr_disposition STRING Disposition set by the sales development representative.
started TIMESTAMP Start date and time of the call.
system STRING System information related to the call.
title STRING Title or headline of the call.
url STRING URL associated with the call.
workspace_id STRING Identifier for the workspace to which the call belongs.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
callTranscripts (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
started TIMESTAMP The start time of the call associated with the transcript.
call_id STRING Unique identifier for the call associated with the transcript.
_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.
speaker_id STRING Unique identifier for the speaker in this segment.
topic STRING Topic being discussed in this segment.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: callTranscripts__transcript__sentences

Section titled “Subtable: callTranscripts__transcript__sentences”
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.
start INT64 Start time of the sentence in milliseconds.
end INT64 End time of the sentence in milliseconds.
text STRING The transcribed text of the sentence.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
extensiveCalls (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
startdatetime TIMESTAMP Datetime for extensive calls.
collaboration__brief STRING
content__brief STRING
id INT64 Unique identifier for the call (from metaData.id).
interaction__questions__company_count FLOAT64
interaction__questions__non_company_count FLOAT64
media JSON The media urls of the call.
meta_data__calendar_event_id STRING Unique identifier for the calendar event associated with the call.
meta_data__client_unique_id STRING Unique identifier for the client related to the call.
meta_data__custom_data STRING Custom data associated with the call.
meta_data__direction STRING Direction of the call (inbound/outbound).
meta_data__duration INT64 Duration of the call in seconds.
meta_data__id STRING Unique identifier for the call.
meta_data__is_private BOOL Indicates if the call is private or not.
meta_data__language STRING Language used in the call.
meta_data__media STRING Media type used for communication (voice, video, etc.).
meta_data__meeting_url STRING URL for accessing the meeting associated with the call.
meta_data__primary_user_id STRING Unique identifier for the primary user involved in the call.
meta_data__purpose STRING Purpose or topic of the call.
meta_data__scheduled TIMESTAMP Scheduled date and time of the call.
meta_data__scope STRING Scope or extent of the call.
meta_data__sdr_disposition STRING Disposition set by the sales development representative.
meta_data__started TIMESTAMP Start date and time of the call.
meta_data__system STRING System information related to the call.
meta_data__title STRING Title or headline of the call.
meta_data__url STRING URL associated with the call.
meta_data__workspace_id STRING Identifier for the workspace to which the call belongs.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__highlights

Section titled “Subtable: extensiveCalls__content__highlights”
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.
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__highlights__items

Section titled “Subtable: extensiveCalls__content__highlights__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.
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__highlights__items__start_times

Section titled “Subtable: extensiveCalls__content__highlights__items__start_times”
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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__key_points

Section titled “Subtable: extensiveCalls__content__key_points”
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.
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__outline

Section titled “Subtable: extensiveCalls__content__outline”
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.
duration FLOAT64
section STRING
start_time FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__outline__items

Section titled “Subtable: extensiveCalls__content__outline__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.
start_time FLOAT64
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__points_of_interest__action_items

Section titled “Subtable: extensiveCalls__content__points_of_interest__action_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.
snippet STRING
snippet_end_time FLOAT64
snippet_start_time FLOAT64
speaker_id 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.
duration FLOAT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__trackers

Section titled “Subtable: extensiveCalls__content__trackers”
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
count FLOAT64
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__trackers__occurrences

Section titled “Subtable: extensiveCalls__content__trackers__occurrences”
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.
speaker_id STRING
start_time FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__trackers__phrases

Section titled “Subtable: extensiveCalls__content__trackers__phrases”
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.
count FLOAT64
phrase STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__content__trackers__phrases__occurrences

Section titled “Subtable: extensiveCalls__content__trackers__phrases__occurrences”
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.
speaker_id STRING
start_time FLOAT64
_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.
system STRING External system name. Allowed: Salesforce, HubSpot, MicrosoftDynamic, Generic.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__context__objects

Section titled “Subtable: extensiveCalls__context__objects”
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.
object_id STRING Object ID.
object_type STRING Object Type. Allowed: Opportunity, Account
timing STRING Timing of object. Allowed: Now, TimeOfCall.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__context__objects__fields

Section titled “Subtable: extensiveCalls__context__objects__fields”
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.
name STRING Field name. For Account supported fields are: Name, Website, Industry and all the custom fields. For Opportunity supported fields are Name, LeadSource, Type, StageName, Probability, Amount, CloseDate and all the custom fields.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__context__objects__fields__value

Section titled “Subtable: extensiveCalls__context__objects__fields__value”
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: extensiveCalls__interaction__interaction_stats

Section titled “Subtable: extensiveCalls__interaction__interaction_stats”
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.
name STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__interaction__speakers

Section titled “Subtable: extensiveCalls__interaction__speakers”
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.
id STRING
talk_time FLOAT64
user_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__interaction__video

Section titled “Subtable: extensiveCalls__interaction__video”
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.
duration FLOAT64
name 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.
affiliation STRING Whether the participant is from the company or not. Allowed: Internal, External, Unknown
email_address STRING Email address.
id STRING Unique ID of the participant in the call.
name STRING The name of the participant.
phone_number STRING The phone number of the participant.
speaker_id STRING Unique ID of a participant that spoke in the call. References to this id will appear in the ‘/v2/calls/transcript’ endpoint response.
title STRING The job title of the participant.
user_id STRING The user ID of the participant within the Gong system, if the participant exists in the system.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: extensiveCalls__parties__methods

Section titled “Subtable: extensiveCalls__parties__methods”
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.
scorecards (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created TIMESTAMP The timestamp when the scorecard was created
enabled BOOL Indicates if the scorecard is enabled or disabled
scorecard_id STRING The unique identifier of the scorecard
scorecard_name STRING The name of the scorecard
updated TIMESTAMP The timestamp when the scorecard was last updated
updater_user_id STRING The user ID of the person who last updated the scorecard
workspace_id STRING The unique identifier of the workspace associated with the scorecard
_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.
created TIMESTAMP The timestamp when the question was created
is_overall BOOL Indicates if the question is an overall score or not
question_id STRING The unique identifier of the question
question_revision_id STRING The revision identifier of the question
question_text STRING The text of the question
updated TIMESTAMP The timestamp when the question was last updated
updater_user_id STRING The user ID of the person who last updated the question
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Indicates if the user is currently active or not
created TIMESTAMP The timestamp denoting when the user account was created
email_address STRING The primary email address associated with the user
extension STRING The phone extension number for the user
first_name STRING The first name of the user
id STRING Unique identifier for the user
last_name STRING The last name of the user
manager_id STRING The ID of the user’s manager
meeting_consent_page_url STRING URL for the consent page related to meetings
phone_number STRING The phone number associated with the user
title STRING The job title or position of the user
trusted_email_address STRING An email address that is considered trusted for the user
_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.
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 Gong 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 Gong?

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

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

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

Use calls and callTranscripts to study what happens in your sales conversations.

Join scorecards with answeredScorecards to track coaching and call quality over time.

Group calls by user to compare activity and outcomes across the team.

Bring Gong calls together with your CRM data to connect conversations to deals.

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