■Overview
This is a flow that adds a user to Microsoft Entra ID when a row is added in Google Sheets.
■Recommended for
1. Those who manage information using Google Sheets
・Those who manage user information with Google Sheets
2. Those who manage users with Microsoft Entra ID
・Companies using Microsoft Entra ID
■Benefits of using this template
When using Microsoft Entra ID, user registration is required each time, which may feel cumbersome.
Additionally, manual user addition raises concerns about human errors such as input mistakes or omissions.
This template is suitable for those who want to automate user addition.
It allows you to automatically add user information managed in Google Sheets, improving work efficiency and making management tasks easier.
■Notes
・Please integrate both Google Sheets and Microsoft Entra ID with Yoom.
・Microsoft365 (formerly Office365) has a home plan and a general business plan (Microsoft365 Business). If you are not subscribed to the general business plan, authentication may fail.
・Microsoft Entra ID is an app available only with the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operations and data connections of the flow bot you have set will result in errors, so please be careful.
・Paid plans such as the Team Plan and Success Plan offer a two-week free trial. During the free trial, you can use apps that are subject to restrictions.


When a row is added
When a row is updated
Write a value to a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete a sheet (tab)
Replace values
Rename a sheet (tab)
Delete rows
Get Spreadsheet Info
Get Sheet Names
Fill a Formula Across a Range
Write Values to a Range
Insert an Image into a Cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
When a row is added
When a row is updated
Write a value to a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete a sheet (tab)
Replace values
Rename a sheet (tab)
Delete rows
Get Spreadsheet Info
Get Sheet Names
Fill a Formula Across a Range
Write Values to a Range
Insert an Image into a Cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
Insert columns
Delete columns
Enter values into multiple columns
Add user
Search User
Delete User
Add User to Group
Remove User from Group