How to Add a User in Google Workspace 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 back-office staff may be responsible for issuing Google accounts to new employees.
Have you ever felt that this task is cumbersome?
In companies where new members join every month, issuing accounts can be time-consuming.

In such cases, by implementing the automated integration explained in this article, you can reduce the hassle of issuing accounts for Google Workspace!
If you like, please refer to the steps explained below and try the automated integration with Yoom!

Benefits of Integrating Google Sheets with Google Workspace

Benefit 1. Minimize manual work with automated user addition

When adding new users in Google Workspace, it usually requires manual intervention.
For example, if you use Google Sheets as the core database for member management, you need to input data into both applications, resulting in double the effort.
However, with this integration, by simply adding users to Google Sheets, the same information is automatically added to Google Workspace, reducing the burden of manual work.

Benefit 2. Easier management of user information

"Automatically adding users to Google Workspace based on the information added to Google Sheets" means that you can check all user information added to Google Workspace just by looking at Google Sheets.
This enables centralized management of user information, making it easier to manage information.

[About Yoom]

Integration Flow of Google Sheets and Google Workspace

Now, let's introduce the steps to actually integrate Google Sheets and Google Workspace.
The specific setup steps are as follows.

Setting up app triggers
Configuring Google Workspace

Yoom provides the above two steps as a template.

It's easier to create a flow bot than starting from scratch, so first click the "Try it" button on the banner below to copy the template!

Preparation

After copying the template, the first step in preparation is to register the Google Sheets and Google Workspace apps from Yoom's "My Apps".
※ If you have already registered, please proceed to "Step 1: Setting the App Trigger".

Procedure

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

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

Once the Google Sheets and Google Workspace apps are displayed in the My Apps list, preparation is complete!

Let's proceed to the detailed settings!

Step 1: Setting the App Trigger

First, click on the initial setting "When a row is added".
On the first page, the pre-linked account information will be displayed, so please check it.

No changes are needed for other items, so please click "Next" as it is.

On the next page, please set the ID and range of the Google Sheets.
Especially, make sure to set a column with unique values as "Column with Unique Values".
If there are duplicate values within the column, it may not function 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.

In this case, since the flow is to add a user to Google Workspace, at least four pieces of user information are required when adding a user.
<span class="mark-yellow">Therefore, please pre-store the four pieces of information "Address", "Last Name", "First Name", and "Password" in the Google Sheets as shown in the image below.</span>

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

Step 2: Setting Google Workspace

Next, click "Add New User".
On the first page, just like with Google Sheets, only confirm the account information and select "Next".
On the next page, set the details for adding a user.

‍

Use the information output from Google Sheets for the four items "Last Name", "First Name", "Default Password", and "Email Address".

Click "Test" and if no errors appear, click "Save" to complete the Miro settings.

Once all settings are complete, a popup like the image above will appear.
When you turn the trigger ON, the flow will be executed.

Other Examples of Automation Using Google Sheets and Google Workspace

Yoom has many automation examples using Google Sheets and Google Workspace. Here are some representative examples.

1. A flow where an email is sent via Gmail when user information in Google Workspace is updated.

2. This is the flow for issuing a Google account when an employee is registered in SmartHR.

3. This is a flow for creating customer information in CallConnect when information is added to Google Sheets.

Summary

The above was the procedure for integrating Google Sheets with Google Workspace!
Yoom can be used without programming knowledge, making it easy to set up the integration.
When a row is added to Google Sheets, a user is automatically added to Google Workspace, minimizing manual workload.

This integration is expected to not only shorten the task of adding users but also make managing user information easier.

If you are interested, please try it out by registering for free here!

■Notes

・Google Workspace is an app available only with the Team Plan and Success Plan. Please note that you cannot actually activate Flowbot with other plans.
・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 like this one, so please give it a try.