How to Set Up GPT for Sheets – Guide (AI/ChatGPT Inside Google Sheets)
GPT for Sheets is a wildly popular Google Workspace add-on that brings ChatGPT’s powers directly into Google Sheets. And as cold emailers lean more and more on AI…
GMass Blog
Category: 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.
Continue reading →
How to Automatically Apply a Google Sheets Formula to a New Row
You’re not always going to be able to drag a formula down a column in Google Sheets. Sometimes, you need Google Sheets to automatically apply the formula to…
How to Turn Google Sheets Formatting into HTML (Then Mail Merge with GMass)
If you didn’t know, Google Sheets allows you to format pieces of text inside a cell. However, that formatting is trapped inside Google Sheets. It might work if…
How to Trigger a Transactional Email to New Rows in a Google Sheet
Update: Instant emails in recurring campaigns is now a native GMass feature. You no longer need to use this workaround. However, if you’d like to (for whatever reason),…
How to Create an Automated Outreach Tracker Using Google Spreadsheet
As an email marketer, you’ll most likely start your campaign with a Google spreadsheet for prospecting and list management. Whether you’re sending emails manually or using a third-party…
Why you have to enter your Google Sheet ID manually
If you go to connect to your Google Sheet only to find a strange dialog box that looks like this… …it’s because your Google Workspace Admin has blocked…
Update a Google Sheet with Campaign Data (Opens, Clicks, Replies)
You’re probably using Google Sheets to send most (if not all) of your campaigns in GMass. So it only makes sense that you’d want to get campaign data…
Forced migration to Google Sheets API v4 is bullshit
Recently, Google announced that the old version 3 of the Google Sheets API will be shut down in March of 2020, forcing developers to migrate to version 4…
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 email addresses, you simply need a Date column that includes…
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 dropdown used to be. If you had lots…
Use Gmail to send birthday and date-driven emails automatically
Using a combination of Gmail, Google Sheets, and GMass, you can easily set up automated birthday emails to go out on people’s birthdays or any other specific date…
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, and used with auto follow-up emails from GMass, you can maximize the number of responses you…