How to sync Outlook calendar events to Google Calendar with Power Automate (create, update and delete)

In Power Automate, select Create and then Automated cloud flow. Give it a name such as Sync Outlook calendar events to Google Calendar.

Search for event and pick the Office 365 Outlook trigger When an event is added, updated or deleted. Select Create. In the trigger, open Calendar id and choose the calendar you want to sync (the video uses the default Calendar).

Add a Condition (under Control; select See more if you do not see it). On the left, pick Action Type from the trigger. Set it to is equal to and type added on the right. The trigger returns one of three action types: added, updated or deleted.

In the True branch, add the Google Calendar action Create an event and sign in with your Google account. Pick your Google calendar, then map the fields from the trigger:

• Start time: Start time with time zone
• End time: End time with time zone
• Title: Subject
• Description: Body
• Location: Location

Use the "with time zone" versions of the start and end times so the event lands at the right hour.

In OneDrive, create a new Excel workbook (the video names it Sync calendar to Google). Type two headers: Outlook Event ID and Google Event ID. Select them, choose Format as Table, pick any style and check My table has headers.

Every event has a unique ID in each calendar. Saving both IDs is what lets the flow find the right Google event later when you edit or delete it in Outlook.

Back in the True branch, after Create an event, add Add a row into a table (Excel Online (Business)). Set Location to OneDrive for Business, Document Library to OneDrive, pick your file and Table1. Under Advanced parameters, select both columns:

• Outlook Event ID: Id from the trigger
• Google Event ID: Event ID from Create an event

In the False branch of the first condition, add a second Condition: Action Type is equal to updated. In its True branch:

• Add Get a row (Excel Online (Business)) on the same file and table. Set Key Column to Outlook Event ID and Key Value to Id from the trigger.
• Add the Google Calendar action Update an event. Pick the same calendar, set Event ID to Google Event ID from Get a row, and map Subject, Start time with time zone, End time with time zone, Body and Location as before.

In the False branch of the second condition, add a third Condition: Action Type is equal to deleted. In its True branch, add Get a row with Key Column Outlook Event ID and Key Value Id. The trigger only gives you the Outlook ID, so this lookup is how you find the Google ID.

Still in the deleted branch, add the Google Calendar action Delete an event, pick the calendar and set Event ID to Google Event ID from Get a row. Then add Delete a row (Excel Online (Business)) on the same table with Key Column Outlook Event ID and Key Value Id, so the table stays clean. Save the flow.

Select Test, choose Manually, and put both calendars side by side. Create an Outlook event: it appears in Google Calendar almost instantly and a new row appears in Excel. Change the title and time in Outlook: the Google event updates. Delete it in Outlook: it disappears from Google Calendar. A Teams meeting link in the Outlook event comes across in the description.

On the flow's page, the 28-day run history shows every time the flow ran and which branch it took. If you do not need the sync for a while, select Turn off to disable it without deleting it.