How to Send Automated Email using google apps script

Рет қаралды 44,119

6 жыл бұрын

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-apps-script-tut...
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 KZfaq Tools ➜ goo.gl/MX9Z4p and ➜goo.gl/UW1uRX
****** Gear Used To Shoot This Video *****
_Audio & Microphone
amzn.to/2GibdGu
*******Learning partner*******
Video courses ➜click.linksynergy.com/fs-bin/...
💼 To Hire Me 👉 fwd.cx/WLGgpTiZW5HK
Checkout my app 👉 www.myfreshtools.com

Пікірлер: 35

@Amarindaz 3 жыл бұрын

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

@vivianedantassoares614 3 жыл бұрын

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!

@AshirwadKumarsingh 3 жыл бұрын

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

@Amarindaz 3 жыл бұрын

Glad it was helpful!

@rishabhmehta6204 4 жыл бұрын

You just made my day

@penchalaiahjammula183 5 жыл бұрын

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?

@armynatentar3830 3 жыл бұрын

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

@EduardoZertuche 4 жыл бұрын

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?

@CGSheep 3 жыл бұрын

wow it ACTUALLY worked

@ibrahimnazemqader9153 Жыл бұрын

Well done

@jazneo150 3 жыл бұрын

Very good

@aakashsajwan 4 жыл бұрын

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

@ha-pod Жыл бұрын

5 years ago wooow

@sagardawkhar6125 4 жыл бұрын

Can we add attachment as well ?

@davidmcnulty6681 3 жыл бұрын

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

@ladypoupee1496 3 жыл бұрын

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 3 жыл бұрын

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

@vive121 6 жыл бұрын

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 6 жыл бұрын

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

@AshishSingh-qn4sf 4 жыл бұрын

Hi How to add cc option in script?

@sfl1986 5 жыл бұрын

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

@ebooksera3521 6 жыл бұрын

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 6 жыл бұрын

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