Here is a link to a simple Colab file in my GoogleDrive:

https://colab.research.google.com/drive/1Dcf35JDcpxXjahcSHVJtQFkBaLhhQWLu?usp=sharing

As a Colab file, it's stored in my drive & at root it' "just" a json file.

I would expect drive_download() to accept that URL, but as_id() fails for this:

as_id("https://colab.research.google.com/drive/1Dcf35JDcpxXjahcSHVJtQFkBaLhhQWLu?usp=sharing")
# <drive_id[1]>
# [1] NA