How to Add a User in Microsoft Entra ID When a Row is Added in Google Sheets

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

Recommended for

Those who want to automatically upload files attached to Gmail to Dropbox
Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will 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 right away using the template below, so please give it a try!

Some companies that use multiple cloud services may have implemented Microsoft Entra ID for managing the IDs of each service.
It offers features like single sign-on and multi-factor authentication, making it a very convenient service.
However, when adding users, it can feel cumbersome as you need to manually input the information each time.
To address this issue, we have created a flow where adding a row in Google Sheets automatically adds a user to Microsoft Entra ID!

If you're interested, please refer to the steps below and try automatic integration with Yoom!

Benefits of Integrating Google Sheets with Microsoft Entra ID

Benefit 1. Halve the Manual Workload

Among those who use both Google Sheets and Microsoft Entra ID, are there any who add users in the following way?

① Enter user information in Google Sheets
② Enter the same information in Microsoft Entra ID to add the user

When managing data in two applications like this, you have to input the same information twice.
However, by using the integration described in this article, you can add users to Microsoft Entra ID with just step ①.
This can halve the workload and is expected to improve operational efficiency.

Benefit 2. Minimize Input Errors

Those who perform data entry work may have experienced entering incorrect information. Especially when managing a lot of information and frequently performing input tasks, the number of errors can increase.
As long as humans are doing manual work, input errors are inevitable, but you want to reduce the number of errors as much as possible, right?

In such cases, this integration might help solve the problem.
Since part of the previously manual input work is automated, you can minimize input errors like typos and misspellings.

[What is Yoom]

Integration Flow of Google Sheets and Microsoft Entra ID

Now, let's introduce the steps to actually integrate Google Sheets with Microsoft Entra ID.
The specific setup steps are as follows.

Set up the app trigger
Add a user
Update the record

Yoom offers the above three steps as a template.
You can create a flow bot more easily than starting from scratch, so first, click the "Try it" button on the banner below to copy the template!

Preparation

After copying the template, first register Google Sheets and Microsoft Entra ID from Yoom's "My Apps" as a preliminary step.
※ If you have already registered, please proceed to "Step 1. Set App Trigger".

1. After logging into Yoom, click "+ New Connection" from the "My Apps" menu on the left

2. Search for the app name, enter the necessary information for login, and register the app

If Google Sheets and Microsoft Entra ID are displayed in the My Apps list, preparation is complete!

Let's proceed to the detailed settings right away!

Step 1. Set App Trigger

First, click on the app trigger "When a row is added".

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

On the next page, set the Google Sheets ID and range.
<span class="mark-yellow">Especially for the "Column with Unique Values", make sure to set a column that contains unique values.</span>
If there are duplicate values within the column, it may not work correctly.

Once all items are entered, click "Test" to check for errors.

If the test is successful, the specified Google Sheets items will be reflected as output.

<span class="mark-yellow">The following items are necessary information when adding a user in Step 2. Please store the information in Google Sheets in advance as shown in the image below.</span>

Login Name
Initial Password
User's Full Name

‍

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

Step 2. Add User

Next, click "Add User".

On the first page, just like in Step 1, confirm only the account information, and if there are no issues, click "Next".
On the second page, set up to add a user.
Utilize the output information to enter the required fields.

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

Step 3. Update Records

Now, let's proceed to the final step "Update Records".

The beginning of the first page contains account information just like in Step 1 and Step 2.
Below that, there is a database linkage item, so specify the "Spreadsheet ID" and "Tab Name" and proceed to the next step.

On the next page, set up to update records.
A specific column of the record that matches condition ① will be updated to the value set in ②.

For example, if you set it as shown in the image below, the user ID issued by Microsoft Entra ID will be reflected in the "User ID" column of the newly added row in Google Sheets.

‍

Click "Test" and if no errors appear, click "Save".
If a popup like the image below appears, all settings are complete.
When you turn the trigger ON, the flow will be executed.

Other Examples of Automation Using Google Sheets and Microsoft Entra ID

Yoom offers many automation examples using Google Sheets and Microsoft Entra ID.
Here are some representative examples.

1. When a row is added in Google Sheets, add a user to a group in Microsoft Entra ID

We also provide a template for automatically adding users to a group.

2. Delete a Microsoft Entra ID user when a row is updated in Google Sheets

There are cases where you want to automatically delete a user, not just add them. This is a recommended flow for such situations.

3. Add a new user to Microsoft Entra ID when an employee is registered in SmartHR

If you are managing employee information using SmartHR, it is also recommended to integrate SmartHR with Microsoft Entra ID.

4. Add a new user to Microsoft Entra ID when the status is updated in kintone

If you are using kintone for data management, please refer to the following template as well.

Summary

These were the steps to integrate Google Sheets with Microsoft Entra ID!
As you can see, Yoom can be used without programming knowledge, making it easy to set up integrations.
When a row is added to Google Sheets, a user is automatically added to Microsoft Entra ID, reducing manual work.
This also helps prevent input errors, potentially improving productivity.

If you're interested, please start by signing up for free here!