Home → Google Workspace Mail Merge → Printer Friendly Version

Google Workspace Mail Merge

Mail Merge is a powerful tool for writing a personalized E-mail to many people at the same time. It uses the data from GSheet and then uses that to replace placeholders/merge fields throughout the message with the relevant information for each individual that is being messaged.

1. Mail Merge

1.1. How to Mail Merge

https://workspace.google.com/marketplace/app/mail_merge/218858140171

To use mail merge in Gmail:

  • Open Gmail on your computer and click Compose.
  • In the "To:" line, add your recipients and click Use mail merge on the right.
  • Turn on Mail Merge, then enter @ in your message to select and insert a merge tag, such as `@firstname`, `@lastname`, `@fullname`, or `@email`.

To use the Mail Merge add-on with Google Sheets and Google Docs:

  • Prepare a Google Sheets file where the first row contains column names to be used as merge fields.
  • Open your Google Docs template, start the add-on by clicking Add-ons > Mail Merge > Start, and select your spreadsheet.
  • Insert the merge fields into your template, and when ready, click the blue Merge button to start the process.