Sending mass emails from Gmail is sometimes seen as a challenge. I can tell you it's not! In this article we'll look at the basics of building a mail merge script for Gmail and how it can fit your email marketing needs. First, here's what you need to send emails in bulk with Gmail: Gmail (or Google Workspace) account a list of contacts a template of the emails you want to send basic development skills Now let's see the 6 steps to reproduce to create your Google script to send emails. Tutorial: Building a mail merge script for Gmail Open Step 1. Google Apps Script Click on the " " button to create a new project. You should now see the script editor. Step 2. New project From the Google Apps Script editor, copy and paste the following script: Step 3. { recipients = [ , ]; template = { : , : }

 recipients.forEach( {
 MailApp.sendEmail({ : recipient, : template.subject, : template.content
 })
 })
} ( ) function sendEmails const "sally@mailmeteor.com" "neil@mailmeteor.com" const "subject" "My mail merge script for Gmail" "content" `Hi, 
 
 I just wanted to show you how to send emails in bulk with my Gmail account! 
 
 Take care, 
 - Corentin 
 
 PS: <a href="https://mailmeteor.com/mail-merge-gmail/script">Click here to do it by yourself</a>` ( ) function recipient to subject htmlBody Update the variable with your list of recipients. Also update the variable with your subject and content to make it fit your needs. recipients template Click on "Save" to save your changes Step 4. Then click on "▶️ Run" to send your emails. Step 5. Note: the first time you use the script it will ask for the permission to send emails on your behalf. Then it won't ask you again. Emails are usually immediately delivered, but sometimes it takes a few seconds. Check your to confirm that all emails have been sent! As you will see, all your recipients receive a unique email sent from your email address. You don't need to use or any other techniques. "Sent" folder in Gmail bcc Conclusion Some say that it's impossible to send emails in bulk with Gmail. They can't be more untrue. Of course, this is a very basic macro for Google Sheets to send lots of emails with Gmail. You might need to adapt it a little bit more, but thanks to Google Apps Script you can do lot of things. Before you go, here are two things to keep in mind when using Gmail as an email marketing tool: Especially, note that you are limited to send a reasonable amount of emails per day. If you have a @gmail.com email address, you can send at most 500 emails/day while with a Google Workspace account, you sending limit hits 2000 emails per day. That's probably well enough for 99% of Gmail users, but it's good to have in mind those limits. Be sure to abide by Gmail bulk senders guidelines . If you are looking for more a advanced script, for example that let you send personalized emails (e.g. Hi ), I'd recommend you to use a Gmail mail merge tool such a that does it for you. It already handles personalization, as well as dozens of features from attachments to aliases. Learn more about the . {{ firstname }} Mailmeteor features and benefits of Mailmeteor here This article is part of an extended guide on . If you want to learn much more, go check it out! Mail merge in Gmail (2021) Previously published at https://mailmeteor.com/mail-merge-gmail/script

Google

Read My Stories

Too Long; Didn't Read

In your car, at home, or at work — Bosch technology shapes many areas of life.

How To Create A Simple Mail Merge Script With Google Apps Script

Too Long; Didn't Read

Company Mentioned

Corentin Brossault

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

How To Create A Simple Mail Merge Script With Google Apps Script

Too Long; Didn't Read

Company Mentioned

Corentin Brossault

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES