How to automatically send customized mails from Gmail

In this tutorial we would be learning:
1. How to automatically send emails from Gmail using Google spreadsheets
2. How to schedule emails from Gmail.
3. How to set up triggers in Google script

[@CraftingGems]

Thank u very very much.... Now I am able to send mails automatically, and understand Google sheets more clearly.... Keep it up 👍 Excellent 👌👍

[@AutomationMadeEasy]

Most welcome 😊

[@mdahmed1884]

Please provide the code in text file, so others who are facing issues due to small mistakes can be helped. You can out it in Google Drive and share the link. It would helpful. Thanks in advance.

[@fhatuwaniemanuel767]

Please forward the code😂😂😩😩😩 I love your work

[@DaniLong]

What an excellent tutorial. Thank you so much for taking the time to make it. I'm going to build this tomight!

[@AutomationMadeEasy]

Glad it was helpful!

[@catallaxy]

Wow, you really opened up some new possibilities for me. Thank you.

[@AutomationMadeEasy]

I'm so glad!

[@abhishekdas6989]

Thank you so much.. can you show how to send formatted mail with table

[@ruparajakumaripeter1229]

Was very useful. Thank you

[@AutomationMadeEasy]

Glad it was helpful!

[@saptarshighosh6449]

Great explanation! I just tried this and it works. More power to you!

[@AutomationMadeEasy]

Great to hear!

[@TheMegactc]

very great explaination. Thumbs up bro

[@AutomationMadeEasy]

Appreciated

[@dm01417]

brooooo GOD LEVEL EXPLANATION............. Sensi arigato

[@AutomationMadeEasy]

thank u

[@princesitaddisney]

That's for the video :) it is possible to show us how to create a design email like some mail of chimpmail. To add pictures and a nice police? tks

[@user-sh4ow7sn6s]

