Bulk Email Sender

Bulk Email Sender Tool

Google Sheet ID: Google Apps Script URL: Email Subject: Email Body: Attach File:

Paste this Google Apps Script code into your script editor:

function doPost(e) {
    var data = JSON.parse(e.postData.contents);
    var sheet = SpreadsheetApp.openById(data.sheetId).getActiveSheet();
    var emails = sheet.getRange("A2:A" + sheet.getLastRow()).getValues().flat();
    var subject = data.subject;
    var body = data.body;
    
    emails.forEach(function(email) {
        try {
            GmailApp.sendEmail(email, subject, body);
        } catch (e) {
            Logger.log("Failed to send email to: " + email);
        }
    });
    return ContentService.createTextOutput(JSON.stringify({status: "Emails Sent"})).setMimeType(ContentService.MimeType.JSON);
}