In this article we will show how to send mass email from google sheets in just a few simple steps using Lido
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.
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.
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].
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:
This will dynamically populate the subject and body columns with your content.
To send an email via Lido, the formula is =SENDGMAIL(sender, recipient, subject, body).
Example:
SENDGMAIL("youremail@gmail.com", B2, D2, E2)
Input this formula next to your body column to generate another Computed Column.
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.
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!
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 reminders in Google Sheets.
Conditional Formatting with Multiple Conditions in Google Sheets
Conditional Formatting with Custom Formulas in Google Sheets
