How to register an event in a specified user's calendar in Outlook when a row is added in Google Sheets

Before Getting Started

First, if you don't have a Yoom account, please create one on the Yoom Account Creation Page. You can start right away!
Also, please check Getting Started with Yoom for basic operations.

Step 1: Register and Connect Google Sheets and Outlook to My Apps!

(1) After logging into Yoom, select "My Apps" from the left menu and choose "+ New Connection".

(2) From the list of new connections in My Apps, click on Google Sheets.
(3) Click "Sign in with Google".

‍

(4) Next, connect Outlook. As in step (1), click on Outlook from the list of new connections in Yoom.
(5) Log in with your account from the sign-in screen.

If Google Sheets and Outlook are registered in My Apps, the connection is complete!
Next, let's set up triggers using templates.

Step 2: Set Up App Triggers!

(1) We will use the templates introduced earlier. Click "Try it" on the banner below.

Click on "When a row is added" for the app trigger.

(2) From the screen to select the Google Sheets integration account and action, check that there are no errors in the account information linked to Google Sheets, keep the trigger action as "When a row is added," and click "Next."

(3) From the API connection settings of the app trigger, select the trigger interval from the dropdown, and choose the spreadsheet ID and sheet ID from the options.
※ Trigger interval → You can choose from intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
※ The selectable trigger intervals vary depending on the plan.

Scroll further down and enter the table range (start), table range (end), and the column with unique values.
※ This is not a selection format. Please enter directly.

Once the input is complete, click "Test," and if no errors occur, click "Save."

Step 3: Let's integrate with the app!

‍

(1) Next, integrate with Outlook.
Click on "Register an event in the specified user's calendar."

(2) From the screen to select the Outlook integration account and action, check that there are no errors in the account information linked to Outlook, keep the action as "Register an event in the specified user's calendar," and click "Next."

(3) From the API connection settings screen, enter or select from the output the title, start date and time, and end date and time.

Scroll further down and select the user ID from the options.
Other fields are not mandatory. Please fill in the necessary parts as needed.

Once the input is complete, click "Test," and if no errors occur, click "Save."

Step 4: Let's operate the database!

(1) Next, operate the Google Sheets database.
Click on "Update record."

(2) From the database integration screen, check that there are no errors in the account information linked to Google Sheets, keep the execution action as "Update record," and click "Next."

Scroll further down and enter the spreadsheet ID, spreadsheet tab name, and table range.
Once the input is complete, click "Next."
※ The spreadsheet ID can be selected from the options.

(3) From the detailed settings screen for database operations, select the condition for the record you want to update from the dropdown or output. By clicking +, you can add conditions for the record you want to update.

(4) Scroll further down and select the value of the record after the update from the output.
Once the selection is complete, click "Test," and if no errors occur, click "Save" at the bottom.

(5) Finally, change the email trigger from OFF to ON.

With this, the flowbot "When a row is added in Google Sheets, register an event in the specified user's calendar in Outlook" is complete. Well done!

Other automation examples using Google Sheets and Outlook

There are many other automation examples using Google Sheets and Outlook on Yoom, so here are a few introductions.

1. Send to Outlook when an employee is registered in SmartHR

This template is recommended for HR or administrative staff who want to share employee registration with Outlook to proceed with onboarding procedures. By integrating SmartHR with Outlook, when employee information is registered in SmartHR, a notification can be automatically sent from Outlook to the person in charge.
By using it, you can expect to reduce the manual effort of sending emails to each person in charge.
Additionally, the recipient, subject, and body of the notification email can be freely customized, which will be helpful in streamlining the onboarding process.

2. When an email is received in Outlook, extract and summarize the content using AI, then notify Microsoft Teams

This template allows AI to automatically summarize the content of an email when it is received in Outlook and send a notification to Microsoft Teams. It is recommended for those who are often out and find it difficult to check emails. Without opening each email, you can easily grasp the content just by opening Microsoft Teams, enabling efficient information management.

3. Add a record to kintone when a row is added in Google Sheets

This template automatically adds the same information as a record in kintone when a row is added in Google Sheets. For example, simply entering data into Google Sheets will automatically reflect in kintone as well. Furthermore, by integrating with applications other than kintone, it is possible to centralize information across multiple systems.

Summary

In this article, we introduced how to integrate Google Sheets with Outlook.
By integrating Google Sheets with Outlook, you can manage your schedule smoothly!
Yoom is a no-code tool that is easy for beginners to set up and can be flexibly customized by integrating with various apps.
If you are looking to "improve your team's work efficiency," be sure to take advantage of Yoom!
You can try it for free for two weeks using the form below.

Free Registration for Yoom