Kevin Stratvert ：Mail Merge in Google Sheets & Gmail (for free)

In this step-by-step tutorial, learn how to Mail Merge using Gmail together with Google Sheets. This solution to mail merge is free.

👋 Additional resources:
– Get 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
0:00 Introduction
1:06 Get Mail Merge spreadsheet
1:54 Choose location for spreadsheet
2:19 Prepare spreadsheet for Mail Merge
4:50 Prepare draft email for Mail Merge
7:13 Authorize script
8:18 Run Mail Merge
8:50 Review Mail Merge
9:59 Advanced capabilities, like cc and bcc
11:37 Email send limits
12:15 Wrap up

📃 Watch related playlists and videos
– Playlist with all my Google product videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLGL3Ty_1Wbd3nTZ_q_OKFQ
– Playlist with all my Mail Merge videos: https://youtube.com/playlist?list=PLlKpQrBME6xJ6k71ifmYKzWm8MNgkAOZm

🚩 Connect with me on social:
– 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/kevlers?sub_confirmation=1

🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com

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

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.

#gmail #sheets #MailMerge