How to get a *.gsheet file on a network drive
First of all, I'm not a programmer or IT manager, I work in a social non-profit organization (local, small) but I'm the one who gets (tries) to sort things out when it turns to IT related issues.
Recently, we decided to move our shared folders from Google Drive to a local server. Not much of a change... We had xls and gsheet files, which were copied to the new drive and work just about the same. We still use google accounts for emails, and shared google files for collaborative, simultaneous work.
Now the problem is when a team member creates a new gsheet file. Ideally, we'd like the .gsheet file to appear in the network drive's directory structure. But there's no way to export the file in this format directly from the google sheet interface.
Things I've tried : I edited the content of the .gsheet file in notepad and it looks pretty simple (file ID, owner...). I could generate the file "manually" but my colleagues wouldn't like this option. Other option is to have Backup and Synch running and get the gsheet file from there, but computers are not assigned to a specific team member so they would have to re-log into the synch app as well. I tried to understand how the google API "files: export" works, but it's too complicated for me.
In short, is there a simple way to generate a .gsheet file so it can be accessed from a network drive ?
Thanks in advance !