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: December 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

**Customizations**
Adding the Stony Brook Logo to Your Google Mail Signature

Additional Information

Files & Links

Provide Feedback

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

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

Customer Engagement and Support

Customer Engagement and Support Help Portal