How to sync Office 365 / Google Apps calendars because Google Assistant can't access calendar?

Question

I decided last week to move off of iOS and picked up a new Google Pixel. My Google login account is a paid Google Apps account associated with my primary email address. I no longer use Google Apps for email/calendar, having switched to Office 365. For a variety of complex reasons, I'm not able or willing to consider switching back, so please don't suggest it as a solution. I keep the Apps account because there are many other Google services I still use that are associated with that Apps account, while the MX and related records point away to Office 365.

However, apparently Android does not allow you, at the system level, to login to two accounts that happen to have the same username. I have a Google Apps account with my primary email address, and that's successfully logged in. I try adding an Exchange/Office 365 account but get an error saying I already have an account with that username.

Now day-to-day, I couldn't care less because I use the Microsoft Outlook app for my email and calendar on Android. I don't use the Google-provided email and calendar apps. However, it seems Google Assistant can only utilize calendar data from accounts logged in at the system level, and the Outlook App only syncs contact data back to the system.

Google Assistant, it seems unless I'm mistaken, can't be configured to pull calendar data from other apps.

And I can't login at the system level with my Office 365 account.

Possible solutions:

1. Change the username of my Google Apps account. Not even sure if this will be possible, but I suppose it's an option.

2. Sync my Office 365 calendar to Google Apps so Assistant will have the data available to it. No idea what tools can do this. I know I can share calendars with Google Calendar via ICS, but Google only pulls for ICS updates once or twice a day. I need my calendar to be live. I would need a solution that is web app based; if I have to depend on desktop Outlook plugins, I can't expect the calendar data sent over to Google to be current when I'm away from desk (an astronomical percentage of my time). Note that my Outlook calendar is broken into two different calendars: the primary one, and a second that gets fed automatically via ICS from Kayak (my travel calendar). I have no way to consolidate that so it's all on one.

3. What else can I do? What options am I not thinking about?

Please, help me through this!

Answer 1

I completely agree about Microsoft Flow. It's the only working way I've found to integrate Outlook 365/Outlook.com integration with Google Calendar). Microsoft Flow is a service similar to IFTT, except geared to work with Office 365 services (and IFTT can't do this).

Here's a bit more information:

The free level of Flow allows for 750 "events" per month. Events are triggered when a change is made on either of the calendars, so unless you update your calendar an average of more than 25 times per day you will be OK.

You will need to sign up for the free service and activate two "templates":

Either: "Google Calendar to Outlook 365 Online Calendar" & "Outlook 365 Online Calendar to Google Calendar" sync

OR: "Google Calendar to Office.com Calendar" & "Office.com Calendar to Google Calendar". Depending which one you use.

As you may know, if you have Office 365 Online, it can also be linked to an Outlook.com address, so you can have the same synced calendar on both services, if you use both.

Use this Bit.ly link to check out the various templates related to Outlook: https://flow.microsoft.com/en-us/templates/?category=eventsAndCalendar&sort=properties/statistics/instantiations Again, you will need to sign up for the free account before you can use them.

Also, you can see a really helpful step by step guide to setting it up here: https://shift.newco.co/sync-your-calendars-using-microsoft-flow-and-yes-google-calendar-works-too-a28be5a604dd

Answer 2

Try Microsoft flow... It is design to automatically create events in google calendar when an event is created in outlook 365 calendar. I tried it and works live ! Here is the link

https://flow.microsoft.com/en-us/galleries/public/templates/10c5a140c24811e6b5549975d228694f/create-new-events-on-google-calendar-from-office-365/

Answer 3

I think the trouble with syncing calendars is that you will get reminders popping up twice for every appointment you have. I had this for a whole and it gets really annoying. I wonder, if you create an email alias for one of your accounts does that then allow you to sign in using that as the username? Worth giving it a try.