How to Create a Mailing List from a Google Docs Document Sheet

Table of contents:

How to Create a Mailing List from a Google Docs Document Sheet
How to Create a Mailing List from a Google Docs Document Sheet

Video: How to Create a Mailing List from a Google Docs Document Sheet

Video: How to Create a Mailing List from a Google Docs Document Sheet
Video: How to Speed Up Your File Transfers Drastically using PrimoCache | Windows 10 2024, November
Anonim

This wikiHow teaches you how to create a spreadsheet with contact information through Google Docs. You can use the mail merge add-on in Google Docs to convert the contact information on a spreadsheet in a document to a mailing list, then send the email using Gmail. However, Gmail has an email limit of (maximum) 500 messages per day.

Step

Part 1 of 4: Installing " Yet Another Mail Merge " Add-on

Create a Mailing List from a Google Docs Spreadsheet Step 1
Create a Mailing List from a Google Docs Spreadsheet Step 1

Step 1. Visit https://docs.google.com via a web browser

You can use any browser on your PC or Mac computer. The address is the web address of the Google Docs service.

Create a Mailing List from a Google Docs Spreadsheet Step 2
Create a Mailing List from a Google Docs Spreadsheet Step 2

Step 2. Click

It's an icon with three horizontal lines in the upper-left corner of the page. The menu will load on the left side of the page after that.

Create a Mailing List from a Google Docs Spreadsheet Step 3
Create a Mailing List from a Google Docs Spreadsheet Step 3

Step 3. Click Sheets

This option is in the menu that appears when you click the three horizontal lines icon. You can see it next to the icon of a green sheet of paper with a table. The spreadsheet will open in Google Docs.

Create a Mailing List from a Google Docs Spreadsheet Step 4
Create a Mailing List from a Google Docs Spreadsheet Step 4

Step 4. Click Blank

This option is the first box to have a colorful plus sign (“+”) icon at the top of the page. A new Google spreadsheet document will open.

Create a Mailing List from a Google Docs Spreadsheet Step 5
Create a Mailing List from a Google Docs Spreadsheet Step 5

Step 5. Click Add-ons

This option is in the menu bar at the top of the site. A drop-down menu will appear after that.

Create a Mailing List from a Google Docs Spreadsheet Step 6
Create a Mailing List from a Google Docs Spreadsheet Step 6

Step 6. Click Get Add-ons

This option is in the drop-down menu under "Add-ons". A new window will appear and you can use it to search for and install add-ons.

Create a Mailing List from a Google Docs Spreadsheet Step 7
Create a Mailing List from a Google Docs Spreadsheet Step 7

Step 7. Type Mail Merge into the search bar and press Enter

It's in the upper-right corner of the window. A list of mail merge add-ons will be displayed.

Create a Mailing List from a Google Docs Spreadsheet Step 8
Create a Mailing List from a Google Docs Spreadsheet Step 8

Step 8. Click + Free next to " Yet Another Mail Merge"

It's a blue button to the right of the add-on called " Yet Another Mail Merge ". This add-on is marked by a red envelope icon with a rocket underneath.

  • The free version of " Yet Another Mail Merge " allows you to send a maximum of 50 messages per day. The personal package/quota is offered at a price of 24 US dollars (approximately 350 thousand rupiah) per year and allows you to send a maximum of 400 messages per day.
  • There are a variety of other mail merge add-ons you can install. Try different options to see which add-on you like best.
Create a Mailing List from a Google Docs Spreadsheet Step 9
Create a Mailing List from a Google Docs Spreadsheet Step 9

Step 9. Select the primary Google account

When adding add-ons, a list of Google accounts stored in the browser will be displayed. Click the Google account whose access you want to give the add-on.

If you don't see the account you want to use, click “ Use another account ” and log in using the account email address and password.

Create a Mailing List from a Google Docs Spreadsheet Step 10
Create a Mailing List from a Google Docs Spreadsheet Step 10

Step 10. Scroll down and click Allow

It's a blue button at the bottom of the page in the window that opens.

Part 2 of 4: Creating a Spreadsheet with Contact Information

Create a Mailing List from a Google Docs Spreadsheet Step 11
Create a Mailing List from a Google Docs Spreadsheet Step 11

Step 1. Visit https://docs.google.com via a web browser

You can use any browser on your PC or Mac computer. The address is the web address of the Google Docs service.

Create a Mailing List from a Google Docs Spreadsheet Step 12
Create a Mailing List from a Google Docs Spreadsheet Step 12

Step 2. Click

It's an icon with three horizontal lines in the upper-left corner of the page. The menu will be displayed afterwards.

Create a Mailing List from a Google Docs Spreadsheet Step 13
Create a Mailing List from a Google Docs Spreadsheet Step 13

Step 3. Click Sheets

This option is in the menu that appears when you click the three horizontal lines icon. You can see it next to the icon of a green sheet of paper with a table. The spreadsheet will open in Google Docs.

Create a Mailing List from a Google Docs Spreadsheet Step 14
Create a Mailing List from a Google Docs Spreadsheet Step 14

Step 4. Click Blank

This option is the first box to have a colorful plus sign (“+”) icon at the top of the page. A new Google spreadsheet document will open.

Create a Mailing List from a Google Docs Spreadsheet Step 15
Create a Mailing List from a Google Docs Spreadsheet Step 15

Step 5. Create a header segment for contact information

Use the first row above the spreadsheet to create the contact information headers in each box. Type " First name" and " Last name ” in the first two boxes in the row to create a column containing the contact's first name and last name. After that, type " Email address ” in the next box at the top of the spreadsheet to create an email address column. You can also create headers for other available information, such as “ Phone number" and " City" or " Address ”.

