Walkthrough - Import Google Drive Documents to OneDrive for Business with PowerShell

Use PowerShell to automate your Google Drive to OneDrive for Business migration.

Index

• Prerequisites
• Create a CSV guide for your migration
• Create your script

Prerequisites

• Global Administrator or SharePoint Administrator permissions are required.

• Your Google drive domain is set to work in Administrator Mode.

• Your OneDrives have been provisioned.

  • This can be automated with the Get-OneDriveURL cmdlet.

Note: You need to be Site collection admin on each OneDrive, even if you have higher admin privileges. You will use SharePoint admin or Global admin permissions to apply Site collection admin permissions on all your OneDrives and then remove the Site collection admin permissions as you migrate each Google Drive.

Create a CSV guide for your migration

1. Download a list of all your Google Drive user emails as a CSV.
2. Open the CSV file generated from Google Drive.
3. Edit the file so you only have one column with your user's Google Drive email addresses.
4. Insert a new row at the top for the header.
5. Name the first column GOOGLEDRIVEEMAIL.
6. Open ShareGate Desktop.
7. Go to All reports.
8. Click on Create custom report in the top right corner.
9. Select OneDrive for Business as your object type.
10. Click Continue without saving.
11. Select your tenant.
12. Click on Run.
13. Select all your OneDrives with the checkmark box at top of the list.
14. Click  Edit in the quick actions menu.
15. Select Add administrators in the Transformations dropdown.
16. Search and add your account in the Select user or group field that appears.
17. Click Apply.
18. Click Back two times to go back to your report results.
19. Click on Export in the top right corner.
20. Save the file on your drive, and open it.
21. Replace the Site address header by ONEDRIVEURL.
22. Combine the two spreadsheets so that each directory corresponds to the correct URL in your rows.
    
    Note: If sorting alphabetically doesn't work, you can reorganize your data manually or you can look for a solution with Excel macros or PowerShell.
23. Save this new file as a CSV on your drive.

Create your script

Copy and paste the following script in the PowerShell application of your choice.

Import-Module Sharegate
$csvFile = "C:\MigrationPlanning\onedrivemigration.csv"
$table = Import-Csv $csvFile -Delimiter ","
$googleDrive= Connect-GoogleDrive -Email admin@mycompany.com -Admin
$mypassword = ConvertTo-SecureString "mypassword" -AsPlainText -Force
Set-Variable dstSite, dstList
foreach ($row in $table) {
    Clear-Variable dstSite
    Clear-Variable dstList
    $dstSite = Connect-Site -Url $row.ONEDRIVEURL -Username "myusername" -Password $mypassword
    $dstList = Get-List -Name Documents -Site $dstSite
    Import-GoogleDriveDocument -GoogleDrive $googleDrive -SourceFolder $row.GOOGLEDRIVEEMAIL -SourceView "MyDocuments" -DestinationList $dstList
    Remove-SiteCollectionAdministrator -Site $dstSite
}

Adjust your script so that it will work for you. Here are a few guidelines:

• $csvFile: Adjust the path so that it points to the CSV file you saved before.
• $table: The delimiter is the symbol your CSV uses to separate your items in a row. Make sure your script uses the same delimiter as your file (a quick way to verify this, is by opening the CSV with Notepad).
• $googleDrive: Replace the email by your Google Drive admin email.
• $mypassword: Replace "mypassword" by your Microsoft 365 admin account password.
• $dstSite: Replace "myusername" by your Microsoft 365 admin account user name.
  • Connect-Site: If you need to change the authentication method, you will find how to do it in the Connect Site article.
• Set-variable and Clear-Variable: These commands help prevent an issue where a connection failure can cause your data to end up in the wrong OneDrive. If you have to use the browser connection method, you will have to remove these lines.
• foreach: We use foreach to loop through the values in your CSV file. You can find more about it here.
• Remove-SiteCollectionAdministrator: Removes your user account as site collection administrator on the OneDrives after each Google Drive migration.

Run your script once it is properly adjusted and tested.