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

Open Power Automate at make.powerautomate.com (or from the app launcher in Outlook). Go to Create and select Automated cloud flow. Name it something like Sync Google Calendar events to Outlook calendar.

Search for Google and pick the Google Calendar trigger When an event is added, updated or deleted from a calendar, then click Create. Connect your Google account the first time you use it, and choose your calendar in Calendar id.

Under How often do you want to check for items? set the frequency and interval. In the video I use a short interval in seconds so the demo runs quickly. For everyday use, an interval such as 1 hour is fine.

This one trigger fires for all three kinds of change, and it returns the event title, description, start and end time, location and the action type.

Add the Convert time zone action from the Date Time group. Google Calendar and Outlook use different date formats, so this step puts the time in a format Outlook understands.

• Base time: the Start date time from the trigger
• Source time zone and Destination time zone: your local time zone (the video uses Chennai, Kolkata, Mumbai, New Delhi)
• Time unit: Sortable date/time pattern

Rename the action Start time. Add a second Convert time zone action with the same settings for End date time and rename it End time.

Add a Condition from the Control group. On the left pick Action type from the trigger, choose is equal to, and type added on the right. When a new event is created in Google, the flow goes into the True branch.

In the True branch, add Create event (V4) from Office 365 Outlook.

• Calendar id: Calendar (your main Outlook calendar)
• Subject: Title from the trigger
• Start time: the output of the Start time convert action
• End time: the output of the End time convert action
• Time zone: your local time zone

Open Advanced parameters and add Body and Location. Set Body to the trigger's Description and Location to the trigger's Location. If a field is missing from the dynamic content list, click See more.

In OneDrive, create a new Excel workbook online so the cloud flow can reach it. The video names it TG Sync Google Calendar events to Outlook. Type two headers: Google event ID and Outlook event ID. Select them, choose Format as Table, tick My table has headers and click OK. You can keep the default table name Table1.

This table is what makes updates and deletes possible later. It is the only place the flow can look up which Outlook event matches a Google event.

Still in the True branch, add Add a row into a table from Excel Online (Business). Set Location to OneDrive for Business, Document Library to OneDrive, pick the file and Table1.

Open Advanced parameters to show the columns:

• Google event ID: Event ID from the trigger
• Outlook event ID: Id from Create event (V4)

Save the flow. If Power Automate says the interval value is not valid, raise the trigger interval (the video changes it from 10 to 20 seconds) and save again.

Click Test, choose Manually, then create an event in Google Calendar with a location, a description and a Google Meet link. After the next check, the event appears in Outlook and a new row with both IDs appears in the Excel table.

You will notice the Google Meet link is missing from the Outlook event. The next step fixes that.

The trigger's raw output contains the meeting link as hangoutLink in the body, but it does not show up in the dynamic content list. Edit Create event (V4), put your cursor at the start of Body, press Enter to make room, and use Insert expression to add:

triggerOutputs()?['body/hangoutLink']

The expression reads the trigger output and pulls the Meet link from the body. Check the property name against your own trigger's raw outputs. Save and create another test event with a Meet link. The link now appears in the Outlook event body.

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 from Excel Online (Business). Point it to the same file and Table1, set Key Column to Google event ID and Key Value to the trigger's Event ID. The flow now finds the row and reads the matching Outlook event ID.

Add Update event (V4) from Office 365 Outlook.

• Calendar id: Calendar
• Id: Outlook event ID from Get a row
• Subject: Title from the trigger
• Start time and End time: the converted times
• Time zone: your local time zone

In Advanced parameters add Body and Location. In Body, insert the same triggerOutputs()?['body/hangoutLink'] expression, press Enter, then add Description. Set Location to the trigger's Location.

In the False branch of the second condition, add a third Condition: Action type is equal to deleted. In its True branch, add another Get a row with the same file, Table1, Key Column Google event ID and Key Value set to the trigger's Event ID. The trigger only gives you the Google ID, which is why you search on that column.

Add Delete event (V2) from Office 365 Outlook. Set Calendar id to Calendar and Id to Outlook event ID from the last Get a row.

Then add Delete a row from Excel Online (Business), pointing to the same file and Table1. Set Key Column to Google event ID and Key Value to Google event ID from Get a row. This keeps the table clean. Save the flow.

Put Google Calendar and Outlook side by side. Change the time and description of an event, add a new one, rename another and delete one. After the next check, Outlook shows the same events, times and names, and the deleted event is gone. Open the flow's run history to confirm each run succeeded.

This is an automated flow, so it keeps running. Use Turn off on the flow page when you do not need the sync.