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

Bug Fix: Gmail mail merge error when connecting to certain Google Sheets

We just deployed a bug fix that corrects an issue where you would receive an error when connecting GMass to certain Google Docs spreadsheets where an email address had more than 100 characters.

This would be the case if your spreadsheet’s email address column accidentally had text that wasn’t an email address or had multiple email addresses in it. If GMass detected a row in the email address column with text greater than 100 characters, you would get this “entity validation” error:

We have corrected this now by truncating the value of any email address to the first 100 characters. That way, GMass will still connect to a spreadsheet with a “bad” row and pull your email addresses and other fields, but any rows containing an email address value of more than 100 characters will be discarded in the actual sending process, since these addresses will likely be invalid.

Here is an example spreadsheet with an invalid value in the email address column. In this case, the 4th row would be truncated, resulting in an invalid address, and none of the addresses in that row would be sent to.

Note that other non-email address columns may still have values greater than 100 characters. For example, if you have a “Greeting” column, where the column stores a customized greeting sentence that is personalized to each email address, then this sentence can certainly be greater than 100 characters.

Also note that GMass auto-detects which column stores your email addresses versus columns that contain other data (like Greeting, FirstName, LastName, etc.). You won’t need to tell GMass which column in your spreadsheet contains the email addresses to send to. Also, the column need not be named “EmailAddress” as shown in the example — it can be named anything.

Email marketing, cold email, and mail merge inside Gmail


Send incredible emails & automations and avoid the spam folder — all in one powerful but easy-to-learn tool


TRY GMASS FOR FREE

Download Chrome extension - 30 second install!
No credit card required
Love what you're reading? Get the latest email strategy and tips & stay in touch.
   


16 Comments
  1. Hi, Ajay!

    Am having a real-time issue with gmass right now.

    Anytime I try to connect a spreadsheet, it says “duplicate column in given worksheet”.

    1. Hi Dwayne,

      Please check your header row to ensure that each one is unique. (Can’t have multiple columns having the same column header.)

  2. I’m trying to personalize the first name with {FirstName} but for some reason it just refuses to take the name personalization when I send. I have the spread sheet with Name and Email and do have column names mentioned. Kindly advice what’s going wrong.

  3. Hi, I have created new Google Sheets, however GMASS didn’t show the newly created Google Shttes, it only shows the one I created yesterday.

  4. My Google Sheets is properly labeled but when I try to set up the email I only see First Name, Last Name and Email Address. Help? This is the first time this happens, I’ve sent out quite a few campaigns without a problem. Up against a deadline.

  5. I am attaching a Gmass mail to a google sheet but it picks up only 1 address randomly from a sheet with 55 contacts?

  6. GMass is not connecting to the same sheet I’ve already used other times with no problems.

    When I connect it it returns 0 recipients, whereas I have valid email addresses in the sheet.

    1. GMass is not connecting properly to my Sheet (it did in the past). I have a different email subject for each line on my sheet.

      GMass is generatig an email subject that doesn’t exist on my sheet!

  7. My Gmass can connect to my Google Sheet however it is not reading the Email column (which is properly titled). It is sending to 0 recipients, I have over 20 emails on the list.

  8. My problem is that when my Google sheet connects to Gmass, the recipient list doesn’t expand. Gmass or Google does not identify this as a list of emails and nothing sends. A send error is generated. In videos I can see that someone clicks on the subject line and the recipient list expands. Click again and it collapses. This expand/collapse function isn’t working. I’ve tried connecting several different sheets ranging from 6 to 100 rows. 3 simple colulmns and no spaces in the header descriptors.

Leave a Reply

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

Send your first campaign in a matter of minutes

No credit card required

Try GMass for free Then check out the quickstart guide to send your first mail merge email in minutes!

GMass

Share This