<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1822615684631785&amp;ev=PageView&amp;noscript=1"/>

How to Perform Gmail Mail Merge Using Google Sheets

A Gmail mail merge is one of the easiest ways to create personalized emails for tons of recipients at once.

While you can use a Google Apps Script to perform a Gmail mail merge, it’s far too complicated. Alternatively, you could try a few mail merge add-ons, but chances are that these add-ons don’t offer any advanced email capabilities.

So what do you do then?
Don’t worry.

In this article, I’ll show you how to use GMass for effortless mail merges in Gmail. I’ll also cover five of its advanced features and answer some FAQs related to Gmail mail merges.

This Article Contains:

(Click on links to jump to specific sections)

Check out my 45-second tutorial on performing a Gmail mail merge with Google Sheets:

Let’s dive in.

How to Send a Mail Merge in Gmail with GMass

GMass is a powerful email marketing tool that lets you run mail merge campaigns inside Gmail.

The software’s advanced outreach capabilities have made it a popular tool used by employees in powerhouses like Uber, Twitter, LinkedIn, and Google. Its ease of use and affordable pricing make it the perfect email tool for startups, institutions, and individuals.

Instead of wasting time creating a Google Apps script to build a Gmail template for your mail merge, you can use GMass to send multiple emails in seconds!

To begin using the tool, download the GMass Google Chrome extension and sign up for free with your Gmail account or Google Workspace (previously G Suite) account.

Here’s a walkthrough guide on how to send a mail merge with Google Sheets in GMass:

Step 1: Format Your Spreadsheet

First, you’ll need to create a spreadsheet in plain text, which will be your data file.

When creating the spreadsheet, it’s crucial to properly format the rows and columns for the best possible results.

Keep these pointers in mind when preparing your spreadsheet:

  • The first row should contain column names, like FirstName, LastName, EmailAddress, Company, etc. For best results, the column names shouldn’t contain spaces or special characters — stick with numbers and letters for your column headings.
  • The actual data should start on the second row.
  • At least one column should contain email addresses — GMass will auto-detect this column and use it as the recipient address column.

For example, here’s the Google Sheet I’ll be using as my data file:

Google sheet

Note: If your sheet has multiple columns with email addresses, keep the column containing the recipient email addresses to the left of the other columns.

Step 2: Connect GMass To Your Spreadsheet

Log in to your Gmail account.

If you’ve already signed up for GMass, it’s time to load the mail merge data from your Google Sheet.

You can load recipient data in two ways:

1. Click the Sheets button near the search bar to open a dialog window showing a list of Google Sheet files. Then, select your data file from the drop-down menu to import data.

Sheets button

2. Compose your Gmail draft and then click the new GMass button in the upper-right corner of the Compose window. Then, select your datasheet from the drop-down menu.

Gmass button

Note: The drop-down menu won’t show any Excel files that are in your Google Drive. GMass doesn’t connect to an Excel file directly, but you can easily convert your Excel spreadsheet (or an existing CSV file) to a Google Sheet.

Step 3: Choosing Your Worksheet (Optional)

If your Google spreadsheet has multiple worksheets, a worksheets drop-down menu will appear, which allows you to select the specific worksheet you need.

Choose a worksheet

Note: If your spreadsheet has only one worksheet, this drop-down menu will not show.

After clicking the CONNECT TO SPREADSHEET button, GMass will read the email addresses and other data from your spreadsheet. It’ll then load the list of recipients into the To field.

Note: In GMass, each email sent is delivered as an individual email — this means that you don’t have to add email addresses in the Bcc field to preserve recipients’ privacy.

Go back to Contents

Step 4: Decide Whether to Keep Duplicates (Optional)

When sending a mail merge campaign, you’ll likely want any duplicate email addresses to be filtered out — that’s the default setting.

However, sometimes you may want to send duplicate emails.

For example, say you’re in charge of the after-school activities program, and you’ve got to email the parents of children who registered for this program.

Now, what if one of the parents has registered multiple children?

Duplicates

In the spreadsheet above, Joan Smith has three children registered for three different classes.

Here, you’ll want Joan Smith to receive three different personalized emails, one with each child’s class registration information.

When this Google Sheet is connected, GMass will slightly alter the multiple instances of joansmith@yahoo.com (see the screenshot below). Doing so makes it possible for GMass to associate each address to the right row in the spreadsheet.

To section

You shouldn’t alter the “-gmassx” tag that gets automatically added before the “@” sign since these are removed from the addresses when the emails are sent.

To send duplicate emails, click on the downward-facing arrow next to Optional Settings. Then, tick the Keep duplicate emails checkbox when connecting your Google Sheet to your email template.

Downward arrow

Step 5: Send to All Rows or a Filtered Set of Rows (Optional)

Sometimes, you may want to send emails only to particular recipients in your Google Sheet.

In such scenarios, you can easily filter the rows that are a part of the campaign by adding filter criteria (name/value pairs) in the Filter Rows box under Optional Settings.

I’ll send emails only to customers whose “Industry” is “Technology” in this example.

Filter rows

Step 6: Update Your Spreadsheet as the Mail Merge Sends (Optional)

GMass can automatically update your Google Sheet after you’ve sent the campaign and your email recipients open, click, reply, or take other engagement actions on your email.

Google sheet 2

To have GMass create a few additional columns in your Sheet to add the email tracking data, tick the Update Sheet with reporting data checkbox.

Update sheet checkbox

Note: If you haven’t already given permission to write to your Sheets, a pop-up will appear asking you to grant that permission. Check out our guide to updating your Google Sheet with campaign data for more details.

Go back to Contents

Step 7: Personalizing Your Email (Optional)

You can also personalize your mail merged bulk emails with ease.

Just insert merge variables in your email message or subject wherever you want to personalize. The syntax for merge variables (or placeholders) is: the Google Sheet column header surrounded by curly brackets.

For example, if the column is called Name, then you would write {Name} in your Gmail template to personalize based on that merge field.

