1. Home
  2. Google Sheets
  3. Campaigns

New campaign

Mailmeteor is the #1 emailing platform for Google Sheets. Thanks to our easy to use extension, you can send email marketing campaigns right from your spreadsheets.

Let’s see how you can send emails with Mailmeteor inside Google Sheets:

  1. Install Mailmeteor for Google Sheets.
  2. Create a new spreadsheet in Google Sheets.
  3. Name your columns by adding headings on the first row of your spreadsheet.

    Each column represents a piece of information about your contacts. In the example below, we’ve added 4 columns: firstname, email, company, postscriptum.

    Create a new spreadsheet

    You can add as many columns as you want and pick any column header name you want. The only thing that matters is that you make sure these headers are placed on the first row.

    The data in each column can be used as a custom variable in your email. This means you can write a single email template and automatically transform it into a personalized message for each of your recipients.

  4. Fill your spreadsheet with your contact info.

    Fill in your spreadhseet with your contact data

    It’s fine if you leave some cells blank. Except in the “email” column. In the example below, some recipients will get a Post Scriptum, and others won’t.

  5. Now that your contact list is ready, you can open Mailmeteor by going to Extensions > Mailmeteor > New campaign.

    Open Mailmeteor in Google Sheets
  6. From there, you can compose your email from scratch, or select an existing template. The Mailmeteor text editor works exactly like Gmail. You can apply different formatting, insert links, create bullet lists and so on.
  1. Add a subject line to your email template.
  1. (Optional) Personalize your emails with variables.

Mailmeteor is able to pull the data from your spreadsheet using variables. To customize the content of your email, click the { } icon and select a variable.

Alternatively, you can type your variable as follows {{ variable }}. That’s the name of the column inside double curly brackets.

  1. Select the Sender in the From: field. Mailmeteor lets you send emails from another email account that you own. For example, if you have an Outlook account that you want to send emails from, you can use the Alias feature.
  1. Click Preview emails to make sure everything looks great. This handy feature lets you preview how your emails will look for each recipient before actually sending them.
  1. Ready to take off? Hit Send emails to launch your campaign — or schedule it to land at just the right moment 🚀

And that’s it. You’ve just sent your first email campaign from Mailmeteor’s Google Sheets add-on. Congrats! 🎉

Going further with Mailmeteor

Avoid spam & get better email results

When sending large email campaigns, it’s easy to accidentally trigger spam filters or receive a high number of complaints or unsubscribes from your recipients. In the long run, this can negatively impact your account’s reputation and lower your email deliverability.

Make sure to read our sending guidelines to learn how to properly structure your emails, avoid common spam triggers, and ensure that your emails are being sent to engaged and interested recipients.

Become a Pro at emailing

Mailmeteor is packed with advanced features designed to help you achieve better results, in less time. To browse all the possibilities we have to offer, visit the section below.

You’ll learn how to:

Discover Mailmeteor’s hidden features

Want to level up your emailing skills? Here are 5 handy Mailmeteor features that very few people actually know about ⤵️

  1. Send multiple campaigns in the same sheet
  2. Segment your mailing list to follow up or avoid re-sending emails to the same people
  3. Insert personalized links
  4. Insert HTML in your email (such as tables or CTA)
  5. Run A/B testing