Grab my free Workspace Toolkit: academy.jeffsu.org/workspace-toolkit? 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
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!
Massive respect for still personally responding to comments 2 years later that blew my mind Gonna use this tomorrow for dealer to dealer wholesale offers so thank you
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!
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 UA-cam when it comes to navigating Google apps, and features! Thanks again!
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!
Does it work with attachments? Also, don't those emails land in the spam box? Anyway, great video buddy. You're one of the creator who really give value in your videos
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. ?
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 🙄😃
Hi sir, i have an AI AUTOMATION AGENCY. And I absolutely need this, as a college student, i dont get enough time to mail 100 of mail every single day. I am making content for my agency and now i am able to handle things because of this.❤ Thank you so much🎉🎉❤
This was perfect...but the problem I have ran into is the {{First name}} worked when I included it in the Subject line. It would not post the {{First name}} when I posted in the body of the email. I made sure I copied it. Then I removed it from the Subject line and only copied it to the body and it still did not include the First name. What should I do? I really need this to work! Is there a way to keep a logo or picture in the email? I really enjoyed your humor!!!
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)
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?
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 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?
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
This is SO helpful omg THANK YOU! I used this just now to send 126 exclusive promo emails to everyone I've had a sales meeting with this year. I'm stoked!!
@@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 am gonna use this technique for my college club related activites to send emails to all the students of our cub. Thank you so much for the video!! It made work easier.
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 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.
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
I help with a nonprofit and need to send volunteer opportunities to around 1,000 contacts. How can I send these emails and prevent my FROM address getting flagged for SPAM?
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. :)
Thank you so much for the video. I done everything as you told me but was not allowed to send more than 95 emails. I was really hoping I could send a mass email to all the people on my mailing list but unfortunately I get an error saying " Service invoked too many times for one day: email." I wish this wasn't the case, I was extremely excited because I have a song that I've just dropped.
Grab my free Workspace Toolkit: academy.jeffsu.org/workspace-toolkit?
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
Thanks!
Thank YOU Bill!! 😁
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 :)
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 😁
2 years down the lane, this video is still relevant as though it was created just today.
You have a new subscriber.
Great work!
Welcome 😁
Massive respect for still personally responding to comments 2 years later that blew my mind
Gonna use this tomorrow for dealer to dealer wholesale offers so thank you
It's because I care about my viewers 😁
Plot twist: Comment Merge! (Video coming soon...)
Seriously though...solid content! Used it today!
@@OfficeManager-yr4ix how do we know the customer id ?
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 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 UA-cam when it comes to navigating Google apps, and features! Thanks again!
Great to hear Marlene! Best of luck with the fundraising events!
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!! 😁
Hey can you help me with this. I tried to add {{First name}} but when I sent, names didn't appear in the mail.
Does it work with attachments? Also, don't those emails land in the spam box? Anyway, great video buddy. You're one of the creator who really give value in your videos
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. ?
Limit is 100 a day
Can you please confirm that your emails are not spammed on client side.
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 😁
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?)
That last statements in things people do wrong got me hahahahahha made me like the video too 👀
Hahahaha glad to hear it 😁
Thanks!
Thank YOU Michael! 😁
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 😁😁
Hi sir, i have an AI AUTOMATION AGENCY. And I absolutely need this, as a college student, i dont get enough time to mail 100 of mail every single day. I am making content for my agency and now i am able to handle things because of this.❤ Thank you so much🎉🎉❤
No problem!
This was perfect...but the problem I have ran into is the {{First name}} worked when I included it in the Subject line. It would not post the {{First name}} when I posted in the body of the email. I made sure I copied it. Then I removed it from the Subject line and only copied it to the body and it still did not include the First name. What should I do? I really need this to work! Is there a way to keep a logo or picture in the email? I really enjoyed your humor!!!
same for me
Same
@@dk6362 I changed the heading in the excel to just Name.. it works now
Hello, have you figured it out?
@@dk6362 Have you figured it out?
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! 😁
Thank you, Jeff! I love how you discuss the flow of the bulk sending! Clearly you love what you're doing! Keep the fire burning! 👌
Will do!
Jeff you are so active man
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?
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
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
One of the most USEFULL youtube videos ive seen in a while on email marketing. Thank You Jeff. I just subscribed.
Yay welcome 😁
This video has saved me, and I am happy that I've sent out my first test, and it has worked. Thank you, Jeff!
Yay!
Can you please confirm that your emails are not spammed on client side.
First name not showing, plz suggest solution
Same here
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?
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
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.
Yea having same issue
@@AsherDavid-u4b First name column is blank...Doesnt work for me..
Any solution?
This is SO helpful omg THANK YOU!
I used this just now to send 126 exclusive promo emails to everyone I've had a sales meeting with this year. I'm stoked!!
Can you please confirm that your emails are not spammed on client side.
So happy to have continued searching & found this video. Thanks sooo much! Clear, concise & FREE (no add-ons needed).
No problem my friend 😁
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
@@ambientsounds5832what 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
Am i the only one who saw Satya Nutella 🤔
Maybe 😏
It worked for me today, November 6, 2024, just 100 emails/day. Thank you Jeff 🔝
Can you please confirm that your emails are not spammed on client side.
@@ImmaSarah I tried to find out, and some emails get spammed and others don't, I think it's a lottery.
You just saved me so much money and unnecessary overthinking
No problem!
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 😁
Hey Jeff,
Thanks for making this content; content was simple and crisp. I heard once and applied immediately; Keep Shining!
Will do 😁
Jeff's energy is amazing 😍
It's because I'm making videos for amazing viewers such as yourself 😁
If anyone was wondering the max amount of emails you can send at once is 100... but it works!
I think it's 300 haha, check out the help center article linked in the description 😁
@@JeffSu Strange, on "quota's for google services" it shows gmail only supports 100 recipients per day where as google workspace supports up to 1500
@@GallBen Oh that's so weird!! They must have changed it. Sorry about that! My mistake (I saw 300 before)
You had me at "Think outside the box".
I subscribed!
Welcome my friend 😁
Excellent information, Jeff.
Thank you 😁
thanks jeff, i will be testing 1000+ emails a day with this thanks man
That's a lot of emails haha
Mannnn!!!!! This is life saver honestly 🎉🎉🎉
You are so much fun! Thank you for sharing this!
No problem!
I am gonna use this technique for my college club related activites to send emails to all the students of our cub. Thank you so much for the video!! It made work easier.
No problem!
dude just saved me hours of work. thanks man!
No problem my friend 😁
Hey Jeff,You just saved me 180 mins daily x 30 = 5400min monthly.
I really appreciate your effort and simplicity.
Yay 😁
Wow, what a great hack. Love your energy, man. Thanks!
Thanks 😁
This is life-changing! Thanks, Jeff!
No problem 😁
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.
I loved the jokes and the new skill - thanks Jeff ☺☺
Glad to hear it my friend!! 😁
Thank you jeff after two days of struggle final it is working
Glad to hear it!!
i'm to be using this trick apply for hundred of jobs at once thank you jeff
No problem! Best of luck 😁
Great. Thank you for this tutorial buddy
You're very welcome Arpit 😁
finally, it worked just because of your video!... thanks, Jeff!
Glad to hear it my friend 😁
You're a life savior. Thank you!
You're very welcome! 😁
Dude, you're an ancient asian GOD!! Jajaja i can send multiple resume mails to recruiters! Thanks!!!
Good luck!!
2 years after,
Worked Perfectly 😀
Thank You 🌹
Awesome to hear 😁
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 😁
Great personality and positive energy my friend. Very helpful content. Thanks
No problem 😁
This was helpful, thanks Jeff
No problem Gideon 😁
I plan to use it in the dental office to remind patients about appointments
Oh nice! That's a great use case :)
Sir, your a wonderful teacher.
Thank you 😁
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 😁
THANK YOU! You saved me hours of manual work!
No problem 😁
This is one super awesome video! Highly helpful
Glad you think so my friend! 😁
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 😁
Liked your sense of humor!!
Thank you my friend 😁
This is exactly what I need. Thank you for making this video!
No problem!
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 😁
This is awesome!! Thanks a lot!! Saved me a lot of time in bulk sending emails to Hundreds of Clients 🥳
Glad to hear it!
Thanks my friend I am a pastor and I need to send everyone an email. I want to start doing this 😅 have to take care of the flock ❤️
Nice!!! Glad you found this helpful!
I love you. you've just saved me like 10000 hours a month
Not sure there are that many hours in a month but thanks for the sentiment Cindy 😂
This is super amazing man, really great. Thanks for bringing this out, loved it!! Also, wonderful presentation with humor in between, really engaging.
Glad to hear it!
Another great video Jeff!
Thanks my friend 😁
Yo! This is very helpful! Thank you so much!!!
You're very welcome!! 😁
Jeff thank you so much this video helped me a lot
No problem
Asking for the like at the end got the like. Well played sir..
Thank you sir 😉
Great Video, jeff!
Thank yo u😁
I finally found solutions! Thanks
You're very welcome 😁
I help with a nonprofit and need to send volunteer opportunities to around 1,000 contacts. How can I send these emails and prevent my FROM address getting flagged for SPAM?
Use Mailchimp 😁
Such fun.
Now do this for zoho mail ;)
Wait what's Zoho mail
@@JeffSu a pain in my heiny XD
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!
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 😁
Thanks a lot. You saved my time. How many mails i can send a day
I think 100
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 😁
Thanks Jeff, this just saved my day! NAHWC!
Glad to hear it!!!
You crack me up, love your stuff.
Thank you 😁
Amazing work, big fan from Egypt
Hope you're staying safe and well in Egypt Abram, and thank you 😁
This saved me a paid extension, thanks!
No problem 😁
Thanks you have saved me loads of time 🙏
No problem Tim! 😁
THANKKKK YOUUUUUU SOOOOOO MUCHHHHHHHHHHHHH..... MY JOY KNOWS NO LIMIT. JUST THANKKKKK YOUUUU A LOTTTTT
YOU'RE WELCOMEEEEE
Nice one, Jeff!
Thank you 😁
This is very helpful. Thank You!
No problem!
Thank you so much for the video. I done everything as you told me but was not allowed to send more than 95 emails. I was really hoping I could send a mass email to all the people on my mailing list but unfortunately I get an error saying " Service invoked too many times for one day: email." I wish this wasn't the case, I was extremely excited because I have a song that I've just dropped.
Hi Ty! This free method really should be reserved for contacts you know haha, but you might want to send across multiple days!
thank you so much !!! you just saved my job
Wow seriously? Glad to hear it Shivani 😁
Oh thank you so much for creating this video. I'm using it for my cold email man
Great!
Thank you super helpful info!
You're very welcome Ayeshia 😁
I need to send an RFQ to similar vendors so this would work for me once i get it online
Cool!
Thank you very much, works like Magic
Yayyy 😁
This indeed works!! Thank you!! Just sent 220 cold emails.
Nic!