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:

⌚ 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

🚩 Connect with me on social:

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ 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

[KevinStratvert]

Continue learning Google Sheets with FREE Official Training offered by Google:

[truthseeker]

Kevin, your videos by far are some of the best and most valuable tutorials. We are testing a few markets and wanted a free solution, do to being a startup and pretty much just testing options. And once again you come through with straight forward legitimate solutions that work well. KUDOS!

[edwardpovey]

Hi all, a really useful tip. When drafting your email, make sure you've changed to plain text mode, otherwise the {{}} tags in the body of your email won't get read by the script and will appear blank when you hit send. Like me, if you want your email to have a fancy footer and some nice fonts, you can copy and paste your plain text email body into a new draft in normal mode. As long as the {{}} tags are in plain text the script will read them and the merge will work. It's basically taken me about a day to work this out, in which time I could have written all the emails I needed to send out by hand!

[sivarajanv]

My brother came out with this problem of sending multiple mails to different members in his club with individual details. Though I had worked with Mail merge in MS Word, this was a challenge. I found the right solution here. I tried it out myself with test mails before communicating to my brother. Thanks a lot Kevin. Sivarajan, India.

[aditya_suresh]

Thanks a lot Kevin! This was the first video that I requested after viewing your channel! Your tips and solutions have been very useful indeed!

[gajabathiarjuntg]

Thanks Kevin sir for this useful tutorial. Excellent.

[kevinlncconsulting]

Amazing Video Kev. I'm blown away. I've spent so many hours trying other methods that didn't work or had limitations. But this by far is the most cleanest and quickest method. Thanks a bunch!

[indraneelmitra]

Hi Kevin, I was desperately searching for the Mail Merger procedure on YouTube. After encountering several long and talkative videos, I finally came across your short and precise video. It was really helpful and I was able to successfully complete my Mail Merge. Thanks a ton 😊

[arjunm]

Thanks Kevin
Is it possible to send different attachments for different person using mail merge.

[kcoolnow]

This still works three years later. Really great for non-profits trying to do constituent updates. Thank you!

[gloriasonlinediscoveries]

Thank you very much for this, everyone else made it so confusing, but I followed along with you with no problem. You were clear and gave the best tutorial. Well done. Be safe.

[Bhoustonish]

Thank you Kevin. This was clear and logically arranged. You have good attention to detail. And it all worked for me first try.

[agentPLINY]

Thank you for the excellent video! Do you have video going into more depth regarding including attachments with the mail merge in Gmail?

[kathijenmurphy]

Thanks Kevin, the video was very easy to follow. I tested it and I received the message that my email was sent but didn't get the email with all the information. The only fields I had were recipient, student email, student password, email sent and the description. Tried it several different ways but none of them worked.

[HassanAnzit]

Kevin, thank you very much! After watching your channel, this was the first video I asked! Your suggestions and solutions were extremely helpful!

[jimekrut]

Great job, Kevin! I manage a group email list and am helping one of the group leaders personalize communication. The pre-formatted Sheet and your explanation will meet the need perfectly, thanks!

[danilag.badiola]

I love how your tutorials are easy to follow, and I'm sure I did follow your every step in this mail merge tutorial but whenever I receive the test email I created the other columns would not appear in the email. It's frustrating cause I don't know what I'm doing wrong. Nonetheless, Thank you very much Kevin!

[rajukv]

Thanks for the turturioal I love it 🔰🔰

[viviensfilms]

Thank you Kevin. Your tutoring is super simple and I followed every step to the T. I even received the confirmation that the emails were sent, but no email was in fact sent. I don't know what I did wrong.

[CherylDFloyd]

Thank you so much for this great video! I just sent my first mail merge message to 6 recipients. Yay!