Send Personalized BULK Emails in Gmail (for FREE)!
My Premium Resume Package: jeffsu.gumroad.com/l/premium-...
🌟 Google Developer's Website: developers.google.com/workspa...
If you needed to send the same email to multiple people at once, how would you do it? In this video, I show you the best (and easiest) way to send personalized emails in gmail FOR FREE!
When I was in the sales team, I used to need to send mass communication emails to all my clients (I had over 200 of them to manage a quarter). Generic mass emails missed a personal touch so I decided to send customized and personalized emails by using a free Mail Merge script in Google Sheets.
This mail merge script created by Martin Hawksey connects a Google Sheet spreadsheet to your Gmail account and allows you to send customized emails in bulk!
So feel free to follow along for this quick and dirty mail merge tutorial involving Gmail and Google Sheets 😁
TIMESTAMPS
00:00 Mail Merge with Gmail and Google Sheets
00:20 Why Send Personalized Bulk Emails?
00:56 Copy Google's Mail Merge Template
01:37 Example 1 - Account Management
04:14 Example 2 - School Event
05:05 Example 3 - For Professionals at Work
05:50 Mail Merge Pro Tips
RESOURCES I MENTION IN THE VIDEO
Developers support page: developers.google.com/workspa...
Quota page: developers.google.com/apps-sc...
MY FAVORITE GEAR
🎥 My KZread Gear - geni.us/youtube-gear
🎒 What's In My Bag - geni.us/mybag
MY TOP 3 FAVORITE SOFTWARE
❎ CleanShot X - geni.us/cleanshotx
✍️ Skillshare - geni.us/skillshare-jeff
📖 Readwise - readwise.io/jeffsu/
BE MY FRIEND:
📧 Subscribe to my Productivity newsletter - www.jeffsu.org/productivity-p...
📸 Instagram - / j.sushie
🤝 LinkedIn - / jsu05
👨🏻💻 WHO AM I:
I'm Jeff, a full time Product Marketer. In my spare time I like to tinker with tools and create systems that help me get things done faster - or as one of my friends puts it: "Get better at being lazy" 😏
If you'd like to talk, I'd love to hear from you. Messaging me on Instagram (@j.sushie) directly will be the quickest way to get a response!
PS: Some of the links in this description are affiliate links I get a kickback from 😇
Disclaimer: My opinions are my own and may not reflect that of my employer
#gmail #sheets #mailmerge #thinkoutsidethebox
Пікірлер: 1 900
Love your energy, Jeff! You've somehow "merged" humor and serious productivity together in a seamless fashion. Great work!
@JeffSu
2 жыл бұрын
Thank you!! I was going for that 😁😁
@clubvitafm1669
2 жыл бұрын
@@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 :)
This video is very helpful. The Mail Merge will come in very handy, when I'm organizing fundraising events for our local Museum; communicating event details to participants, and other team members. Also the mail merge would be used in my small business to communicate promotions, events, and special offers. I've said it before - you are the best presenter on KZread when it comes to navigating Google apps, and features! Thanks again!
@JeffSu
2 жыл бұрын
Great to hear Marlene! Best of luck with the fundraising events!
My man, this is the 2nd video of yours I've run across in the last month. Really appreciate the detailed explanation and your great attitude! Thanks again!
@JeffSu
Жыл бұрын
And hopefully not the last video you'll come across Robert 😏. You're very welcome!!
Who wants to guess the number of times I said "curly brackets" in this video? 😵💫 TIMESTAMPS 00:00 Mail Merge with Gmail and Google Sheets 00:20 Why Send Personalized Bulk Emails? 00:56 Copy Google's Mail Merge Template 01:37 Example 1 - Account Management 04:14 Example 2 - School Event 05:05 Example 3 - For Professionals at Work 05:50 Mail Merge Pro Tips
@w.w.sakbeh571
2 жыл бұрын
Idk, but you got them into my subconscious so I’m gonna have dreams about ‘em 😳😱
@JeffSu
2 жыл бұрын
@@w.w.sakbeh571 good 😇
@adityaaman5820
2 жыл бұрын
How much email can i send via this method? I want to send thousands of Message in a single day Is it possible? How much gmail i need?
@MaxRuso
2 жыл бұрын
Tnx
@pingpong3153
2 жыл бұрын
Hey bro! Tutorial is good but first name is not working or visible in email
Hey Jeff, I'm seeing you are starting to incline to your student audience. Great job, continue the good work of giving us the knowledge to flaunt over to our friends 🙄😃
@JeffSu
2 жыл бұрын
Of course! I love my student audience 😁😁
Thank you Jeff! Found this online for sending our emails to leads for my business. Great video and much appreciated!
@JeffSu
2 жыл бұрын
Thank you my friend! You're very welcome 😁
So happy to have continued searching & found this video. Thanks sooo much! Clear, concise & FREE (no add-ons needed).
@JeffSu
Жыл бұрын
No problem my friend 😁
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
2 жыл бұрын
Glad to hear it! You can always save this and use it down the line 😁
This is one of my favorite videos. Jeff is incredibly cheerful!!! keep the good work and share the positive productivity to others
@JeffSu
2 жыл бұрын
Thank you Muhammad 😁😁
Your a great KZreadr and smart I love it here!!!!!
@JeffSu
2 жыл бұрын
You're welcome to stay as long as you like 😁
Used this mail merge for our event details to attendees. Was so efficient. Thank you so much!
@JeffSu
Жыл бұрын
Glad to hear it! 😁
This is golden! Always glad to watch new videos from Jeff!
@JeffSu
2 жыл бұрын
Thank you Andrey! Always glad to have you here watching them 😁
Great video…cut and paste “recipients” to stop any typos 😂 (been their and Don that) ❤️
@JeffSu
2 жыл бұрын
Hahahaha for sure! Thanks for sharing James! 😁
@JMS98989
2 жыл бұрын
@@JeffSu it’s the word recipient….how many time can I spell than wrong! (Internally counting…about 40?)
It was interesting to see how excel could be used to do bulk emails :o At my internship, I see Access being used to automatically generate emails though which blew my mind when I first saw it 😂 Thanks as always for the video Jeff and happy holidays if there’s no uploads next week! (I know it gets busy around this time of year)
@JeffSu
2 жыл бұрын
Interesting! So the company you work for uses Microsoft Suite of tools? How do you like it? Oh there definitely will be uploads next week 😁
@Andrea_Dong
2 жыл бұрын
I guess I like it? It just feels comforting since I’ve been using Office 365 throughout college 😂 They actually also use quite a few other ERP softwares which can get confusing, really makes me wish things were more streamlined. First thing I realized after starting this internship is the fact that you won’t always see the textbook example of a centralized system irl 😔 It would either be too complicated to implement or the costs of implementing outweighs the benefits and time savings. Have you come across a similar situation during your time at EY, Jeff?
@JeffSu
2 жыл бұрын
@@Andrea_Dong Haha yes we ran into similar issues while consulting for clients but it really depended on what the client wanted. If they wanted to pick 1 ERP system and stick with it, we'd find the best solution (or as close as possible) based on their needs and implement. And they would make a top-down decision to change their ways of doing things (i.e. the top boss would say this change is going to happen)
@Andrea_Dong
2 жыл бұрын
Interesting, so top-down is the dominant approach? :o in your opinion, would you say top-down is the best approach to system design/development or would bottom-up actually be more effective? I’m kinda conflicted on this topic since on one hand you wouldn’t want to stray too far from the overarching goal for a system (top-down) but on the other hand it could be more efficient if it suited the needs of the people who’ll actually be using it (bottom-up) 🤔 what are your thoughts on this?
I always learn something useful from your videos. Keep it up, Jeff! 👍🏻
@JeffSu
2 жыл бұрын
Super happy to hear that! Thank you my friend 😁
Thanks so much for this video! I actually managed to email nearly a hundred leads in just under 30 minutes because of Mail Merge! Looking forward to more of these!
@JeffSu
2 жыл бұрын
Woohooo congrats!
Great video Jeff. But do you have a tip for sending out customized pdfs attached to each specific mail? For example invoices or coupons?
@JeffSu
2 жыл бұрын
Hm...that's a bit more advanced but I think it's do-able with a more advanced Script 😂
@Himanshumehani
2 жыл бұрын
You can do that with Google apps script
Superb as always Jeff 👌 I'm familiar with mail merge on word but this is new to me , so thanks for the vid. It will be very helpful! Was it 7 times that you mentioned " curly brackets " 🤔?
@JeffSu
2 жыл бұрын
You're welcome!!! I think it's around 7 or 8 times 😂. I think I said "curly brackets" more in this one video than I have in my ENTIRE life
@lordsparky4020
2 жыл бұрын
@@JeffSu 🤣
This is pure gold! Your content is superb for any professional!
@JeffSu
2 жыл бұрын
Glad you think so João! Really appreciate it 😁
This seems to be the easiest way to do this 🙌 I knew people did it with code (there's a video about a guy who asked for flags of all the world and he did it that way), but I never thought of letting something else do the coding for you, lol. Thanks for the video!
@JeffSu
2 жыл бұрын
Yes the real hero here is Martin Hawksey!! You're very welcome!
So helpful Jeff! I’m planning on using this for a launch party at work. This will make email invites much easier. I know you didn’t create the template, but do you know if there’s a way to get feedback in a column if the email was opened?
@JeffSu
2 жыл бұрын
You might need to use a third-party Chrome extension for that!
@kayiriowuna2762
2 жыл бұрын
@@JeffSu hi Jeff, please what third party chrome extension do you approve of?
Am i the only one who saw Satya Nutella 🤔
@JeffSu
Жыл бұрын
Maybe 😏
man.. you are always able to get some really useful ideas for videos. Thankyou for this Jeff.
@JeffSu
2 жыл бұрын
I try my best! Thank you Shiromani 😁
Hi Jeff, I really liked the way you described and your expression was so cool. You merge the seriousness and happiness of creativity in a way.
@JeffSu
2 жыл бұрын
I'm glad to hear you say that Primon!!! That's what I'm going for 😁
I got so much out of your video, thank you. When I've filled in the subject line I have a message back saying - Error: Oops - can't find Gmail draft? and it doesn't give any help :( Can you help at all?
@viveksatam9559
22 күн бұрын
try coping the content to new email, change the subject line a bit and try again. u need to copy the subject line and paste in the mail merge box when it appears
Everything is working well except the name, CID is not visible in recipient mail
@JeffSu
3 ай бұрын
You might have made a typo
@timwatts7705
Ай бұрын
@@JeffSu Doesn't work for me either. Copied and pasted and name not visible in the body of the email.
This is extremely helpful! I've been looking for a simple yet efficient way to do this. Thank you! Keep on with the good content!
@JeffSu
2 жыл бұрын
Woohoo glad I'm able to share something you were actively looking to do! Did it work out well? 😁
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
2 жыл бұрын
Welcome to the channel Serena! Glad to have you here! And happy to hear you're finding so much value from the content 😁
Hey Man! I am in need for some help, I hope you might know the answer to my issue! So every time I sent out a mail merge, everything went well, except of the {{First Name}} integration. For some reason, it stays blank, whatever I do.. Has any of you encountered this problem before? If yes, please help! Thank you in advance for your responses!
@chrismeulbroek296
2 жыл бұрын
I have the exact same problem, I don't know what I did wrong. Have you fixed it yet?
@SeagramPearce
Жыл бұрын
Its because you need to check your capitalisation in the spreadsheet. It's actually {{First name}} (lower case n)
@makug
4 ай бұрын
@@SeagramPearce It was copy pasted to avoid issues...but there's issues? I see lower case n and it doesnt work
@yogeshshrivastava2600
4 ай бұрын
@@makug same happened with me anything in {{}} on email body was not taken from the sheet, have you got a fix?
@monalisaosei-mensah574
4 ай бұрын
Me too. I've tried severally. Can anyone help?@@yogeshshrivastava2600
i dont think this still works.
@JeffSu
3 ай бұрын
Why not?
@ambientsounds5832
3 ай бұрын
the mail merge tab isnt appearing on my google sheets. i found an alternative way however, so this video wasnt useless for me.@@JeffSu
@jaisanwtd4862
3 ай бұрын
@@ambientsounds5832what was the alternative method?
@GloryAdk
2 ай бұрын
@@JeffSu I followed the instructions. Only the recipient and email sent format worked, every other thing doesn't. In the Apps script, it only shows that the Recipient and Email Sent col was included. So in the end, only the emails are personalized, the body of the mail doesn't work. Could you look into this.
@GloryAdk
2 ай бұрын
I agree. Been trying this for over a week to no avail
Tremendous value. I can honestly say that this video has saved me a lot of time and money. Thank you!
@JeffSu
2 жыл бұрын
You're very welcome my friend 😁
Another Banger Jeff! Nice one
@JeffSu
2 жыл бұрын
Thank you my friend 😁😁
Brilliant! I am using this for a school reunion so the video has been extremely helpful. Your instructions work a treat. Thank you.
@JeffSu
4 ай бұрын
Woohoo glad to hear it 😁
Jeff Su, you are the man! Thank you so much. This video was so helpful, precise, and even funny at times. Bravo!
@JeffSu
Жыл бұрын
Dam. Only funny "at times"? 😏. Jk, thanks so much for the kind words!
That last statements in things people do wrong got me hahahahahha made me like the video too 👀
@JeffSu
Жыл бұрын
Hahahaha glad to hear it 😁
This is Gold! Thanks, Jeff!
@JeffSu
2 жыл бұрын
You're welcome Cotfas 😁
I needed this last week 😭
@JeffSu
2 жыл бұрын
It's okay, find another opportunity to send another round of bulk emails! haha
I love the way you spread positivity across the world's human vibes, Thanks a lot Jeff.
@JeffSu
2 жыл бұрын
You're very welcome! I'm happy to do it!
Thank you so much for this wonerful educational but cheerful tutorial. I was able to bring my mass email to a whole new level! :) I cannot but to be grateful. :)
@JeffSu
Жыл бұрын
Awesome! Let me know how it goes Rebecca 😁
Jeff's energy is amazing 😍
@JeffSu
Жыл бұрын
It's because I'm making videos for amazing viewers such as yourself 😁
i'm part of a student organization at my university & i'll be using this to send personalized emails to other organizations and hopefully secure better partnerships :D [context] i'm an external relations vp for my org and i've heard this term used a lot, but haven't had the opportunity to learn about it in-depth. was really glad to see it covered by one of my favorite productivity youtubers :D thanks for teaching me how to write & work better!
@JeffSu
Жыл бұрын
Nice! Loving how you are already using the "context' tip I talked about before. Thanks for sharing 😁
Another banger! This is actually pretty cool 😎
@JeffSu
2 жыл бұрын
It is! thank you 😁
It took me days to figure out what to do. It was pretty complicated, but I finally got it to work. Hooray!!!!
@JeffSu
Жыл бұрын
Awesome!! Congrats Dennis! 😁
This is life-changing! Thanks, Jeff!
@JeffSu
4 ай бұрын
No problem 😁
Thank you for the fantastic video. I went to a conference and wanted to send a follow-up email to everyone I connected with. The conference had an app for everyone to exchange emails. I exported the list and added them to the Mail Merge spreadsheet. I followed your directions, and everything came together fine. I'm sure I saved a ton a time and the mail merge made it seem like a personalized email. Thanks again for your tutorial. You're saving lives out here, lol!
@JeffSu
2 ай бұрын
Glad to hear about your use case!! 😁
@shikhatomar6617
8 күн бұрын
Hey can you help me with this. I tried to add {{First name}} but when I sent, names didn't appear in the mail.
This is awesome!! Thanks a lot!! Saved me a lot of time in bulk sending emails to Hundreds of Clients 🥳
@JeffSu
2 жыл бұрын
Glad to hear it!
This was just what I was looking for. Thank you!
@JeffSu
2 жыл бұрын
Glad to hear it! 😁
Mannnn!!!!! This is life saver honestly 🎉🎉🎉
THANK YOU! You saved me hours of manual work!
@JeffSu
6 ай бұрын
No problem 😁
Why would people forget to not like this video. Awesome stuff Jeff ! ❤️
@JeffSu
2 жыл бұрын
I know right?? 😁
Another great video Jeff!
@JeffSu
Жыл бұрын
Thanks my friend 😁
You just saved me so much money and unnecessary overthinking
@JeffSu
4 ай бұрын
No problem!
This is exactly what I need. Thank you for making this video!
@JeffSu
4 ай бұрын
No problem!
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
2 жыл бұрын
Glad to hear it my friend! Let me know how it goes 😁
Exactly what i was looking for, 'like' truly earned!
@JeffSu
2 жыл бұрын
Glad to hear it Ciaran! Thank you very much 😁
Amazing!! Perfect time I see this as about to do a bulk client holiday promo email for my web design biz!
@JeffSu
2 жыл бұрын
Awesome! Best of luck!!
This is very helpful. Not new to sending emails, but new to sending them this way with mail merge. I'm currently using this to promote events and workshops within my business.
@JeffSu
Жыл бұрын
That's awesome, and how has the results been so far?
@writingvisions
Жыл бұрын
@@JeffSu I sent my first round of emails. I got the email date when it was sent (the time showed on a few of them). I sent a test one to myself and my friend (she loved it). I got some emails kicked back or undeliverable I think these emails were fake or they have changed Overall great experience. I will continue to use this as my email list grows. Thanks again.
You crack me up, love your stuff.
@JeffSu
4 ай бұрын
Thank you 😁
Thank you so much Jeff 😃😃😃😃😃
@JeffSu
2 жыл бұрын
You're very welcome 😁😁
dude just saved me hours of work. thanks man!
@JeffSu
6 ай бұрын
No problem my friend 😁
You had me at "Think outside the box". I subscribed!
@JeffSu
9 ай бұрын
Welcome my friend 😁
great video, Jeff! I am going to use this right now as I am moving my clients to another account manager in our team. I am going to personalise the name of the manager that will take care of them and their email address.
@JeffSu
2 жыл бұрын
That's a GREAT idea Dominik! Nice!
finally, it worked just because of your video!... thanks, Jeff!
@JeffSu
Жыл бұрын
Glad to hear it my friend 😁
You're a life savior. Thank you!
@JeffSu
Жыл бұрын
You're very welcome! 😁
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
2 жыл бұрын
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 😁
Nice one, Jeff!
@JeffSu
Жыл бұрын
Thank you 😁
This is the exact thing i have been looking for Thanks
@JeffSu
2 жыл бұрын
Nice!!
Excellent!! Thanks so much!
@JeffSu
Жыл бұрын
You're very welcome!!
Wow, what a great hack. Love your energy, man. Thanks!
@JeffSu
4 ай бұрын
Thanks 😁
thanks jeff, i will be testing 1000+ emails a day with this thanks man
@JeffSu
2 жыл бұрын
That's a lot of emails haha
Thanks Jeff, this just saved my day! NAHWC!
@JeffSu
2 жыл бұрын
Glad to hear it!!!
Sir, your a wonderful teacher.
@JeffSu
6 ай бұрын
Thank you 😁
Hey Jeff, thank you very much. You are a really big help to me.
@JeffSu
Жыл бұрын
You're very welcome my friend 😁
Thank you jeff after two days of struggle final it is working
@JeffSu
Жыл бұрын
Glad to hear it!!
Like always, awesome content👌
@JeffSu
2 жыл бұрын
Thank you 😁
Love it man!!!
@JeffSu
Жыл бұрын
Thank you Supriyo 😁
2 years after, Worked Perfectly 😀 Thank You 🌹
@JeffSu
5 ай бұрын
Awesome to hear 😁
This was great. Thank you!
@JeffSu
Жыл бұрын
You're very welcome Ali!!
This is going to save me so much time! Thank you
@JeffSu
Жыл бұрын
Glad to hear it Stefania 😁
Thank you very much for this video.
@JeffSu
Жыл бұрын
You're very welcome my friend!
Damn Jeff, you're a life saver and a hero, God bless the hell out of you 🙏
@JeffSu
Жыл бұрын
You're very welcome Keri 😁
I needed this 🙌 💛
@JeffSu
2 жыл бұрын
Glad to hear it Rudra 😁
@rudrajaiswara9851
2 жыл бұрын
@@JeffSu 😀
Absolutely useful.
@JeffSu
Жыл бұрын
Thank you my friend 😁
super useful and easy to follow. Thanks Jeff 😀
@JeffSu
24 күн бұрын
No problem 😁
Excellent information, Jeff.
@JeffSu
Жыл бұрын
Thank you 😁
Great video, just what I need to simplify things for now :D
@JeffSu
Жыл бұрын
Awesome to hear Christopher!
Jeff thank you so much this video helped me a lot
@JeffSu
4 ай бұрын
No problem
I was looking for something else but thanks for this. You are clever and hilarious. Good luck.
@JeffSu
Жыл бұрын
Hahahaha I'm glad this video distracted you from your original goal 😁
Liked your sense of humor!!
@JeffSu
Жыл бұрын
Thank you my friend 😁
Great. Thank you for this tutorial buddy
@JeffSu
2 жыл бұрын
You're very welcome Arpit 😁
Thank you Jeff. This was very helpful.
@JeffSu
9 ай бұрын
Glad to hear it my friend 😁
I love you. you've just saved me like 10000 hours a month
@JeffSu
2 жыл бұрын
Not sure there are that many hours in a month but thanks for the sentiment Cindy 😂
Great personality and positive energy my friend. Very helpful content. Thanks
@JeffSu
7 ай бұрын
No problem 😁
Thanks @Pinkie J. I too was stuck with the text issue. It was not picking up the values in the mail body. Your fix worked perfectly. Thanks
@JeffSu
Жыл бұрын
Love to see viewers helping each other out 😁
Great Video, jeff!
@JeffSu
4 ай бұрын
Thank yo u😁
You are amazing brother, You deserve 1 million subscribers and you will get this things soon.... Stay safe work for us 😍
@JeffSu
2 жыл бұрын
Thank youuuuuuuu! I'll try my best!
thank you for this amazing tool
@JeffSu
Жыл бұрын
You're very welcome Leonardo!
Thank you! This was extremely helpful
@JeffSu
Жыл бұрын
You're very welcome 😁
Yo! This is very helpful! Thank you so much!!!
@JeffSu
Жыл бұрын
You're very welcome!! 😁
Subscribed! Love you bro!
@JeffSu
2 ай бұрын
Thank you 😁