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."
This KB Article References:
This Information is Intended for:
Instructors,
Researchers,
Staff,
Students
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
Important Files & Links:
This Content Last Updated:
05/07/2025