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

How to send a mail merge with Google Sheets

Looking to send a mail merge with Google Sheets?

Mail merges are one of the easiest ways to add tons of email recipients in seconds. In this article, I’ll show you how to send one while also introducing a powerful mail merge tool for your email marketing campaigns.

Here’s what we’ll cover:

Use the links below to jump to a particular section:

  1. What Is A Mail Merge?
  2. How GMass Helps You To Send A Mail Merge Using Google Sheets
  3. Why GMass Is The Most Powerful Mail Merge Tool

What Is A Mail Merge?

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

This data file can be any mail merge document like a spreadsheet or a database file that contains information like the recipient’s name, email address and other details.

When you initiate a mail merge, this data is automatically entered into your email template. Mail merged emails can save you tons of time when sending mass emails as you’re not manually entering each recipients’ email ids.

How GMass Helps You To Send A Mail Merge With Google Sheets

What Is GMass?

GMass is a powerful email marketing software that lets you run mail merge campaigns from your Gmail account. Its powerful mail merge capabilities have made it a popular Chrome extension that’s used by employees from Uber, Twitter, LinkedIn and Google.

With advanced personalization features, it’ll streamline your email workflow and boost your conversions in no time!

However, GMass isn’t aimed at email marketers alone. It can also be used by individuals, social organizations and institutes like schools and churches to send targeted emails to large audiences from a Google account.

How To Send A Mail Merge With Google Sheets In GMass

Instead of wasting time creating a Google Apps script to build a mail merge template, you can use GMass to send emails in seconds.

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

Step 1 – Formatting Your Spreadsheet

You need to create a spreadsheet in plain text for GMass to use it. It’s important to properly format the rows and columns for the best possible results.

  • The first row should contain column names such as FirstName, LastName, EmailAddress, Company, and others. For best results, column names shouldn’t contain spaces or special characters. Personalization works the most reliably if you stick with alphanumeric characters, meaning just numbers and letters, for every column label. If your Sheet already has a column named “First Name”, for example, we recommend removing the space and re-naming it to just “FirstName”.
  • The actual data should start in the second row.
  • At least one column should contain email addresses. GMass will auto-detect this column and use this column as the recipient address column. If your Sheet has more than one column containing email addresses, then rearrange your Sheet so that the column containing the addresses you want used as the recipients for this campaign is to the left of other columns containing email addresses. If you want GMass to send emails to the primary column and another column containing email addresses, see this article on how to send a mail merge to two people per row.

Note – If there are multiple worksheets, use the worksheet tab to select each worksheet and format them separately.

What If You Don’t Want Certain Addresses Included?
To filter out specific addresses, you can manually remove them after connecting your spreadsheet.

Alternatively, you can copy/paste the rows you want in the current spreadsheet to a new spreadsheet, and have GMass connect to the new spreadsheet.

Step 2 – Logging In To Your Gmail Account

Log in to your Gmail account. You’ll notice a “Google Sheets” icon next to the “Build Email List” button.

Step 3 – Connecting GMass To Your Spreadsheet

Click the “Sheets” icon, and it will display a pop-up window showing your spreadsheets. You can now select the sheet to import your recipients’ details.

GMass connects to this spreadsheet using a spreadsheet ID that’s unique to each sheet. The drop-down menu displays all the Google Sheets that you own or are shared with you. If you don’t see the spreadsheet you need, your Gmail account doesn’t have permission to access it.

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 it’s easy to convert your Excel spreadsheet to a Google Sheet.

You needn’t specify which spreadsheet column contains the email addresses. GMass will auto-detect the email addresses from your sheet and generate the personalization variables (first name, last name, etc) for you.

Step 4 – Choosing Your Worksheet

If your Google spreadsheet has multiple worksheets, a Worksheets drop-down will appear, as you can see in the screenshot below. This allows you to select the specific sheet you need.

Note – If your spreadsheet only has one worksheet, this drop-down will not appear.

After clicking the “Connect” button, GMass will read the email addresses and other data from your spreadsheet and load the list of recipients into the To field of a new Compose window.

Step 5 – Personalizing Your Email
Click on the settings arrow to access the personalization buttons – one for each column in the spreadsheet. Click these buttons to insert the personalization fields into the subject and body of your email message before you send it.

