How to Send Mass Email from Google Sheets: A Step-by-Step Guide

Sending mass emails from Google Sheets can be a game-changer, especially if you’re looking to efficiently reach a large number of recipients. By using Google Sheets alongside Google Apps Script, you can automate your email campaigns without the need for expensive software. Here’s a quick overview of how to accomplish this: You’ll set up a Google Sheet with your email data, write a script to automate the email sending, and then run the script to send out your emails.

How to Send Mass Email from Google Sheets

In this section, we’ll break down the steps to send mass emails from Google Sheets. By the end, you’ll be able to automate your email campaigns effortlessly.

Step 1: Set Up Your Google Sheet

Create a new Google Sheet and organize it with columns for recipient email addresses, subject lines, and email body content.

You’ll want to label the first row with headers like "Email," "Subject," and "Message." This makes it easy for the script to identify which data to use.

Step 2: Open the Script Editor

Go to the "Extensions" menu, select "Apps Script."

This will open a new tab where you can write your script. Apps Script is Google’s scripting language, which makes automating tasks in Google Sheets a breeze.

Step 3: Write the Script

Copy the following code into the script editor:

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2; 
  var numRows = sheet.getLastRow(); 
  var dataRange = sheet.getRange(startRow, 1, numRows, 3);
  var data = dataRange.getValues();

  for (var i = 0; i < data.length; ++i) {
    var row = data[i];
    var emailAddress = row[0];
    var subject = row[1];
    var message = row[2];
    MailApp.sendEmail(emailAddress, subject, message);

This script will loop through each row, picking up the email address, subject, and message, and sending the email using the MailApp service.

Step 4: Authorize the Script

Click the "Run" button, and then grant the necessary permissions.

The script needs permission to send emails on your behalf, so you'll be prompted to authorize it. Just follow the on-screen instructions to complete this step.

Step 5: Run the Script

After authorization, click the "Run" button again to send your emails.

The script will now execute and send emails to all the addresses listed in your Google Sheet. You can check your "Sent" folder in Gmail to verify that the emails have been sent.

After completing these steps, the script will send emails to all the addresses listed in your Google Sheet based on the subject and message content you’ve inputted. This can save you a ton of time, especially if you need to send out hundreds of emails.

Tips for How to Send Mass Email from Google Sheets

  • Avoid Spam Filters: Make sure your email content is meaningful and avoid spammy language to prevent your emails from landing in the spam folder.
  • Personalize Emails: Use placeholders in your Google Sheet and modify the script to personalize each email.
  • Test First: Run the script on a small batch of emails to make sure everything works correctly before sending out your entire list.
  • Track and Analyze: Use Google Analytics or other tools to track the effectiveness of your email campaign.
  • Backup Data: Always keep a backup of your Google Sheet and script in case something goes wrong.

Frequently Asked Questions

What if I need to send attachments?

You can modify the script to include attachments by using the MailApp.sendEmail method with advanced options.

How do I schedule the script to run automatically?

You can set up a trigger in the Google Apps Script editor to run the script at specific intervals.

Is there a limit to how many emails I can send?

Yes, Google's daily sending limit is 100 emails for free accounts and 2,000 for G Suite accounts.

Can I use this method for marketing purposes?

While you can, be cautious. Make sure to comply with email marketing laws, like GDPR and CAN-SPAM.

What happens if an email fails to send?

The script won't handle errors by default. You can add error handling in your script to manage this.

Summary of How to Send Mass Email from Google Sheets

  1. Set up your Google Sheet.
  2. Open the Script Editor.
  3. Write the script.
  4. Authorize the script.
  5. Run the script.


Now that you know how to send mass email from Google Sheets, you can streamline your email campaigns and save valuable time. This method is perfect for small businesses, educators, and anyone who needs to reach a large audience without paying for expensive email marketing software. By following the steps outlined and keeping the tips in mind, you can ensure your emails are effective and compliant with legal regulations.

Feel free to explore more advanced features like adding attachments or personalizing each email for deeper engagement. And remember to test your script thoroughly to avoid mistakes. Happy emailing!