How to Get More Out of Mail Merge with Google Sheets

How to Get More Out of Mail Merge with Google Sheets

Learn the ways to know that Google Sheets is the secret to getting more out of your mail merge campaigns.

What would come to mind if I asked you to think about the late 1980s? The music, the fashion, the celebrity gossip?

For business professionals, the end of the 80s didn’t just mean big hair and the rise of grunge music-- it also meant the first professional software suites were hitting the market.

While professional software suites may look very different today than when they first started out-- for example, many of the most popular suites have moved to the cloud-- they remain an essential part of many marketing workflows.

One of the most popular office suites today is G Suite, Google’s collection of cloud-based business applications. Taking advantage of G Suite tools-- in particular, the Google Sheets application-- is the secret to creating a truly effective mail merge campaign to send emails directly from Google Sheets". We would be happy to have a "send emails directly from Google Sheets" text as an anchor to link to our guide sending emails from Google Sheets.

In this article, we’ll prove that Google Sheets is the secret to getting more out of your mail merge campaigns by covering the following:

  • Reasons G Suite is the right choice for your business
  • What the Gmass extension for Google Chrome is and why you should know it
  • How to use the Gmass to take your mail merge campaigns to the next level

G Suite is a powerful mail merge tool for small businesses and large corporations alike.

1. No Matter How Big or Small Your Business, G Suite Has All of the Tools You Need to Succeed

In early 2017, the well-known online technology news source Techcrunch broke a surprising story: Google CEO Sundar Pichai announced that there were more than 3 million businesses using G Suite for smart and secure cloud computing.

But why are so many businesses turning to G Suite for everything from email to word processing to creating spreadsheets and presentation slides?

  • Security
  • Affordability
  • Collaboration

i. Google’s G Suite Platform is Super Secure

Your company relies on data to keep it running day in and day out, so it makes sense that data security is top priority for startups, enterprise-level organizations, and every business in between.

Google has the resources to keep your data secure, and G Suite offers businesses the option to add an extra layer of security with features like two-factor authentication.

ii. The Price of G Suite is Right for Big and Small Businesses Alike

Finding the right tools for your business is a balancing act-- you want the best quality possible without breaking the budget. When you choose G Suite, you don’t have to sacrifice quality or cost. G Suite pricing is fixed at a low monthly rate, making it easy to afford on even the tightest budget.

iii. Teamwork Makes the Dream Work in G Suite’s Collaborative Apps

If two heads are better than one, imagine how much you can get done with a whole team working on a project! G Suite makes real-time collaboration simple, which can take your company’s productivity to a whole new level.

G Suite gives your company the power to innovate and collaborate, plus it makes managing mail merge campaigns easier than ever before.

2. Gmass Streamlines Your Mail Merge Campaigns Using the Google Sheets Application from G Suite

Mail merge-- or the process of automatically pulling information from a database to create personalized communications-- is a key step in many marketing and advertising workflows.

Recommended: Best 5 Techniques Take Your Personalized Marketing to a New Level

If you need to reach out to hundreds or even thousands of people, taking the time to address every message by hand is simply a waste of time.

Luckily, the Gmass extension for Google Chrome makes mail merge easy. It integrates with G Suite tools like Gmail and Google Sheets to provide a seamless mass email experience. Gmass allows you to:

  • Send marketing campaigns to thousands of emails at once
  • Personalize mass emails with name, address, and any other information you make a store in your Google Sheets
  • Schedule emails to be sent later
  • Send follow-up emails
  • Create recipient lists based on search results
  • And more

An effective mail merge campaign is the secret to getting your message recipients to engage with your business.

3. How to Send Smarter Mail Merge Campaigns with Google Sheets

Now that you know why G Suite is a great tool for businesses of any size and the powerful mail merge tool Gmass is on your radar, it’s time to bring those tools together to step up your mail merge game.

After signing up for a Google account and downloading the Gmass extension for Google Chrome, follow these simple steps to get started:

Send Smarter Mail Merge Campaigns

This is what your Google Sheet should look like if you’re going to use it for a mail merge campaign with Gmass.

i. Make sure your spreadsheet is formatted correctly.

In order for mail merge software to read information from your database, your spreadsheet needs to be formatted correctly. When creating your spreadsheet, ensure the first row contains column names with no spaces or special characters.

One of the columns should contain email addresses. Your actual data should be in rows 2 and after.

formatted spreadsheet

You should see an icon that looks like a small grid to the right of your “Search Mail” bar. Click on it to start creating your mail merge campaign with Google Sheets.

ii. Select the spreadsheet you would like to use in Gmass.

Once you have your spreadsheet all set up, go to your Gmail inbox. You should notice a sheets icon near the search bar at the top of your inbox. Clicking on it will open a popup box that allows you to select any of your Google Sheets spreadsheets. Select your spreadsheet, and then click “Connect.”

spreadsheet you would like to use in Gmass

The popup that appears when you click on the spreadsheet icon allows you to connect a spreadsheet for your mail merge campaign.

iii. Create personalized mass emails.

In your message editing window, click on “Settings” to reveal personalization buttons based on the information in your spreadsheet.

Clicking these buttons will insert personalized information into your message. They work in the Subject line and the Body of your message.

Create personalized mass emails

User your email editing window to create and send an effective mail merge campaign with personalized messages.

iv. Send!

That’s it; your personalized mail merge campaign is ready to go! Press the “Gmass” button, and your job is done. Good work!


When you use G Suite and Gmass, it’s easier than ever to create personalized mass emails that truly capture your recipients' attention.

Professional software suites have been a key part of marketing workflows for decades. Today, G Suite is one of the most powerful suites of professional applications available.

Using the Google Chrome extension Gmass, you can take advantage of the G Suite application, Google Sheets, to make mail merge easier than ever before.

Sawaram Suthar (Sam) is a Founding Director at Middleware. He has extensive experience in marketing, team building and operations. He often seeing working on various GTM practices and implement best one to generate more demand. He is also founded a digital marketing blog - TheNextScoop.

7 Best Tips to Create Engaging Business Presentations

Remember those classes in college or university where you...

5 mins read

6 Ways To Stay At The Forefront Of Digital Marketing Knowledge

The online world is a fast-changing, never-slowing-down monster that...

5 mins read