Automatically create a new user in Google Workspace three days before their start date
Automatically create a new user in Google Workspace three days before their start date
Launch this workflow to connect
Google Workspace &
Google Sheets
!
■Overview
Issuing accounts for new hires, especially registering new users in Google Workspace, is an important task for administrators. However, handling it manually often leads to missed steps and configuration errors. With this workflow, simply adding new hire information to a Google Spreadsheet automatically creates a new Google Workspace user three days before their start date. Free yourself from repetitive account provisioning tasks and focus on more important work.
■Who Should Use This Template
- IT administrators who manually create new Google Workspace users and want to automate the process
- HR and labor affairs teams who manage extensive onboarding processes and employee information in Google Spreadsheets
- Managers who want to streamline employee account management and reduce human error
■Benefits of This Template
- Automatically create new Google Workspace users based on their start dates, reducing the time and effort required to provision accounts
- Prevent human errors such as manual data entry mistakes and missed account creation tasks, ensuring reliable execution
■Flowbot Steps
- First, connect Google Spreadsheets and Google Workspace to Yoom
- Next, select Google Spreadsheets as the trigger and set the “When a row is added” action
- In the operation settings, configure the Calculator feature’s “Add or subtract date and time” action to calculate the date and time three days before the start date
- Next, configure the Wait feature’s “Wait” action to pause the workflow until the calculated date and time
- Then, configure Google Workspace’s “Add a new user” action to create a user based on the information in the spreadsheet
- Finally, configure the Email feature’s “Send an email” action to notify relevant stakeholders when the account has been created
■Customizing This Workflow
- In the Google Spreadsheets trigger settings, specify the target spreadsheet, sheet, table range to read, and other details as needed
- For adding or subtracting dates and times, use values such as the start date retrieved from the spreadsheet as variables, and select the desired output format
- With the Wait feature, freely customize the wait time according to when you want to create the account, such as five days before the start date
- When adding a new user in Google Workspace, set fixed values or information retrieved from the spreadsheet as variables for fields such as name and department
- With the Email feature, freely configure the recipients, subject, and body, and include account details and other information as variables in the message
■Notes
- Connect both Google Workspace and Google Spreadsheets to Yoom.
- When using Google Spreadsheets as an app trigger, see the notes.
- You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Note that the shortest available trigger interval varies by plan.
- Operations between Google Workspace and the “Wait” operation are available only on the Team and Success plans. On the Free and Mini plans, the configured Flowbot operations and Data Connect will result in errors.
- Paid plans, including the Team and Success plans, come with a two-week free trial. During the free trial, you can use apps and features (operations) that are otherwise restricted.
Check Out Similar Templates!
Add employees to Google Workspace from form responses and notify on Slack.
The workflow automatically registers employees to Google Workspace from form responses and sends team notifications to Slack. It prevents manual registration and notification omissions, streamlining the hiring process and ensuring smooth onboarding.
See more
About the Apps
Google Workspace
Related apps
Templates using
Google Workspace
In this workflow, it is possible to automatically add new users to Google Workspace based on Jotform responses. This workflow ensures that information is seamlessly reflected in Google Workspace, simplifying administrative tasks.
In this workflow, it is possible to automatically add new users to Google Workspace based on Typeform responses. This automation reduces manual data entry and errors, enabling efficient user management.
In this workflow, it is possible to add new users to Google Workspace based on responses from Zoho Forms. This eliminates the need for manual user addition and enables accurate user management.
Google Sheets
Related apps
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
About the apps you use
Google Workspace
Yoom allows you to integrate with Google Workspace's API without any code, enabling the automation of various tasks. For example, you can automatically create Google Workspace accounts for new employees upon their joining. Additionally, you can automatically sync employee information from Google Workspace to Yoom's database, making it useful for various purposes.
see detailsTemplates
In this workflow, it is possible to automatically add new users to Google Workspace based on Jotform responses. This workflow ensures that information is seamlessly reflected in Google Workspace, simplifying administrative tasks.
Add a new user to Google Workspace based on Jotform responses.
In this workflow, it is possible to automatically add new users to Google Workspace based on Typeform responses. This automation reduces manual data entry and errors, enabling efficient user management.
Add a new user to Google Workspace based on Typeform responses
In this workflow, it is possible to add new users to Google Workspace based on responses from Zoho Forms. This eliminates the need for manual user addition and enables accurate user management.
Add a new user to Google Workspace based on responses from Zoho Forms.
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add order information to WooCommerce when a row is added in Google Sheets.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Add a new tab to the Google Spreadsheet at the beginning of each month.
No-Code API Actions
Executable API actions
Flowbot triggers
When a User Is Registered
When User Information Is Updated
When a Row Is Added
When a Row Is Updated
Flowbot operations
List Groups
Add Member to Group
Get Group Member List
Add a New User
Remove Member from Group
Search Users
Search Groups
Update User Information
Delete User
Require User to Change Password
Get User List
Suspend User
Create Group
Stop Webhook
Set a Value in a Cell
Get Values
Clear Values
Create a New Spreadsheet
Flowbot triggers
When a User Is RegisteredWhen User Information Is Updated
Flowbot operations
List GroupsAdd Member to GroupGet Group Member ListAdd a New UserRemove Member from GroupSearch UsersSearch GroupsUpdate User InformationDelete UserRequire User to Change PasswordGet User ListSuspend UserCreate GroupStop Webhook
Flowbot triggers
When a Row Is AddedWhen a Row Is Updated
Flowbot operations
Set a Value in a CellGet ValuesClear ValuesCreate a New SpreadsheetCopy a Sheet (Tab)Add a New Sheet (Tab)Delete Sheet (Tab)Replace ValuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet Sheet NamesApply a Formula to a RangeEnter Values in a RangeEmbed an Image in a CellSort by Specific ColumnHide a SheetAdd a Note to the Specified CellsInsert ColumnsDelete ColumnsWrite Values to Multiple ColumnsAdd RowsMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
