How to create an event in Google Calendar based on information submitted through Google Forms and notify via Slack

[About Yoom]

How to Create an Integration Flow with Google Forms, Google Calendar, and Slack

Now, let's explain in detail how to create a flow that creates an event in Google Calendar based on reservation information submitted via Google Forms and notifies the content in Slack, as an example of automatable tasks.

With the no-code tool Yoom, you don't need programming expertise or skills.
If you haven't registered with Yoom yet, please create an account here!

Preparation

This workflow is triggered by responses from Google Forms.
Please create a form in Google Forms that will serve as the source of information for event creation.
When creating events related to meetings or individual briefings, it is advisable to make essential fields such as the respondent's identity information (company name, name, email address) and preferred date and time.

Once you have completed the preparation up to this point, please log in to Yoom.
We will actually create the integration and automation flow using a template.

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

1. After logging into Yoom, select "My Apps" from the left menu and click "+Add" on the right side of the screen.

‍

‍

2. From the list of new connections in My Apps, select Google Forms, Google Calendar, and Slack, and integrate the apps.
　※For Slack integration, please refer to this guide.

‍Step 2: Set up a trigger to activate when a response is submitted to the Google Form reservation form

3. Open the copied template and change the title as needed.
　※ Initially, it is saved in "My Project".
　　If it does not open automatically, select the relevant template from My Project,
　　and click "Edit" in the upper right corner of the screen.

4. Select "App Trigger Once the form has been submitted" from Flowbot.

‍

‍

5. Set up "Select linked account and action".
　Change the title of the app trigger as needed and click "Next".

‍

‍

6. Set up the API connection for the app trigger.
　・Trigger activation interval: Set an appropriate time according to business needs.
　・Form ID: Refer to the note at the bottom of the field and enter the ID of the Google Form created in advance.

‍

‍

7. Conduct a test, confirm success, and click "Save".

Step 3: Set up an action to create an event in Google Calendar

8. Select "Integrate with App Create an Event" from Flowbot.

‍

‍

9. Set up "Select linked account and action".
　Change the title as needed and click "Next".

‍

‍

10. Set up the API connection.
　Enter and select each item, referring to the notes at the bottom of each field.
　If necessary, you can also refer to the output obtained in Step 2 - Procedure 7.
　※ The image below is an example of input.

‍

‍

‍

11. Conduct a test, confirm success, and click "Save".

Step 4: Set up an action to notify Slack

12. Select "Integrate with App Notify Slack" from Flowbot.

‍

‍

13. Set up "Select linked account and action".
　Change the title as needed and click "Next".

‍

‍

14. Set up the API connection.
　Enter the channel ID and message for the posting destination.
　※ If there is an error in setting the channel ID, refer to here.
　※ You can also refer to the output obtained in Step 2 - Procedure 7 or Step 3 - Procedure 11.
　※ The image below is an example of input.

‍

‍

15. Conduct a test, confirm success, and click "Save".
Finally, switch the trigger of the saved flow to "ON" to activate it.

This completes the flow of "When reservation information is submitted via Google Form, reserve it in Google Calendar and notify Slack"!

Other Automation Examples with Google Forms, Google Calendar, and Slack

In addition to the flow introduced this time, you can achieve various business automations by using the APIs of Google Forms, Google Calendar, and Slack.
All of these can be used with simple settings, so if you find something interesting, please give it a try!

Automation Examples Using Google Forms and Google Calendar

Add Events to Google Calendar Based on Google Forms Responses

This is a flow bot that adds events to Google Calendar based on Google Forms responses.
By integrating with chat tools, you can share schedule information.

Automation Example Using Google Forms and Slack

Process Form Responses and Send Notifications

This is a flow bot that converts form responses into PDFs or creates invoices and sends notifications to Slack.

Example of Automation Using Google Forms

Register Information Submitted via Google Forms

By integrating with a task management tool, you can register information submitted via Google Forms, potentially eliminating the need for manual data entry.

Examples of Automation Using Google Calendar

Register the Due Dates of Registered Tasks in Google Calendar

This is a flow bot that integrates with task management tools to register the due dates of registered tasks in Google Calendar.
The automation flow is expected to improve the efficiency of schedule management tasks.

Examples of Automation Using Slack

Notify Approval and Completion of Applications

Notifications of application approvals and completions are sent to Slack, allowing for quick understanding of application status.

What are the Benefits of Integrating Google Forms, Google Calendar, and Slack?

1. Reduce Manual Tasks

When scheduling meetings, you can create events in Google Calendar based on reservation information submitted through Google Forms and notify the details via Slack.
While integration with Google Forms is necessary, automation of workflows can potentially eliminate some processes when checking form responses and setting up events in the calendar.
Additionally, the need for manual sharing when notifying stakeholders of the schedule is eliminated, leading to reduced work time and prevention of errors.

2. Facilitate Communication

Through automation, it is possible to automatically create events in Google Calendar based on responses from Google Forms.
Information regarding the content and timing of events such as meetings can be extracted from Google Forms, allowing for automatic creation of events in Google Calendar and notifications to all participants.
This enables efficient schedule adjustments and leads to smoother communication with team members and business partners exchanging information via Slack.

3. Improve Work Efficiency

By automatically sending Google Calendar events to Slack at pre-set times, it can also be utilized as a schedule reminder function.
The risk of forgetting important meetings is reduced, allowing for smooth operations from preparation to the actual event.
Since the response content from Google Forms is directly reflected, it may eliminate the need for data entry tasks.

By integrating these tools, you can expect more efficient schedule management and enhanced communication!

Conclusion

This time, we introduced the benefits of integrating Google Forms, Google Calendar, and Slack, as well as the workflows that can be automated.
Since it leads to more efficient schedule management and improved communication both internally and externally, be sure to try integrating and automating various workflows!