Hi! This is a super great tutorial! Thank you so much! It opened up new ways of working for me (and I usually don't code). I have a question, How do I replace 2 parts of the message? I want to individualize in the message a) a product name b) a date Thank you very much

[@AutomationMadeEasy]

In the tutorial it is explained how certain parts of the message can be replaced.

[@swapppy3339]

Wonderful explanation

[@AutomationMadeEasy]

Glad it was helpful!

[@haribhaskar72]

Awesome.... Very useful.. I wish to use this to automate daily reminders. Thanks Bro. You are rocking..

[@AutomationMadeEasy]

Thank you.

[@minaldhami7738]

Very informative 👍👍

[@AutomationMadeEasy]

Glad it was helpful!

[@SAHILKUMAR-ue4cf]

very helpful

[@AutomationMadeEasy]

Glad you think so!

[@11bishnu]

Just Wow! very well explained. I just tried and it works. Fabulous work! You have saved tons of my time. Keep creating content like this.

[@AutomationMadeEasy]

Glad it helped

[@11bishnu]

@@AutomationMadeEasy There is one minor problem, the email texts are wrapped and using many lines in stead of few lines as there seems a limitation on the length of the lines. Can it be fixed?

[@11bishnu]

Also, is there a limit per day for number of emails to be sent?

[@AutomationMadeEasy]

yes 100 but it can increased with the help of G-Suite license

[@JozuaOshea]

@@11bishnu I was facing that too. Took a day to figure out but still can’t. I was trying to use a ready made html format, but it’s too complex for me and I can’t seem to run it

[@ReigneChannel]

What if i want to send a pre-designed email? Not the plain looking emails? Is there a way?

[@faheemabas]

Great work, Can u please copy the script in the description or provide a downloadable link of this script?

[@paulguerra4886]

It would help a lot avoiding miswriting

[@mokshadham]

This is so cool, are you able to copy the code in your description please, thank you!

[@andrielsilva6543]

Very very very THANKS

[@AutomationMadeEasy]

ur welcome

[@hermonburger7143]

Good day, I have used this video to set up automatic email. Is it possible to attach on this system as well?

[@alimaster5292]

I don't have total Bill lol just want to send simple message to a batch of people every month

[@bamideleadedamola4309]

Awesome!!! Please what if I want to copy someone on the email?

[@pavanmuttepawar5696]

Thank You 🙏

[@AutomationMadeEasy]

Welcome!

[@rbm307]

Hi and thank you for sharing. I had no idea of this functionality. I am trying to grab emails from the body of an email and then generate an auto reply to them. I was wondering if you had something that you could send me. Thank you so much!

[@moisesruedarivero8795]

Excelent

[@AutomationMadeEasy]

thnx

[@mdfarhan0203]

thank you bro

[@AutomationMadeEasy]

Welcome

[@dayanecosta7652]

Hello. Your video makes me to build a sistem to help me in the days. I so gratefull. I can control some routines easyly after this video. E-mails have sent automatic way. From Brasil.

[@AutomationMadeEasy]

Glad I could help!

[@mdahmed1884]

Please provide the code in text file, so others who are facing issues due to small mistakes can be helped. You can out it in Google Drive and share the link. It would helpful. Thanks in advance.

[@supportcadmacro1057]

Thanks for video...and it shows reference error

[@AutomationMadeEasy]

at which line are u getting the error?

[@Kurtcorp]

That's a great video thank you

[@mdahmed1884]

Please provide the code in text file, so others who are facing issues due to small mistakes can be helped. You can out it in Google Drive and share the link. It would helpful. Thanks in advance.

[@SepiaMN]

Is possible to change fonts and make some areas *bold* ?? Thanksss

[@rajeshkumarr1424]

really helpful . how to send table to automatic mail

[@AutomationMadeEasy]

Will upload soon

[@pritam4622]

HIi it is helpful information.....Can we customize the trigger date also from the google sheet .. means different sending dates for different customers..

[@AutomationMadeEasy]

well triggers along with some custom code shall be helpful to achieve it

[@doctorlewis9779]

this is mad crazy amazing

[@AutomationMadeEasy]

thank u

[@lildbooo7421]

I need to sending 4-5 music files on every email but i gotta adding them from ma desktop to every email. So you already showed everything i need but adding some mp3 files to every email. Somebody help me wit dat please

[@joniedeltolentino1636]

This is a great video! I would like to know if it is possible to send the other tab as a pdf attachment instead? and if it is possible to send it to a specific email only?

[@AutomationMadeEasy]

refer below tutorial: kzbin.info/www/bejne/mWi2YWBprZ6bfNk

[@sridharsri23]

@@AutomationMadeEasy how to send a Google sheet like this

[@user-uo2qz6yn9v]

My message has several hyperlinks and bold text. What is the code for maintaining them? I also would like to add bullets but need the code for that too. Many thanks!

[@AutomationMadeEasy]

below tutorial will provide guidelines for your requirement. kzbin.info/www/bejne/pYnMfIyPq8aknNU If you need customized solution write into [e-mail]

[@hondaxblade2127]

Thank you 😍😍

[@AutomationMadeEasy]

You're welcome 😊

[@mv00889]

How do I style the mail content, this way only a simple text is being sent. I want to bold certain words and colour some others. Can you tell me how to do that

[@tituchauhan6027]

Is there any script to send Pivot table on mail body and data as attachment from google sheet?

[@AutomationMadeEasy]

Well its possible to do that. Will soon create a tutorial around it.

[@tituchauhan6027]

@@AutomationMadeEasy Thanks for your fast reply and waiting for proper reply against my query.

[@rajeshkumarr1424]

waiting for that

[@anirudhkannan9]

Hi, is there any way to cleanly include a link in the email body? I don't want to put the link in the body text in the Excel/Google Sheet cell because the link looks ugly and isn't clickable. You have to copy and paste it manually, which is really slow. Is there any way to solve this?

[@user-si9pj3gc5s]

i have a question. i want to send email with the receiver's name repeating in the body. could you help my write a syntax for it

[@AutomationMadeEasy]

you could have place holders in the mail body and replace the place holder with the actual name in the script. In the tutorial it is explained how we can replace text.

[@sojuelpsicologia3934]

Very very helpful

[@AutomationMadeEasy]

Glad to hear that

[@nileshphalke2365]

How to add Images with this email, I mean different inline images for each recipient

[@salsaproductions5859]

Is there a way to put the firstname in the subject?

[@paulguerra4886]

If they don't want to keep receiving the MESSAGES, is there a way to put a link button in order to automatically make them, by clicking, stop the messages?

[@ramakrishnahare]

great thnks its wrking. want to attach pdf file please upload

[@princesitaddisney]

hello, My signature is not in the email, Could you please show us how the script can add the signature?

[@SepiaMN]

kzbin.info/www/bejne/mWi2YWBprZ6bfNk add a file attach

[@SahilSingh-dj8iu]

Thanks man appreciate u

[@AutomationMadeEasy]

Happy to help

[@GP-ty8ix]

Hi Automation Made Easy how would you send an attachment document such as resume in this code ?!?!?!

[@AutomationMadeEasy]

Will upload a tutorial for the same

[@gaspardzhou2859]

Really helpful contents! can you also do a video showing how to automatically send customized mails from MULTIPLE sender addresses to ONE receipient address

[@AutomationMadeEasy]

seems to be an invalid scenario.

[@MoneyModels]

Pretty cool!

[@AutomationMadeEasy]

thank you

[@royalgati]

Can we give the range instead of cell when fetching the values.

[@elmahtutnaser8329]

great thnks its wrking

[@AutomationMadeEasy]

You're welcome!

[@Saywhatohno]

Amaazing Video!!! What if you have 2 email accounts and you want to send the email from a different email account? Currently it uses the default one I am also getting an error, in my email subject and body it shows " function () { [native code] }"

[@AutomationMadeEasy]

it will only send emails from id you are logged in. For error I need to see your code.

[@prasadhingankar7866]

In line 3 type error cannot read property getsheetbyname of null, please suggest

[@AutomationMadeEasy]

check spelling of sheet name

[@tambolisadik]

getting error file.next() is not function help me

[@SurferBro1000]

Great video! But I wonder if it is possible to automatically send an email when I receive a specific email? Is there a specific trigger that I need to use?

[@AutomationMadeEasy]

it is but will need lot of customization.

[@nuggethunter101]

This seems like a nice tutorial! I am trying to automate my bulk email sending task for my business. I have a question, is it possible to track those emails? like i want to know if my emails were opened or not

[@AutomationMadeEasy]

not feasible

[@MrDonald911]

@@AutomationMadeEasy It is feasible but you need to send html and you need a server. Basically requires programming knowledge

[@davidsteinberg2545]

ReferenceError: wrkBK is not defined (line 4, file "Code")? What is that error?

[@AutomationMadeEasy]

share ur code

[@ShyamPrathap]

I am unable to see script editor in tools ? ,How to take it further..

[@AutomationMadeEasy]

UI has changed a bit. Go to 'Extensions' menu. there you will find option for App script.

[@ankishtirpude6364]

Thanks 👍

[@AutomationMadeEasy]

No problem 👍

[@tavarwhyte7973]

Can you use a next loop instead of for loop

[@AutomationMadeEasy]

any loop shall work

[@akshilmy]

Great !

[@AutomationMadeEasy]

thnx

[@shwanabraimhassan8706]

thanks, can i have the script please

[@bossthumb3356]

Hi sir can you make a video on how to make no reply automation email

[@UmeshDube-cy4po]

If my email should be sent based on today's date then how it can be possible

[@AutomationMadeEasy]

you just need current date of content also based on dates?

[@maelstrom57]

Thanks a lot! :)

