Automate URLs to Youtube Videos in Google Sheet, and then they automatically gets transcribed and then added to a google doc

Questions & Answers
1

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.

2

Make doesn’t have an integration for this third-party service.

If the external service has a Developer API Reference/Documentation then you might be able to integrate the endpoints in Make using the generic HTTP “Make a request” module.

You can also suggest for it to be made in the Idea exchange. Don’t forget to search for it first, in case someone already suggested it!

3