June 26, 20251 yr Hi friends,I could use some assistance from more knowledgeable users in aim of creating an efficient workflow that auto converts Google Meet .mp4 recordings into .mp3 files.My use case is as follows:I use Google Meet to conduct online 1/1 and group video meetings.Google Meet records the meetings and automatically saves them as video files in a Google Drive folder called “Meet Recordings”.However, the video files created by Google Meet are not saved with the .mp4 file type [for example: " kcn-kpmw-uyk (2025-06-25 12 13 GMT+3) "], so when I download such a file, my computer doesn’t understand this is a video file, so it won’t play it – unless I manually add the .mp4 file type to the file name. [for example: "kcn-kpmw-uyk (2025-06-25 12 13 GMT+3).mp4 "].Currently, I found a long and inefficient way to automate the file rename and media conversion into MP3 using Nextcloud, but this workflow is very crude and requires quite a few steps. A. I first need to auto download the original video recording file (without the .mp4 extension) from Google Drive to my laptop computer using the Google Drive Desktop sync app.B. The Nextckoud Desktop sync app will then automatically upload this file to my Nextcloud server on my homelab.C. Once the video file is uploaded to a specific folder on my Nextcloud server, an automation distinguishes the file has no .mp4 extension, so it adds the extension.D. Once the file has been updated with the .mp4 extension Nextcloud automatically runs a Media Convert flow to convert the .mp4 file to .mp3.E. The new .mp3 file is then automatically downloaded back to my laptop computer using the Nextcloud Desktop sync app.F. Finally, the new .mp3 file is uploaded to my Google Drive using the Google Drive Desktop sync app, and the workflow is finished.Can someone suggest a quicker and more efficient workflow?I am open to exploring and installing any Unraid community app on my home server that could directly sync with Google Drive, rename these video files and convert them without the long Nextcloud process.Or better yet, if there is a way to create a script that will auto run the rename and media conversion processes directly on Google Drive, this will be the best. Hope someone can help 🙏 Edited June 26, 20251 yr by mjeshurun
June 27, 20251 yr 22 hours ago, mjeshurun said:Hi friends,I could use some assistance from more knowledgeable users in aim of creating an efficient workflow that auto converts Google Meet .mp4 recordings into .mp3 files.My use case is as follows:I use Google Meet to conduct online 1/1 and group video meetings.Google Meet records the meetings and automatically saves them as video files in a Google Drive folder called “Meet Recordings”.However, the video files created by Google Meet are not saved with the .mp4 file type [for example: " kcn-kpmw-uyk (2025-06-25 12 13 GMT+3) "], so when I download such a file, my computer doesn’t understand this is a video file, so it won’t play it – unless I manually add the .mp4 file type to the file name. [for example: "kcn-kpmw-uyk (2025-06-25 12 13 GMT+3).mp4 "].Currently, I found a long and inefficient way to automate the file rename and media conversion into MP3 using Nextcloud, but this workflow is very crude and requires quite a few steps. A. I first need to auto download the original video recording file (without the .mp4 extension) from Google Drive to my laptop computer using the Google Drive Desktop sync app.B. The Nextckoud Desktop sync app will then automatically upload this file to my Nextcloud server on my homelab.C. Once the video file is uploaded to a specific folder on my Nextcloud server, an automation distinguishes the file has no .mp4 extension, so it adds the extension.D. Once the file has been updated with the .mp4 extension Nextcloud automatically runs a Media Convert flow to convert the .mp4 file to .mp3.E. The new .mp3 file is then automatically downloaded back to my laptop computer using the Nextcloud Desktop sync app.F. Finally, the new .mp3 file is uploaded to my Google Drive using the Google Drive Desktop sync app, and the workflow is finished.Can someone suggest a quicker and more efficient workflow?I am open to exploring and installing any Unraid community app on my home server that could directly sync with Google Drive, rename these video files and convert them without the long Nextcloud process.Or better yet, if there is a way to create a script that will auto run the rename and media conversion processes directly on Google Drive, this will be the best.Hope someone can help 🙏ChatGPT is pretty good at making simple scripts like this, I shoved this prompt inI need a simple script that changes the file extension for files in a folder named "Input" to file extension .mp4, and then copy that file to a folder named "Video Output", and then uses ffmpeg to convert the file to an mp3 in a folder named "Audio Output"and it spit outimport osimport shutilimport subprocess# Folder pathsinput_folder = "Input"video_output_folder = "Video Output"audio_output_folder = "Audio Output"# Create output folders if they don't existos.makedirs(video_output_folder, exist_ok=True)os.makedirs(audio_output_folder, exist_ok=True)# Process files in Inputfor filename in os.listdir(input_folder): input_path = os.path.join(input_folder, filename) if os.path.isfile(input_path): base_name = os.path.splitext(filename)[0] mp4_filename = base_name + ".mp4" mp4_path = os.path.join(input_folder, mp4_filename) # Rename to .mp4 os.rename(input_path, mp4_path) # Copy to Video Output video_output_path = os.path.join(video_output_folder, mp4_filename) shutil.copy(mp4_path, video_output_path) # Convert to MP3 using ffmpeg mp3_output_path = os.path.join(audio_output_folder, base_name + ".mp3") subprocess.run(["ffmpeg", "-y", "-i", video_output_path, mp3_output_path])print("All files processed.")Don't know if it works or not, but it should give you a good place to start
June 27, 20251 yr Author Thank you very much for the suggestion. After first trying with ChatGPT, I ended up using Gemini, because it was more thorough in its procedures explanations. So thanks to you, it looks like I managed to get it to work in a much more efficient way 🙏🙏Step 1 consists of using Google Apps Script to add the file extension to the new video file directly on Google Drive. And step 2 consists of my laptop automatically running a convert to mp3 script when the new file is synced to my local HDD.This is much better compared to my original workflow 🙏🙏
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.