[@AutomationMadeEasy]

You're welcome!

[@Dharmendrakumar-zj6cp]

Thanks

[@AutomationMadeEasy]

Your welcome

[@JourneyThroughNature]

Hey - i have a query, if in your Gmail account you have set up send/receive using diff mail accounts can we make this pick one of those email id than the default gmail?

[@AutomationMadeEasy]

only from the account you have logged in

[@JourneyThroughNature]

@@AutomationMadeEasy yeah - I tried to set the default ID as different and sent but it went from the default one itself. But nevertheless very handy video. I expanded to add conditional check and also setting a flag when mail Is already sent .

[@shamialbasharprothoy4908]

Hey thanks a lot. I have a question, when the mails are being sent why is my name not appearing ,instead my gmail address is being shown.

[@AutomationMadeEasy]

Use below code: MailApp.sendEmail(emailAddress, subject, finalmsg,{name:'Your name'})

[@rastam2001]

If I want to attach a PDF what would be the command line?

[@AutomationMadeEasy]

Tutorial for attachments coming soon.

[@deyobaleyo8192]

How about in facebook? Please

[@nikhilsingh-te8hn]

Thanks for the great video. But I need urgent help. I am trying to solve it from past 1 hour but couldn't find the solution. In your example email you can see that the word "charges" is going to next line but I want it to be next to "fee". Is there a way to solve it? Thanks.

[@nikhilsingh-te8hn]

solved it by replacing, MailApp to GmailApp in code

[@AutomationMadeEasy]

great..

[@akpadmini]

I used a ocr and just corrected it

[@fayzkm7666]

