How to Mail Merge in Gmail | Send Bulk Emails on Google Sheets

In this video, I have explained how to Mail Merge in Gmail.

Sometimes, we need to send one email in Gmail to multiple people in one go. However, the email body should have some variants depending on the recipients. You can achieve this using Mail Merge.

There are a lot of add-ons and extensions for mail merge in Gmail. But I have explained the free method. This method is offered by Google itself.

For this, you need to copy a Google sheet on your Google account.

The copied Google sheet contains an Appscript, which connects with your Gmail account and sends the email with the data on the sheet.

To run the app script, you need to authorize some access. This is required because the script will connect with the Gmail account.

For the email body, create a draft with the fields you want; each field should be inside double curly brackets {{field}}.

You can have multiple drafts, this script will send the mail merge emails for the subject you provide when sending running it.

Timestamps:
0:00 Mail merge in Gmail
0:30 Copy Mail Merge Google Sheet
1:15 Assign column names on the Sheet
2:20 Create the email body
3:30 Authorize the app script
3:50 Send Mail merge emails
5:39 Subscribe to Technologiate

Subscribe to the channel:

Follow and engage on social media:

#mailmerge #gmail #googlesheets #bulkemail #emailmarketing #emailcampaigns #gmailtips #mailmerge #personalization #emailautomation

[ruchikasharmatiwari]

Hello! Many thanks for this tutorial. It is brief, accurate and bang-on.
I just have one question. I needed to add First names in the mail template and did add the column name with curly brackets but except the name showing up in the email, everything else worked.
Just wanted to understand what did I miss. Will appreciate your help and response, thanks.

[laiyungcheung]

Hi, thank you so much for your tutorial. I am using a domain email which already connected to gmail. May I ask that is this mail merge enable to send bulk emails which using the domain email as the "sender"? Because there seems no choice for the senders, but I need to send the emails by the domain email. thanks so much!

[Cloud]

how to schedule sending email? i want to send email by day and time?

[norhawidaazihanhamzah]

Thank you very much for the tutorial. Really saved my day.

[sparky]

Thanks this worked but why does some emails says serviced invoked where the category email sent is?

[eugenesintos]

Hi I tried adding Cc column but its not sending to the email on Cc column I created. Is there a script available with Cc functionality?

[Archai.]

the email which we write in the mail body, after sending email all the data i typed are becoming one paragraph
sapces are no there after sending the emails

[sumitrawat]

Hi,
I am using {{First name}} but it's not working and not working for other columns as well, Could you please tell me the possible reasons why it's not working in my case.

[supportleevents]

ONly recipent working in mail other thing i add but not working

[tashfiatabassum]

Thanks for sharing this video. It was helpful

[IbrahimThufail-dm]

i have question how keep in Cc in that is there any way??

[sugatmisra]

if i use {{ in body of mail its not working bro

[iHayri]

This is really a great tutorial, thanks for that. Unfortunately you can only send less than 100 emails per day and now I have to find something else to send the rest of my 650 emails.

[naseemashaik]

Its showing that failed to send email no recipient please suggest

[sriyanipremasiri]

how many emails can i send per day with this method?

[jankigupta]

Nice Explanation but Why emails are showing in spam section. please update me on this if you have any solution.