You could check Windows Event Log for the startup script execution details. Every Server startup creates records in the Windows Event Log.
Google Drive Streaming creates a virtual drive accessible only by the Windows Account logged into the Google Drive application. This drive can’t be accessed from another scope like another windows service.
I did manage to configure the Public folder with Google Drive Streaming by using a Worker (agent) that runs under the same credentials as my Windows Account. (picture A)
There is another option to configure Google Drive. When Google Drive is set to Mirror files (instead of Stream files), your files are really synced to the folder, and no virtual drive is created. (picture B)
