How to Create a Mailing List from a Google Docs Spreadsheet


This wikiHow teaches you how to create a spreadsheet with contact information using Google Docs. You can use a mail merge add-on in Google Docs to convert the contact info in your Google Docs spreadsheet into a mailing list, and then send an email using Gmail. Gmail has a daily sending limit of 500 emails per day.[1]

Part 1
Installing the "Yet Another Mail Merge" Add-on

Installing the

1
//docs.google.com using a web browser. You can use any web browser on PC or Mac. This is the web address to Google Docs.

Installing the

2
It's the icon with three horizontal lines in the upper-left corner. This displays the menu to the left.

Installing the

3
It's in the menu that flies out when you click the icon with three horizontal lines. It's next to an icon that resembles a green sheet of paper with a table on it. This opens Spreadsheets in Google Docs.

Installing the

4
It's the first square at the top of the page that has an icon that resembles a colorful plus (+) sign. This creates a new Google Spreadsheet document.

Installing the

5
It's in the menu bar at the top of the website. This displays a drop-down menu.

Installing the

6
It's in the drop-down menu below "Add-ons". This displays a window you can use to search for and install add-ons.

Installing the

7
The search bar is in the upper-right corner of the window. This produces a list of Mail Merge add-ons.

Installing the

8
It's the blue button to the right of the "Yet Another Mail Merge" add-on. It has a red icon with an icon that resembles an envelope with a rocket under it. A free version of "Yet Another Mail Merge" allows you to send up to 50 emails per day. A personal plan costs $24 per year and allows you to send up to 400 emails per day. There are other mail merge add-ons you can install too. Try different ones to see which one you like best.

Installing the

9
When you add the add-on, it displays a list of Google accounts. Click the Google account you want to grant the add-on access to. If you don't see the Google account you want to use, click Use another account and sign in with the email address and password associated with your Google account.

Installing the

10
It's the blue button at the bottom of the page in the window.

Part 2
Creating A Spreadsheet of Contact information

Creating A Spreadsheet of Contact information on How to Create a Mailing List from a Google Docs Spreadsheet

1
//docs.google.com using a web browser. You can use any web browser on PC or Mac. This is the web address to Google Docs.

Creating A Spreadsheet of Contact information on How to Create a Mailing List from a Google Docs Spreadsheet

2
It's the icon with three horizontal lines in the upper-left corner. This displays the menu.

Creating A Spreadsheet of Contact information on How to Create a Mailing List from a Google Docs Spreadsheet

3
It's in the menu that flies out when you click the icon with three horizontal lines. It's next to an icon that resembles a green sheet of paper with a table on it. This opens Spreadsheets in Google Docs.

Creating A Spreadsheet of Contact information on How to Create a Mailing List from a Google Docs Spreadsheet

4
It's the first square at the top of the page that has an icon that resembles a colorful plus (+) sign. This creates a new Google Spreadsheet document.

Creating A Spreadsheet of Contact information on How to Create a Mailing List from a Google Docs Spreadsheet

5
Use the first row at the top of the spreadsheet to create headers for your contact information in each cell. Type First and last in the first two cells create a column your contacts first and last names. Then type Email in a cell at the top of the spreadsheet to create a column for your contacts email addresses. You can also create headers for any other information you have, such as Phone number and Location or Address.

Creating A Spreadsheet of Contact information on How to Create a Mailing List from a Google Docs Spreadsheet

6
Type the contact's name in the columns below the "First" and "Last" header cells. Then type their email in the column below the "Email" header. Then add any other contact information you have in the columns below the appropriate headers. You can also import contact information by clicking Add-ons and then selecting Yet Another Mail Merge. Select Import Contacts and then select Google Contacts or Other CRMs. Select a contact group using the drop-down menu next to "Groups", and then click Import Contacts.

Part 3
Creating an Email Template

Creating an Email Template on How to Create a Mailing List from a Google Docs Spreadsheet

1
//mail.google.com in a web browser. You can use any web browser on PC or Mac. This is the website for Gmail. If you aren't logged in, click your Gmail account, or click Use another account and sign in with the email address and password associated with your Gmail account.

Creating an Email Template on How to Create a Mailing List from a Google Docs Spreadsheet

2
It's in the upper-left corner of the Gmail website. It's the white button with a colorful plus (+) sign.

Creating an Email Template on How to Create a Mailing List from a Google Docs Spreadsheet

3
There is no need to enter anything in this line. This line will be filled in with the Yet Another Mail Merger add-on.

Creating an Email Template on How to Create a Mailing List from a Google Docs Spreadsheet

4
Use the "Subject" line to type a subject for the email you intend to send using the contacts from your spreadsheet.

Creating an Email Template on How to Create a Mailing List from a Google Docs Spreadsheet

5
Type the message you intend to send to your contacts in your spreadsheet. Gmail automatically saves your email as a draft every minute or so. You can pull information from your spreadsheet by typing $%[Header]% in your email message. For example, if you want to address the recipient by their first name, you would type something like Hello $%First% in the email message. This will pull the contacts name from the email.[2]

Part 4
Using the Another Mail Merge to Create a Mailing List

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

1
//docs.google.com using a web browser. You can use any web browser on PC or Mac. This is the web address to Google Docs.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

2
It's the icon with three horizontal lines in the upper-left corner. This displays the menu.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

3
It's in the menu that flies out when you click the icon with three horizontal lines. It's next to an icon that resembles a green sheet of paper with a table on it. This opens Spreadsheets in Google Docs.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

4
To open the spreadsheet, click on the document in the list of Spreadsheets.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

5
It's in the menu bar at the top of the web page.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

6
This displays a sub-menu for Yet Another Mail Merge.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

7
It's at the top of the Yet Another Mail Merge sub-menu.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

8
It's the blue button at the top of the window in the middle of the page. The pop-up window lets you know that you can send 50 emails per day using the free version of Yet Another Mail Merge. The Personal Plan costs $24 per year and allows you to send 400 emails per day.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

9
Use the line next to "Sender Name" to type your name.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

10
Click the drop-down menu next to "Email Template" and select the email template you created for your mail merge in Gmail from the list of email templates.

Using the Another Mail Merge to Create a Mailing List on How to Create a Mailing List from a Google Docs Spreadsheet

11
It's the blue button in the lower-left corner of the window. This sends an email to all the email addresses below your "Email" header using the email template you selected. You can view a tracking report on the right. The "#" in the "Send # Emails" displays the number of emails you will be sending. Click Recieve a Test Email to send yourself a test email before sending the email to everyone in your spreadsheet.