Connect with us


2 Easy Methods to Create a Mail Merge for Gmail




Author profile picture

@frenchcoocCorentin Brossault

Developer Advocate at

There are 2 ways to mail merge in Gmail. You can either use a Google add-on that will do the job for you or build your own mail merge script in Gmail.

We’ll cover both methods in this guide. Even though we recommend using software built for that purpose which cover most issues and will probably save you time.

Method 1:
Building a Merge in Gmail Using Google Apps Scripts

As a developer, it’s a good challenge to try to build your own Gmail mail merge without an add-on. And thankfully we’re going to use Google
Apps Script, which makes it really easy to create Google add-ons.

Google Developer Advocates have already released a great script to help us move forward with the code. Here is the latest version of the open-source code hosted on GitHub written by Martin Hawksey – @mhawksey.

We gonna look at it step-by-step:

1. Create a copy of the sample mail merge spreadsheet:

Open this demonstration spreadsheet and click on “Make a copy” to get your own copy.

2. In your new spreadsheet:

Click on Tools > Script editor to open Google Apps Script. From there, you will see that a script is already tied to your spreadsheet. That’s because you’ve made a copy of the previous spreadsheet!

In the script editor, you can update the code as you wish. Changes will be reflected immediately.

Back to copied spreadsheet, update the “Recipients” column with email addresses you would like to use in the mail merge. Replace the cells’ value under the “Recipients” column with your own email address for example.

3. Now, open Gmail to create a new draft email:

You can use personalized variables, like

{{ firstname }}

which correspond to column names of the spreadsheet you just copied. This indicates text you’d like to be replaced with data from the copied spreadsheet.

4. Back in the copied spreadsheet, click on the custom menu item called “Mail Merge” and then click on “Send Emails”:

This item menu was created by the Apps Script project and will start the mail merge process.

5. A dialog box appears for authorization. Read the authorization notice and continue:

Important note: The script we are using has been created and proofread by Google Apps Script teams. Always be super careful when authorizing scripts and third-party apps in general.

When prompted enter or copy-paste the subject line used in your draft Gmail message. Then click OK.

6. Sending your emails:

You will see that the “Email Sent” column will update with the message status. Back in Gmail, check your Sent folder and review the emails the program just sent for you!

Keep in mind that using a script is at your own risk. Check Gmail’s sending limit before sending large volumes of emails. Be especially aware that your account can get blocked by Gmail if your emailing activity seems unusual in the eyes of anti-spam filters.

For these reasons, we would recommend using a mail merge solution such as Mailmeteor. Mailmeteor deals with all these aspects for you and ensures that your privacy remains protected.

Method 2: Using a Mail Merge Add-On Like Mailmeteor

We’ll start with a real-life example to show you how to do a mail merge from Gmail using a Google Sheets add-on. In this example, we’re using Mailmeteor, the best rated Google mail merge add-on.

1. Get Mailmeteor

All you have to do is to install Mailmeteor from the Google Workspace Marketplace. The Worskpace Marketplace is a place where you can find all the apps compatible with your Google Suite. Mailmeteor is a tool that integrates with Gmail and Google Sheets to merge emails with Gmail.

2. Add contact in Google Sheets

Once Mailmeteor is installed, open a Google Sheets spreadsheet.

First of all, you will need to add recipients to a Google Sheets spreadsheet. This spreadsheet will be the place where you store your contact list. You will also be able to track your campaign metrics from there.

To create a mailing list you can either add your recipients manually or import contacts. To import contacts in Google Sheets, go to Menu > File > Import and select your Excel or .csv file.

Here’s a mail merge demo spreadsheet we’re going to use:

👉Link to mail merge demo spreadsheet

Note: When opening Mailmeteor for the first time, you will be guided through a quick onboarding tutorial. A demo spreadsheet like this one will be created for you.

Let’s breakdown how your spreadsheet should look like:

➤ Add column headers on the 1st row

Mailmeteor will pull the information from your spreadsheet to personalize your emails. Each column represents a personalized field. This field will be replaced in your email template.

