Introduction

In this article, you will learn how to bulk reset user passwords in Google Workspace using xFanatical Foresight. As organizations grow, IT administrators often need to reset multiple user passwords due to security policies, compliance requirements, or account recovery needs. Manually resetting passwords for each user through the Google Admin Console is time-consuming and inefficient.

Let’s take an example: A company faces a security breach and needs to enforce an immediate password reset for all employees to mitigate potential risks. Manually resetting passwords for hundreds of users would be time-consuming and inefficient. With xFanatical Foresight, IT admins can quickly reset multiple user passwords in bulk, ensuring a swift response to the breach while saving valuable time and maintaining security compliance.

Illustration of how xFanatical Foresight automates the bulk reset of user passwords in Google Workspace.
Illustration of how xFanatical Foresight automates the bulk reset of user passwords in Google Workspace.

Introducing xFanatical Foresight Automation

xFanatical Foresight is a powerful automation platform designed specifically for Google Workspace. It enables administrators to efficiently reset user passwords in bulk in Google Workspace. Instead of manually resetting passwords one by one in the Google Admin Console, you can quickly update multiple user passwords at once, ensuring security compliance and minimizing downtime. This helps protect sensitive data, enforce strong password policies, and streamline IT operations. With Foresight’s intuitive interface and powerful automation, bulk password resets are fast, accurate, and hassle-free.

Automation Setup Instructions

In this section, we guide you through the automation setup in xFanatical Foresight. We have 2 ways to set up automation rules, Set up automation from a template and Set up automation from scratch. After completing the automation rule, verify whether the automation meets your requirements.

Set Up Automation From a Template

Set Up Automation From a Template

Supported plans: xFanatical Foresight Elite plan.

  1. Sign into xFanatical Foresight with your Google Admin account. 
  2. Go to the Templates page.
  3. Search for Bulk reset user passwords and click on it.
    In the Templates then, search for Bulk reset user passwords template in xFanatical Foresight.
  4. In the Templates > Bulk reset user passwords page, click Copy rule.
    In the Templates then, Bulk reset user passwords page, click the 'Copy rule' button to duplicate the automation rule in xFanatical Foresight.
  5. For the first time use of the template rule, an dialog Action needed will display requesting necessary permissions required to copy the rule. Click Connect with Google and authorize the permissions.
  6. Upon authorization, a dialog titled Copy of Bulk reset user passwords will display.
  7. Click Next. 
  8. Click on Email action.
  9. In the Edit actions >Email action,
    Configure email subject line and email body as required.
    1. In the Subject field, customize the subject line as required.
    2. In the Email body, customize the company name and relevant details.
    3. Click Review.
  10. In the Review screen,
    In the Review page, provide rule name and create bulk reset user passwords rule.
    1. In Rule name, customize the automation rule name.
    2. Click Create.
  11. The rule is created in the Rules page. 
    xFanatical Foresight rule graph for bulk reset password for users in Google Workspace.
    xFanatical Foresight rule graph for bulk resetting passwords for users in Google Workspace.
Set Up Automation From Scratch

Set Up Automation From Scratch

Supported plans: xFanatical Foresight Elite and Professional (Legacy).

  1. Create a Google Sheet with a User Primary Email column. Once completed, click File > Download > Comma Separated Comma (.csv) to download the Google Sheet as a CSV file.
    Prepare a CSV file to upload into the bulk reset user passwords rule.
  2. Sign into xFanatical Foresight with your Google Admin account. 
  3. Go to the Rules page. 
  4. Click the New Rule The New Rule button in xFanatical Foresight button.
  5. In the Select a trigger screen, select Data Uploaded trigger.
    Selecting Data Uploaded trigger on Select a trigger screen
  6. Click the Choose a CSV file created in Step 1.
  7. Click Next.
  8. In the Select an action screen, select the Get user info action.
    Select the get user info action for the rule
  9. In the Edit actions > Get user info screen,
    Configure get user info action for bulk reset user passwords rule
    1. In the Primary email field, select the User primary email variable from the Data uploaded trigger.
    2. Click on Add next action.
  10. In the Select an action screen, select If action.
    The IF action to create get unusual apps report automation in xFanatical Foresight
  11. In the Edit actions > If screen,
    Configure If action for bulk reset user passwords rule.
    1. Rename Branch 1 to Has secondary work email, then add a condition to check if the secondary work email is not empty. 
    2. Click Add next action.
  12. In the Select an action screen, select
    The generate password action to create the rule..
  13. In the Edit actions > Generate password screen,
    Configure generate password action for bulk reset user passwords rule.
    1. No configurations needed in the Generate password action.
    2. Click on Add next action.
  14. In the Select an action screen, select Reset user password action.
    Select the Reset user password action for bulk reset user passwords rule.
  15. In the Edit actions > Reset user password screen,
    Configure reset user password action for bulk reset user passwords rule
    1. In the User primary email field, select the User primary email variable from the Get user info action.
    2. In the New password field, select the Generated password variable from the  Generate password action.
    3. Click Add next action.
  16. In the Select an action screen, select the Email action.
    Select Email action on select an action screen.
  17. In the Edit actions > Email screen,
    Configure email action for bulk reset user passwords rule.
    1. In the To field, select the Secondary work email variable from the Get user info action.
    2. In the Subject field, customize the subject line as per your need.
    3. In the Email body field, personalize the message by including the generated password and clear instructions to inform the user that a password reset is required.
  18. Click on the If action.
  19. In the Edit actions > If screen,
    Configure branch name for If action for bulk reset user passwords rule.
    1. Rename Fallback Branch to No secondary work email. 
    2. Click on Add next action.
  20. In the Select an action screen, select Email action.
    Select Email action on select an action screen.
  21. In the Edit actions > Email screen,
    Configure email action of fallback branch for bulk reset user passwords rule
    1. In the To field, enter the admin’s email address to notify them about the required update to the secondary work email.
    2. In the Subject field, customize the subject line as per your need.
    3. In the Email body field, customize the message to notify the admin about updating the user’s secondary email address.
    4. Click Review.
  22. In the Review screen,
    In the Review page, provide rule name and create bulk reset user passwords rule.
    1. In Rule name, give your rule a name for easy identification.
    2. Click Create.
  23.  The automation rule is created.
    xFanatical Foresight rule graph for bulk reset password for users in Google Workspace.
    xFanatical Foresight rule graph for bulk resetting passwords for users in Google Workspace.
