Send Personalized BULK Emails in Gmail (for FREE)!

[@adilzia897]

I dedicated 6 minutes and 49 seconds to this video, and trust me, it will now save me countless hours in my daily routine of sending emails with the same template to my clients. Thank you immensely; this is truly informative! My only question is whether there is a limit or quota on the number of emails that can be sent in one day. ?

[@JeffSu]

Limit is 100 a day

[@JMS98989]

Great video…cut and paste “recipients” to stop any typos 😂 (been their and Don that) ❤️

[@JeffSu]

Hahahaha for sure! Thanks for sharing James! 😁

[@JMS98989]

@@JeffSu it’s the word recipient….how many time can I spell than wrong! (Internally counting…about 40?)

[@clubvitafm1669]

Love your energy, Jeff! You've somehow "merged" humor and serious productivity together in a seamless fashion. Great work!

[@JeffSu]

Thank you!! I was going for that 😁😁

[@clubvitafm1669]

@@JeffSu Your humor is very well received, especially for such a serious subject matter. Looking forward to more content!

[@JeffSu]

@Dioney Luna You will need to check the link in the help center since the limit changes and yes of course! But I only use it with contacts I know :)

[@kayheath8446]

i agree! i'm guessing you might be from HK? but you don't have to say!

[@JeffSu]

@@kayheath8446 Yup I'm from HK :)

[@angelv1393]

Thank you! I am using Google contacts by saving importing their email. My last try was for 350 persons. Once their email was imported and set specific label, i just use it by typing the label in the TO select the label and all the emails are inserted. I will try this tip as you suggested, thanks. Nice video looking forward for more great videos from your channel. 👏

[@JeffSu]

Glad to hear it my friend! Let me know how it goes 😁

[@PreciousHouseFinderDavis-Owens]

So happy to have continued searching & found this video. Thanks sooo much! Clear, concise & FREE (no add-ons needed).

[@JeffSu]

No problem my friend 😁

[@anthonyfoxlive]

Your a great KZbinr and smart I love it here!!!!!

[@JeffSu]

You're welcome to stay as long as you like 😁

[@PriyanshuBharadwa]

Thank you so much Jeff 😃😃😃😃😃

[@JeffSu]

You're very welcome 😁😁

[@serenageorge5481]

Oh my goodness, I found Jeff yesterday and I feel like he is so helpful and sooo underrated. I am a student and his tips have been so helpful. Thanks!

[@JeffSu]

Welcome to the channel Serena! Glad to have you here! And happy to hear you're finding so much value from the content 😁

[@churchgrowthoutreach]

Great personality and positive energy my friend. Very helpful content. Thanks

[@JeffSu]

No problem 😁

[@herika006]

Watching this on a Friday night. Wonder if I can log this is in my timesheet as training 😁 thanks, this is great info, can’t wait to share it with my team

[@JeffSu]

I think every video I make can be logged as training... 😉. No but seriously thank you so much! Let me know what the team says 😁

[@colettepereira5353]

Thank you! This was very clear and helpful although did need Wesley Murray's additional help as mentioned in the comments.

[@JeffSu]

Glad to hear we're all helping each other out 😁

[@acballard]

I am a new subscriber fresh out of the car business and I wish I would have had this video much sooner. This could have helped me so much with my customer base and customer retention outside of the CRM tool that was provided for my dealership. As I go into business for myself this will definitely be of great help.

[@JeffSu]

Glad to hear it! You can always save this and use it down the line 😁

[@shazzansawyers]

I plan to use it in the dental office to remind patients about appointments

[@JeffSu]

Oh nice! That's a great use case :)

[@richmondtoolbank9195]

Tip from Enterprise user here. When sending mIl merge emails from our enterprise gmail accounts, we kept getting a Recipient error when adding {{Recipient}} to "To" field. But when we did not include anything in the "To" field, messages were sent without error. So basically, just leave the "to" feild empty. Not sure why, but it worls. Maybe give it a try if you run into a similar problem.

[@JeffSu]

Thank you so much for sharing this tip with others Richmond!

[@naomithefirstlady4531]

This worked magic!😂✨. THANK YOU. Although I had issues with the First name column, It just didn't reflect. But it's cool. I will tweak it again

[@JeffSu]

