Google Sheets Automation - Email On Basis Of Cell Value

Make your googles sheet automated, send auto email basis on cell value in just less then 5 min

#excelmind #excel mind #excel #msexcel #exceltips #exceltutorial #exceltricks #excelformula #excelsupport #msexcelfullcourse #msexceltricks #msexceltutorial #Inputbox #xlookup #hlookup #index #match #formula #excelfunctions #mergedcell #combinecell #training #tutorial #excelsolution #excelshortcuts #knowledge #trending #youtuber #youtubechannel #excel365 #microsoftexcel #microsoftexceltutorial #dashboard #autoemail #lambda #formual #googlesheets
#basic #gmail #pivot #googleapps #googlesheetsautomation #automation #trend #performance #lockcell #exceldashboard #transcript #hindi #hinditraining #excelhindi #msexcelhindi #cell #cellvalue #button #excelproctect #vlookup #excellock #excelprivacy #youtubechannel #youtuber #trending #dynamiclookup #index #indexmatch #shortcut #earnmoneyonline #targetline #scrollable #datatable #msgbox #vba #cc #html #c++ #print #button #printvba #inventory #inventorymanagementsystem #stockmanagement #autoemail #trending #outlook

[davidtierney]

Im having trouble getting this to work - it works with value 0 but I need the value to be 3 to send the email - any help would be much appreciated - i have done this

for (var i = 3; i < lastRow; i++) {
if (values[i][3] === 3 && emailSent[i][3] !== "SENT") { //

[danielcerdeira]

Awesome! Thats exactly what I was looking for!! Tks!!! Its working here!

[excxmoody]

Is there a way after email is sent to receiver, when receiver emails back, based on either email content or attachment, its no longer considering stock for example as empty. Based on key words? Use to use a whiteboard but someone recently mentioned auto follow up, which love the idea but don't wish to have it spamming receiver after certain requirements sent back. If possible...have to figure out other times to stretch.

[ewilner]

I have emails that some need to go out weekly and some monthly. can you help me set this up and how much would it cost?

[khcscij]

Great video, is there a way to trigger an email if the quantity gets below a certain threshold. For example, I would set a Minimum Quantity on D2 and On Hand Quantity on C2. I have created an equation that creates a "0" or "1" value on column P using "=IF(C2<D2, "0", "1")" but I'm guessing the script does not recognize that equation as a numerical value which is why it doesn't send the email.

[crusader]

Great video, I am looking for an Email alert if cell change color, I have portfolio sheet with stock with it's weightage, I want alert if weightage changes to specific percentage range.

[yosemitejml]

If there were email addresses listed in column [B] which are specific to the stock name where emails would be sent to rather than sending to one email address coded in the script, how would you amend the script to reference the corresponding email address in column [B] for the value that changes to 0?

[nickmontanari]

This is fun but only works if the cell is manually changed which makes this not very practical. I was hoping that when a cell changes because of a formula checking if a todays date has passed another date, it would produce 0 but that doesnt tripper this code and a google search appears to indicate therea no code based on formula changing a cell.

[im_pavan]

Hi,

can you make the same automation send email to multiple email address automatically

[BrandonRayClark]

I'm having trouble getting the Reminder email "SENT" prompt to populate. When I run the code it says successful, but i'm not getting any emails. Any suggestions?

[ElizavetaErmolenko]

How can I send different cell values to different emails listed in column A, for example? I need this to send people their results on test.

[BikashDas-dfwf]

Hi suppose I need automation mail for every edit that is more then zero in stock in hand column. Is it possible?

[DianaBarnuevo]

Hi ! I tried it and yes it is working but it only show the value of i2 .

[SouravGhoshkulti]

If Cell value<-2.5 or >2.5, then i need the email. Plz do the needful changes in
for (var i =0; i < lastRow; i++) {
if (values[i](0) === 0 && email sent[i](0) !== "SENT") {

[sehbirk]

Having a little issue with this line
4:27:19 PM Error
TypeError: Cannot read properties of null (reading 'getRange')

var range = sheet.getRange("L:L"); // Replace "C:C" with the range of your column

Does everything look right? Any help is appreciated