Create a mail merge with Gmail & Google Sheets Print

Step 1: Set up the spreadsheet.

1. Click here to make a copy of the Gmail/Sheets Mail Merge sample spreadsheet.
2. Update the Recipients column with email addresses you want to use in the mail merge.
3. (Optional) Add, edit, or remove columns to customize the data you want to include in your email template.
   If you change the name of the Recipient or Email Sent columns, you need to update the corresponding code in the Apps Script project. To open the Apps Script project, click Extensions > Apps Script.

Step 2: Create an email template.

1. In your Gmail account, create an email draft. To include data from the spreadsheet in your email, use placeholders that correspond to column names surrounded by curly braces, such as {{First Name}}.
2. Copy the subject line of your email draft.

Step 3: Send emails.

1. In the spreadsheet, click Mail Merge > Send Emails. You might need to refresh the page for this custom menu to appear.
2. When prompted, click Review permissions and authorize the script.
3. Click Mail Merge > Send Emails again.
4. Paste the email template's subject line and click OK.