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

  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.

Leave a 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