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:
Google Mail
This Information is Intended for:
Instructors,
Researchers,
Staff,
Students
Created: 11/19/2014 Last Updated: 12/12/2023
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