Google Sheets for sending automatic Birthday Wishes | Malayalam Tutorial 

Check my video on ChatGPT. You can paste the same code in ChatGPT and ask to modify the code for your requirements. It may take some iterations, but you will get the desired result.

😀👍

Welcome 😊

😀👍

😀👍

Thank you

You said that 'Mails were sent'. If there is an issue in receiving mails, the recipient should contact the email service provider. Before that make sure to check the Spam folder.

In the sheet it is showing executed, but in the respective sending mail it is not showing as sent. The receiving side was also not received, chkd in spam also

Thanks for prompt❤

I haven't tested the following code. But I believe it will take care of your requirement. Replace "YOUR_IMAGE_URL" with the URL of your image. function sendBirthdayWishes() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var dataRange = sheet.getDataRange(); var data = dataRange.getValues(); var today = new Date(); var todayDayMonth = today.getDate() + "-" + (today.getMonth() + 1); var imageUrl = "YOUR_IMAGE_URL"; // Replace with the URL of your image for (var i = 1; i < data.length; i++) { if (data[i][0] === '') { continue; // Skip empty rows } var name = data[i][1]; // Adjust column index based on your sheet var dobCell = data[i][2]; // Date of Birth column var dob; if (typeof dobCell === 'object' && dobCell instanceof Date) { dob = dobCell.getDate() + "-" + (dobCell.getMonth() + 1); // Format DD-MM } else if (typeof dobCell === 'string' && dobCell !== '') { var dobParts = dobCell.split("/"); dob = dobParts[0] + "-" + dobParts[1]; // Format DD-MM } else { continue; // Skip rows with invalid or empty Date of Birth } if (dob === todayDayMonth || (dob === "29-2" && (todayDayMonth === "28-2" && !isLeapYear(today.getFullYear())))) { var email = data[i][3]; // Email column var subject = "Happy Birthday " + name + "!"; var message = ` Dear ${name}, Wishing you a very Happy Birthday! Have a fantastic day! Best Regards,[Your Name] `; MailApp.sendEmail({ to: email, subject: subject, htmlBody: message }); } } } function isLeapYear(year) { return ((year % 4 === 0) && (year % 100 !== 0)) || (year % 400 === 0); }

@@XLnCADMalayalam sir, thanku for your reply

My pleasure :)

@xlncad

4 വർഷം ആകുമ്പോഴല്ലേ നിങ്ങൾക്ക് ഒരു വയസ്സ് കൂടുന്നത്. അതുകൊണ്ട് പ്രശ്നമില്ല, അതുപോലെ തന്നെ കൊടുത്താൽ മതിയാകും ☺️

Interesting question! Following code will take care of the people born on February 29. function sendBirthdayWishes() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var dataRange = sheet.getDataRange(); var data = dataRange.getValues(); var today = new Date(); var todayDayMonth = today.getDate() + "-" + (today.getMonth() + 1); for (var i = 1; i < data.length; i++) { if (data[i][0] === '') { continue; // Skip empty rows } var name = data[i][1]; // Adjust column index based on your sheet var dobCell = data[i][2]; // Date of Birth column var dob; if (typeof dobCell === 'object' && dobCell instanceof Date) { dob = dobCell.getDate() + "-" + (dobCell.getMonth() + 1); // Format DD-MM } else if (typeof dobCell === 'string' && dobCell !== '') { var dobParts = dobCell.split("/"); dob = dobParts[0] + "-" + dobParts[1]; // Format DD-MM } else { continue; // Skip rows with invalid or empty Date of Birth } if (dob === todayDayMonth || (dob === "29-2" && (todayDayMonth === "28-2" && !isLeapYear(today.getFullYear())))) { var email = data[i][3]; // Email column var subject = "Happy Birthday " + name + "!"; var message = "Dear " + name + ", Wishing you a very Happy Birthday! Have a fantastic day! Best Regards, [Your Name]"; MailApp.sendEmail(email, subject, message); } } } function isLeapYear(year) { return ((year % 4 === 0) && (year % 100 !== 0)) || (year % 400 === 0); }

Use the following code and see whether it's working or not. You will get detailed logging statements which helps in troubleshooting. You can also take the help of ChatGPT or Gemini for debugging. function sendBirthdayWishes() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var dataRange = sheet.getDataRange(); var data = dataRange.getValues(); var today = new Date(); var todayDayMonth = today.getDate() + "-" + (today.getMonth() + 1); Logger.log("Today's date: " + todayDayMonth); for (var i = 1; i < data.length; i++) { if (data[i][0] === '') { continue; // Skip empty rows } var name = data[i][1]; // Adjust column index based on your sheet var dobCell = data[i][2]; // Date of Birth column var dob; if (typeof dobCell === 'object' && dobCell instanceof Date) { dob = dobCell.getDate() + "-" + (dobCell.getMonth() + 1); // Format DD-MM } else if (typeof dobCell === 'string' && dobCell !== '') { var dobParts = dobCell.split("/"); dob = dobParts[0] + "-" + dobParts[1]; // Format DD-MM } else { Logger.log("Invalid date format or empty Date of Birth for: " + name); continue; // Skip rows with invalid or empty Date of Birth } Logger.log("Checking " + name + " with DOB: " + dob); if (dob === todayDayMonth) { var email = data[i][3]; // Email column Logger.log("Sending email to: " + email); var subject = "Happy Birthday " + name + "!"; var message = "Dear " + name + ", Wishing you a very Happy Birthday! Have a fantastic day! Best Regards, [Your Name]"; MailApp.sendEmail(email, subject, message); Logger.log("Email sent to: " + email); } } }

@@XLnCADMalayalam 💚