GoogleフォームとGoogleカレンダーの連携イメージ
How to add an event to Google Calendar and send an email based on responses from a Google Forms reservation form
Learn more about Yoom
Try this template
GoogleフォームとGoogleカレンダーの連携イメージ
Flowbot Usecases

2025-07-17

How to add an event to Google Calendar and send an email based on responses from a Google Forms reservation form

s.nakazawa
s.nakazawa

Have you ever thought about streamlining the process of manually registering appointments in Google Calendar and sending emails via Gmail after accepting bookings through Google Forms? Not only is this manual work inefficient, but it also poses a risk of human error, which can delay customer service. However, by integrating tools, you can automate the process of scheduling and sending emails. This article introduces a no-code method to integrate Google Forms, Google Calendar, and Gmail, which can serve as a reference when aiming to improve business efficiency.

  • Companies using Google Forms, Google Calendar, and Gmail
  • Those using Google Forms, Google Calendar, and Gmail but facing challenges with manual input
  • Those aiming to speed up customer service by integrating Google Forms, Google Calendar, and Gmail

For those who want to try it immediately

In this article, we 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 immediately with the template below, so please give it a try!


■Overview

This is a flow where an event is added to Google Calendar and an email is sent when a response is made to a Google Form.

The entire process from adding to the calendar to sending an email can be automated with just the form response.

Preparation

It is necessary to register (link) 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 easily. https://intercom.help/yoom/ja/collections/3041779

・To set the end time in Google Calendar, it is necessary 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 1 hour after the start. Depending on the function settings, it is also possible to set 30 minutes or more than 1 hour.

※Here is the actual operation when the flow bot is activated https://youtu.be/M-gZDyO5dp0

[What is Yoom]

Now, let's introduce how to "add a schedule to Google Calendar based on responses from Google Forms and send an email" using the no-code tool Yoom.

How to Add a Schedule to Google Calendar Based on Google Forms Responses and Send an Email

This method can be realized by receiving responses from Google Forms using the Google Forms API and adding them to Google Calendar using the API provided by Google Calendar.

Additionally, by using the API provided by Gmail, you can also notify by email with the response information from Google Forms and the registration information from Google Calendar.

Generally, programming knowledge is required to achieve this, but with the no-code tool Yoom, it can be easily realized without programming knowledge.

We will create this in the following major processes:

  • Register Google Forms, Google Sheets, Google Calendar, and Gmail as My Apps
  • Copy the template
  • Set the trigger for Google Forms, which will be the starting point of the flow, followed by the settings for Google Sheets, Google Calendar, and Gmail
  • Turn on the trigger button and check the integration operation

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

Step 1: Integrate Google Forms, Google Sheets, Google Calendar, and Gmail with My Apps

First, register Google Forms, Google Sheets, Google Calendar, and Gmail with Yoom by adding them to My Apps.

1. Select "My Apps" on the left side of the Yoom management screen and click "+ Add".

__wf_reserved_inherit

2. On the following screen, search for Google Forms, Google Sheets, Google Calendar, and Gmail respectively and proceed to the next screen.

<For Google Forms>

__wf_reserved_inherit

・Sign in as above,  and click "Continue" to complete the registration in My Apps.

__wf_reserved_inherit

<For Google Sheets>

__wf_reserved_inherit

・Sign in as above and click "Continue" on the screen below to complete the registration in My Apps.

__wf_reserved_inherit

<For Google Calendar>

__wf_reserved_inherit

・Log in on the screen above, and click "Continue" to complete the registration in My Apps.

__wf_reserved_inherit

<For Gmail>

__wf_reserved_inherit

・Sign in as above, and click "Continue" to complete the registration in My Apps.

__wf_reserved_inherit

3. Copy the Template

Next, copy the template for integrating Google Forms, Google Sheets, Google Calendar, and Gmail.

・Open the link below.


■Overview

This is a flow where an event is added to Google Calendar and an email is sent when a response is made to a Google Form.

The entire process from adding to the calendar to sending an email can be automated with just the form response.

Preparation

It is necessary to register (link) 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 easily. https://intercom.help/yoom/ja/collections/3041779

