Merge to Emails
How do I merge to email using Google Sheets?
Mail merge to emails (powered by Gmail) from a Google Sheet. Write 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.
Watch a 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.
Introduction to the 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 is packed with useful features which make mail merge easy. All of this means that Mail Merge is the best mail merge add-on available.
The steps below detail:
How to create a mail merge from Google Sheets to Gmail template
How to mail merge from Google Sheets for free
How to email mail merge to Gmail for free
How to mail merge from Google Sheets to Gmail for free
Step 1: Open and check your 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, such as Name, Address, Email, etc. These column names will be 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 the Google Sheets Mail Merge extension
Start the Mail Merge add-on by clicking Extensions > Mail Merge > Start.
This will open the Mail Merge dialog box.
Step 3: Set your 'email to' field
In the Email To drop down 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 of course). You can enter multiple email addresses in the same cell, separated by a comma, semicolon, etc. (e.g. abc@quicklution.com, xyz@quicklution.com).
You can further customize your email merge settings by sending emails on behalf of someone else.
Step 4: Enter your email subject
Enter your email Subject, such as ‘Confirm Contact Details'.
You can even insert a merge field into the email subject, e.g. 'Confirm Contact Details for *|Name|*'.
Step 5: Create your mail merge template in Google Sheets
Click New under Body Template.
You can add multiple templates and they can be shared across different sheets inside your file.
Step 6: Write your email mail merge template in Google Sheets
Write your Google Sheets mail merge template and give your template a name.
This will serve as the basis for your online mail merge to emails.
Step 7: Add your *|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 and clicking 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 your email body template
Click Save when you have finished editing your Google Sheets email merge template.
Step 9: Select your email body template
Select your template from the Body Template drop-down.
Step 10: Mail merge to create your emails
At this point, you have three options:
A. Merge Emails: This will mail merge to Gmail and send all of your emails straight away.
B. Merge to Drafts: This will mail merge to Gmail's draft folder and give you the opportunity to check and edit your email merge before you send it.
C. Send Test: This will give you a good idea of how your email merge will appear to recipients, before sending emails. It will merge 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 email merge to Gmail process.
Congratulations! You now know how to mail merge from Google Sheets to emails and how to mail merge to Gmail using the best mail merge for free!
Why the Quicklution Mail Merge add-on is the best mail merge for Google Sheets:
Easy mail merge installation and free mail merge for your first 20 merges
Free mail merge online support for both free and premium customers, including 24/7 fast remote support, how to mail merge help and FAQs and video tutorials
Over 5 million users, over 20,000 reviews and a rating of 4.9/5 on Google Workspace Marketplace, and customers that include Google, Uber and Tripadvisor
Create a mail merge online using one add-on for Google Docs, Google Sheets, Google Slides and Google Forms, and enjoy seamless integration with Gmail and Google Drive
Easy mail merge from Google apps to emails, letters, envelopes, certificates and PDF files - anytime, anywhere - using your favorite web browser and operating system
Create your mail merge to emails with images, QR codes, barcodes, hyperlinks, file link attachments or personalized PDF attachments
Free mail merge to Gmail at scheduled times, automatically on a Google Form submit, on behalf of someone else or over SMTP
Managing your online mail merge is easy with useful tools such as filtering and tracking rows to merge
Check out Quicklution's online mail merge add-ons for Google Workspace, including Avery Label Merge.