Ah, I was hoping that since a google drive could be used as a sync location for your own drive that it could also be directly shared.
Is there a way to just give someone a link to an excel/sheet/whatever file type on another file server option like dropbox, one drive, github, etc that they could put into the private share link? Having to copy stuff to your own drive to then be able to access is sadly a step to complicated for many a person

. I need it more permanent than a short time share, but it's not so widely accessed to setup a public long term share either.