Learn How to Automatically Send Email from Google Sheets

Learn How to Automatically Send Email from Google Sheets | Send Mass Email from Google Sheets

Рет қаралды 65,529

2 жыл бұрын

In this video you will learn how to use the #GoogleSheets to send automatically.
This tutorial will also show you how you can get creative and fully automated way to send multiple email with one go.
Send email from Excel: • How to Send Emails fro...
Sample Template: docs.google.com/spreadsheets/...
Code for code.gs: docs.google.com/document/d/1f...
Code for email.html: docs.google.com/document/d/1z...
Topics Covered:
send mass email from google sheet
how do i send a mass email from google sheets
send email from google sheets
send email from google sheets with attachment
send email from google sheets script
send email from google sheets when cell value changes
send email from google sheets based on cell value
send html email from google sheets
***************************
Subscribe: kzfaq.info?s...
Follow us on Facebook: / exceldose
Website: exceldose.com
Follow us on Instagram: / exceldose

Пікірлер: 70

@user-bo8ex4yi5b 7 ай бұрын

Just amazing ! Thanks a lot

@ExcelDose 7 ай бұрын

🙏Please do not forget to subscribe our channel

@ericdonofrio3869 Жыл бұрын

very helpful, thanks!

@ExcelDose Жыл бұрын

Thank you 🙏

@abhisekgupta_ 2 жыл бұрын

Thank you sooo much!!

@ExcelDose 2 жыл бұрын

You’re welcome 😇

@mahmoudkholif1872 Жыл бұрын

Hello There, your vidoe is amazing and thank you for taking the time to put this code together. the code worked great for me but I was wondering how to add SendReminder button on the Google Sheet like the one you have in yours, please?

@groupgroup-sf3zp Жыл бұрын

😊

@daffaburhan6675 10 ай бұрын

Very helpfull Thanks! Is it automatically send the email based on the time trigger or I have to click send reminder manually everyday?

@ExcelDose 10 ай бұрын

Glad to hear that you like this video. Hope you have subscribed to our channel. If you setup the trigger then it will automatically send an email. No need to click on Reminder manually.

@mariaponcardas9526 Жыл бұрын

Subscribed!

@ExcelDose Жыл бұрын

Thank you!

@mahmoudkholif1872 Жыл бұрын

I was wondering how to add the SendReminder button on the Google Sheet like the one you have in yours, please?

@ExcelDose Жыл бұрын

That will be automatically added or you can add it as ribbon

@rockingraghav499 Жыл бұрын

Hi, Good to see script to send emails automatically which will certainly reduce manual intervention. I'm looking for a script which helps to identify blank cells in a row and send emails to recipient to fill them. Can you please help?

@ExcelDose Жыл бұрын

We have not tried yet but will try and share on our channel

@rockingraghav499 Жыл бұрын

@@ExcelDose Hi. I'm unable to convert date format using utilities service. Can you please help? Actual Out put is Tue Aug 30 17:00:51 GMT+05:30 2022 And when I try to convert it to yyyy-mm-dd format using the utility service, the output I get is gibberish "2022-33-30" Here is the code: var dueDate = sheet.getRange('I:I').getValues(); dueDate = new Date(); dueD = Utilities.formatDate(dueDate, "GMT+05:30", "yyyy-mm-dd");

@23umeshk 6 ай бұрын

Hi, Thanks for making this video. please do let me how to add send reminder button into google sheet. Thanks

@ExcelDose 6 ай бұрын

Hey, click on Insert option and then click on Drawing. Create your button and then assign the script

@followmemose 2 жыл бұрын

I just made a copy of the spreadsheet. I wanted to modify the Email doc. I made a copy of the email.html file and deleted the original. I made some modifications but they did not show up. What line of code do I have to modify either in the code or email file?

@ExcelDose 2 жыл бұрын

Please watch the video I have mentioned which part need to be updated

@followmemose 2 жыл бұрын

@@ExcelDose figured it out... very useful sheet... thank you

@vikranthsaisagar1855 2 жыл бұрын

Hi bro need help to write the reminder count how to capture please help me

@ExcelDose 2 жыл бұрын

Please have a look in shared code

@grandhimithilesh911 Жыл бұрын

Hi ExcelDose, I wish to change the body of the email. How do I add the days overdue and also no of days past the due date and last reminder sent details in the email body? Plz help. If you have any tutorials also you can plz share with me. Thank you.

