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
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!
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.
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!
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
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
1000000000000000000000000000000000000000 TIMES out of 5. You just saved my Thousands of Dollars!! Bring more videos like this man! Subscribed, liked and shared!
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.
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.
Hi, thanks a lot for this tutorial! I am looking forward to using this on one of my marketing campaigns. Can you please tell if it is possible to change the form address? Or else it is simply the address which we are using to access the spreadsheet and press the button?
Thanks for this amazing tutorial. 1 question ..... I have a list of 100 people and I send random 10 people an e-mail. Can I get a checkpoint of 10 randompeople?
I love your videos and they're making me very productive with GSHEETS. I'd like to ask a favor. Whenever you teach us a Script, could you insert on the description the finished sample so we can copy and work on.
Greetings, I watched your video and am delighted, I have a question when I need to transfer means, google script, formatted text to a variable like , How to do this? I just need to add hyphens as , I take the body email itself from the cell
great tutorial! I have a question, Is it possible if we make a button to upload a pdf file to a spreadsheet? then we can press the email button and the uploaded pdf file will be sent to the name "checked in the box.
Thanks for this, May I ask if there is any way I can add attachments (taken from my Google drive) to this mail merge, wherein each email will receive different files from each other?
I have a question. When you set it to send email only the box are checked, could it be date for exemple? Whenever get today date the email would be send? I couldn’t find any comment about it. Thank you
Thank you for the video, it has helped me on most of the email I am trying to send out. Now to figure out how to put the html code in for a different link to go to each person.
This is wonderful. I am a part of a massive spreadsheet and its hard for me to see each detail. Is there a way to only send an email for the cell that's been edited?
is there an easy way to populate the cell value to confirm an email has been sent for the rows you have checked. So, if you want to send the email to a couple of people first, then when you return to send it to the others you will see that some people have already been sent the email?
@@ExcelGoogleSheets thank you for answering hope not to bother you. I am just trying to learn spreadsheets. I was trying to make the video work for the 2nd (I am slow to learn) and found that error message -there is no 'row' function. I just got stuck there. Probably I'll try again tomorrow. I am sure it is my fault.
This is great. Thanks. But is their a solution for the step before which brings your emails from gmail into google sheets automatically (respecting your filters and labels)
Hi Can you please help me out with exporting email subject lines from Gmail App using App Scripting? Please advise or please make a new session about this.
Hi, I have a problem, what's the error 429? I have a code that works with cycle to find if an employee is active at work on that day, but after sending several emails, he gets stuck with this code, how come? Thanks so much
Hi, I tried some of the codes but got stuck. The following are the problems I am not able to add Google Script as add on in my sheet. It is not appearing in the search at all. So the command ".getActivSpreadsheet().getSheetByName("Customers"); is not working. I get the following error - TypeError: Cannot call method "getSheetByName" of null. (line 7, file "Code") Can you pls help me to rectify. Also if you can explain the function of each command it would be good for people like me. Thanks
This a great tutorial video!!! I was able to get the functionally working on the first try!!! Now, I am trying to enhance it a little further, by adding the ability to email to a Group of Emails from the Label option withing Google Contacts, any tips or suggestions on how this can be done? I am still digging and doing some googling, I can't be the first person to want to have the ability to enter an email address OR to multiple emails set up with the same label in Google Contacts.
Hey, I coded as it is in video still throwing an error syntax error missing ) after argument list (line 9, file code.gs". What could be the problem Can you please fix this ?
I have a question. This sends to one recipient. What is the additional code I need to add to email a second or third recipient (ie. CC'd) for the same email being sent?
Well, here.s another question in spite you didn’t answer the previous one!! My question is there a code that I can use which can save user account who edit my sheet. For example, I shared a sheet with about 20 friends. All of them can edit a certain field in the sheet. I want to know who edited values in the sheet and save his account in a pen another sheet. I hope you got what I mean.
hey man thanks for the video, im getting this error tho and im unsure how to fix it ? SyntaxError: Unexpected token ';' (line 35, file "Code"), same code and everything but few more variables