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.
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.
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.
Subject: Thank you, [@Name] Body: Hello [@Name], we've received your inquiry regarding [@Service].
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). Example:
SENDGMAIL("firstname.lastname@example.org", 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!
Copy the entire code by clicking the Copy raw file icon in the upper-right corner of the code.
After copying, paste it in the code area of Apps Script.
Click Save project.
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.
In the Drawing box, start drawing a button that you want to use. Once you are done, click Save and Close.
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.
A small box will appear with a textbox. Type emailMerge to the textbox, then click OK.
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.
A new window will appear, asking you to select the Google account associated with the spreadsheet containing the button.
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.
A new page will appear listing the 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!
You will see that the timestamp when the email was sent will appear in Column D.
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!