Type a left curly bracket character ({) in your draft email, and a flyout menu will appear with your placeholders.

Personalize

Alternatively, click on the downward-facing arrow next to the GMass button to access GMass Settings.

Next, choose the merge field (or variable) you want to insert into the Gmail template by clicking the Personalize drop-down menu. When you click on a mail merge field, it automatically gets copied to your clipboard.

Personalize field

You can then easily paste the personalization variable or placeholder into your subject line or email body by pressing CTRL+V or CMD+V on your keyboard.

Note: If you’re not using a spreadsheet, the {FirstName}, {LastName}, and {EmailAddress} tags are defaults when using a Google Contact list (or Gmail Contacts).

Step 8: Start Mail Merge and Send Your Emails

Hit the GMass button to start mail merge and send out your mail merged campaign.

Your mail merged emails will either go out now or later, depending on how you set the Scheduling section.

Gmass

Note: The campaign will only be sent to the addresses in the To field of your Gmail draft at the time of sending. As a result, if you want to add addresses after scheduling the email, you’ll have to add them directly to the To field (and the Sheet to ensure personalization works). 

To learn more about how the timing of when email addresses are pulled from the mail merge Sheet works, click here.

Go back to Contents

In addition to simplifying the mail merging process, GMass offers other features to optimize your email campaigns. I’ll cover some of those features next.

5 Advanced Features for Gmail Mail Merge Wizards

Here are five powerful GMass features that can take your Gmail mail merge campaigns to the next level:

1. Automatic Follow-ups

Not everyone will respond to your email campaign — some may have forgotten about it, while others were too busy to respond.

Whatever be the case, GMass can help you improve recipient engagement by automating your email follow-ups. You can customize everything about these emails, including the total number of email follow-ups to send, frequency of following up, and more.

Follow ups

2. Advanced Personalization

The problem with most bulk emails is that they’re not personalized for each recipient. As a result, your emails may come across as generic or irrelevant, and the recipient will likely decide not to engage with them.

But creating personalized emails can be challenging when you’ve got to email tons of people.

Fortunately, GMass can help you create personalized mass emails effortlessly— it lets you automatically personalize names, paragraphs, links, images, file attachments (e.g., PDF files), and more.

Advance personalization

3. Bypass Gmail’s Sending Limits

While a regular Gmail account can send 500 emails per rolling 24 hours, a Google Workspace (formerly G Suite) account can send 2,000 emails per rolling 24 hours.

GMass, however, lets you surpass this sending limit by allowing you to send 10,000 emails.

How?
It automatically distributes these emails over multiple days based on your Google account’s sending limits.

Send limits

Note: You can send virtually unlimited emails in Gmail using the GMass-SendGrid SMTP integration.

4. Recurring Automated Campaigns

Manually adding new members to your email campaigns can be tiring.

Fortunately, GMass lets you create automated campaigns connected to a Google spreadsheet.

You can connect a campaign to a particular mail merge sheet, and whenever a new recipient is added to the sheet, GMass automatically adds them to your campaign.

repeat

5. Create Dynamic Suppression Lists

Sometimes you need to suppress specific email addresses from your campaign.

For example, say you and a colleague are both emailing the same offer to your customer list. And let’s assume that you handle half of the email list and your colleague handles the rest.

In this scenario, you may want to suppress those email addresses your colleague is sending to in your campaign.

To do so, you can use suppression lists — a list of recipients you don’t send emails to.

But what if your colleague is continually adding multiple recipients to their campaign? How do you make sure that the suppression list stays updated?

Manually updating and managing an email suppression list for your marketing campaigns can be time-consuming.

Enter dynamic suppression lists.

When you connect your email campaign to a dynamic suppression list, any addresses present in the list will be automatically omitted from any future messages.

Suppress field

GMass also offers other robust functionalities that’ll change your outlook on what an email outreach tool can do, like:

  • Detailed Reports: track email opens, clickthroughs, replies, bounces, and unsubscribes through comprehensive analytics reports generated in your Gmail inbox.
  • Scheduling: schedule emails to go out at optimal times — when recipients are most likely to respond.
  • Sentiment Analysis: identify who your most interested prospects are by looking at the sentiment scores for your responses.
  • A/B Testing: compare the performance of different test emails to discover which email campaign can bring you the best results.
  • Gmail Add-on: access advanced email outreach capabilities on your smartphone using the GMass add-on for the Gmail Android app.
  • Email Lists: quickly build email lists using Gmail labels, search, or transactional email notifications.

Go back to Contents

Next, I’ll answer a few FAQs about doing a Google Sheets mail merge in Gmail:

Gmail Mail Merge FAQs

Here are answers to some commonly asked questions related to Gmail mail merges:

1. What Is a Mail Merge?

A mail merge is an automated process that fetches recipient details from a data file to insert them into a mail merge template.

This data file can be a spreadsheet or a database file containing the recipient’s name, email address, and other details. And the mail merge template can be a Google Doc, Microsoft Word document, or Gmail draft.

In any case, when you initiate a mail merge, the sheet data is automatically entered into your mail merge template.

Mail merging can save you tons of time when sending personalized mass emails as you’re not manually entering the email addresses of multiple recipients and their personalization details.

2. How Does the Timing Work in Gmail Mail Merges?

To understand how timing works in a Gmail mail merge when using GMass, let’s consider two scenarios:

Scenario 1
You used the Sheets connector button (see screenshot below) to pull the email addresses from the data file, and you sent a standard one-time broadcast email campaign. In this scenario, the campaign only goes out to email addresses in the To field.

Sheets button

Unless altered, your To field and the data file would contain the same email addresses.

Scenario 2
You connect the spreadsheet using the Sheets button, configure your campaign, and schedule it to go out 24 hours from now. But an hour after scheduling, you add a few rows of email addresses to your Google sheet.

When the campaign goes out at the scheduled time, it won’t have the addresses you just added.

Why?
Because those new addresses weren’t part of the “pull” when you connected to the Sheet. As a result, those addresses aren’t present in the To field.

You can solve this problem in two ways:

  1. Add addresses directly to the To field (and the data file to ensure personalization works).
  2. Use the Repeat option under Schedule Settings to automatically send customized emails to the newly added recipients the next day.

Repeat 2

3. How many mail merges do we perform daily?

Here’s a table of live counts of mail merges GMass has performed over the last 7 days. This data is updated daily at midnight GMT.

MonthDayYearMerges
12420212,387
12320218,116
12220218,829
12120219,247
1130202111,076
1129202126,446
112820217,705

Go back to Contents

Wrapping Up

Performing a mail merge using a Google Apps Script can be unnecessarily time-consuming and complicated. A far easier alternative is to do your Gmail mail merge using Google Sheets combined with GMass.

GMass makes sending customized emails at scale and maximizing your conversions incredibly easy. You’ll have everything you need to quickly send, manage, and follow up on your multiple emails.

Don’t take my word for it.

Download the GMass extension today and experience it yourself!

262 Comments
    1. Hi ,is there an Android compatible option?
      I am an Educator ,and have been using FormMule to send out mails . Generally we need it to email Parents about the responses of Google Form ( we use for Assessments)
      If there is an Android compatible option,it would be nice.

  1. This error is likely specific to your Gmail account, as I haven't had any other reports of issues. Can you email me your email address, and then I can investigate further?

  2. Hi,

    I wanted to send out a mass email today but its unclear if the the email recipients will see all the emails in in the To: box

  3. Also, if I do not want to personalise it (as I do not have the names), I only have a spreadsheet with email adresses. How does the email then look like? I really want to see how the email looks like before sending it off. Is this possible?

  4. Hi Vivianne — if you use the GMass button, then no recipient will see any other recipient's email address. Individual emails will be sent, one to each recipient with just that person's address in the To line, If you use the default Gmail "Send" button, however, then all of the email addresses will be shown in the To line.

  5. If your spreadsheet only contains email addresses, that is fine. You just won't be able to personalize. You can always send yourself a test message first. In the future, I'll be adding a feature to make sending test messages easier.

  6. My emails are on an excel spreadsheet. How do I convert / prepare the spreadsheet so it is compatible with Google Sheets for import into Gmass?

  7. Never mind – figured it out. Copied excel data into a new Google Sheet and renamed, etc. Thanks! Great resource! Looking forward to giving it a whirl!

  8. I just tried sending a mass email to 1200 people, it seemed to go through but in my sent box i can only count about 30 emails that seemed to go out.

    Any thoughts?

  9. Hi GMass! Thanks for creating a great product. I have a list of emails (non-gmail) on one column, and a list of first names on another column. How do I pull data for the first names into the mail merge?

  10. I just sent a Gmass email to 78 recipients using google sheets for my contact list. It all looked fine but I don't see anything in my sent box and it is still in drafts. I clicked to send now but it says it is scheduled for 4 am! I guess I have to wait until tomorrow morning to see if it got sent. Maybe the problem was that I asked to do drafts only but then nothing happened and I did not see any drafts. So I decided to try and send it and this is what happened. I don't want to try again until tomorrow in case it actually goes out. I'll follow up tomorrow. However, why didn't the drafts part work when it said it was? Thanks!

  11. Hi Brian — all you do is follow the instructions in this blog post to connect to the Google Sheets spreadsheet. Then, if your column name is "FirstName" for example, you would use {FirstName} in your Subject or Message to substitute the person's actual first name.

  12. Abs — yes, any columns that are present in your spreadsheet can be used as personalization variables. GMass will create personalization buttons, as shown above, for each column in your spreadsheet.

  13. Yes, it's very easy to convert an existing CSV file or Excel spreadsheet to a Google Sheets spreadsheet, and then connecting that spreadsheet to GMass. Let me know if you need any more help.

  14. You likely received the email I sent to you and a few other users that were affected a server disk issue earlier this evening. I did re-queue your emailing after I fixed the issue, and it did go out to all 78 recipients, eliminating anyone that had already received it. As far as the scheduling, I'm wondering if you saw the time in GMT time after you sent it. It might have looked like it was going out in the future, when it was actually in mid-sending at that time. We do attempt to localize times based on your computer's set time zone though. If that happens again, please send a screenshot to hello@gmass.co.

  15. Hello I have just tried GMass and it seems great can you tell me how many emails I can send from GMass daily as I dont have any Google apps account.

  16. Hello I have just tried GMass and it seems great can you tell me how many emails I can send from GMass daily as I dont have any Google apps account.

  17. With a regular Gmail account, 500 emails/24 hours. With a Google Apps account, 2000 emails/24 hours. We are about to release a feature that will make sending up to 10,000 emails very easy — we'll distribute it over multiple days so you don't violate your account limits.

  18. Just remove the Chrome Extension. Click the three lines icon on the right-hand side of the toolbar in Chrome, More Tools -> Extensions, locate the GMass and click remove.

  19. Is Gmail/Google going to block this extension at some point because it potentially violates SPAM laws? Just curious. I've been waiting for an extension like this, but I'm hesitant to use it heavily because I'm worried it will be short-lived.

  20. That is unlikely. GMass itself doesn't violate any laws, spam or otherwise. Gmail polices its network quite aggressively for spammers, so if anyone attempts to send spam through GMass, then the individual Gmail account will be closed. GMass isn't doing anything that Gmail doesn't already make possible.

  21. I tried sending emails to all residents ( 300 nos)of my colony . It seemd to work very well. Around 250 people opened as per report generated.
    I am using google sheet on drive for email ids.

    One of the fields is "Name". It did not work for quite some time. But when I erased and re-entered the same "name" , it worked. Does formatting of header row affect in any way ???????

    Using Gmass with secrwaj@gmail.com id.

  22. Argh. I LOVE This! Except when I click on the buttons to insert fields, they do not insert. When I type them in manually, they do not work 🙁

    I am on a iMax OSX Yosemite 10.10.5 Chrome Version Version 43.0.2357.132 (64-bit)

  23. If the header column is just "Name", then that should work just fine, whether you're using the personalization button or typing "{Name}" manually in the Subject or Body. If you want, we can do a screen share session and you can show me an example where it doesn't work, so I can fix it. Please email me at support@gmass.zendesk.com.

  24. Clicking on the spreadsheet button does not load the addresses into the To field even though the connection to spreadsheet appears to be good

  25. I like Gmass a lot but I can't figure out how to send emails to a subset of the people listed on my Google Sheets spreadsheet. It looks like when I select a spreadsheet, and compose a message, the recipients listed include everyone on the spreadsheet. I can filter out the people I don't want to email on the spreadsheet itself, but they still appear as recipients when I compose the email. How do I limit the recipients to what would be a "group" in gmail contacts?
    — Arthur

  26. Hi,

    What happens if there are duplicate entries in the spreadsheet? Will Gmass recognise that there are more than one instance of the same email that's being sent?

  27. Unfortunately no. GMass removes duplicate email addresses from an email campaign, even if you have multiple rows of the same address but with different data in your Google Sheets spreadsheet. Several users have asked for a workaround to this though, so I am coming up with a solution.

  28. This is by design. GMass will send to all email addresses in a chosen Google Sheets spreadsheet. To filter out certain addresses, you can manually remove them from the To field after GMass connects to the spreadsheet, or you can copy/paste just the rows you want to send to from the current spreadsheet to a new spreadsheet, and then have GMass connect to the new spreadsheet.

  29. I try to connect a sheet and I get the following:

    GMass: DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.

    Not sure what to do to proceed?

  30. When I tried to insert the column named "Name", "Dear {Name}," it won't insert. It just showed "Dear ,", do you know why? There are about 300 lines in the sheet. Thanks for your help!

  31. Marco,

    I got the same message when trying to connect to a spreadsheet with over 1500 lines.

    GMass: DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.

    Does anyone know what the issue is?

  32. Marco,

    I got the same message when trying to connect to a spreadsheet with over 1500 lines.

    GMass: DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.

    Does anyone know what the issue is?

  33. Hi,
    Any idea why the test email goes through, but not the actual email?
    My google sheet is pretty small, but the Gmass send tab seems to have frozen.
    Thanks!

  34. Hi, tried again and now I get this error when trying the test email function.

    There was a PROBLEM sending your test email to pubudini@creately.com: Google.Apis.Requests.RequestError
    Not Found [404]
    Errors [
    Message[Not Found] Location[ – ] Reason[notFound] Domain[global]
    ]

  35. I got the same error message (hard to copy, as it disappears quickly).

    I send a test email, successfully received.
    I changed the concept.
    I resend a test email, was refused with error message:
    There was a problem sending your test email
    Google.Apis.Requests.RequestError not found [404]
    Errors [Message[Not Found] Location[-]
    Reason [notFound] Domain[global]]
    – inner:

  36. Hi, I am unable to use the Google sheet option. When I click the Red color box to insert the sheet – it is showing "Please wait for Google sheet spreadsheets to load" for 2 mins but it doesn't get loaded. Tried relaod and restart but no luck.

  37. This is strange. Unless you have hundreds of spreadsheets, it should load within just a few seconds. I suspect this was a temporary quirk, as people are using this feature constantly throughout the day. If you still need help, email me at support@gmass.zendesk.com and I'll diagnose your account individually for you.

  38. Pubudini – to answer your other question about the test email — that can happen if you hit the "Send Test Email" button before GMass has a chance to extract certain information from Gmail. Usually if you just hit it again, your email will send and the error will go away.

  39. I'm having this issue persistently for 3 days now. I have tried everything with the lists, I cleaned up formatting, renamed the columns, etc etc. split the list into smaller batches.
    I get the test email where none of the parameters would be inserted.
    I'm really puzzled why. I was supposed to start my campaign on Tuesday

  40. Count me as another vote for this feature. My temporary workaround is to slightly edit the duplicate email addresses so multiple messages are created, sending as draft, then going in and manually correcting the email addresses and sending manually. Not ideal but I'm only merging about 50 rows with 8 or so duplicates.

  41. Hi Ajay, Thanks for the great work. I have a query to ask.

    I got around how to use GMass. But is there any way to change the name of the sender while sending mail. Please note that I have changed – "Send Mail As in the G mail Settings". But the new changed name is not getting used when sending mails via GMass.
    Is there something that I am missing ? Can you tell what to do in this case ?

  42. Hi!

    Is there a way to trigger a gmass email upon a Google Form submission? ie, the moment a Google Sheet gets populated, that gmass can auto-send the auto-follow up email protocol?

  43. Hi,

    Firstly it worked just fine. I was really impressed by GMass. But now when I connect to a spreadsheet and send the mail to say 350 recipients it is only sending the mails to 11 or 12 addresses. I am really in need of this feature. Can you please suggest something?

  44. I just tried sending a mass email to 3000 plus people, it seemed to go through but in my sent box i can only count about 30 emails that seemed to go out.

    Any thoughts?

  45. HI Ajay,

    I have been facing issues, as the Gmass is not detecting names. The final mails are sent as below:
    Dear {Name},

    I have tried all the tricks but am missing something.

  46. Hi Ajay,

    Gmass is working well for me.

    The only problem is my signature does not appear within the message at the bottom, whenever I successfully link to a Google Sheets doc.

    Is there some setting I'm missing? When I compose an ordinary email, the signature is there correctly.

    Thanks..

  47. How does gmass work? Can I edit the google sheet while my email is in draft mode and sending emails daily? Also, if a subscriber is on my list they will only get the email once, correct?

  48. When I say I've tried everything to find a work around for this, I mean it. I'm pretty sure I've thought of everything, to include cutting the sheet down to 5 and even trying to send it to only 1, but no matter what, it will not send. It works fine with other tested sheets. Can't figure this out. And I've even made separate sheets with the same info to try to circumvent the issue. PLEASE HELP

    Google.Apis.Requests.RequestError Not Found [404] Errors [Message[Not Found] Location[ – ] Reason[notFound] Domain[global]]

  49. Hi, I thought I read where you could send up to 10,000 emails per day? It stopped me and said I could only send 500 per day. Is there anyway around this?

  50. Just out of curiosity, is there a feature that I could compose HTML instead of plain text? Usually my messages has embedded links and if you hover the mouse into it, you’ll see an indirect link of google.com.

  51. Hi Ajay, can you help me. I have set (apparently) everything as you describe in this page tutorial. I have loaded the google spreadsheet and wrote my e-mail.

    However when i hit the “GMASS” red button i don´t see nothing happenning.

    What shall i do to shoot my e-mails.

  52. Your GMass request failed. Error details: Google.Apis.Requests.RequestError Not Found [404] Errors [ Message[Not Found] Location[ – ] Reason[notFound] Domain[global] ]

    What does this error mean and how can I fix it? The first three GMass emails went great. Then one said all links in the newsletter had to be replaced. I copied and pasted another version of the email and then got the error above.

  53. hi,i used to send 1000 emails in day with normal gmail account , past few months i cant send even 20 emails, if i send 500 emails it shows that your message has been blocked all the messages were blocked n returned back , why am i facing such problem, still my friend using gmail they are sending bulk emails, so i started using gmass from yesterday, i added 100 recipients, when i press the gmass button its shows “i can send only 50 email in a day, otherewise i have to choose a plan, i dont understand, why i have to pay when i used to send bulk email in 1000s range.please help me out,with normal gmail account all my messages are blocked by sending, so i created new email address to send as new but still am facing the same problem tat “my messages are blocked”give me some solution.. could you respond to it.

  54. Is there any way to add emails from different worksheets within the same spreadsheet? I have one spreadsheet for all of my students with different classes on different worksheets. Each worksheet has it’s own list of emails and I need to be able to send one email to all of my students. So I need to add email addresses from four worksheets to the BCC field in one email.

  55. Hello,

    I am facing an issue with G-mass, Somehow the trail e-mails that I am sending id not able to pick the First name or last name as it should. Can you help me rectify the situation or guide me to the right way of using g-mass.

  56. I set up a test sheet on GOOGLE SHEETS

    about 5 emails….. and I get a message to wait to the sheet to load.

    It has been over an hour…. Am I doing something wrong ?

    Opened a new email… and tried other similiar things…but it is not loading.

  57. Hello Ajay,

    Can we send different draft emails to the 3 emails schedule for tomorrow through google sheet?
    For eg. I have prepared birthday list and daily it automatically runs and send the email as per the sheet. So if there are three birthday on 1 single day then can we have an option to send 3 different draft to 3 birthdays. I have created a draft using birthday wishes image

  58. Ajay – this is going to sound silly….does the google spreadsheet have to remain “intact” until the mailing is done or does GMass read all the necessary data upfront then you can change/delete your spreadsheet if you want? Asking because I scheduled some mail merges for the next day but when they sent, none of the personalised fields (except email) were picked up. Between scheduling the mail merge and it actually being sent, i had changed the spreadsheet and deleted a lot of the fields (in the belief GMass had already captured the data it needed). If you are scheduling the mail merge for later, does the spreadsheet need to remain unchanged in your Google Drive until the send is complete? Furthermore, if you have set up auto-follow up, does the spreadsheet need to remain unchanged until auto-follow up is complete (i think not but could you confirm?). Many thanks – a fantastic product.

    1. Hey Stephen – I believe we spoke over the support address. GMass reads your Google Sheet at the time the Campaign sends. However, once it sends you can edit your Google Sheet as you please, and your Auto Followups will not be affected.

  59. Hi, is there a way to select specific column in Google Sheets for the email addresses to be sent to? I have 2 columns of email addresses and I want to select just 1 specific column.

  60. Ryan Seacrest to host Oscars red carpet pre-show after denying sexual harassment
    allegations by former colleague. Read more on sports

  61. Hi, thanks for this great solution. My question is if emails sent with Gmass provide the ability to see who has read/opened the email, or if not, if the integration of MailTracker or such solution in Gmail will also work for emails sent with Gmass.
    Thank you!

  62. How much we connect gmails accounts?
    Like if i use multiple accounts like in bulks gmail accounts..
    It is possible like i ask above?

    1. Hi Shahid,

      You can subscribe to multiple subscriptions for different Gmail accounts. You might also be interested in signing up for a team plan if you’re planning on subscribing 5 or more email accounts. Team plans have centralized billing as well as a discounted rate from the individual premium subscription plans. Please see https://www.gmass.co/pricing and under G Suite, you will see the option to select either individual or team plans.

  63. Hello,

    I’m attempting to connect a spreadsheet to an email, but when the new message loads rather than an email list of recipients in the email field it just has “GMass Recipient List From Worksheet “. It seemed to work fine with a test spreadsheet that I created, but not with the spreadsheet that I need to connect to. I double checked the formatting on the spreadsheet and it’s set up correctly. Thanks in advance for any help you can offer. 🙂

    1. Hi Brian,

      Please contact our support team through http://gmass.co/g/support with a screenshot of your spreadsheet (including the headers) and your compose window.

  64. Please tell me how to delete Gmass from my gmail account. I DO NOT wish to subscribe and the links are an annoyance.

    I have opened another email account for my bulk emails. Thank you

    1. Contact our support team by email with a screenshot of the error you’re receiving through http://gmass.co/g/support

  65. I can get “Filter Rows” to work if I set Name=Somebody but can NOT get it to work if I set Date=CurrentDateIgnoreYear
    “Connect to Spreadsheet” does nothing whereas when I set Name filter it opens compose window.

    1. Please contact our support team through http://gmass.co/g/support with a screenshot of both your spreadsheet (including your headers) and your compose window for your email.

  66. I am new to GMass.
    1. Can I add an attachment to GMass emails?
    2. Can I add different (personalized) attachment to each GMass recipient?
    If so, how can I do it?

    1. Hi Devon,

      1. Yes, you can attach files using the default attach files icon in Gmail.

      2. Currently, that’s not a feature offered in GMass but it is in the roadmap for future features to be added.

  67. I just sent an email to 9 recipients via google sheets using GMass. I was expecting to see the mail sent, opened, and clicked updates on the sheets, as I did in my test campaigns. But so far the report is only in Gmail and not showing in the google sheets.

    1. Hi Megha,

      GMass does not update the spreadsheet, it is merely used as a list for recipients’ emails and mail merge. You can still download those details such as blocks, click and open tracking through the GMass reports found in your email.

      1. Marvin,
        and what if update the list of recipients of Google Sheet? Adding or removing some?
        What if try to do the same on a list of recipient on stored as a draft of the email of a running campaign?

  68. Hi sir,

    i have small setup for photo editing service world wide. i already use this service. But, my gmail got spammy. Then i get few clarification mail from you if i add CNAME, TXT/DKIM, SPF record to my host domain page. Then, my mail would not be spammy. And, i can work free mind my mailing campaign. my gsuite mail id is retouchhub@retouchhub.org……now, tell me what i did next before start again mail campaign by GMASS service. this time, i dont back so before start campaign. you share me all further process. what you think.

    1. Hi Arvind,

      Please contact our support team through http://gmass.co/g/support with your most recent campaign ID that you’ve found to be landing in spam so that we could address your concern.

    1. Hi Melvin,

      Duplicate the row so that the other columns are also filled in so you’ll have 2 rows one for each email address.

  69. I’ve successfully connected GMass to my Google Drive and sent a test batch of 120 emails. How can I add additional emails (on separate Google Sheets tabs) to the same campaign?

    Thanks!

  70. how do i connect my googlel sheets in my drive to gmass when i click on the tables none of them come up.

  71. Hi Gmass Team

    I am trying to create a list and upload it but Gmass is not able find the email column.
    I am wondering because all emails are there…and I uploaded it before.
    Can u please help me with this one

    Thanks in advance!

    1. GMass: System.Exception: Unable to find the Email column in the given worksheet: Schweiz Kontakte & Accounts all

      This is what is shown.

      1. Hi Franz,

        Please contact our support team at https://www.gmass.co/blog/how-to-get-support-from-the-gmass-team/

  72. Is there a limit to the number of emails? I’d like to purge my list by emailing all 10,000 and eliminating those that bounce.

    1. Hi Diana,

      Our subscriptions do not have usage limits. Although Google Apps accounts are officially limited to 2,000 emails per day, we have noticed over time that there are other factors that affect the send limits for an account. Age is a huge factor in this, as Google limit accounts to lower sending capacity until the account establishes its credibility. This is a measure to prevent scammers and spammers from opening accounts and sending at full capacity. 
       
      There’s some more information about these limits and factors here: https://www.gmass.co/blog/how-many-emails-can-you-really-send-with-gmass-and-gmail/ ( https://www.gmass.co/blog/how-many-emails-can-you-really-send-with-gmass-and-gmail/ )
       

  73. We’re running internal vendor satisfaction surveys, which means that the same person must receive an email for each vendor in their portfolio. How can GMass be configured to believe that duplicate email entries on my spreadsheet means that each separate email recipient entry gets multiple emails, each personalized to the unique information in each row? e.g.
    vendor 1, recipientemail1
    vendor 2, recipientemail1
    vendor 3, recipientemail 2
    vendor 4, recipientemail 3
    vendor 5, recipientemail 3
    etc.

    And in other cases, we have more than one staff member who can respond to a survey for each vendor, e.g.
    vendor 1, recipientemail1, recipientemail4
    vendor 2, recipientemail1
    vendor 3, recipientemail 2, recipientemail5
    vendor 4, recipientemail 3, recipientemail1
    vendor 5, recipientemail 3, recipientemail2
    etc.

    Are both of these configurations possible?

    1. Hi Alice,

      Please contact our support team at https://www.gmass.co/blog/how-to-get-support-from-the-gmass-team/

  74. Where do we see campaign results after an email has been sent? When I click on the GMASS envelope on the side it says there is a campaign error.

  75. If the linked spreadsheet accidentally deleted after sending the email campaigns and now when the follow ups are going the error messages are getting shown. So how we could set followups again for the same campaigns.

    Error: G-Mass was unable to read from your Google Sheets spreadsheet.

    Please suggest a suitable solution

    1. Hi Saharsh,

      You can simply recover the spreadsheet. Since your campaigns are based on the spreadsheet ID, you would need to recover the exact sheet (not just a duplicate of it).

  76. I have added first name in the body of my email but the screen for personalisation is not the same as shown in the tutorial and also it does not enter the (first name) and on test it doesn’t put a first name in the email.

    Why is this

    1. Hi Lisa,

      Your merge tag should match your column headers for your spreadsheet. The {FirstName} and {LastName} are defaults when using Google Contacts.

  77. Can you please add an option to connect to multiple Google sheets at the same time?
    It would be very useful.
    Thanks!

  78. It would be nice if the extension would show the Google Sheet that I’m viewing from sheets.google.com in another tab. I’ve uploaded an .XLSX file to Google Sheets but it will not show in the listing for me to connect to the spreadsheet.

    1. Hi William,

      If you haven’t done so already, XLSX files would need to be converted to a Google Sheet. Double click on your Excel file in your Google Drive and you will see the option to open with Google Sheet. This will convert your file to a Google Sheet which you can then connect to GMass.

    1. Hi Heather,

      With GMass, all of the email addresses are sent an individual email addressed only to each so none of your recipients will see each other’s email addresses. You can try it out by sending a test campaign to a couple of email addresses that you have access to.

      To send a test campaign, simply add those addresses in the TO field and draft out your test email and click the GMass button. When you check those mailboxes, you’ll see that each of those addresses receives an email addressed only to a single recipient. You can also see this in your Sent Folder where each individual email to each of your recipients are also listed.

  79. This is a really good tip especially to those fresh to the blogosphere.
    Simple but very precise information? Appreciate your sharing this one.

    A must read post!

  80. Aw, this was an incredibly good post. Finding the time and actual effort to make a superb article?
    but what can I say? I put things off a whole lot and
    never seem to get nearly anything done.

  81. How much emails send at time means if my excel sheet contact more then 100 when GMASS not spread emails in my account they saying failed. if i am only add 100 or less then they always spread emails.

    Why is doing that? can we not send more then 100 emails at the time.

    1. Hi Avanindra,

      The reason is you’re using the free version of GMass which limits the number of emails you can send or schedule to up to only 50 emails per rolling 24 hours. If you would like to lift this limit, you would need to subscribe to one of our paid plans found here: https://www.gmass.co/pricing/

  82. I’m new to this program just downloaded and sent test message to gmass staff. Trying to test message my first campaign, When I try to connect google sheets to program, nothing happens. The dialog box does not pull up any of my google sheets data.

  83. I have several spreadsheets I want to sent emails to, both with and without multiple tabs.
    I started from one with only 5 emails, so definitely not hitting my limits, nor have I any duplicates there, yet I get this error:
    GMass: System.Exception: There are duplicate columns in the given worksheet: Sheet1

    Any ideas?

    1. Hi Barbara,

      This error means that you have columns that have the same column headers. The reason why you can’t have more than 1 column header with the same name (i.e. firstname, lastname, email,etc) is because column headers are used for the merge tags for personalization. For example, if you have 2 columns with the column header “firstname” and you used the merge tag {firstname} then GMass wouldn’t be able to know which of the 2 columns that has the same header you actually want to pull from. This is the reason why we’ve made it so that whenever GMass detects duplicate column headers it will result in the error notification you’ve received.

  84. I notice that the emails are being repeated for new days even though they do not match the ColumnName=CurrentDateIgnoreYear. Is that due to some configuration error?

  85. WE have not sent any email in the morning today but still, we are facing issues.

    when we are sening one or two email with normal send button it is giving this error

    You have reached a limit for sending mail. Your message was not sent.

  86. Hi!
    I’ve sent an email to support – but when I connect my Google Sheet to the GMass email I want to send, individual emails do not populate, but rather one gmass.co address. Is this because of the number of recipients?
    (I do have columns set up as FirstName EmailAddress)
    Please help!

  87. Hi, I’ve already sent an email to support yesterday, but I haven’t received a reply yet. I’m having trouble connecting my Google Sheets to GMass. Please help, I bought the Premium version yesterday and was hoping to use it today.

  88. We purchased the premium subscription and added GMass to Chrome. However, the Google Sheets icon is not showing up in Gmail. What are we missing?

    1. Hi David,

      Upon checking the registered email you used to make this comment, your subscription has been connected to GMass. We’re showing that you’ve sent the trial campaign already. However, since you mentioned you’re not seeing the “connect Google Sheet” icon, you may have another extension installed that’s causing a conflict with GMass. Please follow the steps outlined in our “Missing GMAss button” troubleshooting guide which would help in isolating what’s causing the issue you’re encountering.

      You may also contact our Support Team directly by going to gmass.co/g/support

  89. Hi,
    I have a googlesheet with 445 email addresses, it pops up with a a dialog box which stating to add showsend@gmass.co.uk to enable the send button, however when I do this the send button is not showing, just the gmass button. Is there another step?
    Please advise

    Thanks

  90. When a new entry arrives in to a spreadsheet, does Gmass send personalized mail to new entry or will it send email to complete list?

  91. The file loader doesn’t seem to be pulling in any of my Shared Drives. I hate to create a personal version — defeats the purpose of keeping the data all in one place.

    1. Hi Lynn,

      At this time, GMass does not support team drives. You would need to save the file in your account’s own drive for GMass to detect it.

  92. My google sheet has 58 email address

    BUT why gmass only show 25 recipients???

    later on I tried put 10 email address on google sheet

    then use gmass

    but it only shows 3 recipients???

    1. Hi Shusen,

      This is because your connected Google Sheet’s email column contains cells that have multiple email addresses. Please note that the email cell should only contain a single email address.

  93. Hi! My google spreadsheet has 2 email addresses per recipient in two different columns, meaning the name is in one column, and one email address in a second column and the second email address in the third column, but it is picking up the email addresses in only one of the columns.
    Also I have 81 recipients in my list by the gmass is picking only 76.

    Please advise.

  94. I am not seeing the “Google Sheets” icon next to the “Build Email List” button. Is there a way to get this to show up?

  95. I have a G suite account. But the gmail is not allowing 1000 mails to send. It is asking for payment.

    1. Hi Anoop,

      The notification you’re receiving is due to attempting to send to 1000 recipients, however, you’re on the free version of GMass which has a limit of 50 emails per rolling 24 hours. If you’d like to remove this limit, please subscribe to one of our paid plans by going to http://www.gmass.co/pricing

  96. I just sent my first campaign out to 7 people via Google Sheet.

    If I have more people that I want to send that same campaign email to, how do I do that?

    Use the same spreadsheet? Add the names directly to same worksheet?

    Will GMass know NOT to send the same email out to the 7 people who’ve already received it?

    Create a new spreadsheet? A new worksheet?

    Thanks.

  97. Can I please get some basic instructions and solutions on how I can mail merge and send from google sheets dynamically all text in mail merge fields and dynamic image fields? I just signed up and emailed support+id36139@gmass.zendesk.com per the sample I sent? I cannot figure this out. I appreciate your helping me resolve. See the below template. Thank you, Jenna

    [Subject/Body Template:]

    To: {Email}
    Subject: {Custom1} {Custom2}

    Body:
    {Company}
    {Custom3}
    {Email}
    {Phone}

    {Custom4}
    {Custom5}

    Insert email signature html below in mail merge:

    1. Hi Jenna,

      Please make sure that you include the IMG HTML code within your image cells so when GMass pulls the data, it will pull the HTML to display each image. Please refer to this updated Sheet based on your Excel file.

      We’ve responded to your ticket directly with a sample Google Sheet based on the image you’ve included.

  98. I am using this to email information to parents on a team. My list is by athlete. I have two situations that aren’t working and need help.

    1. Some students have two email addresses associated with them. Is there a way to send information to multiple emails without copy and pasting the columns twice in my spreadsheet. Example can I put in the email column Email1; Email2, or something?

    2. Is there a way for me to send an email for EACH row, regardless of if it is a repeat email address? Some students are siblings so I have one row for Student 1 with information regarding Student 1 I want to bring into the email via fields and then another row with information for Student 2. Since the email address listed in row for Student 1 and row for Student 2 match, it isn’t sending an email for Student 2… like it knows one was already sent (but then I’m missing information for Student 2).

  99. Please update the images as your product doesn’t have repeat daily to new sheet adresses.
    it has repeat in the schedule

  100. Hi Ajay,

    I have a massive list from SalesQL.com. Their service finds emails from LinkedIn.
    I have business and personal emails for many.

    Been trying to find a way to send to either or, or both emails.

    For example…

    Sam Smith ssmith1@dell.com (business) and Smittyfun@gmail.com (personal).

    Ideally Gmass would say, if business email is NULL, then use personal email.

    Any thoughts on how I could do this?

  101. There seems to be a bug tonight. The gsheet I chose only have 20 unique email address, but GMass is populating the the To field with 121 email addresses. What’s going on?

  102. Thanks all, very impressed, found the instructions superb, and all worked flawlessly!
    Well done Ajay and team!
    Katleen

  103. An example :
    10 mail campaign
    After I add 1 duplicate row for mistake. Will be considered or bypassed?

    Second question : VERIFIED column will be populated in both direct and draft sending mode? If I check the option VERIFY and send immediately, all the recipients mail will be real time verified before sending?

    1. The default option is to skip duplicates, but there are cases where you may want to keep duplicates. This is addressed in this very article.

      Yes, that’s correct on verification. Regardless of whether you’re sending or creating Drafts, as long as you’ve marked the option to update your Sheet, the column will update.

  104. Is there a way to have two columns listed next to each and be uniformly spaced apart? For example one column has a list of devices and the other, across it, displays the device serial number. Each email address has different number of devices. Thank you

    1. Yes, you can actually have spaces in your Sheet cells and have GMass respect that. We recently added an internal setting, at the request of another user, to preserve the spaces around the text in cells, for mail merge purposes. If you want us to turn that setting on for you, just let support know, and reference my comment here.

  105. Hello,
    Are there known issues with certain email platforms receiving a GMASS mailing? Using the GMASS tool, we’re trying to create a personalized email to parents of an organization. The email loads correctly from a google sheet and we’re able to copy and paste the {first_name} then add the text into the body of the email, however we’ve attempted to send a test email to a handful of different folks using Gmail.com and Hotmail/MSN.com addresses. The Gmail addresses received without incident but there’s been frustrating results with the Hotmail/MSN.com addresses. One of those address had the email go directly to junk, while others never received the email at all. What am I missing?

  106. Hello,
    (I am posting this again with my wife’s info attached, please reply to both)
    Are there known issues with certain email platforms receiving a GMASS mailing? Using the GMASS tool, we’re trying to create a personalized email to parents of an organization. The email loads correctly from a google sheet and we’re able to copy and paste the {first_name} then add the text into the body of the email, however we’ve attempted to send a test email to a handful of different folks using Gmail.com and Hotmail/MSN.com addresses. The Gmail addresses received without incident but there’s been frustrating results with the Hotmail/MSN.com addresses. One of those address had the email go directly to junk, while others never received the email at all. What am I missing?

  107. I want to send email automatically for every new row added in the google sheet.
    The set of data captured from import range from other sheet.

    Kindly advice your plotform support this feature or not.

  108. My google sheets are not loading when I go to select it for the campaign. There are some older sheets showing, but it is not updating to the most current sheets. Can you resolve this or look into this problem for me?

  109. I used the gmass function yesterday. I sent out 29 emails, 20 of the emails came back as blocked emails and the other 9 couldn’t be sent out due to reaching my email limit for the day. Which I don’t see how that’s possible, when I’ve only sent less than 50 emails yesterday. Any work around in making my gmass emails to not be blocked or do I have to go back to sending the old fashioned way of one email and BCC everyone on it?

  110. I am trying to link Google sheets from a different Google sheets account than the email account that I am using with Gmass. It shows that Gmass is linked but does not show any spreadsheets in the drop-down.

    I go back to try and link but it is still stuck on the original Google account. How do I change the Google account that I use to link Google Sheets?

    Help.

  111. Is there any way to pull information from two worksheets (tabs) on a google spreadsheet?

    One tab has my site members. They are the ones I want to email and their email address is in the spreadsheet.

    The other tab has one-time users. They will be providing information to the members.
    The information they are providing is in the second tab. The one-time users will need to send a message to the members with their email addresses for follow-up. The email won’t come from the one-time user their email address will just be in the body of the message.

    Can I do this with GMass?

  112. Hello, my question is does GMASS detect duplicates emails when uploading & will it send duplicates emails when scheduled. Also, where do you find this information on GMASS?

    I look forward to your response.

    thanks,

    JERRY

  113. This is pretty good and straightforward. I was able to grasp it quickly and practise using it. However, I’ve not been able to get how I can use it to schedule birthday messages at different dates. Please help.

  114. Pingback: Smartwriter Review
  115. Hi,

    Is there a way to make the scheduled repeat re-read the whole spreadsheet data? I am programmatically regenerating the sheet and all of the data will change (emails, personalized content etc.). Or is there a way to build an automation that would automatically generate a new GMass with an existing template? (We are sending a weekly personalized email to hundreds of recipients depending on the activity in the service so always a different group of recipients)

  116. I seem not to understand what spam really is. Can someone explain this in simple terms because to some of us sending mass emails is tantamount to spam.

  117. I have not yet subscribed. I have just been trying to learn how it works and that
    it is user friendly. I am very keen to have this product but I am struggling to have my
    emails spreadsheet created.

    Can you support?

    Hoping you will find this in order

    Yours sincerely

    Sam

  118. I am trying to compose a GMASS message, but it is not recognizing the most current version of my Google Sheet that I wanted to pull email addresses from.

Leave a Reply to Anonymous Cancel reply

Your email address will not be published. Required fields are marked *

Try GMass today

It only takes 30 seconds to install it!

Install Now GMass requires Chrome

GMass

Share This