Check out the pinned comment for a solution Naomi 😁

[@SeanNyakutira]

i'm to be using this trick apply for hundred of jobs at once thank you jeff

[@JeffSu]

No problem! Best of luck 😁

[@labeldimpleraghanildr7161]

This is awesome!! Thanks a lot!! Saved me a lot of time in bulk sending emails to Hundreds of Clients 🥳

[@JeffSu]

Glad to hear it!

[@dominicchristopher1581]

Sir, your a wonderful teacher.

[@JeffSu]

Thank you 😁

[@ImprovementGang]

Another banger! This is actually pretty cool 😎

[@JeffSu]

It is! thank you 😁

[@inspireoneconsultants]

Hi Jeff how many people can you send the mail to at one go or in a day?

[@JeffSu]

Check out the help center article since it changes 😁

[@parthsalat]

Thanks! Now I'll be able to send a lot of cold emails for getting a job!

[@JeffSu]

Heck yea, good lock!

[@rulesofthesuccess5003]

Really helpful thanks man

[@JeffSu]

You're very welcome 😁

[@SetuRaval-d4g]

This is wonderful - thank you! How do you edit how your "Sender Name" appears? Or which email account the email is sent from?

[@JeffSu]

You can't for now

[@MoeketsiMasoeu]

Hey Jeff, Love your energy !!Great stuff, trying this out and looks like using the curly brackets in the email body doesn't work.

[@VietNguyenAUS]

I'm doing this tutorial in April 2022 - step by step - but the First name and Vertical in the email body didn't pick up, what could be the issue? I'm sure I followed the exact steps demonstrated above :)

[@JeffSu]

Try pasting without formatting 😁

[@VietNguyenAUS]

@@JeffSu forgot to reply, yes it works thanks Jeff ;)

[@JeffSu]

@@VietNguyenAUS hahaha one year later, glad to see you back though 😛

[@lisandrariveraramos5889]

Excellent!! Thanks so much!

[@JeffSu]

You're very welcome!!

[@ciarancronin1575]

Exactly what i was looking for, 'like' truly earned!

[@JeffSu]

Glad to hear it Ciaran! Thank you very much 😁

[@vikram.deoraa]

Hi Jeff, awesome technique. Thanks for the video, But when recipient receives our email instead of our name our email id shown in their inbox. Am I doing something wrong 😃? 🙌

[@JeffSu]

What do you mean email ID?

[@mukundmadhav5222]

Hi Jeff, thank you for the video. Could you please tell maximum how many bulk emails we can send using this?

[@JeffSu]

Check out the help center in the description since it changes I think

[@sonyaroberts6003]

I am getting an error message "Can not find gmail draft" do you know what I might be doing wrong? Great video by the way.

[@ayeshiaroberson5519]

Thank you super helpful info!

[@JeffSu]

You're very welcome Ayeshia 😁

[@leojo3518]

Love the bright personality :)

[@JeffSu]

Thanks Leo! It's because I know there are amazing viewers such as yourself out there 😁

[@Viswaskhatri]

Great Video, jeff!

[@JeffSu]

Thank yo u😁

[@waspbulgasari4498]

Hey Jeff, thank you very much. You are a really big help to me.

[@JeffSu]

You're very welcome my friend 😁

[@atikahauliaputri6677]

This is exactly what I need. Thank you for making this video!

[@JeffSu]

No problem!

[@akashagarwal3266]

bro just love and love for you thanks

[@JeffSu]

You're welcome 😁

[@supriyochowdhury8553]

Love it man!!!

[@JeffSu]

Thank you Supriyo 😁

[@vernabuen5651]

Thank you so much for this very helpful video! Cheers!!!

[@JeffSu]

You're very welcome!

[@angelamunega1915]

Great content. Thank you very much

[@JeffSu]

You're very welcome 😁

[@yaser1081]

excellent stuff. Just tested it and worked really well - Whats the maximum no. of emails you can send in a day using this method?

[@JeffSu]

Thanks Yaser! Check out the help center link in the description because I found it to change 😁

[@laibazaman-lz3ob]

Mannnn!!!!! This is life saver honestly 🎉🎉🎉

[@abdul-rehmanbutt1348]

I have a question, is there any way to track your emails too by sending through this method? Btw, thanks for your helping content.

