🎙️ Google Sheets + Whisper: Effortless Audio Transcription!
ฝัง
- เผยแพร่เมื่อ 16 ก.ค. 2024
- In this video, I'll show you how to create a custom formula named "WHISPER" to transcribe any audio files using OpenAI's Whisper speech-to-text technology directly from Google Sheets. 🔥
I'll guide you through the step-by-step process of setting up the formula and then show you how to use it to convert audio files to text in Google Sheets. 📈📊
I'll also share some tips and tricks to help you get the most out of this incredible tool.
So, whether you're a creative professional, a marketer, or someone who loves exploring new technology, this video is for you! 🤩
Grab a cup of coffee ☕ and dive right in!
Remember to subscribe for more amazing videos. 🤗
There is more:
- AI-Generated text with GPT-3 in Google Sheets: • 📱 Boost Your Social Me...
- AI-Generated images with DALLE in Google Sheets: • 🎨 Google Sheets + AI: ...
🔗 Link to the Google Sheets (you can copy it and use it directly): docs.google.com/spreadsheets/...
🔗 Link to the Apps Script function's code: github.com/bitswired/google-s...
🌐 Visit my blog at: www.bitswired.com
📩 Subscribe to the newsletter: newsletter.bitswired.com/
🔗 Socials:
LinkedIn: / jimi-vaubien
Twitter: / bitswired
Instagram: / bitswired
TikTok: / bitswired
00:00 Intro
01:21 My Other Videos For GPT3 & DALLE In Google Sheets
01:41 Configuration And Prerequisites
02:03 Create The Whisper Custom Formula
03:55 Transcribe Audio Using The Formula
04:44 Outro - วิทยาศาสตร์และเทคโนโลยี
Going to try this! Great tool
Intro ans Outro music by Yung Padre hehe
Thanks 😁
Great job bro ! Keep it up
Let’s gooo bro ❤️
Hey you 😏 love it ! 🦍✨😍
Yes … You 🐆💎
Thanks 🙏🏽
amazing!
Thanks my man 😁
Other than English audio file like bengali, Hindi not converted to english. Pls suggest.
This is great! So do the all functions fire off again when the sheet is modified or reloaded?
Yes if you change the cells used as input to the function.
I suggest that you run the extraction, then copy the resulting text only into another sheet so you can keep it, without triggering again the same transcription :)
Wow, amazing feature, thanks for sharing! It would be great if it could just transcribe longer content like 30 minute talks etc.
Is there still no better workaround for this?
Best would be to split the audio. But it might be painful in Google Sheets 😅
Are you comfortable with Python?
Whisper limits is quite larger outside of the 30 seconds limitation in Google Sheets.
You can Process files up to 25MB, if longer you can split them: platform.openai.com/docs/guides/speech-to-text/longer-inputs
Could it work with TH-cam videos transcriptions? I mean add youtube URLs instead podtrac. TH-cam videos have an advantage because TH-cam automatically generate transcriptions for the content. Would be great
Yes that could work but we should modify the script.
Since TH-cam has already the transcription though we could just download them instead of extracting the audio and then transcribing with Whisper.
Does it make sense to you?