In this video, I’ll show you how to sync your Google Calendar events with your Outlook Calendar using Power Automate. If you’ve ever wanted your Outlook Calendar to update automatically whenever you add, update, or delete events on your Google Calendar, this video is for you.
Here’s how I do it: I set up a flow in Power Automate that tracks what’s happening on my Google Calendar and makes the same changes on my Outlook Calendar. It’s a one-way sync, so any changes you make on Google will appear in Outlook. I also use an Excel file to store the event IDs from both calendars to make this work. This helps the flow know which events to update or delete.
To get started, I opened Power Automate and created a new flow. I choose Google Calendar as the trigger, so the flow will run whenever I add, update, or delete an event. I connect my Google account, pick the calendar I want to sync, and set how often it should check for changes. For testing, I set it to check every 20 seconds, but for normal use, you might prefer a longer interval, like an hour.
Next, I convert the event times from Google Calendar into a format that Outlook can understand. This step ensures the times are accurate when they show up in Outlook. After that, I add an action to create events in Outlook. The flow pulls all the details—like the title, description, location, and time—from Google Calendar. If the event has a Google Meet link, I include it in the description.
To keep everything organized, I created an Excel file in OneDrive. This file has two columns: one for Google Event IDs and one for Outlook Event IDs. Whenever a new event is created, the flow saves the IDs in this file. That way, when it’s time to update or delete an event, the flow knows exactly which event to change.
For updates, the flow looks up the event in Outlook using the ID stored in the Excel file. Then, it updates the event with the latest details from Google Calendar, such as time changes or descriptions.
For deletions, the flow finds the event in Outlook, deletes it, and removes the corresponding row in the Excel file.
Once I set everything up, I tested the flow by creating, updating, and deleting events on Google Calendar. I also checked my Outlook Calendar and the Excel file to make sure everything was working perfectly. I also reviewed the flow’s run history in Power Automate to see if it was running smoothly.
This setup is a one-way sync from Google Calendar to Outlook. If you want to learn how to do the reverse—sync Outlook Calendar events to Google Calendar—check out this video: [ Ссылка ]
Chapters:
0:00 Introduction
33:00 Open Power Automate
46:00 Create a New Automated Cloud flow
1:38 Trigger to fetch actions from Google Calendar
2:05 Convert date and time
3:53 Check if an event is created on Google
4:43 Create the event on Outlook
6:12 Store events IDs in Excel file
9:54 Fetch the Google Meet link
11:24 Check if an event is updated on Google
12:49 Update events as on Google Calendar
14:16 Check if an event is deleted on Google
15:03 Delete the event on Outlook
16:20 Test the floe for new events, updated events and deleted events
18:03 Turn off the Power Automate flow when not necessary
18:18 Understand the complete process
Subscribe to the channel:
[ Ссылка ]
Follow and engage on social media:
Facebook: [ Ссылка ]
Instagram: [ Ссылка ]
#sync #googlecalendar #outlook #powerautomate #automate #flow
