Bulk move user files to Google Apps from Windows

After doing a quick poke around Google Drive for work, here's a possible solution: (WARNING: its not very pretty. In fact, its quite ugly, but it just might work.)

1. Share each users Google Drive folder with an administrator or role account.
2. Log into that account on the Server machine.

3. Using a variable in the batch script (assuming the employees have the same user name on the Windows system as Drive) have the script detect the folder and automatically place it in the correct drive folder.

   FOR %%c in (C:\Users\*.*) DO    
   set FileName=%%c
   robocopy C:\Users\%FileName% C:\...\GoogleDrive\%FileName% /E /Z /TEE /LOG:migrationLog.log 
   del %FileName%
   exit
   

Basic theory behind this found here: http://learn.googleapps.com/products/drive/set-up-file-share

Here is Microsoft's page on robocopy and its functions and attributes: https://technet.microsoft.com/en-us/library/cc733145.aspx

Here is what I did in the end

• Created a service account in Google Apps
• Setup the Google Drive Sync Utility for Windows
• Transferred all the files and folders to that one Google Drive Account
• Created a Google Apps Script to Share the users folder properly

Here is the Apps Script I used, each folder has the name of the user:

function myFunction() {
  //Top Level Directory that contains each users folder
  var folder = DriveApp.getFolderById('0ByoBlv24h');

  //Get a list of all the folders (also usernames)
  var folders = folder.getFolders();

  //Loop through all the folders
  while(folders.hasNext()){
    var thisFolder = folders.next();

    //Get the username and email address
    var username = thisFolder;
    var email = username + '@domain.com';

    //Add the user as an editor for this folder
    thisFolder.addEditor(email);

    //Add a name for the folder
    thisFolder.setName(username + ' - Google Drive');     
 }
}