The issue is that our Zapier integration doesn't support YouTube links (the same as the API). It only supports direct download links.
A Direct Download Link it's a link that points directly to the file. In the following video you can see the difference between a share link from Google Drive and a direct download link from Google Drive: