Bug Fix: Gmail mail merge error when connecting to certain Google Sheets
Posted: Wed Dec 11, 2024 3:44 am
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 oany email address to iceland phone number resource 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.
Ready to transform Gmail into an email
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 oany email address to iceland phone number resource 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.
Ready to transform Gmail into an email