Script for Auto Mailing
//CONFIGURATION const CONFIG = { // Google Sheets ID SHEET_ID : '' , SHEET_NAME : '' , // Google Docs template ID (your admit card template) TEMPLATE_DOC_ID : '' , // Your email details SENDER_NAME : 'IAF' , EMAIL_SUBJECT : 'Your Admit Card' , // Google Drive folder to save PDFs PDF_FOLDER_NAME : 'Admit Cards 2025' }; // ====================== MAIN PROCESS ====================== // Process all students in the sheet function processAllStudents () { try { console . log ( 'Starting admit card generation...' ); const sheet = SpreadsheetApp . openById ( CONFIG . SHEET_ID ). getSheetByName ( CONFIG . SHEET_NAME ); const data = sheet . getDataRange (). getValues (); const headers = data [ 0 ]; const pdfFolder = getPdfFolder (); let successCount = 0 ; let errorCount = 0 ; for ( let i = 1 ; ...