This repo contains code for 3 Azure Logic Apps to sync the e-mails and calendar between M365 and GSuite.
Here are the steps:
- Go to the Azure Portal
- Search for "Deploy a Custom Template"
- Click "Build your own template in the editor"
- Click "Load File" and select
./az-logicapp/1-azuredeploy-connections.json - Edit parameters and deploy
- Open the resource group and select each resource. Fix/authorize the connection for each resource
- Repeat steps 1-5 but for
./az-logicapp/2-azuredeploy-connections.json
Note
I initially attempted to create a single ARM template for this but I have yet to figure out how to make the logic apps deploy property without the API connections properly configured first.
This solution assumes that M365 is the primary productivity platform and GSuite is the secondary platform. For this use case, GSuite is seldom used. But we need it to:
E-mails received in Gmail are forwarded to M365.
- If the M365 e-mail address is in the recipient list, the e-mail is not forwarded.
- Label the e-mail with a prefix to know that the mail came from Gmail. This way, if you need to reply, you can go to Gmail to reply.
- Since M365 is the primary platform, e-mails received in M365 are not forwarded to Gmail.
Calendar events are synced two-way so that colleagues on both accounts have an accurate view of your availability.
- If the calendar event is marked as private, the contents of the invite are not synced.
- Add a prefix to the synced calendar event to indicate where the invite came from.
- Add a source calendar event ID as a suffix to the destination synced calendar event.
Limitations: GSuite Calendar to M365 Calendar
- Since Google calendar does not have a "private" flag, the details are synced as is.
Limitations: M365 Calendar to GSuite Calendar
- Since Google calendar only has a "Busy" or "Free" status, M365 calendar events marked as "Tentative" are created as "Busy" in Google calendar.