In our example, we have 4 columns named: firstname, email, company, postscriptum.

Add as many columns as you want and pick any column header name you want. Make sure you have a column named “email”.

Fill the columns with your recipients’ information

Fill your spreadsheet with your recipients’ info. Ensure all email cells are filled with valid email addresses. Apart from the emails, you can leave some cells blank, that is fine! In the example below, some recipients will get a Post Scriptum whereas others won’t.

3. Open Mailmeteor from the Add-ons menu in Google Sheets

Once your contact list is ready, open Mailmeteor. To open Mailmeteor go to the menu and select Add-ons> Mailmeteor > Open Mailmeteor.

This is the Mailmeteor interface. It tells you how many emails you can send per day and details related to your campaign. Next, we are going to compose the template that will be used for the mail merge.

4. Compose a new email template

Click on the “Create new template” button. This will open an editor in which you can compose your email. The Mailmeteor editor is the exact same as Gmail, you will find all the actions you need to customize your email.

Now we’re going to personalize your email. Personalizing emails is important as it helps make your recipients feel unique when they receive your emails. Using personalization will also dramatically improve your opening rates – and thus the replies you will get.

5. Personalize your emails

A mail merge transforms a standard email template into a personalized email copy. It’s done by replacing variables fields within the template with the content from your spreadsheet.

To insert a variable it’s easy: add variables using double brackets like this

{{ firstname }}

. Here is a template you can copy-paste:

 Hello {{ firstname }}, I'm glad we could meet lately. As discussed, we are using a brand new mail merge solution called Mailmeteor. Mailmeteor lets you send hundreds of personalized emails, right from Gmail. I’d love to let you see some of the features to get your feedback. We want to ensure Mailmeteor would actually help you do your job better at {{ company }}. Would you have 10-15 minutes free to chat? (I promise to keep the time!). Let me know the time that suits you best.

When adding a variable, always make sure that it matches a header in your spreadsheet.

Once you are satisfied with your template, click the “Save” button.

6. Preview emails before sending

Mailmeteor offers a preview feature that is super helpful to review emails before sending. The preview mode gives you a glimpse of the actual output of your email once personalized for each recipient.

You can also send a test email to yourself. Testing your emails on several devices is a best practice. This will ensure your emails will display correctly in most situations.

7. Send your mail merge

Ready for take-off? It’s time to send your mailmerge campaign.

We know that sending your mail merge can be a bit daunting at first. No worries though, if you follow these steps, everything will be alright!

✨ That’s it! You are now ready to mail merge emails with Gmail using an add-on such as Mailmeteor ✨

Here’s a real-life example. Watch this teacher use Mailmeteor to mail merge emails to his students:

Your Turn!

That’s it for this guide to mail merge in Gmail. We hope you now
better understand this simple yet incredibly powerful tool called mail

This guide is part of an extended guide on Mail merge in Gmail (2021). If you want to learn much more, go check it out!

Previously published here.


Join Hacker Noon

Create your free account to unlock your custom reading experience.

Checkout PrimeXBT
Trade with the Official CFD Partners of AC Milan
The Easiest Way to Way To Trade Crypto.


What is an Action Refund Review?




You have been defrauded by a fraudulent broker. What are you going to do ? In this Action Refund review, we’ll explain everything to you.

A study by “Scamwatch”, with the help of the ACCC (Australian Competition & Consumer Commission), suggests that so far, in 2020, around 195,848 reports of all types of scams have been submitted, with a loss of approximately $ 150,838,567. This is insane!

A real company called “Action Refund” had the ambition to help victims internationally to recover their stolen capital from various crooks in the foreign exchange market. Their team is made up of knowledgeable service agents who have helped dozens of users and victims of scams across the world. In addition, Action Refund offers a free consultation over the phone with a professional case analyst. We suggest that you contact Action Refund as soon as possible.

When you are in the middle of the process of filing a refund claim with a complicated case, it is very important to have professional assistance on your side. If you’re curious about what the company’s collection service is all about, below is an interview with a fraud victim to understand what Action Refund did with their case:

Can you tell us how it all started? (Action Refund Review)

