00:00There has been a few comments asking how you can send an email using Google Sheet
00:04here. Well this is how I do it. I have a address to where to go to in cell A3
00:08and the subject and associated message. First you're going to go to extension
00:13app script. Once the app script is locked let's create a new function. After that
00:18we'll get the destination email address from cell A3 and then we'll get the
00:23subject from cell B3 and then we'll get the message from cell C3. And finally to
00:32send email we use a send email function like this. If you require this code kindly
00:36leave a comment and I will be glad to provide it for you. Once that's done click
00:40on save and then click on run. If it runs correctly your execution lock should look
00:45something like this. Now if you go to your gmail address you will see that the new
00:49hello message is being populated on your email account.
Comments