I just wanted to give an update on my situation. After many free trials last night, I settled with pCloud. They are priced very well and their link sharing blew everyone out of the water (at least for what I’m needing). With a simple trick in excel, I can now build massive link lists and upload them into my Glide app without issue.
Big thanks to this community for such quick responses and suggestions. You guys are awesome!!
It does work overall but the Glide documentation says it should have the extension .mp3 and be publicly available.
I was using google drive to store my files, however, I noticed an error would pop up randomly. Earlier tonight I have receiving an error while my brother was not (he has an older iPhone), this went on for about 45 minutes. So I thought maybe I really do need the .mp3 and avoid headaches.
Based on reading the comments, I decided to try Cloudinary and it works great! When you share the audio it automatically releases it with the .mp3 extension so the problem is solved now :), thank you for taking the time to answer quickly.