・To set the end time in Google Calendar, it is necessary 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 1 hour after the start. Depending on the function settings, it is also possible to set 30 minutes or more than 1 hour.

※Here is the actual operation when the flow bot is activated https://youtu.be/M-gZDyO5dp0

・Click "Try this template" to complete the copy.

__wf_reserved_inherit

Step 2: Setting up the Triggering Google Form

Set up the trigger action that initiates the flow.
This flow is triggered when a response is submitted to the Google Form.

1. Select "My Projects" in the Yoom management screen and click "【Copy】Add Google Calendar event based on Google Form reservation form response and send email".
※You can change the template title on the next screen.

__wf_reserved_inherit

2. Click "App Trigger When a response is submitted to the form".

__wf_reserved_inherit

3. Verify the account linked with Google Form and click "Next".
※Other items are set by default.

__wf_reserved_inherit

4. Set the trigger activation interval and form ID, then click "Test".
※Trigger activation intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes are available, and the selectable time varies depending on the plan.
※The flow bot is activated once per selected interval when the trigger action is confirmed and executed. A short interval setting is generally recommended.

__wf_reserved_inherit

5. If the test is successful, the information obtained from the Google Form will be displayed in the output.
Add meeting-related content from "+Add value to obtain" in the output and save.
※By default, the obtainable outputs (values) are limited to "Response ID", "Last response date", and "Response creation date". To obtain response content, you need to add outputs using JSONPATH. The method for adding is explained on this help page.
※The meeting date must be in the format "2021-12-12" and the time in the format "13:00".

__wf_reserved_inherit

Step 3: Setting up Registration in Google Calendar

Next, set up registration in Google Calendar based on the responses submitted to the Google Form.
※Since Google Calendar requires setting an end time for meetings, if only the start time is obtained from the Google Form, you need to calculate and obtain the end time 30 minutes or 1 hour later via Google Sheets.
※In this case, a Google Sheet is created with the function set as follows to obtain the time 1 hour after the start. Depending on the function settings, it is also possible to set 30 minutes or more than 1 hour.

__wf_reserved_inherit

1. Click "Enter value in cell to link with app".

__wf_reserved_inherit

2. Verify the account linked with Google Sheets and click "Next".
※Other items are set by default.

__wf_reserved_inherit

3. Specify the cell to input the start time of the meeting responded in the form and conduct a test.
※Select the spreadsheet ID and sheet name from the "Candidates" displayed when clicking the frame. (Select the Google Sheet that calculates the meeting end time)
※Specify the cell to input the meeting start time.
※Set the value to the item obtained from the Google Form output (in the following, the meeting start time). (Values are displayed in double brackets)

__wf_reserved_inherit

4. Save if the test is successful.

__wf_reserved_inherit

5. Click "Get value to link with app".

__wf_reserved_inherit

6. Verify the account linked with Google Sheets and click "Next".
※Other items are set by default.

__wf_reserved_inherit

7. Set up to obtain the information of the cell where the meeting end time is input using a function and conduct a test.
※Select the spreadsheet ID and sheet name from the "Candidates" displayed when clicking the frame. (Select the Google Sheet that calculates the meeting end time)
※Specify the cell where the meeting end time is input.
※Set the direction to column.

__wf_reserved_inherit

8. Save if the test is successful.

__wf_reserved_inherit

9. Click "Create schedule to link with app".

__wf_reserved_inherit

10. Verify the account linked with Google Calendar and click "Next".
※Other items are set by default.

__wf_reserved_inherit

11. Set each item to register the schedule in Google Calendar.
※The calendar ID can be selected from the "Candidates" displayed when clicking the frame.
※Information about the meeting schedule can be selected from the output displayed when clicking the frame, such as "When a response is submitted to the form" or "Get value". This allows dynamic reflection of values that change for each form.

__wf_reserved_inherit

12. If the test is successful, the schedule will be registered in Google Calendar.
Save if there are no issues.

__wf_reserved_inherit

Step 4: Setting up Gmail Sending

Finally, set up to communicate details via Gmail.

1. Click "Send email Send email".

__wf_reserved_inherit

