How to Send Mass Email from Google Sheets (Easiest Way 2023)

Click here to Send Mass Email From a Lido Spreadsheet

In this article we will show how to send mass email from google sheets in just a few simple steps using apps script and with Lido

Send Bulk Email From a Lido Spreadsheet (Easiest Way)

1. Inputting Recipient Details into Google Sheets

Start by populating Sheet 1 with details like the recipient's name, email, and any other relevant data. Keep each piece of data in its own column.

how to send mass email from google sheets

2. Set Up a Lido Account

Lido, an advanced spreadsheet software designed for automation, works seamlessly with Google Sheets. It lets you automate without delving into Google Apps Script or other coding methods. Sign up for free at Lido's Signup Page.

3. Link your Google Sheet with Lido

  • Click the ‘Connect Data’ button located at the top left.
  • Opt for Google Sheets.
  • Paste your Google Sheets link and proceed to connect.
  • Authenticate your Google account when prompted.
  • Select the columns from your Sheet you want to sync with Lido. Lido will ensure your records are continuously updated.
  • Choose 'Add Data', and your spreadsheet data will now be reflected in Lido.
how to send a mass email from google sheets
mass email google sheets
mass email from google sheets
how do i send a mass email from google sheets

4. Draft Your Email Template in a Fresh Worksheet

In a new worksheet, draft your email subject and body. Use this format [@Column] to reference your columns.

For instance:

Subject: Thank you, [@Name]
Body: Hello [@Name], we've received your inquiry regarding [@Service].

how to send bulk email from google sheets

5. Create Columns for Email Subject & Body Using Templates

Lido offers a formula, =STRINGTEMPLATE(), which substitutes column references (e.g., [@Name]) with the row values from a table.
For creating dynamic subjects and bodies:

  • Use this for the subject: =STRINGTEMPLATE(Sheet1!$B$1)
  • And this for the body: =STRINGTEMPLATE(Sheet1!$B$2)

This will dynamically populate the subject and body columns with your content.

6. Implement the =SENDGMAIL() Formula

To send an email via Lido, the formula is =SENDGMAIL(sender, recipient, subject, body).

SENDGMAIL("", B2, D2, E2)

Input this formula next to your body column to generate another Computed Column.

7. Conduct an Email Test

For a test run, right-click on a SENDGMAIL formula cell and opt for 'Run action'. The first time, you’ll need to sign in to your Gmail.

8. Dispatch All Emails

Click the 3-dot menu in your SENDGMAIL column and choose 'Run column now' for dispatching all emails simultaneously.

You have now mass emailed all of the names and emails in your google sheet!

Send Bulk Email From Google Sheets (AppsScript)

You can also send bulk email using AppsScript but this is more complex and less user friendly than the method above. If you are more tech savvy, here are the steps:

1. Format the Spreadsheet

The script we will use to send mass email requires two sheets / tabs to work correctly: one for the email list and the other for the email subject and body:

Rename the first tab emails: add the following headers for each column: Name for Column A; Email Address

for Column B; Phone number for Column C; and Sent? for Column D

how to send mass email from google sheets

Create a second tab called subjectbody. In Column A we will add the headers Email Contents in cell A1, Subject in cell A2 and Body in cell A3.

We will set B2 as the cell containing the email subject and C2 as the cell containing the email body. We also add the headers in Column A: Subject 

how to send a mass email from google sheets

We can add dummy data first to see whether the script works later on. 

Email list:

mass email google sheets‍

Subject and body:

mass email from google sheets‍

2. Click Extensions then select Apps Script

We are now ready to add the script. Click Extensions then select Apps Script

how do i send a mass email from google sheets

A new tab containing the Apps Script workspace will be loaded, with placeholder code placed in the code area.

how to send bulk email from google sheets

We will clear the code area by selecting the placeholder code and deleting it. You can do this using keyboard shortcuts: Ctrl+A then Del for Windows and Cmd+A then Delete for Mac OS. 

Google apps script page‍

3. Copy and Paste Script to Apps Script

Go to the following page:

Github, copy raw file icon in the upper-right corner of the code area‍

Copy the entire code by clicking the Copy raw file icon in the upper-right corner of the code. 

Script we will import, stored in github

After copying, paste it in the code area of Apps Script

Apps script with code pasted‍

Click Save project.

Save project icon above code area, apps script

You can now close the Apps Script tab.

4. Insert a Button

To run the script on demand, we need to insert a button. To start, click Insert then select Drawing. Alternatively, if you already have designed a button and saved it in an image file, click Image then follow the instructions on uploading it to Google Sheets. 

Click insert, select drawing‍

In the Drawing box, start drawing a button that you want to use. Once you are done, click Save and Close

Drawing area, button drawn‍

The button will be inserted to the spreadsheet. Hover your cursor over the button. A set of three dots will appear on the upper-right corner of the button. Click it, then select Assign script among the drop-down list that will appear. 

Right click button, select assign script

A small box will appear with a textbox. Type emailMerge to the textbox, then click OK.

Assign script, name of the function typed

5. Authorize Script

Since it is the first time you will run the script, Google will ask for your authorization to run it. Click Continue

Authorization required box, click continue

A new window will appear, asking you to select the Google account associated with the spreadsheet containing the button. 

Choose an account to run the script

After selecting the account, a warning will appear reminding you that Google has not verified the app. Click the small link on the lower-left corner labeled Advanced. Another reminder will appear to continue only if you understand the risks and trust the developer. Click Go to Untitled project (unsafe) or whatever the project name is in Google Apps Script.

Google asking you to run the script even if it is not verified

A new page will appear listing the permissions needed by the script. Click Allow

List of permissions needed by the script, click allow

The window will close, and the script will run. You have now successfully sent emails to your email list!

Dummy email sent as test of the script‍

You will see that the timestamp when the email was sent will appear in Column D. 

Timestamp of email sent listed in the sheet‍

What if you want to send an email to the same recipient? Simple. Delete the timestamp. The script is designed to not send emails to recipients with existing time stamps.

We hope that you now have a better understanding of how to send mass emails from google sheets!

If you enjoyed this article, check out our article on how to set up email notifications in google sheets or how to set up email reminders in google sheets.

Lido is a new spreadsheet built for automation. Trigger emails, slack messages, and more directly from a spreadsheet.