Getting Started

How To Use Mail Merge Addon

Overview

This add-on is for users of Gmail and Google Spreadsheet.
(It is also available for those who use their company’s domain email address with Gmail.)

Prepare your mailing list in Google Sheets
Create a list of email addresses and the items you would like to insert into the emails as shown in the example below.
Create your email template in Gmail
Open Gmail, click [Compose] and create a template.
Enter {{column name}} in the subject line or body and the values in that column will be inserted into the email. ex: Hello, {{name}}.
Once you have created the template, press the x in the upper right corner to close it
Make sure you have the created template in your drafts folder.
Reopen the spreadsheet you just created.
Click [Extensions]->[Mail Merge from Threeups]->[Start] in the menu.
Select the template you just created in the Template field
Select sender’s email address
Enter sender name
Select the column name of the recipient’s email addresses
Click [Send Test Email]
An email generated based on the information in the first line will be sent to the logged-in account.
Check your gmail’s inbox to see if you received the test email and make sure the contents of the email is correct.
Click [Send] to start sending emails.
A column named [SEND_STATUS] is added to the rightmost column. The word [Sent] is inserted to the column when an email has been sent successfully. If you close the dialog box, the sending process finishes.