At the end of 2019, I came across an advertisement in my inbox approving that Bill Gates made a fortune from forex trading, so I thought “I’ll give it a shot” and left some of my details on the site of this company.

They assigned me an account manager named “Gary Silverson”. He was polite and appeared to be an expert, promising the world and more with future profits. He assured me that with his advice, my trading account could be multiplied by 10 in no time. I thought that was probably an overestimate, however, if the forex market is open to everyone it is very possible to increase my income and triple my investments, at least that’s what I got. has sold. I wanted to deposit around $ 750 to open an account so I followed his instructions.

Gary explained to me very briefly about the application they are using, omitting crucial details and saying “trust me, you don’t need this info, we need more repositories”. You could say that I was very naive.

That seems good to me…

Back then, I was making decent profits instantly. We had a few trading sessions together for two months. Over time, he started to take control of my account transactions and I followed his lead, not asking anything because I knew he wouldn’t respond correctly. A few days later, the agent reached out to me via WhatsApp regarding a new opportunity emerging due to the announcement of the US election. Gary offered me a zero risk plan so that we could increase my earnings. I confirmed it, and we did make a little more profit.

At the time, my account was showing a profit of $ 5,129 from my initial deposit. I wanted to request a withdrawal of $ 1000 and it was returned to me without a problem. I remember I was quite surprised. I thought to myself, “How could I not find this forex trading company before?”. A month passed, and I reconsidered depositing an additional $ 15,000. Then I got promoted for what the company calls “platinum membership”.

So you claim that you had no problem withdrawing funds from the trading account?

Not at all. As I mentioned, everything went well at first. Honestly, it looked like Gary was doing a good job.

Continue Reading


Vestle Review 2021 – CySEC Broker Or CySEC Scam?





Description: Can you be scammed by Vestle broker? Read our comprehensive Vestle review covering the most important information about the broker.

Whether you have or plan to have an account with this broker, this Vestle review is something you must read

Regulated by: CySEC
Headquarters Country: Cyprus
Foundation year: 2015
Platforms: Web trader
Instruments: FX, commodities, shares, indicies, crypto, ETFs

Is Vestle a legit broker?

Over the years, many clients had a terrible experience with CySEC regulated brokers. Therefore, we decided to check few things in our Vestle review. 

For a start, is Vestle regulation a real regulation or yet another attempt of a regulated company to have an off-sight brand. How the broker operates, and the odds that it will steal your money. Let’s start.

 Vestle Regulation and Security

Vestle is a brand owned by iCFD Limited, regulated by CySEC. The company was formerly known as iForex Ltd. Whenever the broker changes its name, there is a reason for that. And usually, the reason is hundreds of unsatisfied traders and bad reviews. 

When it comes to funds, allegedly, every payment method the company uses is supervised by another EU country. It seems that the broker just listed all the countries where payment providers are based.

What can you trade with a Vestle broker?

Vestle is a broker that provides a high range of trading assets. Clients can trade with currency pairs, commodities, indices, shares, cryptocurrencies, and ETFs. There are over 900 assets available.

All the trades are executed on the web trader of a broker called FXnet. This type of trading platform is always riskier than trading with MT4 or MT5. Every experienced trader prefers MetaTrader in the first place because of security reasons, but also because it has more features. Unfortunately, the broker does not have a Demo account, so we couldn’t test the web trader and decide if it’s good or bad. Besides the web trader, the broker also offers Vestle mobile, its own app for Android and iOS devices. 

When it comes to leverage, it’s limited by CySEC rules. The highest leverage is 1:30 for currency pairs.



Deposit and Withdrawal Methods

When we talk about funding the account, there are several methods available. The client can deposit using debit/credit card, wire transfer, and few E-wallets. For card deposits, funds are visible instantly, while for wire transfers and E-wallets takes up to 5 business days. The same methods are available for withdrawals; only it takes up to 10 business days for the money to appear on the client’s account.

As per our Vestle review, it seems that the broker has issues with double charging. Many clients of this company complained that they see the double transaction in their bank statement. 

