Send Personalized BULK Emails in Gmail (for FREE)!

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

MY FAVORITE GEAR

*MY TOP 3 FAVORITE SOFTWARE*

BE MY FRIEND:

👨🏻‍💻 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" 😏

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

[MSL_]

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 YouTube when it comes to navigating Google apps, and features! Thanks again!

[clubvitafm]

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

[robertmontes]

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!

[dayashankarsuresh]

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 🙄😃

[soundbodymusicanddance]

Thank you Jeff! Found this online for sending our emails to leads for my business. Great video and much appreciated!

[muhammadrifqiramadhan]

This is one of my favorite videos. Jeff is incredibly cheerful!!! keep the good work and share the positive productivity to others

[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.

[srgb]

I always learn something useful from your videos. Keep it up, Jeff! 👍🏻

[JeffSu]

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

[anthonyfoxlive]

Your a great Youtuber and smart I love it

[etigpdu]

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

[NormanVsNorman]

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!

[Andrea_Dong]

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)

[JMS]

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

[PrimonChowdhury]

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.

[aadreein]

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!

[lordsparky]

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 " 🤔?

[bastiankourim]

Great video Jeff. But do you have a tip for sending out customized pdfs attached to each specific mail? For example invoices or coupons?

[andrgavr]

This is golden! Always glad to watch new videos from Jeff!

[socialtude]

Used this mail merge for our event details to attendees. Was so efficient. Thank you so much!