Prepare a contacts list in a Google sheet

YAMM uses the email addresses listed in a Google sheet to send mail merges. All you need to do is name one of the columns Email and list any other contact information in additional columns.

About this task

To illustrate a basic contacts list, we demonstrate how to add and fill the columns Email, First name, and Last name in this order. For the purposes of each mail merge, only the Email column is required. You can use each additional column to send further personalized information to each recipient.

Prerequisites

Make sure that you are logged in to your Google account.

Procedure

1. Open Google Sheets.

2. Create a new Google sheet by selecting Blank under Start a new spreadsheet.

   

3. In the first row, define the column names Email, First name, and Last name. The only requirement is that you correctly type the name of the Email column. The order in which you define the column names does not matter.

   

4. Fill out data for the recipients of your first mail merge.

   

Result

Your contacts list is now ready.

What’s next

You can now create an email template in Gmail for your first mail merge.