Add a Google Calendar event based on the responses from the reservation form and send a notification to Slack.

No items found.

■Overview

This flow adds an event to Google Calendar and notifies Slack when a response is submitted to a Yoom form.

You can automate the entire process from adding to the calendar to notification with just the form response.

‍

■Preparation

・You need to register (link) your My Apps with the apps you will use in advance. Below is a reference guide for linking.

※There may not be a detailed guide available for apps that can be linked simply.

https://intercom.help/yoom/ja/collections/3041779

・To set the end time in Google Calendar, you need to calculate the end time from the start time using a function in a spreadsheet.

※In this case, a function is set to obtain the time one hour after the start. Depending on the function settings, you can also set it to 30 minutes or more than an hour.

‍

■Spreadsheet with the actual function set (view-only access. Please copy if you wish to use it.)

https://docs.google.com/spreadsheets/d/1R3J9RioMYRQvRJEhyaYcUo4y5QKCOVC9C-O6Y5JYWnA/edit#gid=0

‍

■Creation Method

① Select the form trigger, set the following, and save.

・Each question item: Set the question items such as name, contact information, desired date, and time for the reservation form.

・Obtained values: You can enter demo values on the next page. Please enter demo values as they will be used in the subsequent test.

※There is no data type for time, so set it as text format and include instructions in the description field, such as "Please enter in the format of half-width numbers and : like 15:00".

※For detailed form settings, please refer here. https://intercom.help/yoom/ja/articles/8009267

② Press the + mark under the trigger, select Google Spreadsheet from the operations to link with the app, set the following, and test and save.

・Action: Enter value in cell

・Spreadsheet ID: Click the field and select the prepared spreadsheet containing the function from the displayed candidates.

・Sheet name: Click the field and select the target sheet from the displayed candidates.

・Target cell: Set the cell to enter the start time obtained from the form. In this example, it is set to A2.

・Value: Embed the start time obtained from the form in ① like {{○○}}. (Embed the output)

The end time is required when setting up Google Calendar later. This operation is necessary to calculate the end time from the start time using a function in the spreadsheet.

※For embedding the output, please refer here. https://intercom.help/yoom/ja/articles/8223528

③ Press the + mark, select Google Spreadsheet from the operations to link with the app, set the following, and test and save.

・Action: Retrieve value

・Spreadsheet ID: Click the field and select the prepared spreadsheet containing the function from the displayed candidates.

・Sheet name: Click the field and select the target sheet from the displayed candidates.

・Range: Set the range of the cell where the end time is reflected by the function. In this example, it is set to B2.

・Direction: Select column direction.

This operation allows you to retrieve the end time reflected by the function.

④ Press the + mark, select Google Calendar from the operations to link with the app, set the following, and test and save.

・Action: Create event

・Calendar ID: Click the field and select the ID you want to reflect from the displayed candidates. (Usually, it will be the address of your Google account)

・Event title: Enter the event title. You can also embed the value obtained from the form in ①.

・Event start date: Embed the date value obtained from the form in ① like {{○○}}.

・Event start time: Embed the time value obtained from the form in ① like {{○○}}.

・Event end date: Embed the date value obtained from the form in ① like {{○○}}.

・Event end time: Embed the end time value derived from the function obtained from the spreadsheet in ③ like {{○○}}.

・Event description (optional): Enter any description. You can also embed the value obtained from the form in ①.

⑤ Press the + mark, select Slack from the operations to link with the app, set the following, and test and save.

・Action: Send message to channel

・Channel ID to post to: Click the field and select the channel you want to send to from the displayed candidates.

・Message: Enter any message. You can also embed the values obtained so far as shown below.

ーーーーーーーーーーーーーーーーーーー

A meeting reservation has been made.

-----

・Name: {{Name}}

・Schedule: {{Desired date}} {{Desired start time}}

・Questions: {{Questions for the day}}

-----

ーーーーーーーーーーーーーーーーーーー

‍

このテンプレートを試してみる

How to request materials and apply for a demo

Here

Here are some Similar Templates!

Issue a Zoom meeting URL from the Yoom database and add it to Google Calendar.

Issue a Zoom meeting URL from the Yoom database and automatically add it to the specified Google Calendar. The Zoom meetings to be issued and the information to be added to Google Calendar can be created based on the information registered in the Yoom database.‍

See details

Notify LINE WORKS of Google Calendar events every morning.

This is a flow bot that retrieves today's schedule registered in Google Calendar at a specified time every morning and notifies LINE WORKS. Based on the list information of the event titles and start times obtained from Google Calendar, a message for sending is created with ChatGPT and notified to the LINE WORKS talk room. You can freely change the information of the talk room to be notified and the calendar to be linked. It is also possible to send to a talk room with only yourself and the bot.‍

See details

Retrieve the list of events from Google Calendar and transfer them to Google Sheets.

This is a flow that starts at a specific date and time, retrieves a list of events from Google Calendar, and transfers them to a Google Spreadsheet. By automatically retrieving the list from Google Calendar and transferring or notifying, information sharing becomes smoother, and it also helps prevent any omissions in sharing.

See details

Notify Chatwork of Google Calendar events at a specified time every day.

A flow that retrieves events registered in Google Calendar at a specified time every day and notifies them in Chatwork. Since the events registered in Google Calendar are reflected in real-time, schedule management becomes more efficient, and the latest schedule can be shared with the entire team.

See details

When a response to a leave request is submitted in the Yoom form, an approval request is automatically made, and once approved, the event is added to Google Calendar. This flow automates the process from approval to event registration, enhancing work efficiency. By automatically adding events, the accuracy of schedule management is improved.

See details

Automatically sync Google Form responses with Google Calendar and Garoon Calendar.

When an event is registered in Google Calendar, it is automatically added to the Garoon calendar as well. Since the event is automatically registered in the Garoon calendar, it helps prevent any missing or overlooked information.

See details

See all templates