How to analyze past Gong transcripts and AI insights in Google Sheets?

Hi ​@nam11nguyen, 

For new calls you can use Gongs existing Zapier trigger

For existing calls you may have to use Zapier webhooks to query historic calls in Gong, and to take it a step further to get transcripts and more details, query data for individual calls. Both endpoints listed below:

1. /v2/calls - specify calls within a date range
2. /v2/calls/id - get data for a specific call

You’ll probably have to incorporate Looping by Zapier in your flow to accomplish this. Each loop should end in a Google Sheet update.

Hope this helps!

Hi ​@nam11nguyen 

For processing past Gong calls, try this…

Export the data to a CSV from Gong.

Configure a Zap that triggers from a GDrive New File in Folder.

Use Files by Zapier to get the CSV Rows.

Use Looping to iterate thru each Row. (NOTE: MAX 500 loop iterations)

Hi ​@nam11nguyen, 

 

For new calls you can use Gongs existing Zapier trigger

 

 

For existing calls you may have to use Zapier webhooks to query historic calls in Gong, and to take it a step further to get transcripts and more details, query data for individual calls. Both endpoints listed below:

1. /v2/calls - specify calls within a date range
2. /v2/calls/id - get data for a specific call

You’ll probably have to incorporate Looping by Zapier in your flow to accomplish this. Each loop should end in a Google Sheet update.

 

Hope this helps!

 

​@robintrainward I was able to do this successfully when my trigger is a new call, but when it’s not new call for some reason it fails.  Here is how I have it set up.  Under Basic Auth, I have my API Key|Secret Code.  Any thoughts on how to fix this?  The error message I get is “Failed to create a request in Webhooks by Zapier”

​@Troy Tessalone I don’t think there is a way to export transcript data from Gong directly into a csv.

​@nam11nguyen 

Try searching Gong help links about the possibility of downloading data: https://help.gong.io/docs/download-call-data

I don’t believe you can mass download/export call transcripts.  You can do it one by one, but if you export call data, it won’t include the transcript.

​@nam11nguyen 

Try reaching out to Gong Support to see if there is a way to download the desired data from Gong.

Hi ​@nam11nguyen, 

 

For new calls you can use Gongs existing Zapier trigger

 

 

For existing calls you may have to use Zapier webhooks to query historic calls in Gong, and to take it a step further to get transcripts and more details, query data for individual calls. Both endpoints listed below:

1. /v2/calls - specify calls within a date range
2. /v2/calls/id - get data for a specific call

You’ll probably have to incorporate Looping by Zapier in your flow to accomplish this. Each loop should end in a Google Sheet update.

 

Hope this helps!

 

​@robintrainward I was able to do this successfully when my trigger is a new call, but when it’s not new call for some reason it fails.  Here is how I have it set up.  Under Basic Auth, I have my API Key|Secret Code.  Any thoughts on how to fix this?  The error message I get is “Failed to create a request in Webhooks by Zapier”

 

​@nam11nguyen  I should have mentioned that these are both GET Requests, I see you’ve specified POST in the request, once you change that it should go through!
 

1. GET /v2/calls - specify calls within a date range
2. GET /v2/calls/id - get data for a specific call

​@robintrainward Thanks! Looks like that worked to get call data when I use GET /v2/calls, but how do I get transcript data from the calls?

​@nam11nguyen 

Gong API endpoint docs to get Call Transcript: https://gong.app.gong.io/settings/api/documentation#post-/v2/calls/transcript

Hey ​@nam11nguyen, just checking in! 👋

Did the “Retrieve transcripts of calls” endpoint allow you to get the transcript that you were after?

Want to make sure you’re all set here so let us know if you still need any help at all! 🙂