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.

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

[@dm01417]

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

[@AutomationMadeEasy]

thank u

[@TheMegactc]

very great explaination. Thumbs up bro

[@AutomationMadeEasy]

Appreciated

[@saptarshighosh6449]

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

[@AutomationMadeEasy]

Great to hear!

[@ReigneChannel]

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

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

[@salsaproductions5859]

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

[@ruparajakumaripeter1229]

Was very useful. Thank you

[@AutomationMadeEasy]

Glad it was helpful!

[@IsabelleFandke]

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.

[@abhishekdas6989]

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

[@hermonburger7143]

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

[@fhatuwaniemanuel767]

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

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

[@SepiaMN]

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

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

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

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

[@andrielsilva6543]

Very very very THANKS

[@AutomationMadeEasy]

ur 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.

[@moisesruedarivero8795]

Excelent

[@AutomationMadeEasy]

thnx

[@royalgati]

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

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

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

[@JenniferAllen-b8s]

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]

[@SAHILKUMAR-ue4cf]

very helpful

[@AutomationMadeEasy]

Glad you think so!

[@TranHongAnh-w7h]

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.

[@alimaster5292]

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

[@tavarwhyte7973]

Can you use a next loop instead of for loop

[@AutomationMadeEasy]

any loop shall work

[@pavanmuttepawar5696]

Thank You 🙏

[@AutomationMadeEasy]

Welcome!

[@nileshphalke2365]

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

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

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

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

[@sojuelpsicologia3934]

Very very helpful

[@AutomationMadeEasy]

Glad to hear that

[@supportcadmacro1057]

Thanks for video...and it shows reference error

[@AutomationMadeEasy]

at which line are u getting the error?

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

[@mokshadham]

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

[@bamideleadedamola4309]

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

[@prasadhingankar7866]

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

[@AutomationMadeEasy]

check spelling of sheet name

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

[@mdfarhan0203]

thank you bro

[@AutomationMadeEasy]

Welcome

[@MoneyModels]

Pretty cool!

[@AutomationMadeEasy]

thank you

[@elmahtutnaser8329]

great thnks its wrking

[@AutomationMadeEasy]

You're welcome!

[@doctorlewis9779]

this is mad crazy amazing

[@AutomationMadeEasy]

thank u

[@SahilSingh-dj8iu]

Thanks man appreciate u

[@AutomationMadeEasy]

Happy to help

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

[@federicabelfiore880]

I keep getting the message: TypeError:Cannot read property'getRange' of null( line 7,file "Code"). Can you please help me with this?

[@AutomationMadeEasy]

in the loop you must be reaching a blank cell because of which you may be getting that error.

[@pranavvangari3708]

I have the same problem what do I do Automation made Easy? There isn't anything wrong with my cells because I set them right.

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

[@rajeshkumarr1424]

really helpful . how to send table to automatic mail

[@AutomationMadeEasy]

Will upload soon

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

[@davidsteinberg2545]

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

[@AutomationMadeEasy]

share ur code

[@rastam2001]

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

[@AutomationMadeEasy]

Tutorial for attachments coming soon.

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

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

[@noorhiryanirosli]

does this spreadsheets work with outlook as well?

[@AutomationMadeEasy]

nopes

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

[@hondaxblade2127]

Thank you 😍😍

[@AutomationMadeEasy]

You're welcome 😊

[@kbj1-f2s]

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!

[@shwanabraimhassan8706]

thanks, can i have the script please

[@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'})

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

[@tambolisadik]

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

[@bossthumb3356]

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

[@maelstrom57]

Thanks a lot! :)

[@AutomationMadeEasy]

You're welcome!

[@deyobaleyo8192]

How about in facebook? Please

[@bhartisingh8789]

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

[@ankishtirpude6364]

Thanks 👍

[@AutomationMadeEasy]

No problem 👍

[@akshilmy]

Great !

[@AutomationMadeEasy]

thnx

[@gopalsasda3155]

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

[@sarss231]

Could you share the script?!

[@deepakgautam6904]

It is Java Script or VBA

[@AutomationMadeEasy]

neither. its google app script

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

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

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

[@ramakrishnahare]

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

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

[@nxmo]

can You make an Pastebin for the Code 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..

[@Kishan84098]

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

[@Dharmendrakumar-zj6cp]

Thanks

[@AutomationMadeEasy]

Your welcome

[@ScorpionGuzel]

Can you give source code please🥺

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

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

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

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

[@lijojose9104]

Hi Can I get the source code

[@AutomationMadeEasy]

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

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

[@akpadmini]

I used a ocr and just corrected it

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

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

[@Kishan84098]

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

[@AutomationMadeEasy]

its Google App Script

[@ashishkumarsingh3970]

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

[@Kishan84098]

❤️❤️

[@uttamsingh6705]

Bro keep codes links too

[@chinmoydas8541]

Hey Can you send me that script to my gmail?

[@praveshsingh8255]

getting this error--Syntax error: SyntaxError: Invalid left-hand side expression in postfix operation line: 8 file: Pravesh.gs