Get Alert Mails on Expiry | Google Sheets Malayalam Tutorial 

Code for generating mails with Alert messages function checkExpiry() { // Set current time before performing other tasks var currentTime = new Date(); var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); sheet.getRange("L3").setValue(currentTime); var lastRow = sheet.getLastRow(); var expiredValues = []; // Array to store expired values var expiringSoonValues = []; // Array to store expiring soon values for (var i = 4; i 0 || expiringSoonValues.length > 0) { var recipientEmail = 'yourmail@xlncad.com'; // Replace with your actual email address var subject = 'Notification from Google Sheet'; var message = ""; if (expiredValues.length > 0) { var expiredMessage = "Expired Items: " + expiredValues.join(", "); message += '1: ' + expiredMessage + " "; } if (expiringSoonValues.length > 0) { var expiringSoonMessage = "Items Expiring soon: " + expiringSoonValues.join(", "); message += '2: ' + expiringSoonMessage; } MailApp.sendEmail(recipientEmail, subject, message); } }

Perfect. ഇതെപോലുള്ള സർവീസ് തരുന്നത്തിന് പ്രത്യക നന്ദി അറിയിക്കുന്നു

Ur the best👍👍👍 നിങ്ങളെ വിഡിയോ കണ്ട് ഞമ്മളെ കാര്യങ്ങൾ എല്ലാം നമ്മൾ ചെയ്യാറുണ്ട് Google sheet lover 🌹

thank you sir... nice tutorial

Very good narration...

Appreciated!! thanks for sharing

You are great in this. Love ❤

Perfect Thank you for the amazing content

Very useful video. Thanks 🙏🏼

Thank you again for a beautifully simple explanation 🙏

Great sir 😊

Sir.Appreciations and Thanks. Highly useful utility. Looking more going ahead

Very informative video.

Done. Ignore previous message. Thank you so much

Worth watching ❤

Google sheets related videos iniyum ponnotte👍😍

As always, it's a very good class sir !

try cheydu its working. very helpful

Good explanation. Nice content.

Car rental income and expence salary or video cheyyo

Alerts via whatsapp nadaukumo

Very good video. Thanks. I don't use outlook. What is the code to get email alert from my gmail account?

എന്റെ google mailൽ message വരുന്നില്ല... Execution കറക്ടായി നടക്കുന്നുണ്ട്,permission നും കറക്ടായി കൊടുത്തു.എന്താ കാര്യമെന്ന് മനസ്സിലാകുന്നില്ല.

How to send alerts as HTML Mail (Table structure with coloured rows/columns)

nice

Function EDATE parameter 1 expects number values. But '17-04-2024' is a text and cannot be coerced to a number.

നിങ്ങളുടെ equations കൊടുത്തപ്പോൾ expiry ആൻഡ് expiring soon ഇത് രണ്ടും വരുന്നുണ്ട് പക്ഷെ blank ആയ കോളങ്ങളിൽ expired എന്നാണ് കാണിക്കുന്നത്. ഇത് എങ്ങനെ ഒഴിവാക്കാം?

Automatic message alert setup cheythathinu shesham, oronnum renew cheythaal athil update cheythathinu shesham Run kodukkano

i have tried by copying your code and made necessary changes and ran the programme; successful, but one one item is shown in the mail every time. why?

Small business vendi koodi cheyumallo

11:03:20 PM Notice Execution started 11:03:21 PM Notice Execution completed___________ but no mail coming. alreadychanged the mail address

Enik excel expert level padikkanam A2z padikkanam enda vayi step by step class undo

In Status column, valid ayathinu active enn engane add cheyyum?

Not able to get notufications in email.

Google sheet open ചെയ്യാതെ പുതിയ items, date ഒക്കെ add ചെയ്യാനും, നിലവിൽ ഉണ്ടായിരുന്നത് renew ചെയ്യുമ്പോൾ അത് update ചെയ്യാനും കൂടെ ഇതിൽ add ചെയ്യാൻ പറ്റുമോ?? Google form pole ഏതെങ്കിലും സർവീസ് ഉപയോഗിച്ച്?

Extensions tab engana add cheyyunnath

👍

Sir Ithe Microsoft Excel le cheythe outlook l connect cheyan pattumo.

Suggestion Only: =IF(E4

How can I trigger a separate email for each item whenever an item got expired.

Can we use Edate formula to find the expiry date within days. Like for tender 15 days time is given, to find whether it is expired or not, can we use Edate formula?

Function EDATE parameter 1 expects number values. But '14/08/2023' is a text and cannot be coerced to a number. INGANE ERROR VARUNNU

Is this available in Excel? I don't use Google sheets.

Google sheet on the computer is not free. Can we get free

search bar option cheyyyamo?

Ithu sms aayi cheyyan pattumo

Ith Excel il cheyyan pattumo

Power B I seperate course undo?

Can i join for ur course online?

Hai sir How to add cell reference between contiguous data?

How to write code

💗👌

12.56 il 2 cell add akiyappol day left enna column thil -45424 ennu kanaam... Adh varaaradhirikkaan endhanu cheyyendadh

WHEN CLICKING EXTENSION , PAGE IS NOT OPENING AND SHOWING AS BAD REQUEST ERROR 400, IT WORKS ONLY IN INDIA?

If the "Months" is Date, How to Write the Code

Hi Sir Function EDATE parameter 1 expects number values. But '21/04/2023' is a text and cannot be coerced to a number. show in expiry date calculation what is the issue?

എന്റെ google mailൽ message വരുന്നില്ല... Execution കറക്ടായി നടക്കുന്നുണ്ട്,permission നും കറക്ടായി കൊടുത്തു.എന്താ കാര്യമെന്ന് മനസ്സിലാകുന്നില്ല.