Send Birthday Email Reminders using Google Sheets & Apps Script Send Automatic Birthday Reminders using Google Sheets & Google Apps Script This tutorial shows you how to use Google Sheets and Apps Script to send automatic email reminders for birthdays — be it for friends, family, or office colleagues. A scheduled trigger will run daily and send beautiful HTML emails when a birthday matches today's date! 📋 Step 1: Setup Google Sheet Create a new Google Sheet and name it Birthday Reminder Tracker . Use the following structure: Column Details Sr No 1 Name Jane Doe Birthday 1995-06-28 Email janedoe@email.com Reminder Time (HH:MM) 09:00 Last Sent (empty) Reminder Time: This lets you define when to send the mail (in 24-hour format like 08:30 or 17:45). Last Sent: This column will be updated automatically to avoid duplicate mails. 💻 Step 2: Add Google Apps Script Click Extensions → Apps Script Clear any default code Pas...