News & Updates

A Step by Step Guide to Setting Up Mail Merge in Gmail

When you need to send a large number of personalized emails, but not enough to justify using a full marketing automation platform, mail merge can be a powerful tool. We have put together this step-by-step explanation on how to mail merge and set up emails sent to relatively large mailing lists using Gmail and G Suite with the plug-in Yet Another Mail Merge.

Mail Merge Using G Suite (Gmail, Contacts, Google Sheets)

Step 1 - Install Plug-in

Follow this link to download the Google Spreadsheet add-on, or open a Google Spreadsheet and click on Add-ons > Get add-ons and search for “Yet Another Mail Merge."



Step 2 - Create your mailing list

Using Google Spreadsheets, import your contacts to a new workbook. Alternatively, input contacts manually using separate columns for Email Address, First Name, Last Name, and any details you would like to include to personalize the message.


Step 3 – Create your email

In your Gmail box, compose a new email message to create your email template. Using double curly brackets, include fields as placeholders for {{First Name}} and/or any information you would like to personalize for each email. Make sure the information you include in the brackets matches the column headers exactly as this plug-in is case sensitive.


Step 4 – Mail Merge

Go back to your Google Spreadsheet from Step 2. Start Mail Merge under Add-ons > Yet Another Mail Merge > Start Mail Merge.


You can send up to 50 recepients by clicking continue on the next screen.


On the next screen, select the email draft you created in Step 3 under email template. Once you’ve confirmed that all of the settings are correct for you, click on “Receive a test email.”


If you are satisfied with the test, continue to send your emails.

Additional information:

For more information, check out the developer's website

There are several other plug-ins available for mail merge with G Suite. Mail Merge with Attachments is one such alternative.

Request a Free Trial and Boost Sales

SciLeads is easy to use and delivers unique insights and opportunities that help drive your sales and marketing activities forward. Get in touch to learn more.

Request your Free Trial

© 2015-2021 SciLeads Ltd. All Rights Reserved
Terms & Conditions | Privacy Policy | Do Not Sell My Personal Information
We have received European Union support.

North American Office - 701 West Georgia Street, Suite 1500, Vancouver, British Columbia, V7Y 1C6, Canada
Headquarters - Arnott House, 12-16 Bridge Street, Belfast, BT11LU, United Kingdom