Skip to main content

Is it possible to export the transcript of a call to a spreadsheet? I am wanting columns with Time, Speaker, and Transcribed Audio.

Hi @AnthonyZ, welcome to the Gong Community! That’s a great question — I’ve pinged our internal team for some thoughts on this. 

 

Someone will get back to you on this thread very shortly. Thank you for your patience! 


Hi Anthony!

 

The short answer is no but there are a few things I can recommend. 

 

The closest you can get to what you’re looking for is if you go into the Read Along Transcript (the Transcript button in the bottom right of the video playback area on the Call Review page) and highlight all of the text from top to bottom and then use the copy option as if you were copying any other text on your computer and then go to a blank spreadsheet and paste it, you’ll get the speaker and transcribed audio each in their own column within the same row with a skip row or two between each separate speaker.

 

With that being said, knowing more about your use case might help us better direct you to the way that Gong can help you accomplish this most easily. Feel free to share here or if you know who your Gong CSM is they’d be the best person to reach out to for a more in depth discussion.

 

Finally, some of our best product ideas come from our community members so I’d encourage you to go to the product tab up top here and look for the feedback form on the right side of that page if you’d like to submit this as a feature request.


@AnthonyZ  you can export your Transcript to a spreadsheet

  • Review the Beginners Guide To The Gong API - Recap post
  • Click on the recording link
  • Go to 28:21 in the video to see an example of how get the transcript into a spreadsheet. 
  • Suggest you go back in the recording to get the full context, and see that you can also do this with the API 

 


@AnthonyZ  you can export your Transcript to a spreadsheet

  • Review the Beginners Guide To The Gong API - Recap post
  • Click on the recording link
  • Go to 28:21 in the video to see an example of how get the transcript into a spreadsheet. 
  • Suggest you go back in the recording to get the full context, and see that you can also do this with the API 

 


Can we also export the audio file to a drive folder?


 @Maruthi Medisetty Use the https://api.gong.io/v2/calls/extensive call and look at the returned media.audioURL property. Notice the URL has an X-Amz-Expires property with a value of 28800, which is 8 hours, so you will have to run the call and copy the file before the expiration. See there is also a videoUrl property. 

Defer to you on the best way to build the S3 data pipeline part.

 

Gong Media Files

 


+1! my use case is try and copy/paste a transcript into ChatGPT to get a summary and ask specific question about the conversation. When I copy/paste the names/speaker info is missing. Thinking about scraping it off of the html. 


I managed to hack into the html, parse it and get a proper log, pasted it in ChatGPT and asked for a summary of the call. It was AMAZING. I also was able to ask for a short summary, which was very comprehensive, ask about whether a specific topic was discussed and get the details, and ask about overall sentiment of the different people. This is a lot of awesomeness that Gong should unlock either through an AI integration, or easy export!


I managed to hack into the html, parse it and get a proper log, pasted it in ChatGPT and asked for a summary of the call. It was AMAZING. I also was able to ask for a short summary, which was very comprehensive, ask about whether a specific topic was discussed and get the details, and ask about overall sentiment of the different people. This is a lot of awesomeness that Gong should unlock either through an AI integration, or easy export!

@Maxime Beauchemin please can you provide some instructions how to do this as I’d like to do the same!


It’s really stupid that we have to do this hack given that a simple export feature would avoid jumping through hoops. Anyhow, here’s the script I wrote using ChatGPT to parse the html:

https://gist.github.com/mistercrunch/f793f9d2be221e34ccac7dc03856d4fc

 

Good luck.


It’s really stupid that we have to do this hack given that a simple export feature would avoid jumping through hoops. Anyhow, here’s the script I wrote using ChatGPT to parse the html:

https://gist.github.com/mistercrunch/f793f9d2be221e34ccac7dc03856d4fc

 

Good luck.

Agreed - such a basic and expected feature. Thank you.


I used Maxime’s python script as a template for creating a JavaScript bookmarklet instead. You drag the bookmarklet to your bookmarks bar, and then click the bookmark when you’re on the call page. It copies the contents to your clipboard.

If they ever change the page design though, it will start to break, so no guarantees it will work in the future.

https://projects.sia.codes/gong-transcript/


Reply