Google Workspace Migration
Migrate from Google Workspace to Microsoft 365 with comprehensive support for Gmail, Google Drive, Calendar, and Contacts. OpsPilot365 provides automated user mapping, incremental synchronization, and coexistence support during the transition period.
Note: Migration uses Google Workspace Admin APIs with service account authentication. Domain-wide delegation must be enabled to access user data. The migration process preserves folder structures, labels, sharing permissions, and metadata where possible.
Migration Scope
- Gmail — All email messages, Labels to Folders, attachments, read/unread status
- Drive — My Drive to OneDrive, Shared Drives to SharePoint, sharing permissions, Google Docs to Office format
- Calendar — Primary calendar, recurring events, attendees and responses, meeting details
- Contacts — Personal contacts, contact groups, contact photos, custom fields
Prerequisites
- Create Google Cloud Service Account — Create a service account in Google Cloud Console with domain-wide delegation enabled. Download the JSON key file for authentication. Required API scopes:
gmail.readonly,calendar.readonly,contacts.readonly,drive.readonly - Enable Domain-Wide Delegation — In Google Admin Console, authorize the service account client ID to access user data across the domain with the required API scopes.
- Prepare Microsoft 365 Target — Ensure target mailboxes exist in Microsoft 365 with appropriate licenses assigned. Users should have Exchange Online and OneDrive provisioned.
- User Mapping — Create a mapping file or use automatic matching to map Google Workspace users to Microsoft 365 accounts.
Data Mapping
| Google Workspace | Microsoft 365 | Notes |
|---|---|---|
| Gmail Labels | Outlook Folders | Multi-labeled emails duplicated to each folder |
| Google Drive (My Drive) | OneDrive for Business | Folder structure preserved |
| Shared Drives | SharePoint Document Libraries | Map to existing or new sites |
| Google Docs/Sheets/Slides | Word/Excel/PowerPoint | Converted to Office formats |
| Google Calendar | Outlook Calendar | Recurring events preserved |
| Google Contacts | Outlook Contacts | Contact groups mapped |
Google Docs Conversion
- Google Docs to Word — Formatting, tables, and images preserved. Comments and suggestions converted.
- Google Sheets to Excel — Formulas, charts, and conditional formatting converted. Complex formulas may need review.
- Google Slides to PowerPoint — Layouts, transitions, and speaker notes preserved. Embedded videos linked.
Warning: Google-specific features like add-ons, Apps Script, and Forms are not migrated. Review complex spreadsheets after migration for formula compatibility.
Migration Options
Email Options
- Migrate labels as folders — Convert Gmail labels to Outlook folders (Enabled)
- Include spam folder — Migrate messages from Gmail Spam (Disabled)
- Include trash — Migrate messages from Gmail Trash (Disabled)
Drive Options
- Convert Google formats — Convert Docs/Sheets/Slides to Office (Enabled)
- Preserve sharing links — Create redirect for shared URLs (Enabled)
- Include trashed files — Migrate files from Drive Trash (Disabled)
Coexistence Period
During migration, you may need to maintain both systems. OpsPilot365 supports incremental sync to keep data synchronized until cutover.
- Delta Sync — Run incremental migrations to sync new and changed items before final cutover
- Mail Forwarding — Configure Gmail to forward new mail to Microsoft 365 during transition
- Calendar Sync — Keep calendars synchronized bidirectionally until users fully transition
Best Practices
- Audit Google Workspace data and storage before migration
- Clean up unnecessary data to reduce migration time
- Create user mapping and validate accounts
- Test with pilot group first
- Communicate timeline to end users
- Monitor progress and address errors promptly
- Run delta syncs to capture new data
- Have rollback plan ready if needed
API Reference
POST /api/migration/google-workspace— Create Google Workspace migration