Create your own transcription service right inside Google Sheet with this apps script!

1. Load your audio files into Google drive

2. Create a google sheet alongside this example
   https://docs.google.com/spreadsheets/d/1BMpZPdiv5gdUizYpDfwamsk-lrVMVCpeHGq474oCLzY/edit#gid=0

3. Create a new AppsScript with Extensions->Apps Script

4. Add the apps script code, and the HTML file (if you want to use the audio player

5. Get the link to your audio drive directory to place into the YELLOW cell

6. Create a Google Cloud Project and set up your Billing

7. Add the Speech to Text API

8. Get the API key into the GREEN API key cell

9. Add file names you want transcribed from within that directory (you don’t need to add the links!)

10. Click the transcribe button!

The script will add links to each of the files separately, get you a transcription for them (if there isn’t already something in the cell) and get you a confidence value for what you EXPECTED would be there.

Full youtube video here!
https://youtu.be/0esx7QAc8fg