[@JeffSu]

Not that I know of unfortunately Abdul 😅

[@freshcleanair]

Great tool, but when merging Gmail/sheets mail merge, I can not get the FIRST NAME to appear after following the first example to a tee.

[@GokulBhatia-ub8nb]

Same

[@gaurav4u786]

Thanks for Gmail video but Could you please make video on "How to mass reply to all or multiple emails at once in Outlook"

[@JeffSu]

Why would you mass reply to emails?

[@ImoimionImoukhuede]

Thanks! Saved me a ton of time.

[@JeffSu]

No problem 😁

[@keriomajene8257]

Damn Jeff, you're a life saver and a hero, God bless the hell out of you 🙏

[@JeffSu]

You're very welcome Keri 😁

[@ThatsBrilliantWithPC]

This is great and will be helpful in sending donation receipts or event details for non-profits donors and volunteers.

[@JeffSu]

Awesome! Thanks for letting me know how you'll use this. What a great cause!

[@massivemotivation]

Great video btw and please tell what is the limit of send email through this process...

[@JeffSu]

100

[@PasqualeBombino]

Thank you, Jeff. You make learning fun

[@JeffSu]

That's what I LOVE to hear!

[@TheArtofUnlearning]

This is going to save me so much time! Thank you

[@JeffSu]

Glad to hear it Stefania 😁

[@innovativephotographybyeve3464]

I bet working with you is a lot fun! You can never be boringness. Loved your positively and happy way to teach! You speak very fast, haha, hard for Português Brasilian to understand 😹! Great job sharing your experience

[@JeffSu]

Hahaha I think half my colleagues love me and the rest hate me because I'm so anal about stuff 😂, but thank you!

[@gonzo3333]

Wow this is great. Is it safe though? Are the emails I send shared with anyone or their recipients? Also, can you add an attachment (pdf) to these mails? Awesome content. Your channel rocks.

[@JeffSu]

Should be safe enough! Don't think attachments work though!

[@mikethechap]

Thanks!

[@JeffSu]

Thank YOU Michael! 😁

[@ksmith1964]

I think this will be helpful the next time I have to send out requests for quotes to multiple contractors. Hopefully! 🤞🙏🏻

[@JeffSu]

Let me know how it goes!

[@DanishKareem01]

This is the exact thing i have been looking for Thanks

[@JeffSu]

Nice!!

[@CessTee]

Really helpful! Thanks much for this! Subscribed 💯

[@JeffSu]

You're very welcome Cess! Welcome 👏🏻

[@rjmcgowan]

Asking for the like at the end got the like. Well played sir..

[@JeffSu]

Thank you sir 😉

[@AM-pc3yd]

Your video was very informative. How do you tackle multiple Gmail emails that land in spam when they are sent out at the exact same time. Is there something that you can do to mimic an actual person sending out emails, for example one to 5 emails per hour... Or something close to that? Thank you.

[@JeffSu]

Ah I only use this to send emails to my contacts so I don't have the spam problem...

[@AM-pc3yd]

@@JeffSu thank you for taking the time to answer

[@mikinpin]

Big thanks mate

[@JeffSu]

You're very welcome!!

[@mint5601]

Really good Video Jeff, Thanks a lot! I have to say though code seems bit temperamental, my be it's my set up but interested to hear if others are having same issues - missing some of the info. when doing the mail merge, unless you type a whole new email template each time. Also, you definitely have to clear the Email sent column.

[@JeffSu]

Oh that's a weird issue. Could you expand?

[@amyjopson1643]

@@JeffSu This is a great video! I'm trying to include the first name of clients so I did a copy and paste of that field from the spreadsheet but it's not adding it. What am I doing wrong? Also, if I want to create a new list, do I just copy the spreadsheet?

[@JeffSu]

@@amyjopson1643 Try refreshing the page, and no you need to make a copy of the original Google Workspace link

[@amyjopson1643]

