Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function readCell() {
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain1 = sheet1.getRange("C2:C46").getValue();
- var operationpurchase1 = sheet1.getRange("D2:D46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin1 = sheet2.getRange("B3");
- var amount1 = sheet2.getRange("B4");
- if(operationgain1="gain position") sendEmail(operationgain1);
- function sendEmail(operationgain1) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount1+" "+coin1+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin1+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain2 = sheet1.getRange("E2:E46").getValue();
- var operationpurchase2 = sheet1.getRange("F2:F46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin2 = sheet2.getRange("C3");
- var amount2 = sheet2.getRange("C4");
- if(operationgain2="gain position") sendEmail(operationgain2);
- function sendEmail(operationgain2) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount2+" "+coin2+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin2+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain3 = sheet1.getRange("G2:G46").getValue();
- var operationpurchase3 = sheet1.getRange("H2:H46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin3 = sheet2.getRange("D3");
- var amount3 = sheet2.getRange("D4");
- if(operationgain3="gain position") sendEmail(operationgain3);
- function sendEmail(operationgain3) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount3+" "+coin3+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin3+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain4 = sheet1.getRange("I2:I46").getValue();
- var operationpurchase4 = sheet1.getRange("J2:J46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin4 = sheet2.getRange("E3");
- var amount4 = sheet2.getRange("E4");
- if(operationgain4="gain position") sendEmail(operationgain4);
- function sendEmail(operationgain4) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount4+" "+coin4+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin4+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain5 = sheet1.getRange("K2:K46").getValue();
- var operationpurchase5 = sheet1.getRange("L2:L46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin5 = sheet2.getRange("F3");
- var amount5 = sheet2.getRange("F4");
- if(operationgain5="gain position") sendEmail(operationgain5);
- function sendEmail(operationgain5) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount5+" "+coin5+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin5+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain6 = sheet1.getRange("M2:M46").getValue();
- var operationpurchase6 = sheet1.getRange("N2:N46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin6 = sheet2.getRange("G3");
- var amount6 = sheet2.getRange("G4");
- if(operationgain6="gain position") sendEmail(operationgain6);
- function sendEmail(operationgain6) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount6+" "+coin6+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin6+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain7 = sheet1.getRange("O2:O46").getValue();
- var operationpurchase7 = sheet1.getRange("P2:P46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin7 = sheet2.getRange("H3").getValue();
- var amount7 = sheet2.getRange("H4").getValue();
- if(operationgain7="gain position") sendEmail(operationgain7);
- function sendEmail(operationgain7) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount7+" "+coin7+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin7+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- };
- function readCell() {
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain = sheet1.getRange("O2:O46").getValues(); // Modified
- var operationpurchase = sheet1.getRange("P2:P46").getValues(); // Modified
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin = sheet2.getRange("H3").getValue(); // Modified
- var amount = sheet2.getRange("H4").getValue(); // Modified
- // Below script was added.
- var email, subject, body
- if (~Array.prototype.concat.apply([], operationgain).indexOf("gain position")) {
- email = "//my email here//";
- subject = "Your " + amount + " " + coin + " are somewhere in gain position.";
- body = "Keep an eye on your " + coin + "s, they're goin' up.";
- }
- if (~Array.prototype.concat.apply([], operationpurchase).indexOf("purchase position")) {
- email = "//my email here//";
- subject = "Purchase position for your " + amount + " " + coin + " somewhere there!";
- body = "Your " + coin + "s might be about to be sold, give them a look.";
- }
- if (email && subject && body) MailApp.sendEmail(email,subject,body);
- };
- function readCell() {
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain1 = sheet1.getRange("C2:C46").getValue();
- var operationpurchase1 = sheet1.getRange("D2:D46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin1 = sheet2.getRange("B3");
- var amount1 = sheet2.getRange("B4");
- if(operationgain1="gain position") sendEmail(operationgain1);
- function sendEmail(operationgain1) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount1+" "+coin1+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin1+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain2 = sheet1.getRange("E2:E46").getValue();
- var operationpurchase2 = sheet1.getRange("F2:F46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin2 = sheet2.getRange("C3");
- var amount2 = sheet2.getRange("C4");
- if(operationgain2="gain position") sendEmail(operationgain2);
- function sendEmail(operationgain2) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount2+" "+coin2+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin2+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain3 = sheet1.getRange("G2:G46").getValue();
- var operationpurchase3 = sheet1.getRange("H2:H46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin3 = sheet2.getRange("D3");
- var amount3 = sheet2.getRange("D4");
- if(operationgain3="gain position") sendEmail(operationgain3);
- function sendEmail(operationgain3) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount3+" "+coin3+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin3+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain4 = sheet1.getRange("I2:I46").getValue();
- var operationpurchase4 = sheet1.getRange("J2:J46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin4 = sheet2.getRange("E3");
- var amount4 = sheet2.getRange("E4");
- if(operationgain4="gain position") sendEmail(operationgain4);
- function sendEmail(operationgain4) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount4+" "+coin4+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin4+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain5 = sheet1.getRange("K2:K46").getValue();
- var operationpurchase5 = sheet1.getRange("L2:L46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin5 = sheet2.getRange("F3");
- var amount5 = sheet2.getRange("F4");
- if(operationgain5="gain position") sendEmail(operationgain5);
- function sendEmail(operationgain5) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount5+" "+coin5+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin5+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain6 = sheet1.getRange("M2:M46").getValue();
- var operationpurchase6 = sheet1.getRange("N2:N46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin6 = sheet2.getRange("G3");
- var amount6 = sheet2.getRange("G4");
- if(operationgain6="gain position") sendEmail(operationgain6);
- function sendEmail(operationgain6) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount6+" "+coin6+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin6+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- var ss1 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss1.getSheetByName("AutoMail");
- var operationgain7 = sheet1.getRange("O2:O46").getValue();
- var operationpurchase7 = sheet1.getRange("P2:P46").getValue();
- var ss2 = SpreadsheetApp.getActiveSpreadsheet();
- var sheet2 = ss2.getSheetByName("YourData");
- var coin7 = sheet2.getRange("H3").getValue();
- var amount7 = sheet2.getRange("H4").getValue();
- if(operationgain7="gain position") sendEmail(operationgain7);
- function sendEmail(operationgain7) {
- var email = "adrian@semeniuk.biz";
- var subject = "Your "+amount7+" "+coin7+" are somewhere in gain position.";
- var body = "Keep an eye on your "+coin7+"s, they're goin' up.";
- MailApp.sendEmail(email,subject,body);}
- };
Add Comment
Please, Sign In to add comment