Mail Merge is a Google Sheets add-on designed to send personalized emails, newsletters or forms to multiple recipients without needing to know how to write HTML for your templates.
Simply select your existing draft in Gmail or compose a template using our rich text editor and the add-on will replace the template tags with names or any other information from a spreadsheet, before automatically sending mass emails to a list of recipients.
Mail Merge is available on Gmail, Google Apps for Work, Education & Government.
Import contacts (name, email etc...) from Google contacts or add manually
Write your messages using visual editor or use existing Gmail draft as template
Add personalized attachment to each email using file URLs from your Google Drive
Add personalized cc and bcc to each email simply by adding cc, bcc columns in sheet
Send merged email immediately or schedule later at specific date and time
Open tracking for email in real time using Google Analytics Email Tracking Measurement