Send an email from Google Sheets (Beginners Apps Script tutorial)

In this video I’ll show you how to make a Google Sheet that can send an email. All you need is a Gmail/Google Docs account. The tutorial takes less than five minutes. While this script requires pressing a button to send the email, we will learn how to automate this in a following tutorial.

#GoogleSheets #AppsScript #Tutorial

[moniquecatipon]

I have stumbled upon this fantastic video and lesson... Super appreciate you for sharing! ❤❤🎉

[labocuphealthlabourreahab]

Many thanks for your excellent video and lesson! 😊❤

[krraman]

Many thanks James for your absolutely great video. Can you please tell me how to trigger the email based on the value of a particular cell in my spreadsheet ?

[fratrisilva]

Thank you for this! This was truly very helpful!

[JoeyTheGrove]

This is a GREAT video! Question: How would I personalize the email? Like Hi James... (I don't want to just say "Hi there..." in the body. And, how do I send this to a list? I've tried to create a range formula, but it's not working.

[michaelc]

Thanks for posting this was very helpful. I was wondering if there was a way to input a pdf attachment to this script.

[mrigankverma]

Hii bro I want to attach google dashboard photo in mail. Is it possible?

[rdtrgfw]

hello, can you help me with doing this, but it automatically sends an email if a student is 5 consecutive late

[karylzoeubalde]

how to make the sender's full name and not their email address as display when email is arrived?

[joannaemma]

How to attach a Google Excel as attachment in automated email?

[donmustard]

Is there a way to avoid the DMARC blocking of the auto generated emails?
Admittedly very new to this but each email address I tried to send to came back with email server blocking the emails due to DMARC initiatives

[ChaitanyaMankar]

How to deploy the code, it working when I click on Run, mot sure how to deploy the same

[cmwbmqd]

James, when you type in the let sheet = i'm unable to see the drop down list of values

[wanmeireles]

Thanks, very helpful! Unfortunately I'm having some problems. I tested the e-mail and the body is like stanzas instead of the paragraphs I wrote. Do you know whats the problem? Also, is it possible to add a pdf file to the e-mail?

[thephischmann]

I am a school teacher. I have a folder with googlesheets of student info that I want to give share viewer rights to the parents. Is there are way I can do this enmasse? Thank you

[omonoxo]

i'm collecting data daily from a simple form to a Google Spreadsheet with headers, how can I send an email with that data each time new data is added into the spreadsheet?

[kiranbarack]

How to add multiples mails ? and what's the code??