Add or edit a SharePoint connection

You add a source connection to allow Google Workspace Migrate to read, convert, and transfer data from Microsoft SharePoint to your Google Workspace account.

Add a source connection for SharePoint

1. In the Google Workspace Migrate platform, click New Connection.
2. Under Name, specify a connection name.
3. Under Type, select your version of SharePoint.

   If you're migrating from OneDrive, select SharePoint Online.

4. Under URL, specify the URL of your SharePoint site collection.

   If you're only migrating from OneDrive, enter your SharePoint site collection URL with -my added to the subdomain (for example, example-my.sharepoint.com).

5. Under Account, choose an option:
   • Select an existing SharePoint administrator account.
   • Click Add a new account.
     • If you're connecting to SharePoint Server, specify the administrator’s account username and password.
     • If you're connecting to SharePoint Online, specify a client ID and client secret for your SharePoint site. For details on how to generate a client ID and client secret for SharePoint Online, go to Create app-based credentials for SharePoint Online.
6. If you’re defining a list of site collections or OneDrive accounts for migration, under List, select your location list. For details, go to Create a location list.

   Note: If you only want to migrate the single site collection defined by the URL in step 4, you can skip this step.

7. Click Create.

Troubleshoot connection errors

If you get a 401 (Unauthorized) error when setting up the SharePoint connection, open Microsoft PowerShell and try these troubleshooting options:

• Make sure you're signed in as the SharePoint Online administrator or Global Administrator and enter Connect-SPOService -Url https://<SharePoint-site> to connect to a SharePoint Online connection. 

  For details, go to Connect-SPOService.

• Enter Set-spotenant -DisableCustomAppAuthentication $false to enable custom app authentication.

  For details, go to Granting access using SharePoint App-Only.

Next step

Create a sharding users list (Optional)