Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start the process of automatically saving Outlook Calendar events to Google Sheets, you first need to access Pabbly Connect. Open a new tab and navigate to www.pabbly.com/connect. This platform will facilitate the integration between your Outlook Calendar and Google Sheets.

If you are a first-time user, you can sign up for free. Pabbly Connect offers 100 free tasks every month, allowing you to test the integration without any cost. Once you log into your account, you can begin creating your workflow.

2. Creating the Workflow in Pabbly Connect

After logging into Pabbly Connect, you will need to create a new workflow. Click on the option to create a new workflow and name it appropriately, such as “Outlook to Google Sheets Integration”. This will help you identify the workflow later.

  • Select the trigger application as Microsoft Office 365.
  • Choose the trigger event as “Calendar Event Created”.
  • Click on the “Connect” button to establish a connection with Microsoft Office 365.

Once the connection is established, you will be prompted to give permission for Pabbly Connect to access your Outlook Calendar. Accept the permissions to continue.

3. Testing the Trigger for Event Creation

With the trigger set up, the next step is to test it. Create a new event in your Outlook Calendar to see if Pabbly Connect captures the event details correctly. For example, you can create an event titled “Sales Performance Review” scheduled for July 1, 2026, from 10:30 AM to 4:30 PM.

After saving the event, return to your Pabbly Connect dashboard. Click on the “Save and Send Test Request” button to check if the event details have been captured. You should see the event name, description, and time in UTC format.

4. Formatting Date and Time for Google Sheets

Since the event details come in UTC format, you need to convert this to a readable format for Google Sheets. In this step, Pabbly Connect allows you to format the date and time easily. Add an action step and select “Date Time Format by Pabbly” as the application.

  • Map the UTC date and time from the previous step.
  • Set the from format as UTC and the to format as your desired local time format.
  • Select the time zone as Asia/Kolkata for accurate time representation.

Once you have configured the date and time format, click on “Send Test Request” to ensure the formatting works correctly.

5. Saving Event Details to Google Sheets

The final step is to save the formatted event details into Google Sheets. In this section, you’ll again use Pabbly Connect. Select Google Sheets as your action application and click on “Sign in with Google” to connect your Google account.

Choose the spreadsheet where you want to save the event details. Map the fields such as event date, subject, and description into the corresponding columns in your Google Sheet. After setting everything up, click on “Send Test Request” to verify if the data is being saved correctly.

Once the test is successful, you will see that the event details have been added to your Google Sheets. This automation ensures that every new event created in your Outlook Calendar is recorded in your Google Sheets automatically, streamlining your workflow.

Conclusion

Using Pabbly Connect, you can seamlessly integrate your Outlook Calendar with Google Sheets to automatically save event details. This process saves time and ensures that all important events are recorded efficiently.