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
Пікірлер: 200
@CraftingGems4 жыл бұрын
Thank u very very much.... Now I am able to send mails automatically, and understand Google sheets more clearly.... Keep it up 👍 Excellent 👌👍
@AutomationMadeEasy4 жыл бұрын
Most welcome 😊
@mdahmed18843 жыл бұрын
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.
@fhatuwaniemanuel7672 жыл бұрын
Please forward the code😂😂😩😩😩 I love your work
@DaniLong2 жыл бұрын
What an excellent tutorial. Thank you so much for taking the time to make it. I'm going to build this tomight!
@AutomationMadeEasy2 жыл бұрын
Glad it was helpful!
@catallaxy9 ай бұрын
Wow, you really opened up some new possibilities for me. Thank you.
@AutomationMadeEasy9 ай бұрын
I'm so glad!
@abhishekdas69893 жыл бұрын
Thank you so much.. can you show how to send formatted mail with table
@ruparajakumaripeter12297 ай бұрын
Was very useful. Thank you
@AutomationMadeEasy7 ай бұрын
Glad it was helpful!
@saptarshighosh64494 жыл бұрын
Great explanation! I just tried this and it works. More power to you!
@AutomationMadeEasy4 жыл бұрын
Great to hear!
@TheMegactc2 жыл бұрын
very great explaination. Thumbs up bro
@AutomationMadeEasy2 жыл бұрын
Appreciated
@dm01417 Жыл бұрын
brooooo GOD LEVEL EXPLANATION............. Sensi arigato
@AutomationMadeEasy Жыл бұрын
thank u
@princesitaddisney5 жыл бұрын
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-sh4ow7sn6s7 ай бұрын
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
@AutomationMadeEasy7 ай бұрын
In the tutorial it is explained how certain parts of the message can be replaced.
@swapppy3339 Жыл бұрын
Wonderful explanation
@AutomationMadeEasy Жыл бұрын
Glad it was helpful!
@haribhaskar724 жыл бұрын
Awesome.... Very useful.. I wish to use this to automate daily reminders. Thanks Bro. You are rocking..
@AutomationMadeEasy4 жыл бұрын
Thank you.
@minaldhami7738 Жыл бұрын
Very informative 👍👍
@AutomationMadeEasy Жыл бұрын
Glad it was helpful!
@SAHILKUMAR-ue4cf Жыл бұрын
very helpful
@AutomationMadeEasy Жыл бұрын
Glad you think so!
@11bishnu2 жыл бұрын
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.
@AutomationMadeEasy2 жыл бұрын
Glad it helped
@11bishnu2 жыл бұрын
@@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?
@11bishnu2 жыл бұрын
Also, is there a limit per day for number of emails to be sent?
@AutomationMadeEasy2 жыл бұрын
yes 100 but it can increased with the help of G-Suite license
@JozuaOshea2 жыл бұрын
@@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
@ReigneChannel2 жыл бұрын
What if i want to send a pre-designed email? Not the plain looking emails? Is there a way?
@faheemabas3 жыл бұрын
Great work, Can u please copy the script in the description or provide a downloadable link of this script?
@paulguerra48863 жыл бұрын
It would help a lot avoiding miswriting
@mokshadham7 ай бұрын
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
@hermonburger71434 жыл бұрын
Good day, I have used this video to set up automatic email. Is it possible to attach on this system as well?
@alimaster52924 жыл бұрын
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?
@pavanmuttepawar56963 жыл бұрын
Thank You 🙏
@AutomationMadeEasy3 жыл бұрын
Welcome!
@rbm3072 жыл бұрын
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
@dayanecosta76523 жыл бұрын
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.
@AutomationMadeEasy3 жыл бұрын
Glad I could help!
@mdahmed18843 жыл бұрын
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.
@supportcadmacro10573 жыл бұрын
Thanks for video...and it shows reference error
@AutomationMadeEasy3 жыл бұрын
at which line are u getting the error?
@Kurtcorp5 жыл бұрын
That's a great video thank you
@mdahmed18843 жыл бұрын
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.
@SepiaMN3 жыл бұрын
Is possible to change fonts and make some areas *bold* ?? Thanksss
@rajeshkumarr14243 жыл бұрын
really helpful . how to send table to automatic mail
@AutomationMadeEasy3 жыл бұрын
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
@doctorlewis97794 жыл бұрын
this is mad crazy amazing
@AutomationMadeEasy4 жыл бұрын
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
@joniedeltolentino16363 жыл бұрын
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 how to send a Google sheet like this
@user-uo2qz6yn9v8 ай бұрын
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!
@AutomationMadeEasy8 ай бұрын
below tutorial will provide guidelines for your requirement. kzbin.info/www/bejne/pYnMfIyPq8aknNU If you need customized solution write into info@automationandagile.com
@hondaxblade21274 жыл бұрын
Thank you 😍😍
@AutomationMadeEasy4 жыл бұрын
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
@tituchauhan60275 жыл бұрын
Is there any script to send Pivot table on mail body and data as attachment from google sheet?
@AutomationMadeEasy5 жыл бұрын
Well its possible to do that. Will soon create a tutorial around it.
@tituchauhan60275 жыл бұрын
@@AutomationMadeEasy Thanks for your fast reply and waiting for proper reply against my query.
@rajeshkumarr14243 жыл бұрын
waiting for that
@anirudhkannan910 ай бұрын
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.
@sojuelpsicologia39343 жыл бұрын
Very very helpful
@AutomationMadeEasy3 жыл бұрын
Glad to hear that
@nileshphalke23652 жыл бұрын
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?
@paulguerra48863 жыл бұрын
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?
@ramakrishnahare4 жыл бұрын
great thnks its wrking. want to attach pdf file please upload
@princesitaddisney4 жыл бұрын
hello, My signature is not in the email, Could you please show us how the script can add the signature?
@SepiaMN3 жыл бұрын
kzbin.info/www/bejne/mWi2YWBprZ6bfNk add a file attach
@SahilSingh-dj8iu3 жыл бұрын
Thanks man appreciate u
@AutomationMadeEasy3 жыл бұрын
Happy to help
@GP-ty8ix5 жыл бұрын
Hi Automation Made Easy how would you send an attachment document such as resume in this code ?!?!?!
@AutomationMadeEasy5 жыл бұрын
Will upload a tutorial for the same
@gaspardzhou28594 жыл бұрын
Really helpful contents! can you also do a video showing how to automatically send customized mails from MULTIPLE sender addresses to ONE receipient address
@AutomationMadeEasy4 жыл бұрын
seems to be an invalid scenario.
@MoneyModels2 жыл бұрын
Pretty cool!
@AutomationMadeEasy2 жыл бұрын
thank you
@royalgati2 жыл бұрын
Can we give the range instead of cell when fetching the values.
@elmahtutnaser83293 жыл бұрын
great thnks its wrking
@AutomationMadeEasy3 жыл бұрын
You're welcome!
@Saywhatohno2 жыл бұрын
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] }"
@AutomationMadeEasy2 жыл бұрын
it will only send emails from id you are logged in. For error I need to see your code.
@prasadhingankar78662 жыл бұрын
In line 3 type error cannot read property getsheetbyname of null, please suggest
@AutomationMadeEasy2 жыл бұрын
check spelling of sheet name
@tambolisadik3 ай бұрын
getting error file.next() is not function help me
@SurferBro10002 жыл бұрын
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?
@AutomationMadeEasy2 жыл бұрын
it is but will need lot of customization.
@nuggethunter1013 жыл бұрын
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
@AutomationMadeEasy3 жыл бұрын
not feasible
@MrDonald9112 жыл бұрын
@@AutomationMadeEasy It is feasible but you need to send html and you need a server. Basically requires programming knowledge
@davidsteinberg25453 жыл бұрын
ReferenceError: wrkBK is not defined (line 4, file "Code")? What is that error?
@AutomationMadeEasy3 жыл бұрын
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.
@ankishtirpude63643 жыл бұрын
Thanks 👍
@AutomationMadeEasy3 жыл бұрын
No problem 👍
@tavarwhyte7973 Жыл бұрын
Can you use a next loop instead of for loop
@AutomationMadeEasy Жыл бұрын
any loop shall work
@akshilmy3 жыл бұрын
Great !
@AutomationMadeEasy3 жыл бұрын
thnx
@shwanabraimhassan8706 Жыл бұрын
thanks, can i have the script please
@bossthumb33563 жыл бұрын
Hi sir can you make a video on how to make no reply automation email
@UmeshDube-cy4po2 ай бұрын
If my email should be sent based on today's date then how it can be possible
@AutomationMadeEasy2 ай бұрын
you just need current date of content also based on dates?
@maelstrom573 жыл бұрын
Thanks a lot! :)
@AutomationMadeEasy3 жыл бұрын
You're welcome!
@Dharmendrakumar-zj6cp4 жыл бұрын
Thanks
@AutomationMadeEasy4 жыл бұрын
Your welcome
@JourneyThroughNature3 жыл бұрын
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?
@AutomationMadeEasy3 жыл бұрын
only from the account you have logged in
@JourneyThroughNature3 жыл бұрын
@@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 .
@shamialbasharprothoy49083 жыл бұрын
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.
@AutomationMadeEasy3 жыл бұрын
Use below code: MailApp.sendEmail(emailAddress, subject, finalmsg,{name:'Your name'})
@rastam20015 жыл бұрын
If I want to attach a PDF what would be the command line?
@AutomationMadeEasy5 жыл бұрын
Tutorial for attachments coming soon.
@deyobaleyo819211 ай бұрын
How about in facebook? Please
@nikhilsingh-te8hn3 жыл бұрын
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-te8hn3 жыл бұрын
solved it by replacing, MailApp to GmailApp in code
@AutomationMadeEasy3 жыл бұрын
great..
@akpadmini3 жыл бұрын
I used a ocr and just corrected it
@fayzkm76664 жыл бұрын
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
@AutomationMadeEasy4 жыл бұрын
Its a restirction imposed by Google.
@bhartisingh8789 Жыл бұрын
I got an error "Google has not verified this app" how to resolve it?
@marks49823 жыл бұрын
How do I get this to send an email to a group that I've made in Google Contacts.
@AutomationMadeEasy3 жыл бұрын
will create a tutorial
@Kishan840984 жыл бұрын
Thanks God, I have already read a little Python, otherwise nothing is understood.
@udaykumar69283 жыл бұрын
TypeError: Cannot read property 'getRange' of null help me with this error !
@AutomationMadeEasy3 жыл бұрын
the error indicates you are trying to read a blank cell. Check the loop indexes.
@Kishan840984 жыл бұрын
❤️❤️
@gopalsasda31553 жыл бұрын
Bro please send code link I can copy it's and editing it
@nxmo3 жыл бұрын
can You make an Pastebin for the Code please
@sarss2313 жыл бұрын
Could you share the script?!
@hondaxblade21274 жыл бұрын
Please tell how to send HTML email template instead of message that you show in your video Please answer 🤗
@AutomationMadeEasy4 жыл бұрын
will have to check. Do not have a solution on the top of my head.
@noorhiryanirosli3 жыл бұрын
does this spreadsheets work with outlook as well?
@AutomationMadeEasy3 жыл бұрын
nopes
@deepakgautam69042 жыл бұрын
It is Java Script or VBA
@AutomationMadeEasy2 жыл бұрын
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.
@zacharoni28304 жыл бұрын
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?
@AutomationMadeEasy4 жыл бұрын
You will need an upgraded G-Suite license
@vyfvfyvyy4 жыл бұрын
@@AutomationMadeEasy how do we upgrade it? to which package and what is the maximum emails with the upgraded package?
@preyaspatel31353 жыл бұрын
I have a one more error Exception: Failed to send email: no recipient MailApp.sendEmail(emailAddress, subject, finalmsg) in this line
@AutomationMadeEasy3 жыл бұрын
as the error suggests it is unable to find a valid email id. check variable emailAddress.
@preyaspatel31353 жыл бұрын
@@AutomationMadeEasy its shows error but its works I do not know how
@AutomationMadeEasy3 жыл бұрын
it must be throwing an error when it mut be reacjing a blankcell check your loop.
@preyaspatel31353 жыл бұрын
i have an error ReferenceError: SpreadsheeApp is not defined (line 2, file "Code")
@AutomationMadeEasy3 жыл бұрын
't' is missing in SpreadsheetApp
@preyaspatel31353 жыл бұрын
@@AutomationMadeEasy Thanks a lot for the correction
@ScorpionGuzel2 жыл бұрын
Can you give source code please🥺
@uttamsingh67052 жыл бұрын
Bro keep codes links too
@JozuaOshea2 жыл бұрын
Hi Sir, can you do one that goes through HTML format? Thank you
@AutomationMadeEasy2 жыл бұрын
refer below tutorial for including html kzbin.info/www/bejne/a5zciJR5Z81qrZo
@JozuaOshea2 жыл бұрын
@@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.
@printfaastchennai61203 жыл бұрын
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);
@AutomationMadeEasy3 жыл бұрын
check emailAddress variable value
@Kishan840984 жыл бұрын
That script is Something like the python script... I thing...
@AutomationMadeEasy4 жыл бұрын
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
@motomavrick70553 жыл бұрын
Hey bro is it possible to talk with you by any how. Then please notify me.
@AutomationMadeEasy3 жыл бұрын
write into info@automationandagile.com
@motomavrick70553 жыл бұрын
@@AutomationMadeEasy thanx bro.
@mdahmed18843 жыл бұрын
@@AutomationMadeEasy I cannot resolve an error, I have sent a mail regarding the error details, please help me sir.