Merge to Emails

How to merge to emails using Google Sheets?

Mail merge to emails (powered by Gmail) from a Google sheet. Type your email body template or insert your HTML code for marketing campaigns. For Google Sheets linked to a Google form, a new email can be automatically sent on a Form Submit.

Video tutorial

Watch this quick tutorial or follow the step-by-step instructions below to find out how to mail merge from Google Sheets to emails.

If you have not done so already, install Mail Merge add-on for Google Sheets

Introduction to best mail merge for Gmail

The Mail Merge add-on is free to install, works from four Google Workspace apps, benefits from free 24/7 support, and it is packed with useful features that make mail merging easy. All of this means that Mail Merge is the best mail merge add-on available.

The steps below detail:

Step 1: Open and check source data

Open the Google Sheets data file from which you want to mail merge to email.

Make sure the first row in your sheet contains column names (Name, Address, Email, etc.). These column names are used as *|merge fields|* in your Google spreadsheet mail merge template.

To be able to mail merge to Gmail, you need to have at least one row of data under your column names.

You can import your Google Contacts into a Google Sheet by following the steps in this article.

Step 2: Start Google Mail Merge add-on

Start Mail Merge add-on by clicking on Extensions > Mail Merge > Start to open the Mail Merge dialog box.

Step 3: Set Email To field

In the Email To drop down menu, select the column containing the recipient's email address.

Typically, this is a column named Email. All cells in this column must have valid email addresses (except the column name). You can enter multiple email addresses in the same cell, separated by a comma, semicolon (e.g., abc@quicklution.com, xyz@quicklution.com).

You can further customize your mail merge settings by sending emails on behalf of someone else.

Step 4: Enter email subject

Enter your email Subject such as Confirm Contact Details.

You can also insert a merge field into the email subject (e.g., Confirm Contact Details for *|Name|*)

Step 5: Create mail merge template

Click on New under Body Template.

You can add multiple templates and they can be shared across different sheets inside your file.

Step 6: Type email mail merge template

Type your Google Sheets mail merge template and a name it.

This serves as the basis for your online mail merge to emails.

Step 7: Insert and format text or *|merge fields|*

Insert *|merge fields|* into your Google Sheets mail merge template by clicking in the desired location within the template, selecting a field from the Merge Field drop-down menu, and clicking on Add.

Repeat this step for all required *|merge fields|*.

*|Merge fields|* are the column names found in the first row of data in your Google sheet. You can change the (font, color, size, etc.) of the *|merge fields|* in your Google Sheets mail merge template in the same way you would regular text. You can further customize your template by adding images, file attachments and hyperlinks.

Step 8: Save email body template

Click on Save when you have finished editing your Google Sheets mail merge template.

Step 9: Select email body template

Select your template from the Body Template drop-down menu.

Step 10: Mail merge emails

At this point, you have three options:

A. Merge Emails: This mail merges to Gmail and send all of your emails straight away.

B. Merge to Drafts: This mail merges to Gmail's draft folder and give you the opportunity to check and edit your mail merge before you send it.

C. Send Test: This gives you a good idea of how your mail merge appears to recipients, before sending emails. It merges the first row of data in your sheet (that is row 2 since row 1 only contains column headers).

Select one of the three options above to start the mail merge to Gmail process.

Why the Quicklution Mail Merge add-on is the best mail merge for Google Docs:


Check out the other add-ons of Quicklution for Google Workspace, including Avery Label Merge add-on.