<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1822615684631785&amp;ev=PageView&amp;noscript=1"/>

Google Sheets

GMass is a complete email marketing platform that lives inside of your Gmail account. And GMass makes heavy use of Google Sheets, as you'll use Sheets to organize your contacts and set your mail merge fields.

You can do all sorts of things with the native GMass + Google Sheets integration to run campaigns, automations, and more. And here in the Google Sheets archives, you can read all of our articles on different ways to use that connection.

If you're interested in checking out all of the major features of the GMass/Google Sheets connection, have a look at our page on GMass's Google Sheets integration.

September 20, 2023

How to Automatically Apply a Google Sheets Formula to a New Row

Google Sheets automatically add formula to new row walkthrough — how to have Sheets apply your formula down a column instantly.

Continue Reading

July 21, 2023

How to Turn Google Sheets Formatting into HTML (Then Mail Merge with GMass)

How to turn formatting from your Google Sheets into HTML so you can use it in other places, especially mail merge campaigns with GMass.

Continue Reading

November 22, 2022

How to Trigger a Transactional Email to New Rows in a Google Sheet

A Google Apps Script to send an instant, automated transactional email through GMass to the address in any new row you add to a Google Sheet.

Continue Reading
create automated outreach tracker using google spreadsheet

February 13, 2022

How to Create an Automated Outreach Tracker Using Google Spreadsheet

In this post, we'll show you how to create an outreach tracking spreadsheet that tracks and automates email outreach efforts.

Continue Reading
enter Google Sheet ID manually

February 5, 2022

Why you have to enter your Google Sheet ID manually

If your Google Workspace Admin blocks third party access to your Google Drive, you'll be presented with an alternate interface to connect to a Sheet.

Continue Reading
Update Google Sheet

June 16, 2020

Update a Google Sheet with Campaign Data (Opens, Clicks, Replies)

Sending a mail merge campaign with a Google Sheet is pretty easy and fun, but now we can update your Google Sheet with opens, clicks, and more.

Continue Reading

January 4, 2020

Forced migration to Google Sheets API v4 is bullshit

When I read that Google is forcing developers to migrate from Google Sheets API v3 to v4, I was mad. Here's why.

Continue Reading

July 10, 2018

How to send emails to different people on different days

Using a combination of Gmail, Google Sheets, and GMass, you can easily email different people on different days. In the Google Sheets spreadsheet containing your …

Continue Reading

September 21, 2017

The Google Sheets dropdown is now searchable and beautiful

If you’ve used our Google Sheets integration to send your mail merge campaigns, you may have noticed how UGLY our spreadsheet …

Continue Reading

June 7, 2017

Use Gmail to send birthday and date-driven emails automatically

Using Gmail, Google Sheets, and GMass, you can set up automated birthday emails and emails based on any date criteria in your spreadsheet.

Continue Reading

April 13, 2017

Use Google Forms and GMass to send surveys and follow-up emails that MAXIMIZE responses

Google Forms provides a fast and easy way to create online surveys. When combined with GMass, you can follow-up based on specific replies.

Continue Reading

February 21, 2017

How to use a Google Sheets spreadsheet as a dynamic email suppression list

How to create a Google Sheet to serve as a running suppression list you can use to exclude addresses from selected future campaigns.

Continue Reading

Transform your Gmail account into an email marketing powerhouse

GMass is easy to learn and easy to use — but brings unbelievable email power into Gmail

Try GMass for free Then check out the quickstart guide to send your first mail merge email in minutes!

GMass