Create a Mailing List from a Google Docs Spreadsheet Step 16
Create a Mailing List from a Google Docs Spreadsheet Step 16

Step 6. Enter the contact information under the header or in the appropriate fields

Type the contact's name into the box below the "First name" and "Last name" headers. After that, enter the contact's email address under the "Email address" header. Add other contact information in the field under the appropriate header/title.

You can also import contact information by clicking “ Add-ons " and choose " Yet Another Mail Merge " Choose " Import Contacts " and click " Google Contacts " or " Other CRMs " Specify a contact group using the drop-down menu next to “Groups”, then click “ Import Contacts ”.

Part 3 of 4: Creating Email Templates

Create a Mailing List from a Google Docs Spreadsheet Step 17
Create a Mailing List from a Google Docs Spreadsheet Step 17

Step 1. Visit https://mail.google.com via a web browser

You can use any browser on your PC or Mac computer. This address is the Gmail website address.

If you are not logged into your account, click the desired Gmail account or select “ Use another account ” and log in using the account email address and password.

Create a Mailing List from a Google Docs Spreadsheet Step 18
Create a Mailing List from a Google Docs Spreadsheet Step 18

Step 2. Click Compose

It's in the top-left corner of the Gmail website. This white button has a colorful plus sign (“+”).

Create a Mailing List from a Google Docs Spreadsheet Step 19
Create a Mailing List from a Google Docs Spreadsheet Step 19

Step 3. Leave the "Recipients" field blank

You do not need to enter anything in this field. This field will later be filled with information from the “Yet Another Mail Merger” add-on.

Create a Mailing List from a Google Docs Spreadsheet Step 20
Create a Mailing List from a Google Docs Spreadsheet Step 20

Step 4. Type in the title/subject of the email

Use the " Subject " field to enter the subject of the email you want to send using the contact list from the spreadsheet.

Create a Mailing List from a Google Docs Spreadsheet Step 21
Create a Mailing List from a Google Docs Spreadsheet Step 21

Step 5. Type in a message

Enter the message you want to send to contacts from the spreadsheet. Gmail will automatically save your email as a draft every minute or so.

You can retrieve information from a spreadsheet by typing $%[Head]% into the email. For example, if you want to greet the recipient by their first name, type Hello $%Firstname% into the main body of the message. The contact's first name information will be retrieved from the spreadsheet and added to the email

Part 4 of 4: Using Other Mail Merge Features to Create a Mailing List

Create a Mailing List from a Google Docs Spreadsheet Step 22
Create a Mailing List from a Google Docs Spreadsheet Step 22

Step 1. Visit https://docs.google.com via a web browser

You can use any browser on your PC or Mac computer. The address is the web address of the Google Docs service.

Create a Mailing List from a Google Docs Spreadsheet Step 23
Create a Mailing List from a Google Docs Spreadsheet Step 23

Step 2. Click

It's an icon with three horizontal lines in the upper-left corner of the page. The menu will be displayed afterwards.

Create a Mailing List from a Google Docs Spreadsheet Step 24
Create a Mailing List from a Google Docs Spreadsheet Step 24

Step 3. Click Sheets

This option is in the menu that appears when you click the three horizontal lines icon. You can see it next to the icon of a green sheet of paper with a table. The spreadsheet will open in Google Docs.

Create a Mailing List from a Google Docs Spreadsheet Step 25
Create a Mailing List from a Google Docs Spreadsheet Step 25

Step 4. Click the spreadsheet that contains the contact information

To open a spreadsheet, click the document in the spreadsheet list.

Create a Mailing List from a Google Docs Spreadsheet Step 26
Create a Mailing List from a Google Docs Spreadsheet Step 26

Step 5. Click Add-ons

This option is in the menu bar at the top of the web page.

Create a Mailing List from a Google Docs Spreadsheet Step 27
Create a Mailing List from a Google Docs Spreadsheet Step 27

Step 6. Click Yet Another Mail Merge

The submenu for the “Yet Another Mail Merge” add-on will open.

Create a Mailing List from a Google Docs Spreadsheet Step 28
Create a Mailing List from a Google Docs Spreadsheet Step 28

Step 7. Click Start Mail Merge

It's at the top of the “Yet Another Mail Merge” submenu.

Create a Mailing List from a Google Docs Spreadsheet Step 29
Create a Mailing List from a Google Docs Spreadsheet Step 29

Step 8. Click Continue

It's a blue button at the top of the window, in the middle of the page. A pop-up window will appear informing you that you can send up to 50 emails per day using the free version “Yet Another Mail Merge”. However, the personal plan/quota is offered at a price of 24 US dollars (approximately 350 thousand rupiah) per year and allows you to send a maximum of 400 emails per day.

Create a Mailing List from a Google Docs Spreadsheet Step 30
Create a Mailing List from a Google Docs Spreadsheet Step 30

Step 9. Type in your name

Use the field next to "Sender Name" to enter your name.

Create a Mailing List from a Google Docs Spreadsheet Step 31
Create a Mailing List from a Google Docs Spreadsheet Step 31

Step 10. Choose an email template that has been created

Click the drop-down menu next to "Email Templates" and select an email template that has been created for mail merge in Gmail in the list of templates.

Create a Mailing List from a Google Docs Spreadsheet Step 32
Create a Mailing List from a Google Docs Spreadsheet Step 32

Step 11. Click Send # Emails

It's a blue button in the lower-left corner of the window. Messages will be sent to all email addresses under the " Email " heading, using the email template you selected. You can see the tracking report on the right side of the page.

  • The "#" symbol on the "Send # Emails" button displays the number of emails you will send.
  • Click " Receive a Test Email ” to send yourself a test email before you send it to everyone on the spreadsheet.

Recommended: