How to integrate Google Sheets with Outlook to automatically create calendar events in Outlook when events are registered in Google Sheets.

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

Recommended for

Those who want to automatically upload files attached to Gmail to Dropbox
Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".

No complicated settings or operations are required, and even non-engineers can easily achieve it.

You can start right away using the template below, so please give it a try!

We introduce an automation recommended for those who create calendars using Google Sheets and Outlook.
This time, we will introduce the setup of a flow bot that "automatically creates a calendar in Outlook when a row is added in Google Sheets."
By using this automation, sharing calendars will become smoother, reducing the risk of scheduling conflicts on the same day.

Benefits of Integrating Google Sheets and Outlook

Here are two benefits of integrating Google Sheets and Outlook.

Benefit 1: Time-saving

By integrating and automating Google Sheets and Outlook, you can be freed from manually setting schedules, leading to time savings.
By reducing the number of times you input schedules and simplifying schedule management, you can efficiently focus on other tasks.

Benefit 2: Smoother Calendar Sharing

Another benefit of these app integrations is smoother calendar sharing.
For example, when a sales representative inputs a meeting schedule with a client into Google Sheets, it is automatically reflected in Outlook.
This allows, for example, the sales team to smoothly check meeting information, making it easier to coordinate schedules among representatives, and also helps prevent forgotten appointments and double bookings.

[About Yoom]

How to Create a Google Sheets and Outlook Integration Flow

This time, we will introduce how to set up the following template: "When a row is added in Google Sheets, create a calendar in Outlook."
By using this template, you don't need to set up automation from scratch, which is convenient.

The setup only takes 3 steps, so it can be completed in 10-15 minutes.

Set up a flow bot that triggers when a row is added
Set up an action to create a calendar
Set up an action to update a record

If you are not using Yoom, please register for free here.
If you are already using Yoom, please log in.

How to connect Google Sheets and Outlook with Yoom

Register your My Apps to connect Google Sheets and Outlook with Yoom.
Registering My Apps in advance makes subsequent automation settings easy.

First, let's register Google Sheets in My Apps.
Click "My Apps" → "New Connection" on the left side of the Yoom screen.
Search for Google Sheets from "Search by App Name" or find it from the "App List".

The following screen will be displayed, so please log in to Google Sheets.

Next, register Outlook in My Apps, and select Outlook as you did earlier.
When the following screen appears, sign in.

If Google Sheets and Outlook are displayed in your My Apps section, the My Apps registration is complete.

How to create a calendar in Outlook when a row is added in Google Sheets

To set up automation, click "Try it" on the banner below.

Read the following screen display and click "OK".

The following screen will be displayed, so please check the "Title" and "Description".
If you want to make changes, you can do so from the following page.
First, start with the Google Spreadsheet settings, and click "When a row is added".

When the following screen is displayed, check the settings.

"Title" → Can be changed as needed
"Account information to link with Google Spreadsheet" → Check if the account is correct
"Trigger Action" → When a row is added

The following screen will be displayed, so read the setup instructions and proceed to the next setup.

Move to the Google Spreadsheet screen and enter a schedule for testing.
As an example, it was set as follows.

Return to the Yoom screen, scroll down, and make the following settings.

"Trigger Interval" → Choose from 5 minutes, 10 minutes, 15 minutes, 30 minutes, 60 minutes
"Spreadsheet ID", "Sheet ID" → Select from candidates or read the description and enter
"Table Range (Start)" → In this case, A
"Table Range (End)" → In this case, E
※ Specify the alphabet of the column where the items end
"Column with Unique Values" → Specify the column with non-duplicate values
※ Be sure to specify a column with unique values. If values are duplicated, it may not work correctly. In this case, we specified C for the name column.

Click "Test" → "Test Successful" → "Save".
Check if the Google Spreadsheet output is displayed correctly.

Next, set up Outlook by clicking "Create Calendar".
When the following screen is displayed, check the settings.

"Title" → Can be changed as needed
"Account information to link with Outlook" → Check if the account is correct
"Action" → Create Calendar

The following screen will be displayed, so please check the settings.

"User ID" → Select from candidates
"Calendar Title" → Set optionally
※ If you use the Google Spreadsheet output as follows, the calendar title will be updated automatically.
Click the red frame to use the Google Spreadsheet output set earlier.
{{Name}}← The output will be displayed like this.

Click "Test" → "Test Successful" → "Save".

Next, set up to update the Google Spreadsheet row by clicking "Update Record".
When the following screen is displayed, make the settings.

"Title" → Can be changed as needed
"Account information to link with Google Spreadsheet" → Check if the account is correct
"Execution Action" → Update Record

Scroll and click "Database Integration".
Read the description and make the settings.

The following screen will be displayed, so set the "Conditions for the record you want to update".
Here, use the unique value entered at the trigger point to search for the target record.
As an example, it was entered as follows.

Scroll and read the description to set the "Value of the record after update".
Since we want to update the calendar ID obtained from Outlook, use the Outlook output for "Calendar ID".
Click "Test" → "Test Successful" → "Save".

Finally, click "Turn on Trigger" to complete the automation setup.

Other examples of automation using Google Spreadsheet and Outlook

1. This is a flow where an event is automatically registered in your calendar in Outlook when a row is added in Google Spreadsheet.
It is similar to the template introduced this time, but this template registers an event in your own calendar.

2. This is a flow that automatically registers an event in a specified user's calendar in Outlook when a row is added in Google Sheets.
Since the schedule is automatically registered in the specified user's calendar, it is recommended for those who are collaboratively registering schedules.

3. This is a flow that automatically sends an email via Outlook when a row is added to a Google Spreadsheet.
You can quickly check the information registered in the Google Spreadsheet.

Summary

This time, we set up a flowbot to "create a calendar event in Outlook when a row is added in Google Sheets." By integrating Google Sheets and Outlook, you can save the trouble of entering schedules and manage them efficiently. Be sure to use other templates to further improve your work efficiency.

If you are considering introducing Yoom, you can register for free here.