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."

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

Additional Information


KB Details
This KB Article References: Google Mail
This Information is Intended for: Instructors, Researchers, Staff, Students
Created: 11/19/2014
Last Updated: 12/12/2023

Hosted By


Customer Engagement and Support