In Google Drive, create a new Google Sheet in the root of “My Drive”.The following steps use a spreadsheet as an example, but the same steps work for other file types too. Note that other than running the sync script, editing existing files do not require these steps. Lastly, here are the procedural steps I take when I am working on a new file. Google Drive-to-OneDrive Script #!/bin/zsh /Users/username/gdrive/dev/myrsync.sh '/Volumes/GoogleDrive/Shared drives/To365/Technology - Documents/General/FromGSuite' '/Users/username/LT Trust-OneDrive/LT Trust/Technology - Documents/General' > /Users/username/gdrive/dev/ 2>&1 & OneDrive-to-Google Drive Script #!/bin/zsh /Users/username/gdrive/dev/myrsync.sh '/Users/username/LT Trust/Technology - Documents/General/FromGSuite' '/Volumes/GoogleDrive/Shared drives/To365/Technology - Documents/General' > /Users/username/gdrive/dev/ 2>&1 & Procedure Just modify the following scripts with your specific file paths and whatever you named your sync script (I named mine myrsync.sh). I typically only run the former, but if I am collaborating with others, I might run them both.

The sync script is as follows: #!/bin/zsh src='$' dest='$' # From: alias run_rsync='rsync -archive -verbose -recursive -update -times '$' '$'' run_rsync fswatch -o $ | while read f do run_rsync doneįor the wrapper script, I created one for syncing Google Drive to OneDrive and another for synching OneDrive to Google Drive.

The fswatch package - brew install fswatchįor the sync script, I used the logic from this Stack Overflow post.

My Mac-specific solution relies on the following components: Zapier is reputable, but why introduce a threat vector when you don’t have to? Zapier’s integration might have met my needs, but I didn’t want to introduce a potential security vulnerability. I created the script myself instead of using a cloud-based service. I still use Google Drive and its associated apps, but now I also use a script to sync my changes to OneDrive. So what’s a Google guy to do in a Microsoft malaise? Improvise. Therefore, we rolled with Microsoft 365 as our productivity and collaboration suite. The early days of the pandemic were definitely not a good time to disrupt the company with a transition to Google Workspace. When the pandemic rolled around, we had to step up our collaboration game, but we had to do so quickly and smoothly. When I joined LT Trust, we were a small company with little appetite for a major culture shift to Google Workspace.

In fact, back in 2016, I blogged about the advantages of Google Workspace vs. As you can tell by my blog posts, I am a huge fan of Google Workspace.

Excel google drive sync