@@JeffSu Thank you for the quick reply. It is still not working. I can add the recipients just fine and anything in the subject line, but when I try to add to the body of the email it does not work. I tried refreshing the page. I tried pasting the body as plain text. When it copies from the spreadsheet, it is bolded and adds a space after the {{ so I tried both leaving that space and removing it, also leaving it bolded and not bolded. I don't know what else to do. Any more suggestions?

[@TotalFiit1]

Brilliant video, so easy to explain thank you!

[@JeffSu]

You're very welcome 😁

[@thatgirlsharmaine]

Oooh I'm a little bit late to the party but here's me commenting before I proceed watching the rest of the video: I plan to easily send out responses to our recruitment candidates that sent in their applications through email.

[@JeffSu]

That's a great use case! Thanks for sharing Sharmaine!

[@jordanmillhausen]

Is there a limit to the amount of emails sent? Is it possible to get flagged for spam? Great content!

[@anousheypuri6542]

This is great!! How do I change the sender email? I have an additional email address added onto my Gmail account and I'd like to send emails through that one. I even selected the additional email as the default email from "send mail as" section from the Gmail settings in "Accounts and Imports," but it keeps sending emails through my main Gmail email address. Thanks

[@JeffSu]

Unfortunately you can't for now!

[@GregoryTrinh]

Sweeeet Jeff!

[@JeffSu]

thankkkk you!!

[@MattPriceDrumming]

Thank you this is great! Can you run in to problems with emails ending up in spam folders if you are sending cold emails using this strategy? Is it better to only send a few at a time to avoid emails ending up in SPAM?

[@JeffSu]

I only send this to contacts I know!

[@Bamdile]

Hi Jeff, thank you for this example of email merge. I don't understand (I did copy & paste) why the sent email is not inserting the first and last name. Everything else is fine 🤔. Any ideas⁉

[@JeffSu]

You have to copy paste the content within the cell instead of the cell itself. Check the comments for answers as well 😁

[@Bamdile]

Thank you so very much Jeff for your help. All's good now and you have picked up another subscriber ❣

[@jyotid.rautela2826]

super cooooool Thanks loved it

[@JeffSu]

Glad to hear it 😁

[@AgniRaghav]

the best thing that ever happened to me

[@JeffSu]

Yay 😁

[@arvidgansauer6257]

Excelent video! I always wonder how you come across all those amazing hacks. PS: Do you use an email signatur and if yes do you have some tipps on that? And what chrome extentions do you use and enjoy?

[@JeffSu]

A mixture of trial and error and curiosity I think! re: Email signature I just use some free gmail email signature generators online actually! You can google for some 😁

[@jessejames4444]

Magic..... Thank you!

[@JeffSu]

You're welcome! 😁

[@satviksingh3184]

Very cool, but how do i send e-mails at specific time? Can't i put send 10 emails every 1 hour or something?

[@JeffSu]

Not using this free method no

[@Jill_Liu]

Hi Jeff thanks for your sharing i sent a bulk of email with this method with a link a google form (which is a questionare) and a google drive sharing link. However seems does not reach the recipient, since i did not receive any answered questionare. It is really wired. i sent out 40 emails. None of them sent me feedback. please kindly instruct me. many thanks.

[@JeffSu]

Did you send a test email to yourself?

[@galbeeri6258]

Thanks so much, Jeff this is a really helpful one! 💪😁

[@JeffSu]

So the others aren't that helpful? 😭

[@galbeeri6258]

@@JeffSu They are all brilliant! Thanks so much

[@JeffSu]

@@galbeeri6258 Hahaha thank youuuuu

[@yannickpeeters362]

Hi jeff, nice video. can you change the "from" email?

[@JeffSu]

Not without changing the script!

[@jpyepez]

Hi Jeff! Thank you so much for all of your amazing content. Quick question: I need to email a bunch of contacts that have an assistant or an extra person at the office that I want to CC on the email to the person on that "Row". I tried creating a new column on the Google Sheet named "CC" and I added the contact email for the extra person I want to Cc'ed within the company on that row and then I went to Gmail and on the CC section I wrote {{cc}} but the emails that column on Sheets never received the email. What am I doing wrong? Thank you so much!

[@JeffSu]

I don't think cc works for mail merge :(

[@jpyepez]

What a pity. Thanks anyway!@@JeffSu

[@improvementTime10.3.17]

2:05 {{Recipient}} in gmail 'send to 2:41 press mail merge button first to authorize 3:27 copy email subject into excel to send

[@dfxdfx5368]

Oh, now I know what the kid from "Indiana Jones and the temple of doom" ended up doing as an adult.

[@JeffSu]

Oh please, I'm much better looking 😏

[@venusclover353]

Please note that this does not seem to work for the CC-ing of other emails in the origin email, so it will not work if you try to include your boss and someone else in the emails, which definitely did not score me points when I found that out the hard way after sending company emails out.

[@JeffSu]

Yea doesn't work for cc's

[@raulmagdaleno3923]

Greetings, any help would be greatly appreciated. I am able to send the emails in bulk but the emails have the headers ({{Last Name}} and {{Description}} appear instead of the actually wording. Any help would be greatly appreciated as this is a game changer.

[@JeffSu]

You have to double click into the cell and copy paste the words exactly :)

[@Arthousedallas]

Great video, super helpful! Question: When I use the script, it sends my email as my name, all lower case, which isn't great grammar-wise. Any tips on how to fix this? When I send regular emails this isn't a problem.

[@nikitamorozovs4129]

thank you!

[@JeffSu]

You're very welcome 😁

[@fiftyshadesofgore]

Thank you

[@JeffSu]

You're welcome!

[@pbieter]

Any idea on how to send an email from a different emailaddress registered in your account?

[@JeffSu]

That's not possible right now unfortunately :(

[@vincentguilleramores4431]

Good day, Jeff! Great content as always. I am wondering if this tool can also be used in sending unique attachments to each individual email address and how to do it? Thanks!

[@JeffSu]

I honestly don't know but I know it's possible. You'd need to update the App Script

[@MayoodPiano]

Did you figure out how to do it?

[@ghentertainmentchannel2312]

Hello, is it possible to use SMTP? Also can you add delay per message? Looking forward to a response. You have earned yourself a subscriber,

[@RPAOLO1967]

May God bless you, good man!

[@JeffSu]

Thank you so much 😁

[@dalek7804]

Is there a way to import all gmail contacts to the spreadsheet without manually entering each contact separately?

[@JeffSu]

Export from Google contacts

[@elaijamayo]

The {{First name}} isn’t showing in the email with the recipient’s name. 😪

[@kabisolutions]

samee

[@breakingxmyxheart]

Are you still able to do this if you have to include an attachment in the email? This would’ve been super helpful the other day when I spent 5 hours sending out over 120 personalized emails 😭

[@rajraj-w9u7f]

Hi, I found this video very informative & useful. Thanks a lot! Had a small query , While sending emails, I get this error message after 100 emails per day that the service invoked too many times. Is there a fix for this?

[@DILPREETSINGH-tq3if]

Hi Jeff, Thank you for sharing this Mass mailing method Using this method I could not sent more than 100 Emails. Is there any way to send more than 100 Emails at once.

[@JeffSu]

You will probably need to use a service like Mailchimp!

[@djvibedjservices]

Are there any limitations on how many recipients you can send to at a time?

[@JeffSu]

You might need to check the help center linked in the description since the limit changes I believe

[@anissuryanabintinasir7009]

You saved my life thank you

[@JeffSu]

Glad to hear it 😁

[@sylviadelcarmengonzalezmej199]

I am following every steps and everything woks except for the emojis. I have emojis all over my subject lines and email body, so how do I manage to paste everything with the emojis so they paste as well? Thanks

[@JeffSu]

Unfortunately Emojis aren't supported right now

[@brennonhall4203]

Great video! thank you :) ! Any idea on a way to then track if and when recipient emails back, and then have that time stamp added into excel spread sheet in separate column 🤔?

[@JeffSu]

That....I don't know 😅

[@brennonhall4203]

@@JeffSu ok thanks!! Lol

[@ianmarohombsar4140]

Subscribed! Love you bro!

[@JeffSu]

Thank you 😁

[@heavenlygirlly]

Hi jeff. Can i delete the date and unique id? Because i only have to send emails to companies specific people.

[@JeffSu]

Yes you can 😁

[@ssenkungusamuel7232]

Love this great tip. Can I use this to send 5000 emails at a go?

[@JeffSu]

You're limited to 100 a day

[@TheUbeIceCream]

Hey Jeff, I am having trouble with the link to the spreadsheet. It says page is not found?

[@JeffSu]

Try using incognito window