2. Verify the account linked with Gmail.
※Other items are set by default.

__wf_reserved_inherit

3. Set up the message to be sent and proceed to the next step.
※Select the recipient from the output displayed when clicking the frame, such as "When a response is submitted to the form".
※You can directly input a template in the body. You can also dynamically reflect values that change for each customer by selecting values from the output displayed when clicking the frame.

__wf_reserved_inherit

4. Conduct a test, and if successful, the message will be sent to the displayed recipient.
Save if there are no issues.

__wf_reserved_inherit

5. When the trigger is turned ON, the schedule will be automatically registered in Google Calendar and an email will be sent to the customer when a response is submitted to the Google Form.

__wf_reserved_inherit

If you have any questions about the introduced flow, please check this help page.


■Overview

This is a flow where an event is added to Google Calendar and an email is sent when a response is made to a Google Form.

The entire process from adding to the calendar to sending an email can be automated with just the form response.

Preparation

It is necessary to register (link) 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 easily. https://intercom.help/yoom/ja/collections/3041779

・To set the end time in Google Calendar, it is necessary 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 1 hour after the start. Depending on the function settings, it is also possible to set 30 minutes or more than 1 hour.

※Here is the actual operation when the flow bot is activated https://youtu.be/M-gZDyO5dp0

Other Automation Examples Using Google Calendar and Google Forms

In addition to the integrations introduced today, various automations can be achieved by utilizing the APIs of Google Calendar and Google Forms.

If you find something interesting, please give it a try!

Automation Examples Integrating Google Calendar and Google Forms

It is also possible to add an event to Google Calendar when a response is received to a Google Form.
You can also notify the chat tool when a response to a Google Form is registered in Google Calendar.


■Overview

This is a flow where when new interview reservation information is submitted to Google Forms, a reservation is created in Google Calendar and a notification is sent to Google Chat.

You don't need to manually check the response information in Google Forms, as interview reservations are automatically added to Google Calendar and notifications are sent to Google Chat, preventing any omissions or errors in scheduling.

■Notes

・Integration with Yoom is required for each of Google Forms, Google Calendar, and Google Chat.

・Integration with Google Chat is only possible with Google Workspace. For details, please refer to here.

・For information on how to retrieve response content when using Google Forms as a trigger, please refer to the following.

https://intercom.help/yoom/ja/articles/6807133


■Overview

This flow adds an event to Google Calendar when there is a response with schedule information in Google Forms.

You can streamline your work by automatically adding events to Google Calendar without having to manually check the responses in Google Forms, thus preventing any omissions or errors in schedule creation.

■Notes

・Integration with Google Forms, Google Calendar, and Yoom is required.

・Feel free to change the settings of the Google Calendar you are integrating with as needed.

・For information on how to retrieve response content when using Google Forms as a trigger, please refer to the link below.

https://intercom.help/yoom/ja/articles/6807133


■Overview

This is a flow where a Google Calendar is created and added to Slack when meeting reservation information is submitted via a Google Form.

By integrating with Google Calendar, you can create events on Google Calendar using new responses from Google Forms.

You don't need to manually check the Google Form responses, as events are automatically added to Google Calendar and notifications are sent to Slack, preventing any omissions or errors in event creation.

■Notes

・Please integrate Yoom with Google Forms, Google Calendar, and Slack respectively.

Examples of Automation Using Google Forms

Register the content submitted in Google Forms in a task tool

Automatically register the content submitted in Google Forms as a task in Trello, Asana, etc.


■Overview

This is a flow to register information entered in Google Forms into Trello.

■Recommended for

1. Those who collect information using input forms

・Companies using Google Forms

・Those who organize and aggregate collected information

2. Those who manage tasks with Trello

・Those managing project tasks with Trello

・Those adding Google Forms responses as tasks

■Benefits of using this template

Google Forms can be used as a form for surveys from users or inquiries from customers.
However, if you manage the responses from Google Forms as tasks, you might find the manual entry into tools time-consuming and cumbersome.

This template allows you to automatically register Google Forms responses into Trello, reducing the burden of manual entry.
Even if there are many responses to Google Forms, tasks can be added to Trello seamlessly, making task management more efficient.

