Goal: I want to automate the transcription of YouTube videos by taking a URL from a Google Sheet, using Whisper to transcribe it, and then outputting the transcription onto a Google Doc.
Concerns: I can input the YouTube URL into the Google Sheet without issue. The challenge is to download the video, or preferably just its audio, to feed into Whisper for transcription. I’m not sure how to handle the audio extraction or the direct use of the URL with Whisper. I’m wondering if there’s a solution available on Makethat could streamline this process.