How to integrate Google Calendar with LINE WORKS to automatically notify your LINE WORKS every morning with your Google Calendar schedule

If you are already using Yoom, please log in to Yoom.
If you are new to Yoom, please create an account from here.

How to Connect Google Calendar and LINE WORKS Accounts to Yoom

First, we will register a My App to connect Google Calendar and LINE WORKS to Yoom.

Let's start by registering a My App for LINE WORKS.
It is listed on Yoom's help page, so please check here and connect it.

Next, we will register a My App for ChatGPT, but it is described on the help page, so please connect from here.

Next, we will register a My App for Google Calendar.
Once you have logged into Yoom, click "My Apps" → "New Connection" on the left side of the screen.
Search for Google Calendar from "Search by App Name" or find it from the app list.

Once you transition to the screen below, sign in to Google Calendar.

Once registration is complete, check if LINE WORKS and Google Calendar are displayed in your My Apps section.
If they are displayed, registration is complete.

How to Notify LINE WORKS of Google Calendar Events Every Morning

This time, we will create a flow bot that "notifies LINE WORKS of Google Calendar events every morning".
It can be created in the following 4 steps.

1. Set a schedule trigger to activate at 8 AM every day
2. Set to retrieve a list of today's events
3. Set to generate text for message sending
4. Set an action to send a message to a specific user

We will use the following template to create the flow bot, so please click "Try it".

To change the "Title" and "Description," click on the respective parts to modify them.
Next, to set up the schedule trigger that activates daily at 8 AM, click on the part labeled "Daily at 8 AM."

Once you transition to the following screen, check the settings and if there are no issues, click "Save."

• "Schedule Trigger Title" → Can be changed by yourself
• Days of the week → Check Mon~Sun
• Time → 8 (Specify the time you want to activate the flow bot with a number from 0 to 23. You can specify multiple times separated by commas. *Minute-level specification is not possible.)

You can check the schedule trigger setup method here.
If you want to set it by the minute, please check here.

Next, to set up obtaining a list of today's schedule from Google Calendar, click there.
Once you transition to the following screen, check the settings.

• "Title" → Can be changed by yourself
• "Account information to link with Google Calendar" → Check for any mistakes
• "Action" → Obtain a list of schedules
  

Once you transition to the following screen, check the settings.

• "Calendar ID" → Check for any mistakes
• "The day before the start date of the period to be obtained" → {{yesterday_%Y-%m-%d}}
• "End date of the period to be obtained" → {{today_%Y-%m-%d}}

If there are no mistakes, click "Test" → "Test Successful" → "Save."

Next, to set up generating text for sending messages, click there.
Check the following settings.

• "Title" → Can be changed by yourself
• "Account information to link with ChatGPT" → Check for any mistakes
• "Action" → Converse
  

Once you transition to the following screen, the message content is already entered, so leave it as is.
Click "Test" → "Test Successful" → "Save."

Next, to set up sending messages to specific users in LINE WORKS, click there.
Once you transition to the following screen, check the settings.

• "Title" → "Can be changed by yourself"
• "Account information to link with LINE WORKS (API2.0)" → Check for any mistakes
• "Action" → Send a message to a specific user
  

Once you transition to the following screen, set the "Bot ID" and "User ID."
The "Bot ID" can be obtained by creating a bot in the Developer Console.
The "User ID" can be selected from candidates and also checked from "Personal Information" in the "Person Icon at the Top Right" on the LINE WORKS screen.
The "Message" can be changed by yourself, so enter it as you like.

This is a flow that automatically summarizes and transcribes the content of conversations on Zoom, and records it in a Google Spreadsheet.
It helps avoid missing parts of the conversation and allows for automatic management in Google Spreadsheet, thereby improving work efficiency!

Once you turn the trigger "ON," the setup is complete.

‍

Advanced Integration Flow of Google Calendar and LINE WORKS

This time, we explained the flow of "retrieving Google Calendar events every morning" → "sending notifications to LINE WORKS".
We introduce a template using LINE WORKS and Google Calendar as an advanced edition.

First, here's how to use a flow bot with LINE WORKS to "OCR PDF data stored in Google Drive, verify the content, add it to YoomDB, and notify LINE WORKS".

This is created through the following process.

1. When a new file or folder is created in a specific folder
2. Download the PDF file using the file ID obtained by the trigger
3. Extract text from images or PDFs
4. Request action from the person in charge
5. Add the obtained data to Yoom's database
6. Notify the specified talk room

It may seem like there are many steps when viewed in text, but you can set it up quickly using a template.
Since the person in charge is involved in the process, accurate data extraction is possible.

There are also other flow bots like the following.

The following is a flow using Google Calendar: "When an interview is scheduled in Gmail, add the information to Google Sheets and enter the event in Google Calendar."

This is created through the following steps.

1. When an interview appointment is made
2. Manipulate and transform data
3. Add the interview appointment
4. Retrieve values
5. Add the interview appointment to the schedule

By using this template, you can automatically add appointments to Google Calendar when an interview appointment is made.
This helps prevent input errors or omissions in the schedule.
Additionally, since interview appointments are added to Google Sheets, you can keep track of the interviewees.

There are other flows using Google Calendar, such as the following.

Please use it according to your tasks.

Summary

This time, we introduced a flow bot that "notifies LINE WORKS of Google Calendar events every morning."
By integrating Google Calendar with LINE WORKS, sharing schedules becomes easier and communication is facilitated.
There are many apps that can be integrated with Yoom, so please give it a try.
Additionally, a two-week free trial is available, so please try it out.