How to link Airtable with cybozu.com common management to grant accounts for Garoon or Cybozu Office to employees registered in Airtable

Wouldn't it be convenient if you could automatically issue accounts for various Cybozu tools?
Some back-office staff may be issuing accounts for new members as part of their daily tasks.
When there are only a few new employees, manual issuance may not be much of a burden, but in companies where new employees frequently join, it can become a significant burden.
This article explains how to automate account issuance for employees by integrating Airtable with cybozu.com common management to alleviate that burden even a little!
It's recommended for those who want to automate account issuance for tools like Garoon and Cybozu Office by linking with Airtable information.
If you're interested, please try the automatic integration with Yoom in this article.

Benefits of Integrating Airtable with cybozu.com Common Management

Benefit 1. Minimize Manual Work

When adding a new user in cybozu.com common management, it usually needs to be done manually.
For example, if you use Airtable as the core database for employee information, you need to enter information into both applications, which results in double the effort.
However, with this integration, you can automatically issue accounts for Garoon and Cybozu Office just by entering data into Airtable.
This reduces the effort of account issuance and is expected to save working time.

Benefit 2. Accurate Data Management

The more manual input is required, the higher the risk of human error.
For example, "registering an employee's name incorrectly due to a conversion error" or "forgetting to issue an account."
If such mistakes occur, it can hinder the smooth start of operations, so you want to minimize errors as much as possible.
By utilizing the integration in this article, tasks that were previously done manually are automated, leading to a reduction in the risk of human error.
This ensures accurate data is maintained, allowing operations to proceed smoothly.

[What is Yoom]

Integration Flow of Airtable and cybozu.com Common Management

Now, let's introduce how to actually integrate Airtable with cybozu.com common management.
The integration steps are as follows.

Set up the app trigger
Add a user
Update user service usage

Yoom provides the above three steps as a template.
You can create a flow bot more easily than creating from scratch, so first, click the "Try it" button on the banner below to copy the template!
Once the copy is complete, you can operate it from "My Projects" in the sidebar.

Integration of My Apps with Airtable and cybozu.com Common Management

After copying the template, register Airtable and cybozu.com common management in Yoom's My Apps as a preliminary step.
If you have already registered, please proceed to "Step 1. Setting the App Trigger".

<Procedure>

1. After logging into Yoom, click "My Apps" → "+ New Connection" in order

2. Search for the app name and enter the required information

If Airtable and cybozu.com common management are displayed in the My Apps list, the preparation is complete!
Let's proceed to the detailed settings right away!
If you haven't copied it yet, please copy the Flowbot template from below.

1. Hover over the banner and click "View Details"
2. Click "Try this template" on the redirected page
3. Register for Yoom
※ If you have already completed registration, the login screen will be displayed, so please log in.

‍

Step 1. Set up the App Trigger

First, click on the app trigger "When a record is registered".

On the first page, the pre-linked account information will be displayed, so please check it and click "Next" if there are no issues.

On the next page, set up the API connection.
Enter the "Base ID", "Table ID", and "Field Name for Created Time", then click "Test".
※ Please note that the "Trigger Activation Interval" varies depending on your subscription plan. For details,click here.

If the "Test" is successful, Airtable items will be reflected in the output field.
Add the necessary information as needed from the "Add Value to Retrieve" button. For detailed instructions, please refer to this article.

<span class="mark-yellow">In this automatic integration, the login name and password will be required in the next step. Please pre-enter these two items in Airtable and add Login Name and Password from "Add Value to Retrieve".</span>

If there are no issues up to this point, click "Save" to complete the trigger setup.

Step 2. Add Users

Next, click "Add User".

On the first page, the account information will be displayed as in Step 1, so click "Next" if there are no issues.

On the second page, set up the user addition.
"Login Name", "Password", and "Display Name" are required fields, so be sure to enter them using the output information.
Other fields are optional, so fill them in as needed.

Perform a "Test", and if there are no issues, click "Save" to proceed to the next step.

Step 3. Update User Service Usage

Finally, click "Update User Service Usage".

On the first page, the account information will be displayed, so check it and proceed to the next step.

On the second page, select the services to be used.
By setting it as follows, Garoon and kintone accounts will be assigned to the target employees.
It is also possible to select Cybozu Office or Mailwise.

Click "Test" and if no errors occur, click "Save".

If a popup like the one below is displayed, all settings are complete.

Flowbot template used this time

Other Automation Examples Using Airtable and cybozu.com Common Management

Yoom offers numerous automation examples utilizing Airtable and cybozu.com common management.
It is possible to integrate with various applications, so please refer to the following representative examples.

1. Update the Airtable Employee Management Ledger when Employee Information is Updated in SmartHR

Many people use SmartHR for managing employee information.
By using this integration, the task of updating information is automated, reducing the effort required for the task.

2. Register a record in Airtable when a workflow is approved in Garoon

The automated integration introduced in this article was a flow that automated account issuance for Garoon, kintone, and others, starting from Airtable.
However, we also offer a flow that outputs information to Airtable starting from Garoon, as shown in the following template.

3. Grant Garoon or Cybozu Office accounts to employees registered in Notion

For those managing employee information in Notion instead of Airtable, please refer to this template.

Summary

The above was the procedure to integrate Airtable with cybozu.com common management!
As you can see, Yoom can be used without programming knowledge, making it easy to set up integrations.
By integrating Airtable with cybozu.com common management, account issuance can be automated, reducing workload.
Additionally, the risk of human error is minimized, leading to accurate data management.

If you are interested, please start by registering for free here!