How To Trigger Emails From Check Box Ticks | Google App Script | Send Bulk emails

Buy Now : dashboard.stripe.com/payment-...
This video shows how you can trigger automatic emails from google sheets using a check box in the Google Sheets.
If code do not work watch this : • How To Create OnEdit()...
- Please also create a onedit trigger or let me know if u need help on it
#googlesheets #googleappsscript #appscript #googlesheetstips #automations #gmail #emailautomation

[@itsbrex]

Great video! I've setup similar sheets in the past using checkbox event triggers as well. 👏🏼

[@DataInNutShell]

Thanks, yea its really usefull

[@kaptanjay26]

This video is very helpful for me from Thailand.❤

[@DataInNutShell]

Thanks

[@yeasinsanny425]

function onEdit(e) { var row = e.range.getRow(); var value = e.value; var sheet = e.range.getSheet(); switch (value) { case "TRUE": var to = sheet.getRange(`A${row}`).getValues()[0][0]; var subject = sheet.getRange(`B${row}`).getValues()[0][0]; var emailBody = `${sheet.getRange(`C${row}`).getValues()[0][0]}RegardsName`; MailApp.sendEmail({to, subject, htmlBody: emailBody}); break; default: // Do nothing break; } } there alternative code performance are very good

[@dimitrisvoudouris]

wonderful work

[@DataInNutShell]

Thanks for the visit

[@mohcinemarzaq4547]

Thanks veryyyyyy much 😁😁😁🙏🙏👍👍👍❤️❤️

[@DataInNutShell]

welcome

[@Babfernandez]

TypeError: Cannot read properties of undefined (reading 'range')

[@TilakConrad]

Hi - just to say I found my stupid mistake - I hadn't set the trigger - super - thanks very much

[@DataInNutShell]

nothing is stupid, its just a milestone 😬🤟🏻

[@jasmineboomy]

Thanks for video, mine isn't working though! Are you supposed to copy script exactly like yours or add more details? where you have written "row" do we fill with row number? Confused!!

[@DataInNutShell]

share ur sheet with edit access once : [e-mail]

[@user-sn6xo2uj5m]

Greate! amazing video, kindly request you, provide the sheet access

[@DataInNutShell]

done

[@user-zy6ui4xr4x]

Hey this will work on checkbox but I want to do this same as on dropdown list cant it work

[@DataInNutShell]

yes it can work but with some customizations in code

[@user-zy6ui4xr4x]

@@DataInNutShell can you provide me the customized code

[@DaniloNunez-vj8cd]

sent you an email! I tried to adjust this to my specific sheet but I'm waiting errors.

[@DataInNutShell]

replied you over email please check once

[@anandadsul1826]

Hey, tried this. Not working with me for some reason.

[@DataInNutShell]

Can you share the screenshot : [e-mail]

[@DataInNutShell]

I have provided view access of the sheet, pls make a copy and try.

[@mdjahidulislamsaimon8869]

my script showing error which i was unable to fix.

[@DataInNutShell]

Hi , can you give me your sheet access at [e-mail] also the error screenshot

[@user-vj7ry5lb1l]

Hi, I've tried this, this script not working in my sheet. Getting this type of error - TypeError: Cannot read properties of undefined (reading 'range.'). Please help

[@DataInNutShell]

pls share me ur copy link at : [e-mail]

[@DataInNutShell]

Hi Piyush, Apologies for late reply, I tried the script using your sheet, I am getting email , pls check your gmail's sent section, I have received it. Let me know where exactly you are getting the error

[@imjustzoee1320]

Hey, I am having the same issue as well. Also, do I need to identify the sheet because I have a large database, with about 10+ linking sheets...

[@DataInNutShell]

@@imjustzoee1320 I have checked the as of now it is working, If possible pls give me a copy of your sheet and will check

[@vinodkumar-np8nq]

​@@DataInNutShellgetting the same error

[@dimitrisvoudouris]

great, but it won't send my emails

[@DataInNutShell]

tou can send me screenshot snd i hope u r making copy of my sheet and using it as is, bz there are some hidden cells for reference calc, If taking only code then it might nt wrk due to absence of those references

[@richielcana9991]

/I cant access the codes

[@DataInNutShell]

Request for access from share button will give u a view access and then you can create your own copy

[@TilakConrad]

Hi, Thanks very much for this - I'm a noob and your style of teaching is superb. I have a problem - not sure why - the appscript was all cut and paste - BUT - this is the error I get i.imgur.com/p6iGgUp.png hope you can advice what I'm doing wrong. Thanks very much

[@DataInNutShell]

Apology for late reply, if its not resolved yet then can u pls gve me the sheet link once with edit access