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
A new window opens, and it goes directly to the Yet Another Mail Merge (YAMM) widget page for Google Suite. Please press “Install”.
Click “Continue” in the window that appears.
Next is the YAMM licensing that is enabled and taking some action with your data account.
Once you’ve added the YAMM to Google Sheets, go to Google Sheets and start creating a new spreadsheet.
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).
Then enter the exact list of email addresses and contact names in the worksheet according to the column header you created.
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.
When you’re done editing, close that window. Don’t worry, Gmail will automatically save draft email content.
Back in Google Sheets, click Add-ons and in turn choose Yet Another Mail Merge (YAMM)> Start Mail Merge (Start Mail Merge).
Wait a few seconds for YAMM to start up.
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
