Marketingpulse
Registered Member
- Mar 18, 2017
- 94
- 60
A lot of you have been asking about bulk emailing softwares. So, I thought to share this method I found on sending bulk emails using Gmail for free.
Step 1: Open a google sheet and paste your emails and message into first and second column respectively.
Step 2: Click tools and select script editor
Step 3: Copy and paste this code into the editor
Step 4: Change the number of emails to send and the subject
By default, it's 100.
This is the subject line. Unfortunately, this script can only send one subject line to all the emails.
Step 5: Click run
Note: It will require authorization to send emails on behalf of you.
Once you run it, it will send the message to all the emails that you have in first column with the message in second email.
That's it.
You can send bulk emails with whatever limit your account has. Typically, it's 500 for normal gmails accounts and up to 2k for Gsuite accounts.
The only limitations that I think is putting up messages in a column. Not sure about the format. Also, can't put any template but only text emails.
If someone can find a workaround it, then it would be awesome.
Hope it's helpful! Cheers
Step 1: Open a google sheet and paste your emails and message into first and second column respectively.
Step 2: Click tools and select script editor
Step 3: Copy and paste this code into the editor
Code:
function sendEmails() {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 1; // First row of data to process
var numRows = 100; // Number of rows to process
// Fetch the range of cells A1:B100
var dataRange = sheet.getRange(startRow, 1, numRows, 100)
// Fetch values for each row in the Range.
var data = dataRange.getValues();
for (i in data) {
var row = data[i];
var emailAddress = row[0]; // First column
var message = row[1]; // Second column
var subject = "Hello, how are you?";
MailApp.sendEmail(emailAddress, subject, message);
}
}Step 4: Change the number of emails to send and the subject
By default, it's 100.
This is the subject line. Unfortunately, this script can only send one subject line to all the emails.
Step 5: Click run
Note: It will require authorization to send emails on behalf of you.
Once you run it, it will send the message to all the emails that you have in first column with the message in second email.
That's it.
You can send bulk emails with whatever limit your account has. Typically, it's 500 for normal gmails accounts and up to 2k for Gsuite accounts.
The only limitations that I think is putting up messages in a column. Not sure about the format. Also, can't put any template but only text emails.
If someone can find a workaround it, then it would be awesome.
Hope it's helpful! Cheers
Last edited:
