Password generator
and credential sender

This script adds two powerful tools to your Google Sheets menu: a bulk email sender for credentials and a strong password generator.

⚙️ Installation & Setup

Copy the Google Sheet that containing the script, and then open it.

🔑 First-Time Authorization

The very first time you try to run a function from the Password tool menu menu, Google will ask for permission. This is a standard security step.

1. Select a function from the menu, like "Send Credentials".

2. A dialog box will appear asking for authorization. Click Continue.

3. Choose your Google account.

4. You may see a warning that "Google hasn't verified this app." This is normal for personal scripts. Click Advanced, and then click "Go to [Your Script Name] (unsafe)".

5. Click Allow to grant the necessary permissions. You only need to do this once.

🔒 How to Use: Generate Passwords

This feature quickly fills a range of cells in any column with unique, strong passwords.

1. Run the Generator

• Click on the menu Password tool menu > Password Generator > Generate Passwords.

2. Follow the Prompts

A series of pop-up boxes will ask you for the following information:

1. Column Letter: The column where you want the passwords (e.g., C).

2. Start Row: The first row number to fill (e.g., 2).

3. End Row: The last row number to fill (e.g., 50).

4. Password Length: How many characters the password should have (minimum 12).

Once you've entered the details, the script will instantly populate the selected range with strong, random passwords. ✅

📧 How to Use: Send Credentials

This feature sends an email to each person in your sheet containing the data from their specific row, formatted in a clean table.

1. Prepare Your Data

• Your sheet must have the recipient's email address in the first column (Column A).

• The very first row of your sheet must be your headers (e.g., Email, Username, Password, Website). These headers will be used as labels in the email.

2. Run the Script

• Click on the menu Password tool menu > Email Sender > Send Credentials.

• The script will process all rows and send the emails.

• A confirmation message will appear when the process is complete.

Important Notes

• Log Sheet: A new sheet named SendLog is automatically created to track every email that was sent, failed, or skipped.

• No Duplicates: The script checks the SendLog before sending. If an email address is already in the log, it will be skipped to prevent sending the same credentials twice.