Download Article
Send mass emails using Google Sheets
Download Article
This wikiHow guide teaches you how to create a spreadsheet with contact information using Google Sheets. You can use a mail merge add-on (such as Yet Another Mail Merge) in Google Sheets to use the spreadsheet as a mailing list, and then send an email using Gmail. Note that Gmail has a daily sending limit of 500 emails per day. [1] X Research source
Things You Should Know
- Begin creating a spreadsheet in Google Sheets by clicking Blank spreadsheet from the Sheets homepage. Add headers for your contact information and begin populating.
- Install the "Yet Another Mail Merge" add-on by navigating to Extensions > Add-ons > Get add-ons and typing "mail merge" into the search box.
- Write your email in Gmail, then find its subject line in the drop-down menu within the Yet Another Mail Merge extension to send a mass email to your contact list.
Steps
-
Navigate to https://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.
-
Click ☰ . It's the icon with three horizontal lines in the upper-left corner. This displays the menu.Advertisement
-
Click Sheets . 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 Google Sheets .
-
Click Blank spreadsheet . 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.
- If you already have a spreadsheet with contact information, you can open that instead and skip to the next step.
-
Create Headers for your contact information. 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 .
-
Enter your contact information below the appropriate headers. 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.
- If you already have a mail merge extension, you can also import contact information by clicking Add-ons
and then selecting Yet Another Mail Merge
.
- Then, select "Import Contacts" and select "Google Contacts" or "Other CRMs." Select a contact group using the drop-down menu next to "Groups", and then click "Import Contacts."
- If you already have a mail merge extension, you can also import contact information by clicking Add-ons
and then selecting Yet Another Mail Merge
.
Advertisement
-
Navigate to Extensions > Add-ons . It's in the menu bar at the top of the website.
-
Click Get add-ons . It's in the drop-down menu below "Add-ons". This will open a window you can use to search for and install add-ons.
-
Type Mail Merge in the search bar and press ↵ Enter . The search bar is in the upper-right corner of the window. This produces a list of Mail Merge add-ons.
-
Open "Yet Another Mail Merge". It's likely the first add-on listed.
- 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.
-
Select your primary Google account. 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.
- Make sure it is the same Google account from which you plan to send your email(s).
- 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.
-
Scroll down and click Allow . It's the blue button at the bottom of the page in the window.
Advertisement
-
Navigate to https://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.
-
Click Compose . It's in the upper-left corner of the Gmail website. It's the blue button with a pencil icon.
-
Leave the "Recipients" line blank. There is no need to enter anything in this line. This line will be filled in with the Yet Another Mail Merge add-on.
-
Type a subject. Use the "Subject" line to type a subject for the email you intend to send using the contacts from your spreadsheet.
-
Type a message. 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. The wording must be an exact match.
- 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] X Research source
- You can pull information from your spreadsheet by typing <<Header>>
in your email message. The wording must be an exact match.
Advertisement
-
Open the spreadsheet with your contact info. You likely have it open already.
-
Click Extensions . It's in the menu bar at the top of the web page.
-
Click Yet Another Mail Merge . It should be listed at the bottom of the drop-down menu. The extension will take a moment to open.
-
Type your name. Use the line next to "Sender Name" to type your name.
- If you manually signed your email template, this step is not entirely necessary. You also likely already have your name attached to your email address.
- Still, it is worth entering your name to be on the safe side and guarantee your mail merge is addressed appropriately.
- If you manually signed your email template, this step is not entirely necessary. You also likely already have your name attached to your email address.
-
Select the email template you created. Click the drop-down menu next to "Email Template" and select the subject line that corresponds with the draft you created for your mail merge in Gmail.
-
Click Send # Emails . It's the blue button in the lower-right 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.
- You can also select Schedule to send your mail merge at a later time or date.
- We recommending clicking Send test email
to send yourself a test email before sending the email to everyone in your spreadsheet.
- This test email will pull info from the first line of your spreadsheet.
Advertisement
Community Q&A
Search
-
QuestionWhat if script manager is not in tools?LingoWingCommunity AnswerThis error is sometimes caused by a caching issue with your browser. Make sure that your browser is not due for an update, then close all tabs you have open and turn your device's WiFi on and off again. Attempt to access the script manager again. If the option is still unavailable, repeat this step in a different browser. If using a different browser doesn't work, post a message on the Google forums.
-
QuestionHow can I send 50 emails/day with this and not duplicate? I have a list of high school classmates that I want to update on reunion plans. I don't see the point of paying for year when I may send 2-3 times.Community AnswerThis 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.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
References
About This Article
Article Summary
X
1. Navigate to https://docs.google.com/spreadsheets
and create a new spreadsheet.
2. Click Add-ons
in the menu bar at the top and click Get Add-ons
.
3. Search for "Yet Another Mail Merge" and add it to your Add-ons.
4. Use the first row to create headers for "First" and "Last" name and "Email", as well as any other contact information you have.
5. Enter your contact information in the columns below the appropriate headers.
6. Open https://mail.google.com
in a new tab, and click Compose
.
7. Type a draft email for the contacts in your spreadsheet. Leave the "Recipients" line blank.
8. Click back over to your Google Docs Spreadsheet and click Add-ons
.
9. Click Yet Another Mail Merge
and click Start Mail Merge
.
10. Click Continue
to begin.
11. Type your name in the bar next to "Sender".
12. Select your email draft in the drop-down menu next to "Email Template".
13. Click Send Emails
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 131,566 times.
Advertisement
