How to integrate SPIRAL with Google Calendar to automatically register events in Google Calendar when they are registered in SPIRAL

The process consists of 5 steps, so it can be set up in 10-15 minutes.

1. Register SPIRAL and Google Calendar as My Apps
2. Set a trigger to activate when a record is created in SPIRAL
3. Set an action to retrieve records in SPIRAL
4. Set an action to create an event in Google Calendar
5. Verify the automation between SPIRAL and Google Calendar

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

[What is Yoom]

Step 1: Register SPIRAL and Google Calendar as My Apps

To connect SPIRAL and Google Calendar to Yoom, register them as My Apps.
Registering as My Apps makes it easy to set up automation.

Register SPIRAL as My App.
Click "My Apps" → "New Connection" on the left side of the Yoom screen.
Search for SPIRAL from "Search by App Name" or find it from the app list.

When the following screen is displayed, check the explanation and set the "Account Name" and "Access Token".
You can check how to create and set up an API agent here.

Next, register Google Calendar as My App, and select Google Calendar as before.
When the following screen is displayed, please log in to Google Calendar.

Once both My App registrations are complete, SPIRAL and Google Calendar will be displayed.

Step 2: Set a trigger to activate when a record is created in SPIRAL

To set up automation, click "Try it" on the banner below.

Please check the following screen display and click "OK".

The following screen will be displayed, so let's check the "Title" and "Description".
If changes are necessary, you can make them from the following page.
First, to set up SPIRAL, click "When a record is created".

When the following screen is displayed, please check the settings.

• "Title" → Can be freely changed
• "Account information linked with SPIRAL(ver.2)" → Check if correct
• "Trigger Action" → When a record is created
  

The following screen will be displayed, so let's set it up.

• "Trigger Interval" → Select from 5 minutes, 10 minutes, 15 minutes, 30 minutes, 60 minutes
  ※ Please note that the trigger interval varies depending on the plan.
• "App ID", "Database ID" → Read the description and set

After setting, click "Test" → "Test Successful" → "Save".

Step 3: Set up the action to retrieve records in SPIRAL

Next, to set up retrieving records in SPIRAL, click "Retrieve Records".
When the following screen is displayed, let's check the settings.

• "Title" → Can be freely changed
• "Account information linked with SPIRAL(ver.2)" → Check if correct
• "Action" → Retrieve Records
  

The following screen will be displayed, so check the precautions.

When the following screen is displayed, use the output of "When a record is created" to set the "Record ID".
Click the arrow in the red frame to use the output.

After setting, click "Test", and if "Test Successful" is displayed, the schedule information of SPIRAL will be displayed.
Since the output of SPIRAL is used in the Google Calendar settings, you need to manually create the output.
For how to obtain the output, see here.
※ Set the scheduled date in the format "2024-10-18".
Set the scheduled time in the format "13:00".
If you want to set an all-day event, set the start time to 00:00 and the end time to "00:00 the next day".

After setting, click "Save".

Step 4: Set up the action to create a schedule in Google Calendar

Next, to set up Google Calendar, click "Create Schedule".
When the following screen is displayed, please check the settings.

• "Title" → Can be freely changed
• "Account information linked with Google Calendar" → Check if correct
• "Action" → Create Schedule
  

When the following screen is displayed, set the "Calendar ID" and "Schedule Title".

Scroll and use the output of "Retrieve Records" to set the "Required Items".
The output you set will be displayed in the red frame, so select the relevant item from there.
If there are other necessary items, please set them.
Once the settings are complete, click "Test" → "Test Successful" → "Save".
※ Start date and start time must be written in the format specified in the notes.

Step 5: Verify the automation between SPIRAL and Google Calendar

Finally, click "Turn on Trigger" to complete the automation settings.
Please check if the flowbot starts correctly.

‍
The flowbot template used this time
Register a schedule in Google Calendar with information registered in SPIRAL

Other Examples of Automation Using SPIRAL and Google Calendar

1. This flow automatically updates SPIRAL records when a row is updated in Google Sheets.
It ensures that updates made in Google Sheets are synchronized with SPIRAL, preventing any omissions.

2. This is a flow that automatically registers the due dates of tasks registered in Notion to Google Calendar.
‍You can visualize tasks with approaching deadlines, making priorities clear.

3. This is a flow that automatically creates a Google Calendar event when a post is made on Microsoft Teams.
Every time an event is scheduled, it saves you the trouble of adding it to Google Calendar.

Summary

By integrating SPIRAL with Google Calendar, schedule management becomes easier, allowing for smoother workflow. Additionally, speedy information sharing will facilitate better communication within the team. Take advantage of this automation to improve the efficiency of your schedule management.

With Yoom, anyone can easily implement automation. If you would like to experience it, please register for free here.