Note – A personalization tag in your email template should match the column header of your spreadsheet. For example, your column header can’t be “Word 1” while your email template has “First Name.”

The {FirstName} and {LastName} tags are defaults when using Google Contacts.

Step 6 – Sending

Hit the GMass button to send your mail merge. It will either send now or later, depending on how you set the Scheduling section.

Understanding the timing of when email addresses are pulled from the Sheet

If you use the spreadsheet connector to pull the email addresses from the Google Sheet, and you send a standard one-time broadcast email campaign, then the email addresses that the campaign sends to include only the email addresses that are in the To field, which unless altered will be the addresses that were on the Sheet at the time you used the GMass Sheet connector button. For example, let’s say that you click the Sheet connector button, configure your campaign, and then schedule it to send 24 hours from now. But then one hour from now, you add a few rows of email addresses to your spreadsheet. When the campaign goes out tomorrow, it will not include the addresses you just added because those new addresses weren’t part of the “pull” when you connected to the Sheet to configure your campaign and aren’t in the To field. The campaign will only send to the addresses that are in the To field of the campaign’s DRAFT at the time of sending. So if you want to add addresses after scheduling the email, you would have to add the addresses directly to the To field (and the Sheet to ensure personalization works). It’s still important that the spreadsheet exists at the time of sending, because although the email addresses won’t be pulled from the Sheet at the time of sending, the personalization data will. If GMass can’t read your Google Sheet at the time your campaign is sends, then personalization can’t work, and the campaign will fail and you’ll receive an error notification.

If, however, you do want GMass to always pull the latest email addresses from the Sheet at the exact minute GMass sends the campaign, then use any of the Recurring options under the Scheduling section. Any mail merge campaign that is set to repeat that is also connected to a Sheet will always connect to the Sheet to find all of the email addresses at send-time and add that list to the addresses in the To field. So in the above example, where you’re scheduling a campaign to send 24 hours from now, and then 1 hour from now, you add new addresses, if one of the recurring options is set, then when the campaign sends tomorrow, it will include the new addresses that you added to the Sheet later.

Advanced GMass Features For Gmail Mail Merge Users

In addition to simplifying the mail merge process, GMass offers other features to optimize your email campaigns:

1. Automatic Follow-ups

Not everyone is going to respond to your email campaigns.
Some may have forgotten about it, some never saw it and some were simply too busy to respond.

So what do you?
You send a follow-up email.

But what if you have to do that to 100s of people?
You can’t manually type each follow-up email, right?

Fortunately, GMass automates your email follow-ups. It even lets you customize everything about these emails:

  • You can specify the frequency of follow-ups to be sent.
  • You can set the total number of follow-ups each recipient receives.
  • You can personalize the message in each follow-up.

Click here for a detailed guide on automatic follow-ups in GMass.

2. Advanced Personalization

The problem with most bulk emails is that they’re not personalized.

And why is that a problem?

Because it’s far harder to make a connection with a person if they think you’re mass emailing them.

And trust me, recipients can smell spammy, mass emails from miles away!

But what’s the other alternative?
Sending each recipient a personalized email?

Addressing each recipient personally is next to impossible when you have a large mailing list. Email marketers don’t have the time to create personalized emails for hundreds of people, right?

Fortunately, GMass can help with this.
It offers you automated email personalization features to tailor your emails for each prospect. With this, you won’t have to personalize each mail manually  – GMass does it for you!

It gives you  features like:

  1. Auto First Name Detection – GMass automatically inserts a recipient’s first name anywhere you want in your email. The software auto-detects a person’s first name from their email id.
  2. Include customized links – you can add customized links or URLs for each recipient.
  3. Include personalized images – you can add unique images for each recipient in your campaign.
  4. Personalize large blocks of text – GMass lets you customize entire paragraphs in your email message on a person-by-person basis.

Here’s a detailed guide on personalizing your emails with GMass.

3. Bypass Gmail’s Sending Limits

A regular Gmail account can send 500 emails per rolling 24 hours while a G Suite (formerly, Google Apps for Work) account can send 2,000 emails per rolling 24 hours.

GMass, however, lets you surpass this sending limit by letting you send 10,000 emails. It automatically distributes these emails over multiple days based on your Google account’s sending limits.

