How To Send a Mail Merge Using Google Sheets

Wish you could send a mass email to your students or families and track if they received or read the email? Using Yet Another Mail Merge (YAMM) in Google Sheets has you covered. Once you have it set up, one click can send your email to as many families or students as you would like!

First things first, make sure you add the Yet Another Mail Merge extension. This will allow the email magic to happen! Next, open a new Google Sheets document and create columns for any personalized info you would want in your emails. With my students, I typically include their first name, last name, and email address. If parents are included in your emails to students, you may want to add the parent names and parent emails in separate rows at the bottom.

Next, head to your Gmail account and create a new draft for an email. Create the email you would like to send to all of your students. If you would like to personalize the email to the first name (or last name) of your students or parents, in the email draft, put the title of your “First Name” column on your Google Sheet in double brackets in your email draft. Here is an example:

Dear {{First Name}},

I am so excited to have you in math class this year! I am…

Just be sure you use the correct style of brackets and the text in the brackets matches the title of the column on your sheet exactly.

Once your email draft is set, you are almost ready to go! Just head to your Google Sheet, select “Extensions” along the top menu, select “Yet Another Mail Merge for Gmail,” and then select “Start Mail Merge.” You will then be able to select your email draft and send your email to all recipients!

*Tip: I highly recommend sending a test email first, which you will be given the option to do. This will insure that you have the brackets and mail merge set up correctly!

Once sent, you will be able to track which recipients opened your email.

Learn more about how you can save on a wide range of middle school math games, task cards, scavenger hunts, math sorts, and more as a part of these 5th-8th grade math mega bundles.