Division of Information Technology

Mail Merge in Google Mail with a Google Sheet

Use this Google Apps Script in a Google Sheet to "Automatically populate an email template with data from Google Sheets. The emails are sent from your Gmail account so that you can respond to recipient replies."

Audience: Clubs, Faculty, Researchers, Staff, Students and Teaching Assistants

This KB Article References: Google Mail
This Information is Intended for: Clubs, Faculty, Researchers, Staff, Students, Teaching Assistants
Last Updated: September 12, 2023
Average Rating: Not Rated
Your feedback is important to us, help us by logging in to rate this article and provide feedback.

Google has a pre-written script you can use for Mail Merge using Google Sheets and Gmail. Make a copy of the template and learn how to use it here.

Learn more about using this script in these Slides and Videos

More KB Articles Like This

Customizations
Adding the Stony Brook Logo to Your Google Mail Signature

Additional Information

Files & Links

Related Links: 
Create a mail merge with Gmail & Google Sheets

Provide Feedback

Your feedback is important to us, help us by logging in to rate this article and provide feedback.

Sign in with NetID

Getting Help

The Division of Information Technology provides support on all of our services. If you require assistance please submit a support ticket through the IT Service Management system.

Submit A Quick Ticket

Hosted By

DoIT Training and Development