Google Workspace to Office 365 (Automatic Method)

Prerequisites

Need to Enable the below Settings on admin.google.com

Check Google Cloud platform permissions

An automated scenario requires the Google Migration administrator to be able to perform the following steps in the Google admin console:

  1. Create a Google Workspace project.

  2. Create a Google Workspace service account in the project.

  3. Create a service key.

  4. Enable all APIs - Gmail, Calendar, and Contacts.

The Google Migration administrator needs the following permissions to complete these steps:

  • resourcemanager.projects.create

  • iam.ServiceAccounts.create

The most secure way to achieve completion of these four steps is to assign the following roles to the Google Migration administrator:

  • Project Creator

  • Service Accounts Creator

Here's how you do it:

  1. Expand the hamburger menu in the upper right-hand corner.

    image
  2. Select IAM & Admin.

  3. Select Manage Resources.

  4. Select the appropriate resource and in the right-hand pane under the Permissions tab, select Add Principal.

  5. Enter your Google Migration administrator credentials, enter Project Creator in the filter, and select Project Creator.

  6. Select Add Another Role, enter Create Service Accounts in the filter, and select Create Service Accounts.

  7. Other Roles (Need to Assign on the admin user):

    1. Create Service Accounts

    2. Organization Administrator

    3. Owner

    4. Service Account Key Admin

    5. Service Account User

  8. Other Roles (Need to Assign on the Organization):

    1. Access Transparency Admin

    2. Browser

    3. Create Service Accounts

    4. Delete Service Accounts

    5. Editor

    6. Organization Administrator

    7. Organization Policy Viewer

    8. Owner

    9. Project Creator

  9. Select Save.


ISSUES

Additional Settings


Start an automated Google Workspace migration batch in EAC

  1. In the Exchange Admin center, go to Migration, and then select Add migration batch.

    The Add migration batch page appears.

  2. Configure the following settings:

    • Give migration batch a unique name: Enter a unique name.

    • Select the mailbox migration path: Verify that Migration to Exchange Online is selected.

    When you're finished, click Next.

  3. On the Select the migration type page, select Google Workspace (Gmail) migration as migration type, and click Next.

    The Prerequisites for Google Workspace migration page appears.

  4. Verify that the Automate the configuration of your Google Workspace for migration section is expanded, and then select Start in that section to automate the four required prerequisite steps.

  5. In the Google sign-in page that appears, sign in to your Google account to validate your APIs.

    Once the APIs are successfully validated, the following things happen:

    • A JSON file (projectid-*.json) is downloaded to your local system.

    • The link to add the ClientID and the Scope is provided. The ClientID and Scope are also listed for your reference.

  6. Select the API access link. You'll be redirected to Google Admin API Controls page.

  7. Select Add new. Copy the ClientID and Scope from the EAC, paste it here, and then select Authorize.

  8. Once the four prerequisites-related steps are completed, select Next. The Set a migration endpoint page appears.

  9. Select one of the following options:

    • Select the migration endpoint: Select an existing migration endpoint from the drop-down list.

    • Create a new migration endpoint: Select this option if you're a first-time user.

If you've selected Create a new migration endpoint, do the following steps:

  1. On the General Information page, configure the following settings:

    • Migration Endpoint Name: Enter a value.

    • Maximum concurrent migrations: Leave the default value 20 or change the value as required.

    • Maximum concurrent incremental syncs: Leave the default value 10 or change the value as required.

    When you're finished, select Next.

  2. On the Gmail migration configuration page, configure the following settings:

    • Email address: Enter the email address that you use to sign in to the Google Workspace.

    • JSON key: Select Import JSON. In the dialog box that appears, find and select the downloaded JSON file, and then select Open.

    Once the endpoint is successfully created, it will be listed in the Select migration endpoint drop-down list.

    • Select the endpoint from the drop-down list, and select Next. The Add user mailboxes page appears.

  1. Select Import CSV file and navigate to the folder where you've saved the CSV file.

If you haven't already saved or created the CSV file, create a CSV file containing the set of names of the users you want to migrate. You'll need its filename below. The allowed headers are:

  • EmailAddress (required): Contains the primary email address for an existing Microsoft 365 or Office 365 mailbox.

  • Username (optional). Contains the Gmail primary email address, if it differs from EmailAddress.

CSV

EmailAddress
will@fabrikaminc.net
user123@fabrikaminc.net

When you're finished, click Next. The Move configuration page appears.

  1. From the Target delivery domain drop-down list, select the target delivery domain (the subdomain) that was created as part of fulfilling the Google Workspace migration prerequisites in Exchange Online, and click Next.

  1. On the Schedule batch migration page, verify all the details, click Save, and then click Done.

Once the batch status changes from Syncing to Synced, you need to complete the batch.

Filtering Options for Google Workspace migration


REFERENCES

Last updated

Was this helpful?