@ExcelDose Жыл бұрын

Replied to your email.

@christiancebrero8594 Жыл бұрын

@@ExcelDosehi Boss. Can i have the codes for this too. Thank you.

@francisb3623 Жыл бұрын

STEP 1 went to tools but there is no option for script editor.It only shows spelling auto comlete and notification settings

@ExcelDose Жыл бұрын

Let me correct it here. Click on Extension and then you will be able to see

@mittalraghav13 Жыл бұрын

Thanks for this video Is this possible to send the reminders on WhatsApp also Bcoz in today’s time most of the clients easy to communicate on WhatsApp

@ExcelDose Жыл бұрын

So far that is not possible

@vjfsconsultants Жыл бұрын

it is possible but not automatically. for every whatsapp you have to click twice.

@sum8738 11 ай бұрын

Hi, I just created same as you posted. Seems Overdue column have some problems. When I put it of the future date, Overdue column showed -30 days but the system still send email to that user who is not in overdue. Thanks.

@ExcelDose 11 ай бұрын

Ideally it should not happened. I have rechecked the code but it is working fine.

@sum8738 11 ай бұрын

@@ExcelDose are u sure? Did u try the date overdue period that was -30 days? Thx

@vivekjain9846 Жыл бұрын

hi Nice video can u pls guide how to make script for emi due date reminder approx 3 days before

@ExcelDose Жыл бұрын

This is nice suggestion. Will create a video on this topic and share on our channel

@SayafAmer 2 жыл бұрын

Thank you for this amazing video. I created my own google sheet using the same format of yours. Then I edited the codes and run it. It worked, but I didn't receive emails. What should I do?

@ExcelDose 2 жыл бұрын

There could be two major reasons; 1. Email address is not found or it is missing the correct email id. 2. You have choose delay email sent in setting tab.

@SayafAmer 2 жыл бұрын

@@ExcelDose Yes, fixed. I received the emails. The issue was the due date as it was advanced of today.

@ExcelDose 2 жыл бұрын

Good to hear it

@christiancebrero8594 Жыл бұрын

@@ExcelDoseHi boss. May I know how to insert correct email ID and which part in the function based on your code is located the email ID

@yashagarwal672 Жыл бұрын

the code is showing me this error TypeError: Cannot read properties of null (reading 'getLastRow') what do i do

@ExcelDose Жыл бұрын

Checkout our latest video on same. Hope that helps you to resolve this issue

@riiqsot Жыл бұрын

hello sir, error msg > 8:11:23 PM Error Attempted to execute myFunction, but could not save. i made a mistake anywhere?

@ExcelDose Жыл бұрын

Please check the code again as mentioned in video

@imshubhamdas Жыл бұрын

Is it possible to send mail from multiple sheets of one Google sheet file

@ExcelDose Жыл бұрын

That is not possible because reference will be given from one sheet only

@ashutosh5580 10 ай бұрын

TypeError: Cannot read properties of null (reading 'getLastRow') showing this error

@ExcelDose 10 ай бұрын

I have used same code but not getting this error. Can you please recheck this

@syedtaqi7247 Жыл бұрын

How to send pre-filled google form embedded in gmail body

@ExcelDose Жыл бұрын

We have not checked that will check and revert

@rajatdogra96 2 жыл бұрын

How to send same mail with pdf attachment ??

@ExcelDose 2 жыл бұрын

We haven’t tried it yet but will try and share in our video

@christiancebrero3986 Жыл бұрын

I'm unable to send the email due to this error. Could you please advise. Emails Sent The following emails could not be sent:

@ExcelDose Жыл бұрын

this happened when email address is not correct

@moneltse4637 2 жыл бұрын

Thank you for the tutorial! If I want to send the email to person A and want to cc' the email to person B, is there any way to fix the code so that it can cc someone else in the email? Thanks!

@ExcelDose 2 жыл бұрын

We have not tried yet. But will try and share the code if working fine

@vikranthsaisagar1855 2 жыл бұрын

Yes we can fix it using mail function and cc list

@greenpitoonline6430 Жыл бұрын

@@vikranthsaisagar1855 hello can you share di code pleaseee

@christiancebrero8594 Жыл бұрын

@@vikranthsaisagar1855up pls