Additionally, by integrating with chat tools, you can notify task additions to Trello, facilitating smooth task sharing.

■Notes

・Please integrate both Google Forms and Trello with Yoom.

・Refer to the following for how to obtain response content when using Google Forms as a trigger.

https://intercom.help/yoom/ja/articles/6807133

・You can select the trigger interval from 5, 10, 15, 30, or 60 minutes.

・Please note that the shortest trigger interval varies depending on the plan.


■Overview

This is a flow for registering information submitted via Google Forms into Asana.

■Recommended for

1. Those who collect information using Google Forms

・Those who use Google Forms for collecting survey or inquiry content

・Those who manage responses from Google Forms

2. Those who manage tasks using Asana

・Those who want to add Google Forms responses as tasks

・Those who centrally manage customer service tasks in Asana

■Benefits of using this template

Google Forms allows you to create custom forms tailored to your needs.
It can be utilized for collecting surveys or as an inquiry form, making information collection more efficient.

However, when it comes to task management, if you want to add Google Forms responses to a task management tool, manual input is required, which can be cumbersome.
This template allows you to automatically register Google Forms responses into Asana, reducing the burden of manual work.

By automating task registration in Asana, you can prevent manual input errors and omissions.

■Notes

・Please integrate both Google Forms and Asana with Yoom.

・Refer to the following for how to obtain response content when using Google Forms as a trigger.

https://intercom.help/yoom/ja/articles/6807133

・You can select the trigger interval from 5, 10, 15, 30, or 60 minutes.

・Please note that the shortest trigger interval varies depending on the plan.


■Overview

This is a flow for registering information submitted through Google Forms to GitHub.

■Recommended for

1. Those responsible for customer support

・Those who use Google Forms to consolidate inquiries from customers

・Those who utilize Google Forms as an inquiry form

2. Those who use GitHub as a task management tool

・Those who manage customer support tasks in GitHub

・Those who want to automatically link Google Form responses to GitHub

■Benefits of using this template

Google Forms can be used as a form for customer inquiries, allowing for efficient consolidation of responses.
Additionally, managing customer inquiries with a task management tool can help visualize the status of responses.

However, the registration process to the task management tool needs to be done manually, which may lead to input errors or omissions.
By using this template, you can automatically register the content submitted to Google Forms to GitHub, preventing input errors and omissions.

Automating the addition of tasks to GitHub speeds up customer support and improves operational efficiency.

■Notes

・Please integrate Google Forms and GitHub with Yoom.

・Refer to the following for how to obtain response content when using Google Forms as a trigger.

https://intercom.help/yoom/ja/articles/6807133

・You can select the trigger interval from 5, 10, 15, 30, or 60 minutes.

・Please note that the shortest trigger interval varies depending on the plan.

Notify a chat tool when a response is submitted on Google Forms

Automatically notify Slack, Discord, etc. when a response is submitted on Google Forms.


■Overview

This flow notifies Google Chat of the response content when a new response is submitted to a Google Form.

■Recommended for

1. Teams using both Google Forms and Google Chat

・Those who accept surveys or applications via Google Forms and want to notify Google Chat of responses in real-time

・Those who want to share response content with the team to promote prompt action and discussion

・Those who want to eliminate the hassle of manual notifications and information sharing

2. Individuals using Google Forms for information gathering

・Those who want to receive notifications in Google Chat when there is a response to their Google Form

・Those who want to immediately check the response content and take necessary actions

■Benefits of using this template

・Notifications are sent to Google Chat immediately after a new response is submitted to a Google Form, allowing for prompt action.

・Sharing response content in Google Chat facilitates smooth information sharing among team members, leading to efficient responses.

・Eliminating the need for manual notifications and information sharing improves work efficiency, allowing more time for other tasks.

■Notes

・Please integrate both Google Forms and Google Chat with Yoom.

・Integration with Google Chat is only possible with Google Workspace. For details, please refer to here.

・For information on how to obtain response content when using Google Forms as a trigger, please refer to the following: https://intercom.help/yoom/ja/articles/6807133


■Overview

This is a flow that notifies Discord of responses from Google Forms.

