Posts

Image
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: ...
Post a Comment
Read more
Image
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...
Post a Comment
Read more
Image
Automate Google Sheets Task Tracker with Apps Script ✅ Automate Task Completion in Google Sheets Using Apps Script Welcome to Scripted Success Master ! In this step-by-step guide, you’ll learn how to: Create a task management system in Google Sheets Automatically move completed tasks to a separate sheet Track completion date and calculate TAT (Turnaround Time) Use Google Apps Script to power it all 🧱 Step 1: Create the Google Sheet Structure Sheet 1: Task List Rename the first sheet to Task List and create the following columns: ℹ️ Use Data Validation (Dropdown) in the Status column for values like: Not yet Started , WIP , Completed Sheet 2: Completed Tasks Create a new sheet and rename it to Completed Tasks . Add these headers: Column Header Note A Sr No From Task List B Task Description From Task List C Start Date From Task List D Priority From Task List E Status...
Post a Comment
Read more