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.
Only GMass packs every email app into one tool — and brings it all into Gmail for you. Better emails. Tons of power. Easy to use.
TRY GMASS FOR FREE
Download Chrome extension - 30 second install!
No credit card required
Ajay is the founder of GMass and has been developing email sending software for 20 years.
I’m still figuring this out
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”.
Hi Dwayne,
Please check your header row to ensure that each one is unique. (Can’t have multiple columns having the same column header.)
OK.
I will do as you have said.
Thanks.
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.
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.
Fixed!
Hi,
Glad you got it sorted out!
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.
I am attaching a Gmass mail to a google sheet but it picks up only 1 address randomly from a sheet with 55 contacts?
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.
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!
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.
DOES ANYONE HAVE A GODDAMN ANSWER
Same issue here – I’m getting 0 recipients, with no solution in sight
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.