Transcribe Audio in Google Sheets!

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ต.ค. 2023
  • Connect your google drive and sheets together, provide links to external parties, prepare for transcription, translation, or check that the audio files say what you expect them to say!
    Purchase the script from the video on my website!
    www.weaveraudio.com/scripts-p...
    Use this method to connect Google Sheets with Google Drive to automatically provide links with just a filename, and use Apps Script to provide some functionality when error checking.
    1. Load your audio files into Google drive
    2. Create a google sheet alongside this example
    docs.google.com/spreadsheets/...
    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.
  • แนวปฏิบัติและการใช้ชีวิต

ความคิดเห็น • 2

  • @subratadas4203
    @subratadas4203 3 หลายเดือนก่อน

    Does it work in Bengali audio and English text?

    • @dweaveraudio
      @dweaveraudio  3 หลายเดือนก่อน

      Should be easy to test, plus Google sheets has a native link to Google translate, if you wanted to use that to go from Bengali audio -> Bengali text -> English text with =GOOGLETRANSLATE