It's giving error exceed maximum execution time. Can u help me with a coding for extending the 4-5 minutes of run time to 30 minutes

[@AutomationMadeEasy]

Its a restirction imposed by Google.

[@bhartisingh8789]

I got an error "Google has not verified this app" how to resolve it?

[@marks4982]

How do I get this to send an email to a group that I've made in Google Contacts.

[@AutomationMadeEasy]

will create a tutorial

[@Kishan84098]

Thanks God, I have already read a little Python, otherwise nothing is understood.

[@udaykumar6928]

TypeError: Cannot read property 'getRange' of null help me with this error !

[@AutomationMadeEasy]

the error indicates you are trying to read a blank cell. Check the loop indexes.

[@Kishan84098]

❤️❤️

[@gopalsasda3155]

Bro please send code link I can copy it's and editing it

[@nxmo]

can You make an Pastebin for the Code please

[@sarss231]

Could you share the script?!

[@hondaxblade2127]

Please tell how to send HTML email template instead of message that you show in your video Please answer 🤗

[@AutomationMadeEasy]

will have to check. Do not have a solution on the top of my head.

[@noorhiryanirosli]

does this spreadsheets work with outlook as well?

[@AutomationMadeEasy]

nopes

[@deepakgautam6904]

It is Java Script or VBA

[@AutomationMadeEasy]

neither. its google app script

[@mclarrenmanalili3882]

What if emailing 200 Gmail in a second? What happen to my account?

[@AutomationMadeEasy]

there are limitations around the maximum emails which can be sent in a day. If you want to increase the limit you may need to purchase google workspace license.

[@zacharoni2830]

I tried this and it works but google is limiting me to only being allowed to send 20 emails at once. I need to send 1,717 emails. Is there any way to bypass this?

[@AutomationMadeEasy]

You will need an upgraded G-Suite license

[@vyfvfyvyy]

@@AutomationMadeEasy how do we upgrade it? to which package and what is the maximum emails with the upgraded package?

[@preyaspatel3135]

I have a one more error Exception: Failed to send email: no recipient MailApp.sendEmail(emailAddress, subject, finalmsg) in this line

[@AutomationMadeEasy]

as the error suggests it is unable to find a valid email id. check variable emailAddress.

[@preyaspatel3135]

@@AutomationMadeEasy its shows error but its works I do not know how

[@AutomationMadeEasy]

it must be throwing an error when it mut be reacjing a blankcell check your loop.

[@preyaspatel3135]

i have an error ReferenceError: SpreadsheeApp is not defined (line 2, file "Code")

[@AutomationMadeEasy]

't' is missing in SpreadsheetApp

[@preyaspatel3135]

@@AutomationMadeEasy Thanks a lot for the correction

[@ScorpionGuzel]

Can you give source code please🥺

[@uttamsingh6705]

Bro keep codes links too

[@JozuaOshea]

Hi Sir, can you do one that goes through HTML format? Thank you

[@AutomationMadeEasy]

refer below tutorial for including html kzbin.info/www/bejne/a5zciJR5Z81qrZo

[@JozuaOshea]

@@AutomationMadeEasy thank you for replying. How about changing the font and formatting of the automated email? I tried it and the paragraphing is weird, cuts halfway.

[@printfaastchennai6120]

Help me out. I am getting this error in my automation. I tried my level best and couldn't correct it. Please support. 7:42:35 PM Error Exception: Failed to send email: no recipient sendMails @ Code.gs:19 MailApp.sendEmail(emailAddress, subject, finalmsg);

[@AutomationMadeEasy]

check emailAddress variable value

[@Kishan84098]

That script is Something like the python script... I thing...

[@AutomationMadeEasy]

its Google App Script

[@lijojose9104]

Hi Can I get the source code

[@AutomationMadeEasy]

most of code is available on blog automationandagile under google sheets menu

[@nikoskorakas7662]

Well done! Is it possible to somehow attach pdf files automatically in the emails?

[@AutomationMadeEasy]

yes just refer to the next tutorial in the playlist

[@motomavrick7055]

Hey bro is it possible to talk with you by any how. Then please notify me.

[@AutomationMadeEasy]

write into [e-mail]

[@motomavrick7055]

@@AutomationMadeEasy thanx bro.

[@mdahmed1884]

@@AutomationMadeEasy I cannot resolve an error, I have sent a mail regarding the error details, please help me sir.

[@ashishkumarsingh3970]

How we can add signature in it plz tell me..