New campaign

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

Ready? Then let’s see how you can send emails with Mailmeteor inside Google Sheets:

Install Mailmeteor for Google Sheets.
Create a new spreadsheet in Google Sheets.
Name your columns by adding text 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.

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.

Already have a mailing list under another format? You can easily import an existing contact list (Excel file or CSV). To do so, go to File > Import in the Google Sheets menu. Then select your file.

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.

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

Next, create the email template that will serve as the basis for the mail merge sent with Mailmeteor. To do so, select Create a new template.

Compose your email. The Mailmeteor text editor works exactly like Gmail. You can apply different formatting, insert links, create bullet lists and so on.

Going further

You can design your template the way you want:

Add a subject line to your email template.

In case you’d like to add your email signature, you just have to paste it at the bottom of your template. If your signature contains images, make sure to read our guide on how to insert images, and test your email before sending the campaign to make sure everything looks good.

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 Insert variable and select a variable.

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

Insert personalized variables in Google Sheets

You can personalize every part of the email, from subject to content. Once you send your campaign, each variable will be replaced with your spreadsheet data.

Your personalized variables must match exactly the headers of your spreadsheet, including upper/lower cases. If there’s a mismatch, the variable will be left blank inside the final email copy.

Once you’re done, click Save template.

Pick a sender name. Add a name in the Sender name field. This is the name your recipients will see when they receive your email.

Going further

It’s possible to 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.

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.

As you can see, variables are replaced by the correct information from the spreadsheet

If your custom variables don’t work properly, it means that the corresponding cell in your spreadsheet is empty or doesn’t have the right formatting. Check our dedicated article to solve any problems you may encounter.

Ready to take off? Click on “Send emails” to launch your campaign 🚀

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

Sending may take a few seconds to several minutes depending on your spreadsheet size.
Check your campaign progress at any given time from the Mailmeteor Dashboard.
Did you make a mistake? You can cancel your campaign in just a few clicks from your Dashboard.
We recommend sending emails progressively with the Autopilot feature or by Scheduling your campaign.
Track your emails in real-time thanks to the tracking report to see who opened or clicked your emails.

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:

New campaign

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 ⤵️