Send Personalized BULK Emails in Gmail (for FREE)!
ฝัง
- เผยแพร่เมื่อ 31 พ.ค. 2024
- 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 TH-cam 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
Love your energy, Jeff! You've somehow "merged" humor and serious productivity together in a seamless fashion. Great work!
Thank you!! I was going for that 😁😁
@@JeffSu Your humor is very well received, especially for such a serious subject matter. Looking forward to more content!
@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 :)
i agree!
i'm guessing you might be from HK? but you don't have to say!
@@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 TH-cam when it comes to navigating Google apps, and features! Thanks again!
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!
And hopefully not the last video you'll come across Robert 😏.
You're very welcome!!
This is one of my favorite videos. Jeff is incredibly cheerful!!! keep the good work and share the positive productivity to others
Thank you Muhammad 😁😁
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 🙄😃
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!
Thank you my friend! You're very welcome 😁
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!
Glad to hear about your use case!! 😁
So happy to have continued searching & found this video. Thanks sooo much! Clear, concise & FREE (no add-ons needed).
No problem my friend 😁
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
Idk, but you got them into my subconscious so I’m gonna have dreams about ‘em 😳😱
@@w.w.sakbeh571 good 😇
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?
Tnx
Hey bro! Tutorial is good but first name is not working or visible in email
Your a great TH-camr and smart I love it here!!!!!
You're welcome to stay as long as you like 😁
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.
Glad to hear it! You can always save this and use it down the line 😁
I always learn something useful from your videos. Keep it up, Jeff! 👍🏻
Super happy to hear that! Thank you my friend 😁
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)
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 😁
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?
@@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)
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?
Great video…cut and paste “recipients” to stop any typos 😂 (been their and Don that) ❤️
Hahahaha for sure! Thanks for sharing James! 😁
@@JeffSu it’s the word recipient….how many time can I spell than wrong! (Internally counting…about 40?)
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.
I'm glad to hear you say that Primon!!! That's what I'm going for 😁
This is golden! Always glad to watch new videos from Jeff!
Thank you Andrey! Always glad to have you here watching them 😁
Great video Jeff. But do you have a tip for sending out customized pdfs attached to each specific mail? For example invoices or coupons?
Hm...that's a bit more advanced but I think it's do-able with a more advanced Script 😂
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 " 🤔?
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
@@JeffSu 🤣
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!
Woohoo glad I'm able to share something you were actively looking to do! Did it work out well? 😁
Brilliant! I am using this for a school reunion so the video has been extremely helpful. Your instructions work a treat. Thank you.
Woohoo glad to hear it 😁
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?
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?
You might need to use a third-party Chrome extension for that!
@@JeffSu hi Jeff, please what third party chrome extension do you approve of?
man.. you are always able to get some really useful ideas for videos. Thankyou for this Jeff.
I try my best! Thank you Shiromani 😁
Used this mail merge for our event details to attendees. Was so efficient. Thank you so much!
Glad to hear it! 😁
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!
I have the exact same problem, I don't know what I did wrong. Have you fixed it yet?
Its because you need to check your capitalisation in the spreadsheet. It's actually {{First name}} (lower case n)
@@SeagramPearce It was copy pasted to avoid issues...but there's issues? I see lower case n and it doesnt work
@@makug same happened with me anything in {{}} on email body was not taken from the sheet, have you got a fix?
Me too. I've tried severally. Can anyone help?@@yogeshshrivastava2600
Everything is working well except the name, CID is not visible in recipient mail
You might have made a typo
@@JeffSu Doesn't work for me either. Copied and pasted and name not visible in the body of the email.
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!
Welcome to the channel Serena! Glad to have you here! And happy to hear you're finding so much value from the content 😁
Jeff Su, you are the man! Thank you so much. This video was so helpful, precise, and even funny at times. Bravo!
Dam. Only funny "at times"? 😏. Jk, thanks so much for the kind words!
Am i the only one who saw Satya Nutella 🤔
Maybe 😏
i dont think this still works.
Why not?
the mail merge tab isnt appearing on my google sheets. i found an alternative way however, so this video wasnt useless for me.@@JeffSu
@@learnwithsofiajadewhat was the alternative method?
@@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.
I agree. Been trying this for over a week to no avail
This is pure gold! Your content is superb for any professional!
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!
Yes the real hero here is Martin Hawksey!! You're very welcome!
Tremendous value. I can honestly say that this video has saved me a lot of time and money. Thank you!
You're very welcome my friend 😁
I love the way you spread positivity across the world's human vibes, Thanks a lot Jeff.
You're very welcome! I'm happy to do it!
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!
Woohooo congrats!
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. :)
Awesome! Let me know how it goes Rebecca 😁
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!
Nice! Loving how you are already using the "context' tip I talked about before. Thanks for sharing 😁
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.
That's awesome, and how has the results been so far?
@@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.
This is life-changing! Thanks, Jeff!
No problem 😁
Wow, what a great hack. Love your energy, man. Thanks!
Thanks 😁
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. 👏
Glad to hear it my friend! Let me know how it goes 😁
I find your videos very helpful and informative. Your presentation is just awesome!
Thank you my friend 😁
This is awesome!! Thanks a lot!! Saved me a lot of time in bulk sending emails to Hundreds of Clients 🥳
Glad to hear it!
Why would people forget to not like this video. Awesome stuff Jeff ! ❤️
I know right?? 😁
Great personality and positive energy my friend. Very helpful content. Thanks
No problem 😁
Amazing!! Perfect time I see this as about to do a bulk client holiday promo email for my web design biz!
Awesome! Best of luck!!
This is exactly what I need. Thank you for making this video!
No problem!
THANK YOU! You saved me hours of manual work!
No problem 😁
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.
That's a GREAT idea Dominik! Nice!
You are amazing brother, You deserve 1 million subscribers and you will get this things soon.... Stay safe work for us 😍
Thank youuuuuuuu! I'll try my best!
This is Gold! Thanks, Jeff!
You're welcome Cotfas 😁
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
Love to see viewers helping each other out 😁
Another Banger Jeff! Nice one
Thank you my friend 😁😁
Jeff's energy is amazing 😍
It's because I'm making videos for amazing viewers such as yourself 😁
Another banger! This is actually pretty cool 😎
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!!!!
Awesome!! Congrats Dennis! 😁
This was just what I was looking for. Thank you!
Glad to hear it! 😁
You had me at "Think outside the box".
I subscribed!
Welcome my friend 😁
dude just saved me hours of work. thanks man!
No problem my friend 😁
Exactly what i was looking for, 'like' truly earned!
Glad to hear it Ciaran! Thank you very much 😁
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
Hahaha I think half my colleagues love me and the rest hate me because I'm so anal about stuff 😂, but thank you!
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
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 😁
Damn Jeff, you're a life saver and a hero, God bless the hell out of you 🙏
You're very welcome Keri 😁
2 years after,
Worked Perfectly 😀
Thank You 🌹
Awesome to hear 😁
Mannnn!!!!! This is life saver honestly 🎉🎉🎉
Jeff thank you so much this video helped me a lot
No problem
Hey Jeff, thank you very much. You are a really big help to me.
You're very welcome my friend 😁
You crack me up, love your stuff.
Thank you 😁
Awesome tutorial, helps me send bulk emails quickly and professionally, thanks!
You're very welcome Michael :)
Sir, your a wonderful teacher.
Thank you 😁
Thanks so much, Jeff this is a really helpful one! 💪😁
So the others aren't that helpful? 😭
@@JeffSu They are all brilliant! Thanks so much
@@galbeeri6258 Hahaha thank youuuuu
I was looking for something else but thanks for this. You are clever and hilarious. Good luck.
Hahahaha I'm glad this video distracted you from your original goal 😁
I needed this last week 😭
It's okay, find another opportunity to send another round of bulk emails! haha
Subscribed! Love you bro!
Thank you 😁
Hi Jeff,
I'm using this to invite people to come see my performances! Thank you so much for explaining this in a way that I wanted to watch the entire video and actually do what you say. XD
Nice! I hope they have a blast at your performance Asther 😁
Hi, I love the way you teach. Really incredible and charming! Love from Bangladesh ❤
Thank you so much for the kind comment Bahauddin 😁, hope you're doing well in Bangladesh! 😁
I would use this for a newsletter for my author side of business. Thank you for this! Now to watch the examples for school and work.
Ooooo author side of the business! I'm interested to hear more 😁
@@JeffSu I write young adult fantasy books.
This is going to save me so much time! Thank you
Glad to hear it Stefania 😁
Really helpful! Thanks much for this! Subscribed 💯
You're very welcome Cess! Welcome 👏🏻
Great video, just what I need to simplify things for now :D
Awesome to hear Christopher!
Thank you Jeff. This was very helpful.
Glad to hear it my friend 😁
finally, it worked just because of your video!... thanks, Jeff!
Glad to hear it my friend 😁
Excellent information, Jeff.
Thank you 😁
This is the exact thing i have been looking for Thanks
Nice!!
Like always, awesome content👌
Thank you 😁
You just saved me so much money and unnecessary overthinking
No problem!
Another great video Jeff!
Thanks my friend 😁
Thank you very much, works like Magic
Yayyy 😁
You are totally crazy man 🤪
Really cool method! Thanks for sharing!!
Thank you George!! Hope you found this helpful 😁
You're a life savior. Thank you!
You're very welcome! 😁
This was great. Thank you!
You're very welcome Ali!!
Great Video, jeff!
Thank yo u😁
Brilliant video, so easy to explain thank you!
You're very welcome 😁
This is awesome, Thank you!
No problem!
Great job, man!
Thanks! 😁
Thanks! Saved me a ton of time.
No problem 😁
Thank you! This was extremely helpful
You're very welcome 😁
Liked your sense of humor!!
Thank you my friend 😁
This is great and will be helpful in sending donation receipts or event details for non-profits donors and volunteers.
Awesome! Thanks for letting me know how you'll use this. What a great cause!
Love it man!!!
Thank you Supriyo 😁