How to Send Automated Email using google apps script

Support Amarindaz on Patreon: goo.gl/it9Gpk -~-
Title: How to send Automated email to different people using google apps script
Description:
In this video, you're going to learn on how to send email from google spreadsheet automatically with the help of google apps script.
We are going to use a class called MailApp and it has a method called sendEmail. We are going to use sendEmail method that accepts three parameters
1)To address
2)subject
3)Email Body
With MailApp class, we can also send an email with attachment as well. Here, we have a set of recipients address and dummy subject and email body.We are writing simple google apps script to send email based on cell value.
When you run that function, it'll automatically send email from google spreadsheet to multiple recipients.
********* Tutorial Playlists *********
Google apps script tutorial for beginners- bit.ly/google-...
Automate internet explorer with VBA- goo.gl/Xmy8Af
Autoit tutorials for beginners- goo.gl/JHB1E2
Selenium Webdriver tutorials for beginners -goo.gl/QqxTrF
***** Contact me *******
Blog: www.amarindaz.com
FB page: / amarindaz
****** Books written by me *******
Autoit tutorials for beginners: amzn.to/2GjaDbD
Excel VBA for beginners: amzn.to/2nhI067
****** Productivity tool ********
My Favorite KZbin Tools ➜ goo.gl/MX9Z4p and ➜goo.gl/UW1uRX
****** Gear Used To Shoot This Video *****
_Audio & Microphone
amzn.to/2GibdGu
*******Learning partner*******
Video courses ➜click.linksyne...
💼 To Hire Me 👉 fwd.cx/WLGgpTi...
Checkout my app 👉 www.myfreshtoo...

[@Amarindaz]

🔥Write code like a Pro with AI-Powered code assistant plugin 👉 bit.ly/get-kite

[@AshirwadKumarsingh]

You are doing a great job, great video, full of content with a simple and perfect explanation.

[@Amarindaz]

Glad it was helpful!

[@ha-pod]

5 years ago wooow

[@CGSheep]

wow it ACTUALLY worked

[@vivianedantassoares614]

Thank you for sharing this video. It helped me a lot and I could do it! Really, it saved 5 hours of my weeks, 20 hours per month. Amazing!

[@rishabhmehta6204]

You just made my day

[@EduardoZertuche]

Is there a way to schedule several emails from a list, each with a different time and date for sending? I understand that you can set up triggers, but I cannot find a way to trigger each mail separately... can you help me?

[@armynatentar3830]

Thank you. Can you also show the script how to add attachments from Google Drive?

[@jazneo150]

Very good

[@ladypoupee1496]

Thanks for the tutorial.... however, how about a coding thing for dummies in Google? I mean, even if I follow your steps EXACTLY, I realize that one already needs to be familiar with those codes... right?

[@HimanshuSharma-un1xg]

How to trigger the mail if the particular cell value (formula output) full fill the certain conditions. ?

[@ibrahimnazemqader9153]

Well done

[@sagardawkhar6125]

Can we add attachment as well ?

[@davidmcnulty6681]

Hi, I am new to google sheets and script have a sheet that I would like to get an email notification if any cell in column V2:V is changed or edited, can you tell me how to do this? Ta

[@aakashsajwan]

Hii, please share "what does Script runtime" mean. what does 6 min / execution limt means

[@penchalaiahjammula183]

Hi your tutorials useful lot to me thanks for videos can I know where i can find script syntax for google apps script for example like for loop does it python?

[@anisharma7889]

How to add default signature of Gmail through script

[@ebooksera3521]

Good day Sir! Thank you for sharing your knowledge with us, zero-knowledge in Google Script. Sir, if it's not a burden to you, could you please, add best features listed below. 1. Add a column where it will not send message that was sent already, it's like a "email-sent" indicator... 2. If all possible for you, could you please, make this script active only in 1 particular worksheet... 3. Please, try also adding a keyword to trigger to run the script automatically... 4. The best part is that, please make it really automatic, I mean, there's no need to click the run button again, just only 1-time set up and it will automatically send email for every new added content or changes... I hope you can read this message and reply. I am looking forward for your kind reply. Thank you in advance!

[@Amarindaz]

I'll create a new video soon for your query. :)

[@sfl1986]

My doubt; how to modify script to send followup email if no reply?

[@vive121]

This was so useful and something new that I learn today. Thanks for sharing your knowledge. As a beginner what other use can I make of GS? Keep rocking Sir :)

[@Amarindaz]

As a beginner, you can create simple function on Google sheets to start up with

[@AshishSingh-qn4sf]

Hi How to add cc option in script?

[@alybondoc2415]

I tried this one and it worked fine but messages are going to spam. Is there any way to avoid this sir? Thanks

[@Amarindaz]

You can change the gmail settings to route it to inbox

[@alybondoc2415]

@@Amarindaz where to go from there please?

[@ELGOYANO96]

@@Amarindaz HOW?

[@abhishektripathi-hi8vx]

sir i try to run this program but its showing me unauthorized so what i do

[@JustIn-case]

you wait a sec, it should have a popup show, if not then try again itll then offer to authorize you.

[@christiantjokrowibowo2979]

When i write the code and save it, it's say "Missing variable name. (line 4, file "Code")" can u help me?

[@ktysergamming5210]

I got the same thing did you ever fix it?

[@creatorkannan675]

Sir I want to Seend more than 1000 of email

[@echobrain1837]

PRO

[@Amarindaz]

I'm so glad that you like this video. Echo BRAIN, please subscribe and stay tuned for more videos!