Say you have a Google Sheets spreadsheet with 8,000 addresses and you’re sending these emails from a G Suite account. GMass sends 2,000 emails immediately, the next 2,000 will be sent 24 hours later, another 2,000 after 48 hours and the final 2,000 will be sent 72 hours later.

This way, you can send all 8000 emails without having to log in for four successive days!

4. Recurring Automated Campaigns

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

Luckily, GMass lets you create recurring campaigns. You can connect a campaign to a particular spreadsheet, and whenever a new recipient is added to the sheet, GMass automatically adds them to your campaign.

Additionally, you can activate auto follow-ups for a sheet to build a fully automated drip campaign. Simply add new prospects to your spreadsheet, and they’ll automatically start receiving your emails, including any follow-ups.

You can also conduct a recurring campaign that’ll send emails to all addresses in a spreadsheet, instead of just new addresses. This helps you conduct a recurring reminder-style email campaign to the same set of people.

5. Create Dynamic Suppression Lists

Unfortunately, no email campaign has a 100% success rate. There will be instances where a recipient is unresponsive.

In this scenario, you can send a few follow-up emails, but if they’re still unresponsive, you’ll have to stop.

You’ll be running the risk of ruining your sender reputation by continually being marked as spam.

In order to protect your reputation, you have to add these recipients to a suppression list. The members on this list won’t receive any of the campaign emails you send out.

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

GMass, however, lets you easily maintain suppression lists for your mail merge campaigns. It allows you to use a Google Sheets spreadsheet as the source of this suppression list. Connect your campaign to this sheet and any of the addresses present will automatically be omitted from any future messages!


While the mail merge google sheets method helps you send mass emails, an effective email marketing campaign requires far more.

Powerful mail merge tools like GMass make it incredibly easy to send effective email campaigns and maximize your conversions. You’ll have everything you need to quickly send, manage and follow-up on your emails with detailed analytics and automation.

Why not download the GMass Chrome add-on today and experience it yourself?

  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: System.Data.Entity.Validation.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: System.Data.Entity.Validation.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: System.Data.Entity.Validation.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.

  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!

    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?

  42. 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?

  43. 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?

  44. 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.

  45. 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.


  46. 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?

  47. 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]]

  48. 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?

  49. 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.

  50. 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.

  51. 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.

  52. 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.

  53. 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.

  54. 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.

  55. 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.

  56. 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

  57. 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.

  58. 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.

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

  60. 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!

  61. 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.

  62. 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.

  63. 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

  64. 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.

  65. 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.

  66. 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?

  67. 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.

  68. 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?


  69. 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.

  70. 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/ )

  71. 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

    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

    Are both of these configurations possible?

  72. 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.

  73. 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).

  74. 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.

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

  76. 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.

  77. I loved this post! I read your blog fairly often and you are always
    coming out with some great stuff. I will shares this on my
    facebook, instagram and some of my loyalty followers.

    Great jobs! Keep work it with it.

  78. 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!

  79. 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.

  80. 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/

  81. 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.

  82. 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.

  83. 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?

  84. 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.

  85. 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!

  86. 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.

  87. 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 (https://drive.google.com/file/d/1DmIOx_9hMWvbhA6C1UMcggZtpKgePLCj/view?usp=sharing), 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

  88. 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


  89. 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?

  90. 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.

  91. 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.

  92. 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.

  93. 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?

    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

  94. 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?


  95. 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}



    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.

  96. 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).

  97. Aw, this was an extremely good post. Taking the time and actual effort to create a superb article… but what can I say… I put things off a whole lot and never seem to get nearly anything done.

  98. One thing I have actually noticed is the fact there are plenty of fallacies regarding the financial institutions intentions whenever talking about property foreclosures. One misconception in particular is the bank wants your house. The lender wants your money, not your own home. They want the money they loaned you together with interest. Averting the bank will undoubtedly draw a new foreclosed conclusion. Thanks for your posting.

  99. The next time I read a blog, I hope that it doesnt disappoint me as a lot as this one. I mean, I do know it was my choice to learn, however I truly thought youd have something attention-grabbing to say. All I hear is a bunch of whining about something that you can repair when you werent too busy searching for attention.

  100. 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?

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

  102. There is apparently a bunch to realize about this. I suppose you made certain good points in features also.

  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?

Leave a Reply to Unknown 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
Share This