Ready to migrate?
Admin Guide

SharePoint to Google Shared Drive Migration Guide

This guide shows you how to migrate your SharePoint Online sites and document libraries to Google Shared Drives using Cloudiway.

15 min read Updated: 2024-12-16 Microsoft 365 to Google Workspace

Overview

This SharePoint to Google Shared Drive Migration Guide shows you how to migrate your SharePoint Online sites and document libraries to Google Shared Drives.

SharePoint Sites to Shared Drives: Each SharePoint site or document library is migrated to a corresponding Google Shared Drive. The folder structure and permissions are preserved.

Cloudiway uses Microsoft Graph API and SharePoint REST API to read data from SharePoint Online. It uses Google Drive API to write data to Google Shared Drives. Microsoft Office documents can optionally be converted to Google native format. All network operations are performed over TLS 1.2.

Looking for our SharePoint Migration Solution?

Discover all features, pricing, and use cases for SharePoint to Google Shared Drive migration.

View Solution Page

Prerequisites

To perform the SharePoint to Google Shared Drive Migration, you need to configure your Microsoft 365 and Google Workspace environments with the appropriate permissions.

Microsoft 365 Requirements (Source)

Cloudiway uses an Entra ID Application with Application Permissions to access SharePoint Online:

App Registration

Create an application in Microsoft Entra ID

API Permissions

SharePoint: Sites.FullControl.All and Microsoft Graph: Sites.ReadWrite.All

Admin Consent

Granted by a Global Administrator or SharePoint Administrator

Google Workspace Requirements (Target)

Cloudiway uses a Google Service Account with domain-wide delegation to access Google Shared Drives:

Automatic Mode (Recommended): Cloudiway can automatically create and configure the Google Service Account for you. Simply authorize Cloudiway with your Google Workspace Super Admin account.

Google Cloud Project

Create a project in Google Cloud Console (or use automatic mode)

Service Account

Create a Service Account with domain-wide delegation

Drive API Scopes

Enable Drive API with full access to Shared Drives

Automatic Setup: The Cloudiway platform can automatically create and configure both the Entra ID Application and the Google Service Account. Simply authorize Cloudiway with your admin accounts.

What is Migrated

The following items are migrated during a SharePoint to Google Shared Drive migration:

All Files
Folder Structure
Document Libraries
Site Permissions
Created/Modified Dates
Word to Google Docs (Optional)
Excel to Google Sheets (Optional)
PowerPoint to Google Slides (Optional)

SharePoint to Shared Drive Mapping

SharePoint Google Shared Drive
SharePoint Site Shared Drive
Document Library Root folder in Shared Drive
Site Owners Shared Drive Managers
Site Members Shared Drive Contributors
Site Visitors Shared Drive Viewers

Limitations

The following items are NOT migrated:

  • SharePoint lists (only document libraries are migrated)
  • SharePoint pages and web parts
  • File version history
  • SharePoint workflows
  • Custom metadata columns
  • OneNote notebooks
Shared Drive Limits: Google Shared Drives have a limit of 400,000 items per drive. Large SharePoint sites may need to be split across multiple Shared Drives.

Migration Process

The SharePoint to Google Shared Drive migration is a five-step process:

1
Create Connectors
2
Global Settings
3
Discovery
4
Mapping
5
Migration

Step 1: Create Connectors

For Cloudiway to migrate your SharePoint sites, it needs to communicate with both your source Microsoft 365 and target Google Workspace tenants. To do this, Cloudiway uses connectors.

Microsoft 365 Connector (Source)

Go to Connectors > New, select Microsoft 365 as connector type, set a connector name and select Sites, Collaborations. Click Next to configure the connector.

Microsoft 365 Source Site Connector configuration
Microsoft 365 Source Connector Configuration
Field Description
Automatic Cloudiway automatically creates and configures the Entra ID Application (recommended)
Manual Manually configure your own Entra ID Application
Email Address Microsoft 365 Global Administrator email address
Administrator Password Password for the Administrator account
Regular O365 Tenant Enable for standard Microsoft 365 tenants. Disable for GCC or government tenants.
Grant Admin Consent Click to authorize Cloudiway to access your Microsoft 365 tenant
Documentation: For detailed instructions on manual setup, refer to our Office 365 Connector Configuration guide.

Google Workspace Connector (Target)

Go to Connectors > New, select Google as connector type, set a connector name and select Sites, Collaborations. Click Next to configure the connector.

Google Workspace Target Site Connector configuration
Google Workspace Target Connector Configuration
Field Description
Cloudiway Google Service Account Use the Cloudiway-managed service account (recommended)
Custom Google Service Account Expert mode - use your own Google Service Account
Domain Names Your Google Workspace domain(s)
Migration Account Google Workspace Super Admin email address
Migration Account Password Password for the Super Admin account
Documentation: For detailed instructions on manual setup, refer to our Google Workspace Connector Configuration guide.