When it comes to the deposit amount, Vestle keeps it hidden. Nowhere on the website, you cannot find the list of account types and deposits necessary. It seems that after you get a call from their support, they will evaluate your financial situation and require a certain amount of money from you.

The same thing can be said about commissions and fees the broker is charging. We were unable to find this list anywhere. This looks bad for the Vestle broker. As a CySEC regulated broker, it should be very transparent when it comes to money.

Conclusion about Vestle

Based on everything in our Vestle review, we can say next. The broker shows a low level of transparency about fees and costs. The trades are executed on the web trader, easy to manipulate and change market prices. Even though the company is in the CySEC register since 2015, on the website of Vestle, there is a claim that they are operating for over 15 years. Now, it opens two questions: were they working unregulated or misleading clients to believe they are joining a long-lasting company. Whatever the answer is, a broker should not be proud to publish it.

After saying all this, we will leave it to you to decide if Vestle is a good broker or yet another CySEC scam.

 Source : Plato

Continue Reading


New method of investment: Copy trading, or copy trading as it was originally called




These are busy days for those who have a certain level of savings in the economy. Because already sharp movements occur in the Turkish lira because of their very high rates of investment to translate the uncertainties in Turkey in recent times with a certain amount of savings. This enables people to turn to different investment methods.

If you are looking for a dynamic investment method and still do not know where to start, we will have a profitable suggestion for you. A type of investment, originally called “Forex copy trading”, and another name that can be translated as copy investment in Turkish is social investment. It can be a good entry-level choice for those who do not know exactly how and how to invest in investment vehicles.

The basic logic of copy trading is to imitate the investments of successful investors in the exchange you want to enter. It’s that simple. Anyway, the name of this investment concept is therefore determined as copy investment.

According to one of the studies conducted in recent years, this type of investment is increasingly taking up a place in the market. The copy investment market will reach an amount of € 70 billion by the end of 2025, according to researches.

To start copy trading, the first thing to do is to choose a reliable and profitable investment platform. At this point, the next step in choosing a reliable investment platform is  Forex Copy Trading

that is, to be able to follow reliable investors for copy investment. Therefore, the choice of platform is very important at this point.

A Close Look at Copy Investment

In short, it is important that copy investment or social investment platforms allow experienced investors to copy their investments directly. Here, when you find such an investment exchange, the investment made in this way is also called “auto investment” because you invest your own account directly into the account of the experienced investor.

You can invest in the form of copy investment in the BIST 100, crypto money exchanges and even foreign exchanges. It is a method that can be followed even for foreign currency deposits. However, it will require serious research at the stage of determining the investors you will follow in the first place.

How Exactly to Invest in Copy?

In fact, there are two popular ways to do this.

Following the Investors’ Strategies One to One

Whichever exchange you are investing in, you can learn the investments made by the really experienced names of that stock exchange with a good research and make these investments one by one.


Simple System: The investment you will make in this way will be a very simple and easy-to-use investment type. This is the reason why it is called auto investment as a type of investment that you can directly imitate the investments of expert investors in the field.

Flexibility: You can follow this type of investment from any digital device. It is a very flexible method as you will do the same no matter where you are, as soon as you hear about the direct investment of the person you follow, as there is no subject to think about.

Choosing a strategy is very easy: All you have to do is find the best in the field with the right research. Once you find it, it will be very easy to determine your strategy.

Transaction Fees: Most successful traders will charge you a certain fee to return their investments. These fee claims create an additional cost. However, you can manage your funds with the confidence that there will be no additional fees or expenses for the investment.

Let others follow your investment. For this, create an investment strategy.

Here you will be the one followed. Of course, this has certain advantages and disadvantages.

Your strategies will directly affect the market: Since you will be the person who will determine the strategy, whatever strategy you follow, the strategy you will follow will be a strategy that will affect the market completely.

You will also get the reward for your labor outside of profits: In this way, you will have to spend all your work on this work. However, you will get more than your followers for your efforts.

You will set the rules of the game: However, doing these operations will require both very serious experience and serious work.

