#Migration to Google Drive

Refer to the table below to view the supported and unsupported object types for SharePoint Online to Google Drive Migration.

√ – Supported; × – Unsupported.

Object Type	Object Type	Object Type	Source Service Account Authentication Support Status	Source App Profile Support Status	Comment
Content	Site/subsite	-	√	√	Sites/subsites will be migrated as folders to the destination Google Drive (User Drive / Shared Drive).
Content	Library	-	√	√	Libraries will be migrated as folders to the destination Google Drive (User Drive / Shared Drive).
Content	List	-	√	√	Lists will be migrated as folders to the destination Google Drive (User Drive / Shared Drive). Folders, items and columns in the lists will be migrated to Google Sheet. Attachments in the lists will be migrated to the destination folder and recorded as links in the Google Sheet. The source item permissions will be migrated to the destination attachments in the folder.
Content	Folder	-	√	√	Folder color can be kept in the migration.
Content	Document set	-	Partially Supported	Partially Supported	Document sets will be migrated as folders to the destination Google Drive (User Drive / Shared Drive).
Content	File	Office 2010 file	√	√
Content	File	Office 2013 file	√	√
Content	File	JPG	√	√
Content	File	PDF	√	√
Content	File	MP3	√	√
Content	File	MP4	√	√
Content	File	GIF	√	√
Content	File	ZIP	√	√
Content	File	RAR	√	√
Content	File	OneNote	Partially Supported	Partially Supported	OneNote data will be migrated to destination folders.
Content	File	Minor version	Partially Supported	Partially Supported	Due to Google limitations, only the latest 100 versions can be migrated.
Content	File	Major version	Partially Supported	Partially Supported	Due to Google limitations, only the latest 100 versions can be migrated.
Content	File	Check out	×	×
Content	File	Hold	×	×
Content	File	Declared	×	×
Content	File	Sensitivity label	Partially Supported	Partially Supported	Fly does not migrate sensitivity labels but allows you to keep source sensitivity labels, or remove source sensitivity labels from files during the migration via configuring the migration policy.
Content	File	Page	×	×
Content	Shortcut from SharePoint	-	×	×
Content	Columns	-	Partially Supported	Partially Supported	Only Modified time of columns can be migrated.Metadata of source folders, files, and items will be preserved in a Google Sheet, and the sheet will be saved in the same path as the migrated folders, files, and items. For columns whose metadata can be migrated, refer to the Supported List for Column Metadata section below.
Security	Permission	-	√	√
Security	User	-	√	√
Security	SharePoint group	-	√	√
Security	Microsoft 365 group	-	√	√
Shared link	-	-	Partially Supported	Partially Supported	Refer to Comment 1 below the table.
Favorites	-	-	×	×

When migrating SharePoint Online data to Google Drive, note the following:

• Google API limitations will affect the migration of files. For details, refer to Upload file data.

• If the source objects inherit permissions from their parent objects, Fly will identify the first parent object with unique permissions. These unique permissions will be regarded as the permissions of the source objects during the migration. Consequently, the destination objects will be assigned the same permissions as the source identified parent objects.

• If source objects have unique permissions, after the migration, the objects will keep the original destination object permissions and be assigned the same permissions as those in the source.

• If you want to migrate source data to a shared drive, make sure there is a user in the destination shared drive who has the Manager access to the shared drive.

Comment 1: Note the following for migrating expiration dates of shared link permissions:

• When the destination is a shared drive, only the expiration dates of file permissions can be migrated due to due to Google API limitations.

• When the destination is My Drive and an expiration date can be set for the shared link permission (such as View permission for folders), the expiration dates can be migrated as follows:

  • Expiration date is within one year – Set the expiration date the same as the source.

  • Expiration date is in one year later – Set the expiration date to one year.

When the destination is My Drive and the expiration date cannot be set for the shared link permission (such as Edit permission for folders), the expiration dates cannot be migrated.

#Supported List for Column Metadata

Refer to the table below for the columns whose metadata can be migrated.

Column Name/Type	Comment
Id (Unique ID of the source object)
Name (Name or title of the source object)
Modified (Modified time)
Created By (Creator)	The column value (user/group) will be migrated to the Google Sheet. User mapping is unavailable for such users and groups.
Type
Source path	The column value (path) will be migrated to the Google Sheet as a non-clickable URL.
Attachment	The column value (attachment) will be migrated to the Google Sheet as a hyperlink, which can direct you to the attachment in the destination.
Single line of text
Multiple lines of text
Choice
Date and time
Person	The column value (user/group) will be migrated to the Google Sheet. User mapping is not available for such users and groups.
Number
Yes/No	The column will be migrated to the Checkbox column in the Google Sheet. The value Yes will be mapped to True, and No will be mapped to False.
Lookup	The column will be migrated to the corresponding data type in the Google Sheet. Supported types: Number, Text, and Date time.
Managed metadata	The column will be migrated to the Dropdown column in the Google Sheet.
Currency
Image	The column value (image) will be migrated to the Google Sheet as a text that records the image properties.
Calculated
Task Outcome

#Data Mappings for SharePoint Online to Google Drive Migration

Refer to the table below to view the mappings of source SharePoint Online data types and the corresponding Google Drive data types.

SharePoint Online Data Type	Google Drive Data Type
Site/subsite	Folder
Library	Folder
Folder	Folder
List	Folder
File	File
Attachment	File
File Version	File Version
OneNote	Folder
Column	Google Sheet Column

Refer to the table below to view the mappings of source SharePoint Online metadata types and the corresponding Google Drive metadata types.

SharePoint Online Metadata Type	Google Drive Metadata	Comment
Created By	N/A	Fly will create the Created By metadata in the destination. In a destination user's drive, the Created By metadata will display the drive owner. In a shared drive, it will show as one of the Manager users.
Modified By	N/A	Fly will create the Modified By metadata in the destination. In a destination user's drive, the Modified By will display the drive owner. In a shared drive, it will show as one of the Manager users.
Created	Created Time
Modified	Modified Time

Refer to the tables below to view the mappings of source SharePoint Online permission levels and the corresponding Google Drive permission levels.

Permission mapping for user drive

SharePoint Online Permission Level	User Drive Permission Level
Full Control	Editor
Contribute	Editor
Design	Editor
Edit	Editor
Read	Viewer
View Only	Viewer
Restricted view/Can’t download	Viewer
Review	Commenter

Permission mapping for shared drive

SharePoint Online Permission Level	Shared DrivePermission Level
Full Control	Editor/Content Manager
Contribute	Editor/Contributor
Design	Editor/Contributor
Edit	Editor/Contributor
Read	Viewer
View Only	Viewer
Restricted view/Can’t download	Viewer
Review	Commenter