■Recommended for

1. Those who use Discord as their main communication tool

・Companies that use it to keep records of interactions within departments

・Team representatives who use it for information sharing

2. Those who use Google Forms for information gathering

・Customer service departments that want to collect surveys from seminar participants in advance

・HR representatives who utilize Google Forms for recruitment activities

■Benefits of using this template

Using Discord for information sharing within teams or departments is very effective for visualizing information and streamlining operations.
However, when responses from Google Forms are received at a specific email address, manually sharing that information on Discord can be a significant hassle.

This flow is effective for those who want to smoothly share responses obtained from Google Forms within their team.
Since it automatically notifies Discord of the content of Google Form responses, quick information sharing becomes possible.
Additionally, as the notification content is quoted from the response content, it prevents input errors in the content.

■Notes

・Please integrate both Discord and Google Forms with Yoom.

・For the method of obtaining response content when using Google Forms as a trigger, please refer to the link below.

https://intercom.help/yoom/ja/articles/6807133


◼️Overview

When a response is submitted via Google Forms, a notification will be sent to any designated Slack channel.

The target channel and message content can be customized as desired.

◼️Setup Instructions

1. Integrate Google Forms and Slack with Yoom. (My App Integration)

2. Set the form ID with the trigger "When a response is submitted to the form" and run a test.

3. Once the test is successful, you can retrieve the response information from the form. Select the information you want to obtain from the response using the [+] button and store it in the output.

4. In the "Notify Slack" operation, set the target channel and message content based on the response details obtained from Google Forms.

◼️Notes

・Account integration with both Google Forms and Slack is required.

・Please adjust the question settings in Google Forms as needed.

Examples of Automation Using Google Calendar

Link Google Calendar with Zoom

When an event is created in Google Calendar, you can automatically create a meeting in Zoom and automatically add the created link to Google Calendar.You can also automatically add a link to a completed meeting to Google Calendar.


■Overview
The workflow of "obtaining a recording link after a Zoom meeting ends and appending it to a Google Calendar event" allows for seamless management of online meeting records. By automatically acquiring the recording link of a meeting held on Zoom and adding it to the relevant Google Calendar event, follow-ups after meetings can be easily conducted.
This reduces the hassle of managing recordings and facilitates smooth information sharing.


■Recommended for

  • Business professionals who regularly use Zoom and Google Calendar
  • Team leaders who find managing online meeting recordings cumbersome
  • Sales representatives who want to streamline post-meeting follow-ups
  • Project managers who need to ensure meeting records are shared accurately

■Benefits of using this template

  • Time-saving: Eliminates the need to manually add recording links after meetings end.
  • Centralized information management: Allows you to check recording links in Google Calendar and access necessary information quickly.
  • Prevention of input errors: Automation prevents mistakes that can occur with manual entry.
  • Speeding up follow-ups: Recording links are shared immediately, ensuring smooth confirmation and sharing of meeting content.

■Overview

With this flow, you can create a Zoom meeting whenever an event is created in Google Calendar. This automation reduces the hassle of setting up meetings and allows you to use your time more effectively.
By using Yoom, you can easily connect apps without the need for programming.

■Recommended for

  • Business professionals who frequently use Google Calendar and Zoom
  • Those who want to automate schedule management and online meeting setup tasks
  • IT personnel at companies looking to improve operational efficiency and reduce manual tasks
  • Leaders who want to reduce the time spent on team meeting setups

■Benefits of using this template

  • Time-saving
    ・A Zoom meeting is automatically created just by adding an event to Google Calendar, reducing the time spent on setup.
  • Error prevention
    ・Prevents omissions and errors in meeting links due to manual settings, ensuring meetings are scheduled accurately.
  • Consistent operation
    ・Zoom meetings are created in a uniform format for all events, maintaining operational consistency.

■Overview
The flow "When an event is created in Google Calendar, automatically create a meeting in Zoom and add the meeting URL to the event" is a business workflow that streamlines meeting setup.
As remote work increases, it is important to quickly and reliably share Zoom meeting information.
By utilizing this workflow, a Zoom meeting is automatically created and the participation link is added to the event details simply by adding an event to Google Calendar.
This eliminates the need for manual setup work and allows for smooth meeting preparation.


