Note: MailChimp has discontinued this add on.

We’ve covered Add-ons for Docs and Sheets in a lot of detail, but I want to go in-depth on one of our absolute favorites. Merge by MailChimp uses the power of Docs, Sheets and Gmail to send custom bulk emails.

Merge actually mirrors the functionality of a Google Apps Script, but brings it into a much more user friendly interface so anyone can use it! You can create your email in Google Docs and personalize it with merge tags from Google Sheets.

You can install Merge (and a bunch of other Add-ons) right inside your Google Doc. From there you can pull in information from a specific Google Sheet so you can send out dynamic emails in bulk.