Add users to a group in Microsoft Entra ID when a row is added in Google Sheets.

■Overview

This is a flow to add a user to Microsoft Entra ID when a row is added in Google Sheets.

‍

■Recommended for

1. Those who use Google Sheets for work

・Those who manage user information with Google Sheets

‍

2. Those who use Microsoft Entra ID to proceed with their work

・Data management personnel who manage user information

‍‍

■Benefits of using this template

When using Microsoft Entra ID in a project, it is cumbersome to register users in the group each time.
Manually adding users is inefficient, time-consuming, and prone to human error.

This template is suitable for those who want to automate user registration to groups.
It allows you to automatically add users managed in Google Sheets to groups, improving work efficiency.

‍

■Notes

・Please link both Google Sheets and Microsoft Entra ID with Yoom.

・Microsoft365 (formerly Office365) has personal and business plans (Microsoft365 Business), and authentication may fail if you are not subscribed to the business plan.

・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 set in the flow bot 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.