Of course, it would be useful for you to carefully investigate whether there is a method to follow completely. However, it is possible to say that you can carry out such transactions with peace of mind with detailed analysis on the leading quality investment and stock exchange platforms such as AMarkets.



Continue Reading


Ethereum Price Smashed $2000, $3000 Incoming At Lightning Speed!




Ethereum Price (ETH) May Hit $10,000 This Cycle!

The Ethereum price that is known to maintain a stable price movement, finally broke the previous ATH to form a new one. It took more than a months time to regain its lost position above $2000, yet sustained successfully. 

Advertisement header-banner-ad

The price took more time than expected to break the $2000 barrier, yet $3000 may be approaching at rocket speed. As predicted by founder of Gokhstein Media, David Gokhstein, the next stop for the ETH price is around $3,900. 

With the continued bullish trend and intensified rally, the price is expected to surge to the highest levels. According to an analyst and Crypto Youtuber, Young and Investing, the Ethereum price may hit $10,000 within the current bull run.

With the accelerated bull run, many analysts believe Ethereum could lead the market instead of Bitcoin too. Therefore providing a huge opportunity for the altcoins to boom within the ETH bull rally. 

Is Altcoin-Season On the Cards?

Many altcoins normally pop-up with the surge in the price of the second dominant crypto Ethereum. Currently, ETH price is trading around its new all time high around $2152 and expected to fly high. Therefore, many small cap altcoins are expected to rise from ashes and pump more than 50x or even 100x also.

Many analysts believe the Altcoin Season of 2021 is on the way and is expected to be the greatest season ever. According to a popular analyst, XRPcryptowolf, the season will reach its peak during the summer.

Moreover, the coins which are believed to be dead or not performing are also expected to rise. One of the analysts, MC also has given a brief idea on which all coins might pump in the current AltSeason.

Collectively, the breakout of Ethereum price has led to initialization of the most awaited AltSeason of 2021. The ETH price rally is expected to intensify in the coming days, that might smash $10,000 soon.

Checkout PrimeXBT
Trade with the Official CFD Partners of AC Milan

Continue Reading
Esports2 days ago

Free Fire World Series APK Download for Android

Esports4 days ago

DreamHack Online Open Ft. Fortnite April Edition – How To Register, Format, Dates, Prize Pool & More

Esports4 days ago

Hikaru Nakamura drops chessbae, apologizes for YouTube strike

Esports2 days ago

Dota 2: Top Mid Heroes of Patch 7.29

Esports5 days ago

Coven and Abomination highlight the new TFT Reckoning Traits

Esports4 days ago

Apex Legends update 1.65 brings five new LTMs for War Games

Esports4 days ago

Ludwig Closes Out Month-Long Streaming Marathon in First Place – Weekly Twitch Top 10s, April 5-11

Esports3 days ago

Position 5 Faceless Void is making waves in North American Dota 2 pubs after patch 7.29

Blockchain5 days ago

Stock-to-Flow-Analyse: Bitcoin bei 288.000 USD

Esports4 days ago

Complete guide to romance and marriage in Stardew Valley

Esports4 days ago

Fortnite: Patch Notes v16.20 – Off-Road Vehicle Mods, 50-Player Creative Lobbies, Bug Fixes & More

Blockchain5 days ago

Welche Probleme bringen US-Bitcoin ETFs mit sich?

Blockchain4 days ago

Which crypto exchange platform is faster, coin transfer or Godex?

Esports4 days ago

TenZ on loan to Sentinels through Valorant Challengers Finals

Esports4 days ago

Wild Rift patch 2.2a brings tons of champion changes and the addition of Rammus later this month

Esports4 days ago

Epic Games Store lost $181 million & $273 million in 2019 and 2020

Esports3 days ago

Fortnite Leak Teases Aloy Skin From Horizon Zero Dawn

Esports2 days ago

Capcom Reveals Ransomware Hack Came from Old VPN

Esports4 days ago

flusha announces new CSGO roster featuring suNny and sergej

Blockchain4 days ago

Bitcoin Preis steigt auf über 60.000 USD, neues ATH wahrscheinlich