If you want to send personalized bulk emails then Yet Another Mail Merge (YAMM) is a perfect Google Sheets extension for you. This mass emailer is perfect to send emails from Google Sheets.
To send bulk emails, you need to install Yet Another Mail Merge extension on Google Sheets. To install it, follow following steps.
Go to the YAMM page in Google Workspace Marketplace or from Google Sheet Extension then add-ons and then Get Add-ons.
Here is process of installing it from Google Market Place. Go to market place and search Yet Another Mail Merge then “Click Install”.
Then click on CONTINUE.
- A Sign in with Google window opens.
- Select for which Google account you want to install YAMM.
- Click Continue to sign in with your Google account.
Click Allow to accept the authorizations.
You are redirected to the Google Marketplace page.
Result
A pop-up window indicates that YAMM has been installed.
What’s next
Click Next and Complete additional setup now after the installation is complete.
You can now launch YAMM.
How to launch YAMM or start mail merge?
Once YAMM is installed on your account, you can start using YAMM.
- Once the installation is done, you can close the confirmation pop-up and click Done
- Create a new spreadsheet to start using YAMM.
- To launch YAMM, select Extensions > Yet Another Mail Merge: Mail Merge for Gmail > Start Mail Merge.
Prepare a contacts list in a Google sheet.
Fill out data for the recipients of your first mail merge.
Before sending mail merge we should always check email validity to make sure there and no spaces or special characters with IsEmail function.
Here is short a short video on checking email validity. One thing to note here, it’s email validation and not email deliverability checker.
Once you validated your emails. You can start your first mail merge. You can see a demo sheet in the following image.
How to create an email template in Gmail for Yet Another Mail Merge?
In the New Message window, compose the email template for your mail merge.
Draft the email by adding text and, optionally, images for extra appeal.
You can again personalize the email body with markers. For example, in the opening greeting line, use the {{First name}} and {{Last name}} markers.
Do not add any recipients in the To field.info Later when you start the mail merge, YAMM uses the email addresses from the Email column in the Google spreadsheet to automatically fill the To field as it sends an email to each recipient.
Add a subject in the Subject field.
In this example, you personalize the subject with a marker. By adding the {{First name}} marker, YAMM automatically replaces it during the mail merge with the first name of each recipient from the First name column in the Google spreadsheet.
To send your first mail merge with YAMM, you need to follow following steps.
Select Extensions > Yet Another Mail Merge: Mail Merge for Gmail > Start Mail Merge.
In Google Sheets, open the spreadsheet with the contacts list.
In the Start Mail Merge window, configure the mail merge.
- Note that YAMM correctly detects column A as the Email column.
Type the name from which you send the mail merge in the Sender Name text box.
Select the email template from the Email Template drop-down menu.
Click the Send emails button to send the mail merge to all recipients in the Google spreadsheet.
You can check the sent emails by opening the Sent folder in Gmail.
How to send a follow-up mail merge in Yet Another Mail Merge
Open your Google sheet.
Select Add-ons > Yet Another Mail Merge: Mail Merge for Gmail > Open tracking report.
Click the + button.
- The follow-up configuration appears.
- Select People who haven’t opened, In same sheet and In same threads.
Click Follow-up.
- The Start Mail Merge pop-up opens with the first mail merge’s configuration.
- Select an email draft from the Email Template drop-down menu which has the same subject line as the email draft from the initial mail merge.
- Click Send emails.
Once you know how to send mass personalized emails, you need a tracker with dashboard where you can see all your campaigns. I’ve created a tracker specially designed for Yet Another Mail Merge (YAMM) where you can see all campaigns result. You can track open rate, bounce rate, response rate, and number of emails sent in each campaign.
Let me give an overview of the Email Tracker.
The tracker consist following Sheets,
Dashboard Sheet
Dashboard tab is where you get a bird’s eye view of your campaigns. Here you can Manage all the campaigns and also track open, bounce, and response rate.
There are multiple columns in the dashboard. We are going to cover each and every column. Let’s start with campaign column.
Campaigns
On Dashboard tab we have campaign column. It’s linked to individual campaign sheets that are having emails and other details. You can jump on specific camp sheets by clicking on the link. We need to give hyper-link to respective campaigns for easy access.
The purpose of the column sheet is easy navigation and also track all of your campaigns on sheet and have a birds eye view about what’s happening with campaigns. Our next column is offers.
Offers
The offer column having unique campaign names so you can test various verticals and angles. You can have duplicate offers. To see all specific offers you can apply filter and analyze you campaigns. You can test multiple offers and by analysis various offers you can strategize your next actions.
Our next column is Email Used.
Email Used
when it comes to sending cold emails or sending emails to your email list. You need to use different emails. You can also have many emails for various purposes for example [email protected] can be specifically for sending newsletters.
You can manage number of emails sent by each email. It will help you avoid emails bans.
Schedule section.
First email date along with first, second, third, and fourth follow-ups under schedule.
In the schedule section we have our first email dates and follow-ups. Follow-ups are scheduled by 3 days intervals with formula. All follow-up dates that are having formulas are highlighted in different color so you can send follow-ups on respective dates and make the date static by copy (ctrl + c) and pasting (ctril + shift + v) values only. when you send an email campaign you need to make the formula entry by copy and pasting only values with paste special.
Based on highlighted cells you can decide which would be your next mail merge campaign.
Follow Ups Section
Later we have tracker where we can see percentage of status. EMAIL_SENT EMAIL_OPENED BOUNCED, and RESPONDED. here you can measure your campaign result.
This will answer how many of your emails are getting opened, bounced, and responded.
Similarly you can track your follow-ups.
This dashboard helps you manage all of your outreach or email marketing campaigns.
To get the Mail Merge for Gmail – Yet Another Mail Merge Tracker with Dashboard click here or checkout our template section.
Check out our other blogs.
