How do I sync a google drive folder to a web server folder

November 21, 2019 236 views
Miscellaneous

We have a google drive folder with a spreadsheet. When the spreadsheet changes we want the contents sync’d to a web server folder. The sheet contains stock levels. When the stock levels change we want the web page to change. We currently use an app called RealTimeSync which monitors the google drive folder and FTP’s the file - but this runs on a local home machine. If the power fails then the process fails. We would like to run a similar process (not necessarily RealTimeSync) on a Digital Ocean droplet which performs the same task. Does anyone have any ideas on the best way to do this and instructions? I had a brief look at Rsync - but I’m not sure this will work. Any assistance would be most helpful.
Thanks

1 Answer

Hello, @paulmanners

rsync is a great file-copying tool but I believe you would need something else to copy your files to Google Drive. I know that rclone is used to sync between a linux machine and Google Drive. The installation is pretty straight forward. You can check the installation tutorial here: https://rclone.org/install/

And the official documentation here: https://rclone.org/docs/ for GDrive: https://rclone.org/drive/

Hope this helps.

Regards,
Alex

Have another answer? Share your knowledge.