Merge by MailChimp - Google Docs add-on
Merge by MailChimp is a simple add-on that lets you send to a list of emails directly from Google Docs and Sheets.
Merge makes it easy for organizations to create and send personalized email right from a Google Doc. By pairing your Google Doc to a Google Sheet with users’ email addresses and data fields, you can merge in personalized content like first name, last name, address, etc., right from your Google Sheet. Then, when you’re ready, hit send. It’s that simple. Merge by MailChimp merges in the data from your sheet and sends the email content to the addresses in your Google Sheet. Use the Reporting tab to see how many emails were delivered and how many people have opened your email.
Merge by MailChimp is designed for sending to small groups of 1000 email addresses or less, and monthly total sends are limited to 6000. Need to send more than that? Check out MailChimp, the app that powers Merge.