■Recommended for

  • Business users who frequently use Google Calendar and Zoom meetings
  • Team leaders looking to automate repetitive meeting setup tasks to improve work efficiency
  • IT personnel in companies who want to facilitate smooth meeting operations in a remote work environment

■Benefits of using this template

  • Time-saving: By automatically generating Zoom meetings just by adding events to Google Calendar, you can reduce the time spent on setup.
  • Error prevention: Prevents mistakes and omissions when manually sharing meeting links, ensuring that all participants receive the link.
  • Consistent operation: Eliminates the hassle of setting up meetings with the same procedure each time, standardizing business workflows.

When an event is added to the database, register it in Google Calendar

When an event is added to Google Spreadsheet, Notion, etc., it will be automatically registered in Google Calendar.


■Overview

The workflow "Create events in Google Calendar based on Notion information" automates the task of creating events.
You can create events in Google Calendar with one click, linked with data on Notion.

■Recommended for

  • Those who use Notion to organize and manage information
  • Those who want to quickly grasp daily schedules
  • Those who want to improve work efficiency by integrating multiple tools
  • Those who manage schedules using Google Calendar
  • Those who find manual event entry cumbersome
  • Those who want to facilitate smooth information sharing within a team

■Benefits of using this template

By integrating Notion with Google Calendar, you can quickly check task and event information.
Using this flow makes task management more efficient and can lead to improved outcomes.

Additionally, the exchange of information between individual systems becomes seamless, making schedule management easier.
Information sharing among members is also promoted, which will enhance overall work efficiency.
This prevents overlooking important tasks and ensures smooth project progress.


■Overview

This is a flow to register events in Google Calendar using information registered in Airtable.

■Recommended for

1. Those who use Google Calendar for business

・Those who use it for visualizing team schedules

・Those who register task deadlines

2. Those who use Airtable for data management

・Those who use it for managing project schedules

・Those who manage tasks

■Benefits of using this template

Google Calendar is an effective tool for managing team schedules.
Additionally, by using Airtable together, centralized information management and task management become possible, facilitating smooth business operations.
However, manually entering information registered in Airtable into Google Calendar can be cumbersome and may lead to decreased work efficiency.

By utilizing this flow, events are automatically created in Google Calendar using information registered in Airtable.
By automating event creation and eliminating manual entry, you can avoid the risk of human error.
Moreover, since events are registered in Google Calendar without waiting for manual entry, it leads to quick information sharing within the team.

■Notes

・Please connect both Google Calendar and Airtable with Yoom.

・You can select the trigger interval from 5, 10, 15, 30, or 60 minutes.

・Please note that the shortest trigger interval varies depending on the plan.


■Overview

This flow retrieves information when an event is added to a Google Spreadsheet and registers the event in Google Calendar as well.

■Recommended for

・Those who use Google Spreadsheets and Google Calendar

・Those who synchronize Google Spreadsheets and Google Calendar using GAS

・Those who want to efficiently link Google Spreadsheets and Google Calendar to improve work efficiency

■Benefits of using this template

・Information is added to Google Calendar along with the registration of information in Google Spreadsheets, reducing manual operations.

・It also prevents omissions in adding to the calendar.

Notes

・Please link Google Spreadsheets, Google Calendar, and Yoom.

・It is necessary to connect Google Spreadsheets and the Yoom database via Data Connect. Please refer to the following for details.

https://intercom.help/yoom/ja/articles/8309502

Examples of Automation Using Gmail

Send canned emails in Gmail from the lead detail page

Send canned emails from your customer management pages, such as Salesforce or HubSpot.


■Overview

This is a flow that automatically sends emails via Gmail using information from a Notion database.

■Recommended for

1. Those who manage customer information or tasks in Notion

・Those who want to automatically send emails via Gmail for regular customer contact or task deadline notifications based on information registered in the Notion database

・Those who want to improve work efficiency by eliminating the hassle of manually creating and sending emails

・Those who want to send personalized emails via Gmail according to customer information or task progress

2. Marketing professionals

