How to use Mail Merge in Gmail

This article guides you through the process on how to mail merge in Gmail without buying a monthly business plan, helping you boost efficiency by sending more personalized emails while maintaining a professional tone. Let’s check it out!

Table of Content

• What is Mail Merge ?
• How to do Mail Merge in Gmail from Google Sheets
• Watch On YouTube

What is Mail Merge ?

Mail Merge is a process which allows you to send personalized emails to a large list of recipients, in this you get option to attach a data source to an email template for customizing your email content

Google only provide Mail Merge option in Business Standard plan, which cost you around Rs. 736 per user / month. But, with our tool you can perform Mail Merge life time with just one time payment.

Let’s see how to mail merge google sheets with Gmail!

How to do Mail Merge in Gmail from Google Sheets

The first step is to create an HTML email template in a Google Doc, and the next step is to review the text format version of the email template. Our email format is as shown below.

Guide – How to send html email in Gmail ?

Access the tool from the button at the bottom

After the payment, please email us at datainnutshellsolutions@gmail.com, and then we will grant you access to the tool

Once you have access of the tool, create a copy of the tool

In your copy, go to Mail Merge tab

At this stage, your tool should look as shown below

There will be headers in three different colors – Black, Blue and Grey.

Black Header : It will be automated populated and is used to check email delivery status

Blue Headers : Next, the user has to enter the details here, which are mainly related to the critical email sections, such as:

• “Recipient Email List“ : Paste all the email addresses you want to send emails
• “Subject” : Subject Line of the emails
• “Send Attachment ?” : If you want to attach a file in the email then tick mark the check box
• “Attachment URL ID : Type PDF Only” : If attachment option is ticked then add the file ID.
  • Note : Your file attachment file should be in your Google Drive and you have provide the file ID in this column
• “Body” : Paste the Google Doc URL of the email template which was created earlier

Grey Headers : From column G to O you have to enter text that you want to replace with the placeholders {{Text1}}, {{Text2}}, {{Text3}} etc. in the HTML email template

Finally, you have to click on “Send Emails” button and wait for script to execute.

IMPORTANT : In Cell B3 you can also check your “Remaining Daily Email Quota:”, make sure you don’t cross your quota limit as it can trigger spam alert to Google and your account may get blocked.

Watch on YouTube Now!

If you don’t have time, you can directly watch the demo on YouTube

You’ll Love This