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

Рет қаралды 54,513

2 жыл бұрын

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/

Пікірлер: 35

@labocuphealthlabourreahab Жыл бұрын

Many thanks for your excellent video and lesson! 😊❤

@fratrisilva Жыл бұрын

Thank you for this! This was truly very helpful!

@jamesmurdza Жыл бұрын

You are welcome!

@moniquecatipon489 4 ай бұрын

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

@jamesmurdza 4 ай бұрын

Of course, thank you! 😁

@mrigankverma3179 Күн бұрын

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

@michaelc8192 11 ай бұрын

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

@krraman2005 3 ай бұрын

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 2 ай бұрын

I'll try to make a video on this. If you need help in the meantime, send an email to me@jamesmurdza.com.

@user-wr9dh6yv1o 5 күн бұрын

Hi . I need help

@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 6 ай бұрын

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

@wanmeireles7182 6 ай бұрын

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

@joannaemma1877 7 ай бұрын

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

@donmustard9020 10 ай бұрын

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 3 ай бұрын

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. kzfaq.info/get/bejne/ip2CnLmq1bLSqHU.html

@BM-xu2ci 9 ай бұрын

How to get attacment for the sheet ?

@thephischmann 9 ай бұрын

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 9 ай бұрын

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

@karylzoeubalde 4 ай бұрын

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

@jamesmurdza 2 ай бұрын

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

@user-rd7tr6gf7w 4 ай бұрын

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

@jamesmurdza 2 ай бұрын

Hi, can you send me an email to me@jamesmurdza.com?

@ChaitanyaMankar99 5 ай бұрын

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

@jamesmurdza 5 ай бұрын

Something like this? kzfaq.info/get/bejne/pdGXequomtq7k2Q.html

@user-cm7wb5mq3d 6 ай бұрын

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

@jamesmurdza 6 ай бұрын

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 6 ай бұрын

@@jamesmurdza thanks so much!

@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: kzfaq.info/get/bejne/pdGXequomtq7k2Q.html