・Those who want to automate segmented email marketing based on customer information managed in Notion

・Those who want to automatically send event or campaign announcements to target customers

3. Project managers

・Those who want to automatically send reminder emails via Gmail to responsible persons when task deadlines managed in Notion are approaching

・Those who want to regularly report project progress to stakeholders via email

■Benefits of using this template

Notion is a useful tool for project management and information sharing, but manually creating and sending Gmail based on information registered in the database is inefficient and time-consuming. Especially when regular communication or email sending based on large amounts of data is required, manual work can easily lead to errors and become a bottleneck in operations.

By implementing this flow, Gmail is created and sent using information from the Notion database as a trigger, allowing you to allocate valuable time to other tasks without the need for manual email creation and sending. Additionally, automation reduces the risk of sending errors and information leaks, enabling accurate and efficient information sharing.

■Notes

・Please integrate both Notion and Gmail with Yoom.


■Overview

Send a template email from Gmail using specific lead detail pages in Salesforce.

Feel free to change the email content to any desired value.

Additionally, attachments can be freely configured.

■Notes

・This can only be used on Chrome as it requires a Chrome extension.

・Salesforce is available only on the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operations and data connections set in Flow Bot will result in errors, so please be aware.

・Paid plans like the Team Plan and Success Plan offer a two-week free trial. During the free trial, you can use apps that are usually restricted.


■Overview

This is a flow for sending template emails via Gmail to leads registered in HubSpot contacts.

By using Yoom, you can easily integrate apps without the need for programming.

By using a trigger with a Chrome extension, you can directly activate the trigger from HubSpot.

■Recommended for

1. Those who manage leads with HubSpot

・Those who use HubSpot to manage new leads but feel the burden of tracking and follow-up

・Those who want to send template emails quickly to leads and facilitate smooth communication

2. Those who use Gmail regularly

・Those who want to improve work efficiency through the automatic sending of template emails

■Benefits of using this template

By sending template emails via Gmail to leads registered in HubSpot contacts, you can provide timely follow-up to leads.
Utilizing this flow eliminates the manual effort of sending emails, thereby improving work efficiency.

Additionally, using template emails ensures consistency in email content, giving a professional impression.
This allows for effective lead nurturing, ultimately leading to increased sales.

■Notes

・Please integrate both HubSpot and Gmail with Yoom.

・For instructions on setting up triggers using the Chrome extension, please refer to here.

Save files received via Gmail to cloud storage

Automatically save files received via Gmail to Google Drive, DropBox, etc.


■Overview

This is a flow that reads document data posted on Gmail using OCR, updates the file name, and stores it in OneDrive.

With Yoom, you can easily achieve this flow without any programming, as it allows integration between apps.

■Recommended for

1. Those who manage files on OneDrive

・Those who manually rename files attached to Gmail and store them in OneDrive

■Benefits of using this template

If you manage files manually, storing them in the wrong location can take time to find them.

This flow allows you to standardize file names and storage locations, preventing errors in renaming and storage locations, thereby enhancing the accuracy of management tasks.

■Notes

・Please integrate Gmail and OneDrive with Yoom.

・Please note that OCR data may not be readable if it exceeds 6,500 characters or if the text is small.

・Branching is a feature available with the Mini Plan or higher. If you are on the Free Plan, the operation of the flow bot you set will result in an error.

・AI operations are a feature available only with the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operation of the flow bot you set will result in an error, so please be careful.

・Paid plans such as the Mini Plan, Team Plan, and Success Plan offer a 2-week free trial. During the free trial, you can use restricted apps and AI features (operations).

・Microsoft365 (formerly Office365) has plans for home use and general business use (Microsoft365 Business). If you are not subscribed to the general business plan, authentication may fail.


■Overview

This is a flow that reads document data posted on Gmail using OCR, updates the file name, and stores it in Box.

With Yoom, you can easily achieve this flow without any programming, as it allows for seamless integration between apps.

■Recommended for

1. Those who frequently exchange files via Gmail

・Those who manage received files with Box

2. Those who use Box

・Those who find renaming files or moving files to be cumbersome

■Benefits of using this template

