Mail merge isn’t a native feature to Gmail currently. However the steps outlined below are a working around method that can be used. With this solution you can automatically populate an email template created as a Gmail draft with data from Google Sheets. Merged emails are sent from your Gmail account allowing you to respond to recipient replies. 


How to create a mail merge using Google 

  1. Create a copy of the sample Gmail/Sheets Mail Merge spreadsheet, or create your own in Google Sheets.

  2. Update the Recipients column with email addresses you would like to use in the mail merge.

  3. Create a draft message in your Gmail account using markers like {{First name}}, which correspond to column names, to indicate text you’d like to be replaced with data from the copied spreadsheet.

  4. In the copied spreadsheet, click on custom menu item Mail Merge > Send Emails.

  5. A dialog box will appear and tell you that the script requires authorization. Read the authorization notice and continue.

  6. When prompted enter or copy/paste the subject line used in your draft Gmail message and click OK.

  7. The Email Sent column will update with the message status.


Creating Additional Columns in the Google Sheet

  1. Click on the next column to the right.
  2. Add in your text using the {{}} annotation - for example {{Address}}
  3. Do not make changes to the Recipient or Email Sent Columns.