GMass and Google SheetsGMass’s Google Sheets integration is complete. You can now send a mass email/mail merge campaign easily to contacts in a Google Sheets spreadsheet.

The basic process of connecting to a spreadsheet and then personalizing and sending a mail merge campaign.

You’ll notice a new Google Sheets icon next to the Build Email List button.

Click the Sheets icon to start.

Click the Sheets icon, and a window will popup showing your spreadsheets, and allowing you to choose one. All Google Sheets that you own or are shared with you will show in the dropdown. If you don’t see the Google Sheet you’re expecting, your account doesn’t have permissions to access it. Also, note that the dropdown will NOT show you your Excel files that are in your Google Drive. GMass doesn’t connect to Excel files directly, but it’s easy to convert your Excel spreadsheet to a Google Sheet.

Choose your spreadsheet and worksheet.

You do not need to specify which column contains the email addresses, because GMass will auto-detect email addresses and read the other columns in the spreadsheet to allow you to personalize your mass email with any of those fields.

A properly formatted spreadsheet

How to format your spreadsheet

Your spreadsheet needs to be formatted properly for GMass to read from it. Proper formatting includes:

  • The first row should contain column names, like: FirstName, LastName, EmailAddress, Company, LastPurchase, and others. It’s best that column names do not contain spaces or special characters. Stick with alphanumeric characters so that personalization works reliably.
  • The actual data should start on the second row.
  • At least one column should contain email addresses. GMass will auto-detect this column.

Choose your Google Sheet

The first step is to choose the Google Sheet you want to use from the dropdown. Only Google Sheets that you own or are shared with you will show up here. Excel files will not show up.

Choose your worksheet

If your spreadsheet has multiple worksheets, then a Worksheets dropdown will also appear, allowing you to select the specific worksheet from which you’d like GMass to read your email list. If your spreadsheet only has one worksheet, then this dropdown will not appear.

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

Personalize

Clicking on the settings arrow will reveal 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.

Use the personalization buttons to insert mail merge tags in your Body.

Advanced Mail Merge Techniques with Google Sheets

Above I’ve shown you how to do a basic mail merge with a Google Sheets spreadsheet and personalize based on columns in the spreadsheet.

You now have the option to insert an Unsubscribe link into your email marketing campaigns with GMass. To insert an unsubscribe link, just click the Add Unsubscribe Link link in the Settings box, and a link will be added at the cursor in the body of the message.

We recommend that an unsubscribe link be added to all mass emails containing promotional or marketing content, but the decision is up to you. If you don’t have regular back-and-forth email correspondence with the people whom you’re emailing, it’s wise to include an unsubscribe link.

If a recipient clicks the link, their email address will be placed on your GMass account’s Unsubscribe List. You’ll also be notified via a report that will appear in the GMass Reports –> Unsubscribes Label in your Gmail account.

When you send future mass emails with GMass, your email list will be checked against your Unsubscribe List, and anyone found on the unsubscribe list will be removed automatically as a recipient. You don’t have to manually remove people that have unsubscribed from your source email list because GMass handles the elimination of unsubscribed addresses from campaigns for you.

What your recipient will see

When your recipient clicks on the Unsubscribe Link, he/she will be taken to an unsubscribe page that looks like this and asks for confirmation:

GMass Unsubscribe Page
This is what your recipient sees after clicking the Unsubscribe Link.

For free accounts, a text link to GMass is also included on this page. For paid accounts, as shown in the screenshot above, there is no link to GMass.

Important Notes about the GMass Unsubscribe Link

  1. To re-subscribe an address, the subscriber must click on the re-subscribe option after unsubscribing. One can re-subscribe anytime by clicking on any unsubscribe link from any past GMass email. Note that deleting an unsubscribe report from the GMass Reports section will not remove an address from your unsubscribe list.
  2. If you wish to manually unsubscribe certain email addresses, you can easily add them to your account. Just follow the instructions here to import an unsubscribe list.
  3. If you wish to manually re-subscribe certain email addresses, you can do so by following these instructions to manually remove an address from your Unsubscribe list.
  4. If you wish to manually insert the unsubscribe link into the body of your emails, so that it flows with your email design, create a link to:https://www.gmass.co/gmass/u?u=OUTBOUNDThe “OUTBOUND” part will be replaced with a unique identifier at the time the email is sent, and the “www.gmass.co” part will be replaced with your account’s tracking domain.

Mail merge campaigns sent via GMass can now be click-tracked. To turn on click-tracking for a mail-merge campaign, just check the box in the Settings box before clicking the main GMass button. Note that click-tracking is turned on by default.

All hyperlinks will be converted to trackable hyperlinks in the following format:

https://www.gmass.co/gmass/c?l=a49161a3-f464-436c-b9eb-7c0efbc318c0&r=d87f514c-0070-4ec0-91db-a1de52a341e7

Certain links will be left alone and not tracked, including “mailto:” links and “tel:” links. All other regular web hyperlinks will be converted to trackable links if click tracking is on. Additionally, previously tracked URLs will not be tracked again. For example, if you track a link in one campaign, and that URL is converted to:

https://www.gmass.co/gmass/c?l=a49161a3-f464-436c-b9eb-7c0efbc318c0&r=d87f514c-0070-4ec0-91db-a1de52a341e7

and then you copy/paste that tracked URL into another campaign, it will be left alone and not converted again.

Reporting

When someone clicks on a link in an email campaign, a report will go into the GMass Reports –> Clicks label in your Gmail account.

Not all links are tracked

In order to prevent your links from looking like phishing links, we do NOT TRACK links where the anchor text itself is a URL.

We just made a change to GMass. Before, if you specified a Cc or Bcc address, and then sent via GMass, the Cc and Bcc addresses were ignored and only the addresses in the To line received the email message.

Now, however, after user requests, we’ve added Cc and Bcc functionality such that any addresses specified as a Cc or Bcc will receive a copy of every individual sent email. For example, if you’re sending via GMass to five recipients, and you set a Cc address, the Cc address will receive all 5 emails.

In the example above, the email is set to send to the eight recipients in the To line. If sent via GMass, each of the eight recipients will receive an individual, personalized email, and the Cc address will receive all eight email messages as well.

Update February 2016: See our corresponding blog post on confusion between the To and Cc/Bcc fields.