How Do I Merge Gmail Mail – Steps To Gmail Mail Merge With Google Sheets
This can be referred to as bulk emailing or mass emailing, it lets you send emails in mass. There are lots of email services that offer this feature, but the one offered by Gmail is by far one of the best. Imagine being tasked with the job of sending over 500 emails to over 500 persons individually? Of course, this is going to take like forever, right? What if you get to know or learn of a better means of doing and accomplishing your task? Yes! Everyone would want that. And this is what this article, Gmail email merge is all about. There is a feature embedded within the Gmail emailing tool that lets you personalize your emailing experience.
What is mail merge? It is simply a feature that lets you combine mail, letters, and pre-addressed envelopes for mass emailing from a template or form letter. It also gives you the ability to include other relevant and important documents and files to different addresses at a time. This file must be containing the recipient’s information such as email address, name, and other relevant details. This process is very effective in the sense that it will save you lots of valuable time as you won’t have to manually enter each of your recipient’s email ids.
The current Gmail email sending limit is 500. This means that you can send 500 emails per every 24 hours when sending emails from their web interface. You can either send 500 emails to a single account or to 5 different emails making it 100 each. But the Gmail email merge, the official limit is 100 recipients per every merge per day for free Gmail accounts. The limit is put in place to help keep the systems and accounts on the platform safe. If you pass this limit, it might lead to an account block.
When you exceed your limit per day, you will be notified. You can however receive messages and can also have access to other Google services. After the suspension period, the sending limits are automatically reset and the user can therefore resume sending emails. Limits are applied over every rolling 24 hours and are not subjected to a specific time of the day.
Mail merge with Google sheet is easy but only if you know how to go about it or you know what you are doing. The processes and steps can actually be complex if you are new to the whole thing.However, for better understanding, I will be briefing them out for you. The process consists of five different steps and they are;
Step #1 – Formatting Your Spreadsheet
In order for gmass to make use of your spreadsheet, it will need to be in plain text. In order to properly format your rows and columns on your spreadsheet;
The first row on your spreadsheet should contain the column names such as your email address, company name, first and last name, and other relevant names. Columns however should not contain special characters or spaces.
The main data should start from the second row.
The email addresses should be at least be contained in one column. Gmass will, therefore, auto-detect this column.
Step #2 – Logging In To Your Account.
You will do this by selecting the Google sheets icon next to the build email list button.
Step #3 – Connecting Gmass To Your Spreadsheet
Click on the sheets icon. A pop-up window will display your spreadsheets.
Select the sheet to import the details of your recipients.
Gmass will, therefore, connect to spreadsheet using a special spreadsheet ID that is unique to each sheet. A drop-down menu will show all the sheets that are shared with you or the ones that you own. However, if you do not see the one you need, know that your Gmail account does not have the necessary permission to access it.
Step #4 – Choosing Your Worksheet
If you have multiple sheets in your spreadsheet you will have to select the specific sheet you need to work with. If your spreadsheet on the other hand has only one worksheet, there will be no drop down menu. You will then need to click on the connect button. Gmass will then read the email addresses and other relevant data from your spreadsheet and then load the recipients in the ‘to’ field of a new compose window.
Step #5 – Personalizing Your Email
To access the personalization buttons, click on the settings arrow. Click on any of the buttons to insert personalization fields into the subject and also the body of your email messages before sending it. When adding a personalization tag in your email template, make sure that it matches with the column header of your spreadsheet.