Good questions!
So if you have a pdf uploaded to Coda, you can access its root URL using the (slightly workaround) method described here
As for uploading to GDrive, I was mistaken originally in thinking the regular GDrive pack includes the ability to upload. Fortunately, there is another pack that does allow for it.
I suspect with those two tools in hand you’ll be able to fully cut Make out of your workflow. Which I can certainly relate to. I recently cut Make out of our workflow and things just got SO much nicer both for me (managing the workflow) and the users (interacting with it)!