Verify Automation

Verify Automation

To ensure that your rule setup automates as expected, it’s essential to conduct a simple test. The following instructions demonstrate how xFanatical Foresight streamlines and automates bulk password resets, ensuring efficiency, security, and accuracy.

  1. Go to xFanatical Foresight.
  2. Go to the Templates page.
  3. Search the Bulk Reset Users Passwords template and click on it.
  4. Click on the Download sample CSV file button, or if you set up automation from scratch, then use the CSV file which you have created.
    Download CSV file from bulk reset password for users template
  5. In the downloaded CSV file, replace the sample data with the actual primary email addresses of the users whose passwords you need to reset in Google Workspace.
  6. Go to the Rules page.
  7. Click on the upload-button. of Bulk Reset Users Passwords rule.
    Upload CSV file to bulk reset password for users rule.
  8. Select the CSV file to upload, which is set up in Step 5.
  9. Wait for the CSV file to be processed and receive a notification in the top right of xFanatical Foresight. In the notification message, click View log.
    A notification will be triggered and sent upon the execution of the rule, informing users of the action taken.
  10. In the Logs > Log details page, the Rule history section explains the automation history and task xFanatical Foresight has automated on behalf of your Google account.
    A detailed log screen, sent upon the execution of the rule, informing users of the action taken.
  11. If the user does not have a secondary work email, the system will notify the admin to update the user’s secondary work email address in the Google Admin Console.
  12. Sign into the admin’s Gmail account and verify that the admin received the email regarding the user’s secondary work email address update.
    Verification for successful rule execution.
  13. If the user has a secondary work email configured, a password reset update will be sent to their Gmail account.
    A detailed log screen for Gmail inbox of the user.
  14. Sign in to the user’s Gmail account to verify that the email regarding the password reset has been successfully received.
    Verification for successful rule execution for user reset password

Notes

  • Once the admin uploads CSV file to the rule, xFanatical Foresight takes full control, automatically resetting user passwords in bulk across Google Workspace.
  • Make sure the upload file to rule headers should be the same as sample CSV file downloaded from Bulk Reset Users Passwords template.
  • A user must have their secondary work email set in Google Admin > Users > {User name} > User information > User details > Contact information > Email (Work).
  • The email is sent to the user's Secondary work email, instead of their primary work email, because the user cannot log in to their account after a password reset.
  • If the Secondary work email is not set, the automation will skip the password reset for that user and send an email notification to the admin to add the secondary work email and retry the automation.
  • With the default configuration, users are required to reset their passwords after signing into their Google accounts using the randomly generated passwords.
  • The user accounts must be active for users to log in and reset their passwords.
  • At each time a rule is executed, you will receive a notification in the app telling you how it has happened to your rules and whether rules ran successfully or not.

Conclusion

In conclusion, using xFanatical Foresight to bulk reset user passwords in Google Workspace simplifies and streamlines password management. By automating this process, administrators can ensure enhanced security, compliance, and consistency across the organization without the need for manual intervention. With its simple interface and powerful automation, xFanatical Foresight makes managing user credentials faster, more efficient, and error-free, saving valuable time.

Try a 14-day free trial with xFanatical Foresight and manage your tasks.

Related Articles

For more article please visit our website: Articles