Step 2: Configure Global Settings

After setting up source and target connectors, configure your global settings. Navigate to Sites > Global Settings.

Site Migration Global Settings
Site Migration Global Settings

Migration Settings

Setting Default Description
Migrate Permissions Enable Migrates site permissions to Shared Drive membership.
Convert Office to Google Format Disable Converts Microsoft Office documents to Google native format.
Preserve Timestamps Enable Preserves the original created and modified dates of files.
Create Shared Drive if not exists Enable Automatically creates the target Shared Drive if it doesn't exist.

Save Your Settings

Click on the Save button to apply your global settings.

Step 3: Fill Site List

The Site List contains all SharePoint sites to be migrated. There are three ways to populate it:

Discovery (Get List)

Automatically discover all SharePoint sites from the source Microsoft 365 tenant.

Import Site List

Upload a CSV file with the list of sites to migrate.

Create Manual Entry

Manually add individual sites one by one.

Option 1: Discovery (Get List)

Click on Site List > Get List to automatically discover all SharePoint sites from the source Microsoft 365 tenant.

Get Sites dialog
Get Sites - Select source pool

Then specify the following parameters:

1

Target Type

Select Shared Drive as the target type.

2

Matching Rule

Choose how SharePoint sites should be mapped to Shared Drives:

  • Site Name: Use the SharePoint site name as the Shared Drive name
  • Custom Naming: Apply a custom naming convention
3

Filter Sites

Optionally filter which sites to include in the migration.

Monitor Progress: You can monitor the progress of this task in the Site List: Get List Logs.

Option 2: Import Site List

Click on Site List > Import to upload a CSV file containing the sites to migrate.

Upload SharePoint Library dialog
Upload SharePoint Library - CSV import
1

Prepare your CSV file

Create a CSV file with the source SharePoint site URLs and target Shared Drive names.

2

Click on Browse

Click on the BROWSE button to open the file selector.

3

Select Connectors

Select the appropriate connectors in the Source and Target fields.

Option 3: Create Manual Entry

Click on Site List > Create to manually add individual sites. Enter the SharePoint site URL and the target Shared Drive name.

Step 4: Verify Mapping Table

Cloudiway automatically populates the mapping table when SharePoint sites are discovered. Make sure that the mapping table was populated correctly.

Critical Warning: Any error in the mapping table will cause permissions to be lost. If a user with site permissions is not in the mapping table, their permissions will not be migrated to the Shared Drive.

Ensure all site members are included in the mapping table.

Ensure that Microsoft 365 email addresses are correctly mapped to their corresponding Google Workspace email addresses for proper permission migration.

Step 5: Run Migration

Now that you have performed all the pre-migration steps, you're ready to migrate.

Before running the migration:
  • Verify that target Shared Drive names are correct
  • Ensure all users in the mapping table exist in Google Workspace
  • Ensure users have valid Google Workspace licenses
Recommendation: We recommend running a test migration on a single site first to verify your configuration.

Start Migration

  1. Under the Sites tab, select all the sites you want to migrate
  2. Click on MIGRATION
  3. Click the Start button

The migration will start as soon as there is a free spot on the platform. You can monitor your migration by clicking on an entry and checking the logs.

Delta Pass

Cloudiway is an incremental migration platform that supports delta passes for site migrations.

Every time you restart the migration:

  • Only files that haven't already been copied to the target will be migrated
  • Files that have been modified in the source will be updated in the target
  • The platform does not duplicate files

How to Start a Delta Pass

To start a delta pass, simply restart the migration and the platform takes care of everything.

Important: Deletions are NOT propagated during delta passes. If a file is deleted from the source after initial migration, it will remain in the target Shared Drive.

Frequently Asked Questions

What is migrated during SharePoint to Google Shared Drive migration?

Cloudiway migrates all files, folders, document libraries, permissions, and metadata from SharePoint sites to Google Shared Drives. Microsoft Office documents can optionally be converted to Google format.

Are SharePoint permissions migrated?

Yes, Cloudiway preserves sharing permissions during migration. Site Owners become Shared Drive Managers, Site Members become Contributors, and Site Visitors become Viewers.

Can I convert Office documents to Google format?

Yes, optionally. Word documents can be converted to Google Docs, Excel to Google Sheets, and PowerPoint to Google Slides. You can also keep the original Office format.

What about SharePoint lists?

SharePoint lists are not migrated as Google Shared Drives only support files and folders. Only document libraries are migrated.

Do I need admin access to both platforms?

Yes, you need Global Admin or SharePoint Admin access to Microsoft 365 and Super Admin access to Google Workspace. Cloudiway can automatically configure the required applications and service accounts for you.

Ready to Start Your Migration?

Get a free migration quote in minutes — entirely self-service.