Automate: Password Generator

This bot generates automatic passwords according to specific password rules and then send these passwords to the users listed in the excel through emails.

Benefits

Simple and easy to generate random passwords, according to the given rules.
Create your own password policy for the bot to follow
Generated passwords will be send to the users via email.

Workflow

Working

Open Excel File activity opens the input excel file which has the required data with specified configuration, creates an Excel Handle and stores it in the specified Excel handle variable.

The robot will read the value of the excel sheet by using Read Sheet activity and stores it in a Data Table variable

In order to get Numbers for the password , we can use the counter activity. This activity creates a counter with a user-specified start value. This activity can be used with the Increment and Decrement activities.

Next, we can use For Each activity. This is a special activity that takes an item from the input data table variable, and uses it to execute the rest of the steps until it encounters the loop end. When the execution reaches the loop end it will it will check if all items in the collection are processed, the next activity is executed.

This activity increments a given Integer variable value on Counter activity variable

Generate Random Text activity generates a random text based on the given input size and text case. In the input section, the size of the random text can be given and here we can also select the required text case.

Get sub text activity gets a subtext from the random text generated from the previous activity.

In order to satisfy the specific rules of a password, it must have a mixture of both uppercase letters, lowercase letters, and numbers. Change text case activity, changes the text case of the subtext.

And join text activity joins these texts. In this activity there is also an option of adding a number between the texts.

Here, we can use join text activity again in order to join the mail body from the excel and the password together to create a new mail body.

Send SMTP Mail activity sends the email message by using SMTP protocol. In the Email configuration section, the email account used to send the message and the password of the mail account used to send the message can be given. In the server configuration section, the email server host that is to be used and port used to send the email message can be specified for e.g., if you are using Gmail, its server is "smtp.gmail.com". In the Property panel, Attachment, Subject, and To fields can be given from the excel data rows as shown below. These fields are taken from the excel sheet. And the email body is taken from the output of second Join text activity.