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

Support me on Patreon: / jamesmurdza
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
For related guides and tutorials: jamesmurdza.com/

[@moniquecatipon489]

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

[@jamesmurdza]

Of course, thank you! 😁

[@krraman2005]

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 ?

[@jamesmurdza]

I'll try to make a video on this. If you need help in the meantime, send an email to [e-mail].

[@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.

[@jamesmurdza]

Thank you! You can use =CONCATENATE in Google Sheets to join strings together to create a simple template. To send to a list, you need to use comma separated values. You can use =TEXTJOIN to convert a range of cells to comma separated format.

[@labocuphealthlabourreahab]

Many thanks for your excellent video and lesson! 😊❤

[@michaelc8192]

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

[@fratrisilva]

Thank you for this! This was truly very helpful!

[@jamesmurdza]

You are welcome!

[@mrigankverma3179]

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

[@user-rd7tr6gf7w]

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

[@jamesmurdza]

Hi, can you send me an email to [e-mail]?

[@karylzoeubalde]

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

[@jamesmurdza]

Hi, I would try something like this: James Did that work?

[@karylzoeubalde]

@@jamesmurdzaNo, it says invalid email address

[@joannaemma1877]

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

[@donmustard9020]

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

[@EamonnCottrell]

Is it blocking your gmail address or a custom email? The DMARC stuff is very confusing for me. I went through the process of setting it up through my newsletter recently and made this video about it if it's helpful. I think that the bit toward the middle on DMARC setup could apply to any custom email since it's where I added the DMARC policy to my custom domain. kzbin.info/www/bejne/imi1momvpbGhrqM

[@BM-xu2ci]

How to get attacment for the sheet ?

[@ChaitanyaMankar99]

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

[@jamesmurdza]

Something like this? kzbin.info/www/bejne/pZzKeHutatmKmZI

[@user-wr9dh6yv1o]

Hi . I need help

[@user-cm7wb5mq3d]

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

[@jamesmurdza]

Hi! The drop down is just the editor's autocomplete. The only thing that matters is that the code is correct in the end. Or, you can just copy the code from here. 🙂 gist.github.com/jamesmurdza/addf30adbd65f7e28f6a855b75469be8

[@user-cm7wb5mq3d]

@@jamesmurdza thanks so much!

[@wanmeireles7182]

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?

[@jamesmurdza]

Hi, I believe this would require some HTML. Unfortunately I'm not exactly clear on how to do this yet.

[@wanmeireles7182]

@@jamesmurdza Thanks, I remember I was able to solve that with the help of ChatGPT

[@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

[@jamesmurdza]

That should be quite straightforward if they have Google Accounts. support.google.com/drive/answer/7166529

[@o0monox0o]

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?

[@jamesmurdza]

You can use an "on change" event trigger, similar to how I show in this video: kzbin.info/www/bejne/pZzKeHutatmKmZI

[@kiranbarack2562]

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

[@jamesmurdza]

Add commas for multiple emails!

[@kiranbarack2562]

@@jamesmurdza no it's showing the address is already there

[@Ovidiogom009]

Laptm ni el inglés entendí 😢😢