Google Docs / Google Docs Power User
Perform a mail-merge
Although Mail Merge is not a menu command in Google Docs, it is possible to perform an email mail merge using Google Sheets and Apps Script. You can list the names, email addresses and any other information to include in the mail merge into a spreadsheet, as well as the standard mail merge text for all recipients. A script will then perform the mail merge for you and email all addresses in the list.
Although you can create your own spreadsheet and add the script manually, you can save time with the mail merge by downloading our ready-to-use template.
You will be prompted to make a copy of the file in your My Drive.
Step 1 - Enter the mail merge data
Enter the names and email addresses of the people you wish to send the mail to
If you wish to include other personalised information in the email body, create any new columns of information as required. Ensure the column heading is typed in the first row of the spreadsheet, with the individual values for each person you are sending emails to underneath this heading.
Step 2 - Compose your email
When all address details have been added to the sheet, compose your email as normal in Gmail, entering a subject for the email that will be used later in the mail merge.
Where you wish to add data from the spreadsheet, type the column name in double braces e.g. {{First name}} or {{Description}}.
Your email can include tables, images, etc.
Step 3 - Running the mail merge
To run the mail merge:
Return to the sheet
Click on the Mail Merge menu and choose Send Emails
The first time you run the script, you will need to authorise it by clicking on Continue
Click on your account name
Click on Allow to authorise the script
Type or paste (Ctrl V/Cmd V) the subject of the email message you have composed
Click on OK
The sheet will record the date and time at which each email was sent.
Please note that to keep within Gmail’s sending limits, you should not email more than 2000 users per day using this method.