0 3 min 3 mths

🌟¬†Google Developer’s Website: https://developers.google.com/workspace/solutions/mail-merge

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: https://developers.google.com/workspace/solutions/mail-merge
Quota page: https://developers.google.com/apps-script/guides/services/quotas#current_quotas

MY FAVORITE GEAR
🎥 My YouTube Gear – https://geni.us/youtube-gear
🎒 What’s In My Bag – https://geni.us/mybag
💻 What’s On My Desk – https://geni.us/mydesk
🛩 What I Travel With – https://geni.us/mytravel

MY FAVORITE SOFTWARE
✍️ Skillshare – https://geni.us/skillshare-jeff

BE MY FRIEND:
📧 Subscribe to my Productivity newsletter – https://www.jeffsu.org/productivity-ping/
📸 Instagram – https://instagram.com/j.sushie
🤝 LinkedIn – https://www.linkedin.com/in/jsu05/
👋🏻 Clubhouse – https://www.joinclubhouse.com/@jsushie

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