Google Form Leave Approval System with Auto Email, Attachments & Manager Action Buttons Google Form Leave Approval System with Auto Email, Attachments & Manager Action Buttons This tutorial shows how to automate leave request approvals using Google Forms, Google Sheets, and Apps Script. Trigger auto emails on form submit CC manager with in-email action buttons Update status in Google Sheet 🧾 Google Form Structure Create a Google Form with the following fields: Full Name Email ID Manager Email ID Leave Type Start Date End Date Duration Reason 📊 Google Sheet Columns After linking your form to Google Sheets, add 3 columns: Status – Manager’s decision Approve Link Reject Link ⚙️ Apps Script Setup Open your linked Sheet → Extensions > Apps Script and paste the following code: ...

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...