Google Sheets Mail Merge - Email - No Addons - Tutorial

Learn how to do Google Sheets mail merge & send emails through Gmail using an HTML template. We'll be using Apps Script & JavaScript and no add-ons.

#GoogleSheets #MailMerge #Email

[brettjones]

I have been needing to know how to this for years. The things I have learned from these videos has saved the nonprofit I work an absurd amount of time by not having to do repetitive, automatable things like this. Thank you!

[WardyHoot]

A very easy to follow step by step instruction. I've used it to send out yearly and half yearly dues for a Lions service club. Excellent and highly recommended.

[dealsplatter]

Can't wait to set this up for some upcoming projects I have. Thank you for sharing.

[jross]

Great tutorial. What I like best is that you quickly show the steps without lingering or saying the same thing 10 different ways. If we don't understand something or it's too quick we can always stop and go back. Unfortunately other videos may mean well but are soooo slow to explain or get to the point. Thanks again

[mithunmusabbir]

I don't have words to thank u enough for this video.. specially the last part.. awesome...

[marcelcharest]

You are an excellent teacher. You explain very well. The explanations are clear. The sound of your voice and your diction are excellent. Thank you for the services you render us. It's very appreciated.
Bon baiser de Montréal

[kylemoore]

This entire series is AMAZING!!!! It has changed the way I do business because there are so many remedial tasks I can automate! Thank you!

[DinoRodriguez]

This was an amazing video, thank you for all your hard work. Super useful!!

[Parthkushwaha]

Thank you so much, looked at a bunch of videos before finding yours. Successful!

[abdulfatiraziz]

TIMES out of 5. You just saved my Thousands of Dollars!! Bring more videos like this man! Subscribed, liked and shared!

[hirenkakkad]

Really fantastic video. Your all videos are informative and I never miss it.

[liangmale]

Excellent tutorial as always, you are doing great work, please create more content like this one

[lexiriam]

How can this video only have 1.5k thumb-ups? It should be in the millions! Thank you for your video. It was perfect and exactly what I needed. #Subscribed!

[abdullahquhtani]

Great but it would be greater if you extend it more to add these following task:
1- add one field so the script can write a value in after sending each email so I can know who I sent email to and didn’t.
2- how to write values in email body in an alternating colored rows in a table.
3- make an option to trigger the script after each submission if I use it with google forms.

I’m sure most ppl need these complete in one script instead of using multi scripts.

Thank you for your appreciated efforts.

[rgetsy]

The best explanation to date. Paid for courses that wasn't near as good as this.

[lionelchng]

A very warm thank you. I appreciate it.

[fttx]

This is what I have been searching for for a long time

[juzfunpartystore]

Wonderful lesson. Very useful. Thanks a lot

[gregking]

Your videos have helped greatly. Keep up the good work. I do have a need to make something like this non-container bound as other processes need to utilize mail merge. My company has blacklisted all mail merge add-ons and need to find a way to make this readily available without duplicating code in spreadsheets.

[DILEEPKUMAR-isvi]

Very good tutorial for custom email. Thanks a lot.