How to send bulk emails using Gmail
The following quick example will show you how. An Excel spreadsheet on your computer, with three customer names and their email addresses. Now we want to import this into Google Sheets. In our example, it will start with no sheets; in your case, you may have previous spreadsheets already there. Google Sheets, with no sheets in it yet.
Click on the folder icon on the right to open the File Picker. Click this folder icon to open the File Picker. Click on Upload. Click on Upload to select your Excel file. The screen will change, asking you to either drag or select a file from your computer. About to select our Excel spreadsheet after clicking here.
From here, pick your Excel spreadsheet from the file manager on your computer. This will then be uploaded to Google Sheets and converted into a new Google Sheet spreadsheet. However, before we can use it in GMasswe have to edit it, very slightly and quickly. So, you will need to just make sure there is nothing above these columns. Do that by holding down shift, clicking on the row number, 1 and then row 2, which will select both these rows: Two rows that we want to delete are selected.
About to delete rows 1 and 2. Sheet is now ready to use with GMass. Click the spreadsheet button to connect to your Google sheet.
This will bring up a window allowing you to select the Google Sheets spreadsheet you want to use to populate the email addresses in your mail merge. The GMass spreadsheet connection window.There are a lot of reasons why you would want to send personalized mass emails with Gmail.
The most popular ones include:.
However you get these email addresses, you should put them in a Google sheet. So, here are the steps to follow for this:. However, it is best for you to gather as much information as you can about the contact group you are sending your outreach emails to—it will help you personalize the emails and increase the response rate.
In the United States, there are a couple of things you need to think about before sending out an email outreach campaign:. In the EU, these laws are even more specific, so it is VERY important to check them out and make sure your outreach emails comply to the current legislation.
Now that you have your database set up, your merge template email done, and your canned responses are enabled, you should install the actual Google Sheets add-on that helps you send out the outreach emails. This is an easy method that works very well when you are just starting out and building your email list — use it wisely!
Email Marketing Mini-Course : Grab the exact walkthrough you need to set up world-class email marketing campaigns for you or your clients. Email Marketing Masterclass : Learn how to use automation to create a powerful email marketing machine. Send it to my email! Before you begin: set up your environment There are a couple of things you will need for this: A Gmail account.
Populate the sheet: it can be consisted of current customers, or information you gathered using a LinkedIn scraping tool, for example. Write the Email Templates Using Canned Response Once you have enabled canned responses, you can start writing your mass email templates.
Start writing an email draft just as you would normally, according to the purpose of your outreach email campaign. So, my first draft email template was this: Once you have drafted your email template, you have to replace the variables in it e.
Keep in mind, these variables are case sensitive. This is how my email looked after replacing all the variables: Click on the little arrow next to the trash bin in your email.
GMass: Powerful mail merge for Gmail
Enter the name of your new canned response. Check to see if your canned response was correctly added. Once you click it, the email body should be automatically filled out with your email template text. Be very, very particular about the email outreach and data privacy laws in your country.
Gmail Mail Merge: How to Send Personalized Emails (at Scale)
For example: In the United States, there are a couple of things you need to think about before sending out an email outreach campaign: You need to be honest about your email outreach. In my case, I added this at the end of the message body, right after my signature. Put your actual address in the footer of the email.
You can easily just type this out at the bottom of your email, as a signature, maybe with a smaller font, and save it to all of your canned emails.
Install Yet Another Mail Merge Add-on Now that you have your database set up, your merge template email done, and your canned responses are enabled, you should install the actual Google Sheets add-on that helps you send out the outreach emails.
To add it to your Google Sheets, follow these steps: Go to the sheet you previously created. You will get a pop-up on the screen and you will be asked to authenticate with your email address. Go ahead and do that. If you pay for it, they will allow you a little bit more.The killer feature: set automatic follow-up emails to be sent sequentially until you get a reply.
Say goodbye to CSV files. Connect to Google Sheets to send a personalized mass email using any of the columns in your spreadsheet. Use Gmail's powerful search feature to find messages containing recipients to whom you want to email.
Then click the Build Email List button, and a Compose window will load containing the email addresses found in those messages. The only mass email service that does this! Have emails sent as new messages or as replies to the last conversation with each recipient. Sending a campaign "as a reply" results in higher engagement because it becomes part of an existing conversation rather than a new one.
Personalize to your heart's content. Connect to a Google Sheet and personalize with any column, or use basic first and last name personalization without a spreadsheet.
Use fallback values. Don't know someone's first name? We'll auto-detect it. Campaign level reports that show how many people opened, clicked, replied, and bounced. See reports inside Gmail on your desktop or the Gmail app on your phone.
Send large email campaigns and break Gmail's sending limits, using our distribution technology. Set automatic follow-up reminder emails to be sent in a sequence until your recipient replies or opens.
The best way to boost response rates. GMass will read data live from any Google Sheet and even monitor for new rows and then send emails automatically. Send to a segment of a prior campaign, like everyone who opened the last campaign, or everyone who didn't click the last campaign. Preview all of your emails as Gmail Drafts first. Then send them with one click. Make sure personalization worked and avoid the dreaded "Dear FName" mistake.
Emails received in response to a mass email, including replies and bounces, are automatically categorized for you, preventing Inbox clutter. Campaigns can be sent as new messages to each recipient or as replies to the last conversation with each recipient. Most people love GMass. Every now and then, a curmudgeon doesn't.
See our thousands of awesome reviews click the "Reviews" tab. Still not convinced? Here's why GMass is better. Im so glad I came across GMass. This will help me save A LOT of time!!!
How to send a mail merge with Excel using Gmail
Simple and easy to use!!!! Extensas funcionalidades como segmentacion de correos por ultima fecha de envio y muchas mas. La verdad estoy muy satisfecho! Gracias Gmass!!!!Samantha is a trainer at Using Technology Better.
She is passionate about helping others find better ways to teach, learn, research and work together. Mail merge is one of those great time-saving features that people love. The very first thing you need to consider is what type of merge do you need? As you may know, G Suite does not have native mail or document merge functionality. However, there are a range of add-ons that you can use for this purpose. They function from within Google Sheets or Google Docs.
For all of them, your source data for a merge needs to be stored in Google Sheets e. Once you have decided what type of merge you need to perform, use the table below to identify a suitable add-on.
You can view it here. Each of these add-ons have documentation and videos to help you get started. Check out the resources below. Need more help? Contact us to design a custom mail merge workshop for your team. Do you want to: Send a personalised email? Send a personal email with a generic attachment?
Send a personalised email with a personalised attachment? Send a personalised email with a generic attachment and a personalised attachment? Create personalised documents for printing including letters, certificates etc. Create mailing labels or name tags for printing i. Need to do a mail merge in G Suite? Getting started with your chosen add-on Each of these add-ons have documentation and videos to help you get started. Business Education Google. Related Blog Posts How to maintain best practice when teaching remotely.
Three ways G Suite can support your Literacy programme in a digital age.Mail Merge is Google Sheets add-on to send personalized emails with attachments per recipient, visual editor, scheduled messages and analytics. Mail Merge is a Google Sheets add-on designed to send personalized emails, newsletters or forms to multiple recipients without needing to know how to write HTML for your templates.
Simply select your existing draft in Gmail or compose a template using our rich text editor and the add-on will replace the template tags with names or any other information from a spreadsheet, before automatically sending mass emails to a list of recipients.
For support, mail your query at support mailmerge. Overview Mail Merge is a Google Sheets add-on designed to send personalized emails, newsletters or forms to multiple recipients without needing to know how to write HTML for your templates. Emails Sent. Active Users. Import contacts name, email etc Write your messages using visual editor or use existing Gmail draft as template.
Add personalized cc and bcc to each email simply by adding cc, bcc columns in sheet. Send merged email immediately or schedule later at specific date and time. Variable repeater merge fields that let you make variable length bullet lists. HTML editor to provide all the flexibility needed by advanced power users. Throttle your email blast across multiple days if larger than daily sending quota.Sometimes, you may only need to send the same email to multiple recipients separately without showing all the email addresses.
In this article, I will show you 3 ways to send massive personalized emails via mail merge. You can do email merge with Gmail, Outlook, or Word. If you prefer using iPhone, then I also get you covered by showing how to do mail merge on iPhone. No matter what email client including Gmail, Yahoo Mail, Outlook.
And separate the email addresses with semi-colons. If you want to send personalized email to multiple recipients, then you need to configure Email Merge. If you prefer using Google Spreadsheet and Gmail, then this method is for you. You can follow the steps below to set it up. Step 1. Prepare your list of recipients and other information in a Google Sheet.
Install the Mail Merge with Attachments add-on. Step 2. You can edit the mandatory columns and add new columns if needed. Step 3. Step 4. Step 5. It is recommended to craft a Gmail draft. Step 6. Go to Gmail and start to write a new email. Step 7. Go to the Mail Merge sheet and select the Gmail Draft and send test email if needed, After you check the test email, then you can send out all these emails. This free version of this add-on allows email up to 50 recipients a day.
If you upgrade to the premium version, then you send emails to recipients. As you know, Gmail has limitations of email sending quota. If you need to send more emails, you can use Outlook. Open a new Word document. You can also import the excel list to Outlook and choose from Outlook contacts. Edit the recipients if needed.
Craft the email and add personalized content to the email message. Sometimes, you may not get a computer around you, and all you have is an iPhone or iPad. In that case, you can use your iOS device to run a mail merge. Download Workflow app from AppStore. Workflow is a free app that obtained by Apple not long ago. Get this Mail Merge workflow. Email Merge can save you lots of time when you want to send a personized email to multiple recipients.
All these three methods will work for Mail Merge.Send bulk emails in Gmail Personalize, send, and track bulk emails within Gmail. Easy, free mail merge. List recipients in a Google Sheet. Send personalized emails. Add to Gmail. Mail Merge Personalize your emails with any fields that you want Use values from Google Sheet columns.
Email Tracking Track email opens Track clicks on links in emails. Templates Create and use email templates within Gmail Track the performance of your email templates. Template Editor Beautiful templates for newsletters or other outreach Use variables for email personalization. Insert unsubscribe links in your emails Let recipients choose to unsubscribe from future emails. Compare the performance of multiple campaigns and templates Measure conversion rates with automatic UTM codes.
Share templates and campaigns with other team members Compare the performance of team members' templates. Send your emails at a specified time Optimize your open rates by sending at just the right time. Send as many emails as you want on our Premium and Team plans Send email using your own email service to have full control. Ready to start?