[No-Code Solution] How to Automatically Integrate Google Calendar Event Data with ChatGPT

Let's Create a Flow to Integrate Google Calendar with ChatGPT‍

Let's get started by creating a flow that integrates Google Calendar with ChatGPT!

This time, we'll use Yoom to proceed with the integration of Google Calendar and ChatGPT without any coding. If you don't have a Yoom account yet, please create one using this registration form.

[What is Yoom]

This time, we will create a flow bot that organizes and notifies schedules registered in Google Calendar using ChatGPT!
The creation process is broadly divided into the following steps.

• Integrate Google Calendar and ChatGPT with My Apps
• Copy the template
• Set up Google Calendar triggers and ChatGPT actions
• Turn on the trigger and complete the preparation for flow operation

Step 1: Integrating Google Calendar and ChatGPT with the App

Here, we will integrate Yoom with each app to enable operations.
First, log in to Yoom, then press "My Apps" on the left menu and click the "Add" button on the right.

‍

‍

Integrating Google Calendar

1. Search‍

Enter "Google Calendar" in the search box and click the displayed icon.

2. Log in‍

You will see the screen below, so click "Sign in with Google".

3. Select Account‍

Select the account you want to integrate.
If you want to integrate an account other than the displayed ones, click "Use another account" and log in with the account you want to integrate.

The screen will transition, so click "Next".

‍4. Allow Access‍

Select "Continue" at the bottom of the page.

Return to the Yoom screen, and if the following display appears, the integration is complete!

Integrating ChatGPT

1. Search‍

Enter ChatGPT in the search box and click the displayed icon.

2. Log in‍

Enter "Account Name" and "Access Token", then click "Add".
For details on how to register ChatGPT as a My App, please refer to here.

Return to the Yoom screen, and if the following display appears, the integration is complete!

Integrating Slack

1. Search‍

Enter Slack in the search box and click the Slack icon.

2. Grant Permissions‍

The access permission screen will be displayed, so select the channel you want to integrate from the dropdown and click "Allow".
For details on how to register Slack as a My App, please refer to here.

Return to the Yoom screen, and if the following display appears, the integration is complete!

Step 2: Copy the Template

Next, click "Try it" on the banner below to copy the template we will use this time.

The template will be copied to your Yoom management screen as shown below, so press OK to proceed with the setup.

Step 3: Setting the Schedule Trigger‍

The copied template is saved in "My Projects" from the menu on the left side of the screen. Check here when you resume the setup!

1. Click on the specified schedule in the red frame

‍Click on "When the specified schedule is reached"

2. Specify execution time‍

Set the day and time you want to activate the flow bot.
This time, we will leave it as the existing settings, but you can set specific dates or more flexible settings.

For schedule settings, please refer to How to set schedule triggers. You can also use Cron settings for more detailed settings than dates or days of the week!

Press the save button at the bottom of the page to proceed to the next setting.

Step 4: Setting Google Calendar

1. Click on Get list of events in the red frame‍

Click on the Google Calendar icon "Get list of events (UTC)".
Since the title and other settings are already completed, press Next!

* This time it will be an action based on UTC standard time called "Get list of events (UTC)", but we also have an action called "Get list of events" within Google Calendar actions, which allows you to retrieve events in JST conversion, so please customize the action according to your usage.

2. Set API connection

‍Enter each item for API connection. Click on the input field as shown in the image below to display a menu, and you can quote by clicking on the item.

Please enter each required item. The input format for the date is automatically converted.

Once the input is complete, enter a temporary schedule on the set date and click "Test".
If the test is successful as shown below, it is complete.

‍

If the schedule is registered in the calendar, you can obtain the output. It is necessary for future settings, so make sure to check it!

Press the save button at the bottom of the page to proceed to the next setting.

Step 5: Text Generation with ChatGPT

1. Click on Generate Text in the red frame‍

Click on the ChatGPT icon "Generate Text".

‍

2. Select the linked account and action‍

The information registered in Step 1 will be listed under "Linked Account Information". Leave the action as is and click "Next".

3. Set API connection
Enter each item for API connection. Click on the input field as shown in the image below to display a menu, and you can quote by clicking on the item.

• Message Content: Set the text to be automatically sent to ChatGPT. You can send prompts tailored to each content by referring to the input examples.
• Role: Basically, use "user", so you can proceed without selecting it.
• Temperature: Can be set in the range of 0 to 2. The higher the value, the more diverse the generation can be expected, and the lower the value, the more consistent the response will be. If not specified, no setting is required.
• Maximum Token Count: You can specify the maximum number of characters for the summary.
• Model: Specify the ChatGPT model to use. By default, "gpt-4o" is used. If not specified, no selection is required.

After completing the settings, execute "Test" and if successful, click Save.

Step 6: Setting the Action for Automatic Notification to Slack

‍1. Click on Send message to channel in the red frame

‍Click on the Slack icon "Send message to channel".

2. Select the linked account and action

‍As before, the information registered in Step 1 will be listed under "Linked Account Information". Leave the action as is and click "Next".

3. Set API connection

• Channel ID for posting: Specify the channel where the automatically summarized content will be notified. Click on the input field to display candidates, and select from the candidates.
• Message: Set the message to be notified to Slack. By quoting the output obtained in the ChatGPT action settings and combining it with a template, you can send messages tailored to each content.

After completing the settings, execute "Test" and confirm that the message has been delivered to the specified channel.
After confirmation, click "Save".

Step 7: Turn on the Trigger and Check Operation

Since the setup is complete, turn the trigger "ON" and check the operation.

‍

Other Automation Examples Using Google Calendar and ChatGPT

By utilizing the APIs of Google Calendar and ChatGPT, you can further automate schedule management and information organization more conveniently.

Below are examples of business efficiency improvements using Google Calendar and ChatGPT. If any of them catch your interest, please give them a try!

Convenient Automation Examples Using Google Calendar

You can automatically register interview appointment dates from received emails into your calendar or update information in other apps based on calendar information.
It is also possible to automatically create schedules from the content of chat tool posts, which seems likely to reduce oversights.

Convenient Automation Examples Using ChatGPT

You can automatically create template email responses to leads and automate text content registered in other tools!

In Conclusion

By leveraging the integration of Google Calendar and ChatGPT, managing your daily schedule becomes significantly easier. It reduces the hassle of manually organizing your plans, allowing you to grasp your schedule more smoothly.

With Yoom, you can easily create integration flows without any programming knowledge. The setup is simple, so you can start using it right away.

If you feel like you want to manage your schedule more efficiently, why not register for Yoom for free and experience the convenience of automation?