After two weeks of development effort, GMass’s Google Sheets integration is complete. You can now send a mass email/mail merge campaign easily to contacts in a Google Sheets spreadsheet.
To get the feature, just do a hard re-load of Gmail in your Chrome browser.
You’ll notice a new Google Sheets icon next to the “Build Email List” button. Please note that we re-named “Compose from Search” to “Build Email List”.
Click the Sheets icon, and after you’ve authorized GMass to access your Google Sheets spreadsheets, a window will popup showing your spreadsheets, and allowing you to choose one.
You do not need to specify which column contains the email addresses, because GMass will auto-detect that and read the other columns in the spreadsheet to allow you to personalize your mass email with any of those fields.
Your spreadsheet needs to be formatted properly for GMass to read from it. The first row should contain column names, like FirstName, LastName, EmailAddress, Company, LastPurchase, and others. The actual data should start on the second row.
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. 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.
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.