If you are manually moving and managing files sent via Gmail to Box, you might find the repetitive tasks cumbersome.
Additionally, if the file naming convention is not standardized, it may cause confusion when searching for files.

When an email with an attached file is received in Gmail, the flow is triggered, allowing for standardized file naming conventions and improving the efficiency of file search and management.

■Notes

・Please connect Gmail and Box with Yoom.

・Please note that OCR data may not be readable if it exceeds 6,500 characters or if the text is too small.

・Branching is a feature available with the Mini Plan or higher. Operations set in the flow bot will result in an error with the Free Plan.

・AI operations are only available with the Team Plan and Success Plan. Operations set in the flow bot will result in an error with the Free Plan and Mini Plan, so please be careful.

・Paid plans such as the Mini Plan, Team Plan, and Success Plan offer a 2-week free trial. During the free trial, you can use restricted apps and AI features (operations).


■Overview

This is a flow to upload attachments received in Gmail to Google Drive.

With Yoom, you can easily achieve this flow without any programming, as it allows for seamless integration between apps.

■Recommended for

1. Those who use Gmail for business

・Those who frequently receive files via email from clients

・Those who want to prevent the risk of missing or losing email attachments


2. Those who use Google Drive for business

・Those who want to quickly save files to a shared drive for the entire team

・Those who manage multiple projects and want to organize deliverables in project-specific folders

・Those who want to organize and manage contracts and invoices sent by customers

■Benefits of using this template

With this flow, files attached to emails with specific labels received in Gmail are automatically uploaded to a designated folder in Google Drive.

It enables timely information sharing after receiving emails, reduces human errors such as missing or incorrect file storage, and prevents the risk of loss.

It is useful for sharing files received via email, such as invoices, project documents and deliverables, and various internal documents.

■Notes

・Please integrate Gmail and Google Drive with Yoom.

・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.

・Please note that the shortest trigger interval varies depending on the plan.

・If you are using email auto-sorting settings to determine the presence of attachments with specific labels, branching settings are not necessary.

Benefits and Examples of Integrating Google Forms and Google Calendar

Benefit 1: Improved Business Efficiency by Reducing Manual Work

Checking meeting reservations answered in Google Forms and manually registering them in Google Calendar and sending emails is cumbersome. By integrating tools, you can automate all these manual processes. For example, if a team is short-staffed, introducing this automation can allow personnel to allocate more time to other important tasks. As a result, an improvement in business efficiency can be expected.

Benefit 2: Faster Customer Response

If the person in charge is slow to check responses in Google Forms, it may not be possible to set up meetings in time. However, by integrating tools, if you can automatically send a reservation confirmation email to the customer, quick customer response will be possible. For instance, even if the person in charge is too busy to check Google Forms, introducing this automation can ensure smooth customer service. As a result, the burden of confirmation on the person in charge can also be reduced.

Benefit 3: Reduction of Human Errors

Manually registering appointments in Google Calendar and sending emails can lead to human errors such as incorrect registration, missed registrations, or sending the wrong schedule to other customers. These human errors can be prevented through automation. For example, if multiple meeting reservations are made simultaneously, you might make mistakes in a hurry to register them. By preventing such human errors through automation, the burden of schedule management can also be reduced.

Summary

By integrating Google Forms, Google Calendar, and Gmail, you can automate reservation management.
This significantly reduces manual work and prevents human errors, enabling prompt customer service.
Additionally, by reducing the burden of schedule management, it is expected to improve the work efficiency of both staff and managers.
The integration of Google Forms, Google Calendar, and Gmail can be achieved without coding by using Yoom.
By following the steps in this article, you can easily implement it, so please give it a try.

With Yoom, you can easily build the kind of collaboration
described here without programming knowledge.
Try Yoom for free
About the Author
s.nakazawa
s.nakazawa
I have been running a personal blog for over five years. When writing, I prioritize clearly explaining the information that readers want to know. Based on the writing experience I gained from managing my blog, I will clearly introduce the usage and appeal of Yoom, which allows for the automation of complex tasks without coding.
Tags
Automatic
Automation
Gmail
Google Calendar
Google Forms
Google Sheets
Integration