Mail Merge in Gmail
Google has a Mail Merge add-on which we have enabled, which will allow you to send a mail merge using Google Sheets and Gmail. With this add-on, you can send up to 50 emails per day. Here the the steps to do so:
- Open a new Google Sheet.
- Go to Add-ons, Mail Merge with Attachments, and Create Merge Template.
- It will ask you for permission to run. Click Continue.
- Choose your Google account. Once you do so, you should have the permission box pop up. Click Allow.
- You will then have this sheet. You can add columns that pertain to your needs.
- If you would like to attach a file to the email, go to Add-Ons, Mail Merge with Attachments, and either "Insert files from Google Drive" or "Select files from Computer."
- When all your data is filled in and you are ready to send the email, go to Add-ons, Mail Merge with Attachments, and Configure Mail Merge.
- Fill out the fields, including sender's full name, and click Continue.
- You can then Use an existing Gmail draft message as a template or Write your own template in plain text or HTML.
- **Remember that putting {{ }} around the text (example: {{First Name}}) will pull the data from that column.
-
Send a Test Email to yourself to make sure it works. Once you are sure it works, click Run Mail Merge.
Video tutorial from the developer: