Gmail Mail Merge Script Example using Google Apps Script

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 build your own mail merge for Gmail:

• a 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

1. Open Google Apps Script

2. Click on the “New project” button to create a new project.

3. You should now see the script editor.

   

4. From the editor, copy and paste the following script:

   Update the recipients variable with your list of recipients. Also update the template subject and content to make it fit your needs

5. Click on “Save” to save your changes
6. Then click on “▶️ Run” to send your emails.

Note: the first time you use this 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 “Sent” folder in Gmail 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 bcc or any other techniques.

Conclusion

Some say that it’s impossible to send emails in bulk with Gmail. It’s totally 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:

1. Be sure to abide by Gmail bulk senders guidelines. 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.
2. If you are looking for more a advanced script, for example that let you send personalized emails (e.g. Hi \{\{ firstname \}\}), I’d recommend you to use a Gmail mail merge tool such a Mailmeteor that does it for you. It already handles personalization, as well as dozens of features from attachments to aliases. Learn more about the features and benefits of Mailmeteor here.

This article was written by Corentin Brossault, Mailmeteor's CEO. Mailmeteor is a simple & privacy-focused emailing software for Gmail. Trusted by millions of users worldwide, it is often considered as the best Gmail mail merge to send mass personalized emails.