we're gonna use a little known mail
merge method between gmail and google
sheets in order to send personalized
bulk emails in gmail
[Music]
hey friends i'm tasia custodian welcome
back to my youtube channel where i share
tech tips app reviews and so much gmail
content you might wonder if we're living
inside gmail right now
but today i'm showing you how to send
bulk emails in gmail so let's go
so if you have to send out mass emails
to clients or colleagues you could use
the bcc method where you just hide
everyone's emails from each other
but that's so basic henny
okay i'm sorry i'll never do that again
but you can actually send out
personalized bulk emails in gmail here's
how so the first thing we need to do is
head to this google workspace for
developers page which i've linked to
down below for you and we're going to
scroll down to the try it section
but before we hit make a copy you need
to make sure you have a google account
in order to do this which of course you
do
that's why you're here
anyway go ahead and click on make a copy
now this new google sheets page is going
to come up asking you if you'd like to
make a copy of the document which we do
so click on make a copy again
now here we are in our mail merge
spreadsheet so this is your own sheet
now since you made a copy so you can
title it whatever you want like maybe
you want to do this based on campaign
you could change that
and you can customize any of these
headers and columns except for the
recipient and the email sent columns so
the recipient column is where we're
going to put in the email addresses of
the recipients we're going to send the
email to
and then the email sent column is going
to give us a sent confirmation once the
email is actually sent out
so let's use the magic of editing to
fill out our spreadsheet according to
our needs
bing just like that here is our filled
out spreadsheet where we have first and
last names emails and the verticals the
recipients fall under and even unique
customer ids remember we can change or
remove any of these except for the
recipient and email sent so maybe you
want to change the vertical to a date
field because maybe this is going to be
for an upcoming event so you could
simply change this entire column to
reflect that
so once you're all set in your google
sheet we're going to head on over to our
gmail now you're going to proceed as
usual in gmail by composing the email
you want to send in bulk and once you
have that all done
in the to field of the email we're going
to put in two left curly brackets
then we're gonna head back to our mail
merge sheet and copy the recipient
header cell so just select the header
cell and then hit command c or control c
then let's head back to our gmail
and paste that in the to field right
after our left curly brackets
then let's close this out with two right
curly brackets
now notice there are no spaces anywhere
here in the to field
so what these curly brackets do is
personalize the bulk email for you so
anything within the curly brackets will
be specified or unique if you will
so we want to use these curly brackets
for our two field because over here on
the mail merge sheet we want to send to
these specific email addresses so each
one individually so the curly brackets
indicate we want to send each one
individually am i making sense okay good
because if you're following we can apply
this same theory for
other uses in our bulk email
okay so as an example in the subject
field we can add them to our subject so
remember how we've got a vertical listed
in the sheet well maybe we want to
specify that vertical in the subject so
instead of what you must know now in
order to grow
we could say something like what you
must know now in order to grow your
and then add our two left curly brackets
add the vertical
and then close that with our right curly
brackets and i'll just add the word
business so this is going to be replaced
with their individual assigned vertical
then we'll do the same thing for their
names in the body of the email
so
hey
curly bracket curly bracket first name
then two more curly brackets and
remember this is an exact copy of the
header
in the google sheet with caps and space
and all so if you've changed your header
you want to copy that exact header and
paste it
right between your curly brackets so
like i said you can apply this method to
anywhere in the body of the email too so
if you wanted to mention the vertical
again or the cid number or whatever
other header you have you can do that
here
so now we actually want to send the
email out
so we'll head back to our sheet
and click on the mail merge option at
the top then click on send emails now in
this pop-up you're going to have to
authorize this action so just press
continue
choose your google account and then you
might get this scary-looking pop-up that
says the app isn't verified but you can
rest assured that this is safe we got
this from the google workspace for
developers page so click on advanced
scroll down a bit select the go to gmail
sheets mail merge option
and then just click allow now before we
actually send the bulk emails i would
encourage you to do these exact steps
but test it by sending it to yourself
and a friend or another account that you
have just so you can make sure
everything is correct so i'm going to
assume you've done that and you're
comfortable moving forward with the bulk
email send so now let's head back to
gmail
we're going to copy the subject line
using command c or control c
then back in our sheet let's head back
to that mail merge option
and click on send emails and now this
time we're going to paste in the subject
line of that gmail draft using command
or control v
then just hit ok
that's all there is to it before you
know it the email sent column is going
to populate with the date and time
stamps the email was sent at
okay so let's head over to one of the
emails that i sent this to and here we
go i've got a personalized email that
i've sent
in bulk now you can just duplicate this
every time you need to send a
personalized fault email i mean come on
it's a pretty good hack
so that's how to send bulk emails in
gmail did you find this video helpful
let everyone know in the comments below
as always thank you so much for watching
if you like this video well i want to
know so give it a like a share or leave
that comment below you can click right
about here to subscribe to my channel
and here and here for even more content
just like this it's good gmail content i
promise thanks so much for watching see
you next time
[Music]