I've seen software products that interface with windows explorer for sharing cloud drives, one was for using gmail as a drive. Is there any documentation on what libraries etcetera are used to accomplish this task?
You'll need to create a Windows shell extension.
This article looks promising - although quite old.
However, as stated in that article, you are discouraged to build a shell extension with managed code.