Mail Merge in Google Sheets and Gmail (Free)

In this step-by-step tutorial, learn how to do a mail merge using Gmail with Google Sheets. This direct mail solution is free.

Additional Resources:
– Get a mail merge spreadsheet: https://developers.google.com/gsuite/solutions/mail-merge
– Gmail daily recipient limits: https://developers.google.com/apps-script/guides/services/quotas#current_quotas

Timestamps
00:00 Presentation
1:06 Get a mail merge spreadsheet
1:54 Choose spreadsheet location
2:19 Prepare a spreadsheet for mail merge
4:50 p.m. Prepare draft email for direct mail
7:13 Authorize script
8:18 a.m. Run mail merge
8:50 a.m. Review of direct mail
9:59 Advanced features, like cc and bcc
11:37 Email sending limits
12:15 p.m. Conclusion

Watch playlists and related videos
– Playlist with all my Google product videos: https://www.youtube.com/playlist?listPLlKpQrBME6xLGL3Ty_1Wbd3nTZ_q_OKFQ
– Playlist with all my direct mail videos: https://youtube.com/playlist?listPLlKpQrBME6xJ6k71ifmYKzWm8MNgkAOZm

Connect with me on social media:
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818

Subscribe to my YouTube channel
https://www.youtube.com/user/kevrers?sub_confirmation1

Want to see again? Quickly come back to my YouTube channel
http://www.kevinstratvert.com

Support me with your Amazon purchases: https://amzn.to/3kCP2yz

For complete information, I use the affiliate links above. Purchasing through these links gives me a small commission to support the videos on this channel – the price is the same for you.

#gmail #sheets #MailMerge

Please take the opportunity to connect and share this video with your friends and family if you find it useful.