About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Automated Audio Transcription and Analysis Workflow

  • 4 March 2024
  • 1 reply
  • 24 views
D

Howdy! I need help with creating Zap that will automate following scheme - I upload an audio file with a recording of the manager’s call to the client to google sheets - whisper transcribes the recording into text - the result is exported to the adjacent cell to the right of my file - chatgpt analyzes the call for execution of the script that I specified - the result is exported exported to the adjacent cell to the right of the previous action - chatgpt analyzed this dialogue between the manager and the client and identified specific mistakes that the manager made during the conversation - the result is exported exported to the adjacent cell to the right of the previous action - chatgpt analyzed this dialogue between the manager and the client and issued a summary of this call to improve the script and suggested additional actions to improve the quality of service for our clients - the result is exported exported to the adjacent cell to the right of the previous action

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

SamB
Rank
Userlevel 7
Badge +11

Hi @D1mb0, welcome to the Community! 👋

It sounds like you want build workflow that takes new audio files of a call, transcribe and analyse them. Then have improvement suggestions created and added into the relevant cells in Google Sheets. I spotted that you tagged the Paths by Zapier app here, is it that you’re wanting to only carry out some of those actions in certain cases? Should the Zap only generate suggestions if mistakes are identified. Am I understanding that correctly? 

What’s app is handling the audio recording part? For example, should the Zap trigger when a new file is uploaded to an app like Google Drive, or is there a phone app that would send the recording to the Zap once it’s created?

For the transcription part you could use the OpenAI Create Transcription action. For the analysis and summary part it might be best to use some Conversation With Assistant (ChatGPT) actions. You can upload files for the Assistant to reference to so that it can better identify potential mistakes and give suggestions. You can learn more about using OpenAI Assistants in Zaps here: Use OpenAI's Assistants API with your Zaps.

Once the summary and suggestions are created you’d likely need to use a Lookup Spreadsheet Row (Google Sheets) action to search for the relevant row that needs to be updated. Followed by an Update Spreadsheet Row (Google Sheets) action to add the summary and any suggestions to the relevant cells in the relevant row in the spreadsheet. 

How does that approach sound? If I've misunderstood what you're looking to do with this workflow or you get stuck setting that up at all just let us know. Always happy to help further! 🙂

Terms & Conditions