How to send bulk emails in Gmail from Google Sheets

 154 total views


2021-03-28 12:28:46

Have you ever wondered how much time it takes you to send emails one by one to each contact? If your list is few people it will be quite fast, but if the list is up to hundreds, this is a pretty time consuming job.

However, this problem is not too difficult now as you can use Google Sheets to solve. Specifically, thanks to the Yet Another Mail Merge add-on for Google Sheets. Specific usage is as follows.

How to send bulk emails in Gmail from Google Sheets with Yet Another Mail Merge

How to bulk email in Gmail from Google Sheets - Photo 2.
How to bulk email in Gmail from Google Sheets - Image 3.

A new window opens, and it goes directly to the Yet Another Mail Merge (YAMM) widget page for Google Suite. Please press “Install”.

How to bulk email in Gmail from Google Sheets - Image 4.

Click “Continue” in the window that appears.

How to bulk email in Gmail from Google Sheets - Image 5.

Next is the YAMM licensing that is enabled and taking some action with your data account.

How to bulk email in Gmail from Google Sheets - Image 6.

Once you’ve added the YAMM to Google Sheets, go to Google Sheets and start creating a new spreadsheet.

How to bulk email in Gmail from Google Sheets - Image 7.

In the new sheet, enter a column header for you to import email contacts to. Simply enter, for example email address and name. Note that they must always be at row 01 (Row 1).

How to bulk email in Gmail from Google Sheets - Image 8.

Then enter the exact list of email addresses and contact names in the worksheet according to the column header you created.

How to bulk email in Gmail from Google Sheets - Image 9.

When you’re done creating your Google Sheets contact list, head over to Gmail and start composing a new email template. Inside {{First Name}} is the contact name of the email according to the worksheet you have set up above. And YAMM will automatically change it according to the email in the list.

How to bulk email in Gmail from Google Sheets - Image 10.

When you’re done editing, close that window. Don’t worry, Gmail will automatically save draft email content.

How to bulk email in Gmail from Google Sheets - Image 11.

Back in Google Sheets, click Add-ons and in turn choose Yet Another Mail Merge (YAMM)> Start Mail Merge (Start Mail Merge).

How to bulk email in Gmail from Google Sheets - Image 12.

Wait a few seconds for YAMM to start up.

How to bulk email in Gmail from Google Sheets - Image 13.

Now enter your name in the required box and select the contact list you just created above and send it.

Very simple, right?

#send #bulk #emails #Gmail #Google #Sheets

Related Posts

Leave a Reply

Your email address will not be published.

Close Bitnami banner
Bitnami