Create a Newsletter from Google Sheets With Gmail Layouts and YAMM

November 14, 2022
Create a Newsletter from Google Sheets With Gmail Layouts and YAMM
Table of Contents
Table of Contents

Sending out a newsletter is a great way to keep your readers updated on what's new with your organization or business. But creating a newsletter can be time-consuming, especially if you're starting from scratch.

Google Workspace and YAMM can help you save time on every step of the newsletter process, from collecting subscribers to sending it out. This article will show you a step-by-step process of creating a newsletter from start to finish..

What you’ll need before creating your newsletter is:

  • A way to collect email addresses
  • A way to manage your contacts
  • Some branded templates
  • A way to send your newsletter
  • A way to track your open and click rates

Let’s get started!

How to collect email addresses

Before anything, you need to collect subscribers interested in receiving your newsletters. The most common way of doing this is with a dedicated subscription form. This form can be shared in different ways so those who want to hear from you can sign up to be a part of your email list.

So, how can you make your subscription form? For free, you could create your own Google Form that explains what information you’ll provide and allow interested individuals to fill out their contact information. There are multiple ways to share them, whether through a link or embedded on your website. You can even customize the theme to match your brand. Google makes it easy to market your business for very little cost.

How to manage your contacts

Once you collect contacts, you’ll need a way to manage them. How you organize your contacts is up to you, but the goal is to create a neat database of your newsletter subscribers. Luckily, if you’ve decided to collect subscribers using Google Forms, it’s easy to create a contact list. Each Google Form comes with a linked spreadsheet on Google Sheets, and any responses from your Google Form will be automatically filled out inside it.

How to create a branded template

You have your newsletter content and a contact list, and now it’s time to put together a newsletter template for you to fill out. This is where Gmail Layouts come in. If you have a Google Workspace account, you can take advantage of Layouts to create branded templates. Gmail has many Layouts to choose from, but there are two specifically for newsletters.

You can customize the template to your brand by clicking “Default styling” and choosing your preferences. Once you insert your layout, you can copy over your newsletter content, change images, and insert links.

Even though a newsletter is an eblast, that doesn’t mean it shouldn’t be personalized. While you’re filling out the newsletter, you’ll need to add markers so you can personalize your newsletter later, like {{First Name}} and {{Date}}.

When you’re satisfied, just save it to your “Drafts” folder!

How to send out your newsletter

Once your newsletter is created and saved in your Drafts, it’s time to plan how you’re going to send it out. You’ll need to figure out:

  • Who you’re going to send it to
  • How you’re going to send it out
  • When you’re going to send it

When it comes to that first question, it’s a matter of looking through your spreadsheet. You have all of your subscribers there, but that doesn’t mean that every subscriber is going to find this particular newsletter interesting. To make sure it’s relevant to who you’re sending it to, you might want to segment your list (i.e. split it up based on subscriber preferences).

So, how should you send out your newsletter? Since you’re already using Gmail and Google Sheets, the best way to do this is to use Yet Another Mail Merge. YAMM allows you to send mass personalized emails from Google Sheets. Once you start your mail merge on your contact sheet, you can select the newsletter draft you created earlier.

With YAMM, you can also schedule the time you’d like to send out your newsletter. This way you can fit it into your email communication schedule.

When configuring your mail merge, make sure to have email tracking turned on.

How to measure your newsletter’s success

You built your subscriber list, created your newsletter, and sent it out to them. Congratulations! However, your effort doesn’t stop there. It’s time to see if it was successful, meaning your subscribers opened it and engaged with it. But how can you know that?

Because you sent out your newsletter with YAMM, this is easy. After you send your mail merge, you’ll be able to see how they faired right in your spreadsheet. The Tracking Report will appear in the right sidebar of your Google Sheet, which gives you several helpful stats:

  • How many emails were delivered
  • How many emails were opened
  • How many clicked your link
  • How many responded to your email
  • How many emails bounced
  • How many unsubscribed from your emails

You can use these metrics to see how well it did and create better newsletters in the future. For example, if you want more click-throughs, you may want to use a button for your CTA rather than an in-text link.

Send out newsletters right from Gmail with YAMM

Sending out your newsletter doesn’t need to be a laborious process. You can see success with your newsletter with mostly just Google products.

Plus, when you want to send out mass emails, you can take advantage of everything Google has to offer with YAMM. The rich template options of Gmail make it easy to create beautiful, professional-looking newsletters that you can send out en masse with YAMM.Why not give it a try? Install YAMM today and see how much easier sending out your newsletter can be!

Great! Next, complete checkout for full access to The Yet Another Mail Merge Blog
Welcome back! You've successfully signed in
You've successfully subscribed to The Yet Another Mail Merge Blog
Success! Your account is fully activated, you now have access to all content
Success! Your billing info has been updated
Your billing was not updated