Thank you for posting your question in our Community Forum.
Google does not provide direct links to files in a Google Shared Drive as the intent of this service is not as a CDN or for public web hosting. Checkout this article from their Developer Blog for more information.
Box.com is one possible low cost alternative for hosting video and other media for use in notifications.
Checkout our Pricing page for information about our plans that include our CDN service. You will see that our Essential and Comprehensive plans will include this service.