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

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

When a response is submitted to the Yoom form, an event is added to Google Calendar and a notification is sent to Slack. This flow allows for seamless automation from calendar addition to notification using only the form response.‍

See details

When reservation information is submitted via Google Forms, schedule it in Google Calendar and add that information to Google Sheets.

This is a flow that synchronizes meeting reservation information from Google Forms to Google Calendar and automatically adds it to Google Sheets. Without having to manually check the responses from Google Forms, events are automatically added to Google Calendar, eliminating any omissions or oversights in event creation. Additionally, while normally setting up Google Forms responses to be added to a specific Google Sheet requires configuration through GAS, this allows you to add information to any Google Sheet without such complex settings.‍

See details

Notify Slack of Google Calendar events every morning.

A flow bot that retrieves today's schedule registered in Google Calendar at a specified time every morning and notifies Slack. Based on the list of event titles and start times obtained from Google Calendar, a message for sending is created using ChatGPT and sent to Slack. You can freely change the information of the channel to be notified and the calendar to be linked. It is also possible to send it to your own DM.‍

See details

When a task is added in Asana, register the task's due date in Google Calendar.

This is a flow bot that registers the due date of a task as an all-day event in Google Calendar when a task is added to a specific section in Asana. When a task is added in Asana, it retrieves the assignee information and registers the event in the assignee's Google Calendar. You can check the task on Google Calendar without logging into Asana.‍

See details

When an event is created in Google Calendar, add it to Notion and send an email.

By using Yoom's workflow, new events created in Google Calendar are automatically added to Notion, and email notifications are sent to relevant parties. This streamlines schedule management and information sharing, enhancing team collaboration.

See details

See all templates