1) Install Google Backup and Sync ( https://www.google.com/intl/en-GB_ALL/drive/download/ )
2) Select which folder you want to have synced from the drive to your local hard drive. Any changes to the folder will automatically get synced to the google drive.
3) Get the google folder shared with you.
4) Follow these instructions to add the shared folder into your drive - https://support.google.com/drive/thread/36271375?hl=en
This should cause the cad files to get download to your machine. And any changes someone else makes will also show up in your drive. You can open the file directly from you hard drive using solidworks.
Be careful because any changes you make will get sync back to the cloud and down to other people's machine. A good idea might be to make backups with your name before you mess with stuff.