Guest User

Untitled

a guest
Nov 17th, 2017
409
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.80 KB | None | 0 0
  1. function readCell() {
  2. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  3. var sheet1 = ss1.getSheetByName("AutoMail");
  4. var operationgain1 = sheet1.getRange("C2:C46").getValue();
  5. var operationpurchase1 = sheet1.getRange("D2:D46").getValue();
  6. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  7. var sheet2 = ss2.getSheetByName("YourData");
  8. var coin1 = sheet2.getRange("B3");
  9. var amount1 = sheet2.getRange("B4");
  10. if(operationgain1="gain position") sendEmail(operationgain1);
  11. function sendEmail(operationgain1) {
  12. var email = "adrian@semeniuk.biz";
  13. var subject = "Your "+amount1+" "+coin1+" are somewhere in gain position.";
  14. var body = "Keep an eye on your "+coin1+"s, they're goin' up.";
  15. MailApp.sendEmail(email,subject,body);}
  16. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  17. var sheet1 = ss1.getSheetByName("AutoMail");
  18. var operationgain2 = sheet1.getRange("E2:E46").getValue();
  19. var operationpurchase2 = sheet1.getRange("F2:F46").getValue();
  20. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  21. var sheet2 = ss2.getSheetByName("YourData");
  22. var coin2 = sheet2.getRange("C3");
  23. var amount2 = sheet2.getRange("C4");
  24. if(operationgain2="gain position") sendEmail(operationgain2);
  25. function sendEmail(operationgain2) {
  26. var email = "adrian@semeniuk.biz";
  27. var subject = "Your "+amount2+" "+coin2+" are somewhere in gain position.";
  28. var body = "Keep an eye on your "+coin2+"s, they're goin' up.";
  29. MailApp.sendEmail(email,subject,body);}
  30. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  31. var sheet1 = ss1.getSheetByName("AutoMail");
  32. var operationgain3 = sheet1.getRange("G2:G46").getValue();
  33. var operationpurchase3 = sheet1.getRange("H2:H46").getValue();
  34. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  35. var sheet2 = ss2.getSheetByName("YourData");
  36. var coin3 = sheet2.getRange("D3");
  37. var amount3 = sheet2.getRange("D4");
  38. if(operationgain3="gain position") sendEmail(operationgain3);
  39. function sendEmail(operationgain3) {
  40. var email = "adrian@semeniuk.biz";
  41. var subject = "Your "+amount3+" "+coin3+" are somewhere in gain position.";
  42. var body = "Keep an eye on your "+coin3+"s, they're goin' up.";
  43. MailApp.sendEmail(email,subject,body);}
  44. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  45. var sheet1 = ss1.getSheetByName("AutoMail");
  46. var operationgain4 = sheet1.getRange("I2:I46").getValue();
  47. var operationpurchase4 = sheet1.getRange("J2:J46").getValue();
  48. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  49. var sheet2 = ss2.getSheetByName("YourData");
  50. var coin4 = sheet2.getRange("E3");
  51. var amount4 = sheet2.getRange("E4");
  52. if(operationgain4="gain position") sendEmail(operationgain4);
  53. function sendEmail(operationgain4) {
  54. var email = "adrian@semeniuk.biz";
  55. var subject = "Your "+amount4+" "+coin4+" are somewhere in gain position.";
  56. var body = "Keep an eye on your "+coin4+"s, they're goin' up.";
  57. MailApp.sendEmail(email,subject,body);}
  58. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  59. var sheet1 = ss1.getSheetByName("AutoMail");
  60. var operationgain5 = sheet1.getRange("K2:K46").getValue();
  61. var operationpurchase5 = sheet1.getRange("L2:L46").getValue();
  62. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  63. var sheet2 = ss2.getSheetByName("YourData");
  64. var coin5 = sheet2.getRange("F3");
  65. var amount5 = sheet2.getRange("F4");
  66. if(operationgain5="gain position") sendEmail(operationgain5);
  67. function sendEmail(operationgain5) {
  68. var email = "adrian@semeniuk.biz";
  69. var subject = "Your "+amount5+" "+coin5+" are somewhere in gain position.";
  70. var body = "Keep an eye on your "+coin5+"s, they're goin' up.";
  71. MailApp.sendEmail(email,subject,body);}
  72. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  73. var sheet1 = ss1.getSheetByName("AutoMail");
  74. var operationgain6 = sheet1.getRange("M2:M46").getValue();
  75. var operationpurchase6 = sheet1.getRange("N2:N46").getValue();
  76. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  77. var sheet2 = ss2.getSheetByName("YourData");
  78. var coin6 = sheet2.getRange("G3");
  79. var amount6 = sheet2.getRange("G4");
  80. if(operationgain6="gain position") sendEmail(operationgain6);
  81. function sendEmail(operationgain6) {
  82. var email = "adrian@semeniuk.biz";
  83. var subject = "Your "+amount6+" "+coin6+" are somewhere in gain position.";
  84. var body = "Keep an eye on your "+coin6+"s, they're goin' up.";
  85. MailApp.sendEmail(email,subject,body);}
  86. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  87. var sheet1 = ss1.getSheetByName("AutoMail");
  88. var operationgain7 = sheet1.getRange("O2:O46").getValue();
  89. var operationpurchase7 = sheet1.getRange("P2:P46").getValue();
  90. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  91. var sheet2 = ss2.getSheetByName("YourData");
  92. var coin7 = sheet2.getRange("H3").getValue();
  93. var amount7 = sheet2.getRange("H4").getValue();
  94. if(operationgain7="gain position") sendEmail(operationgain7);
  95. function sendEmail(operationgain7) {
  96. var email = "adrian@semeniuk.biz";
  97. var subject = "Your "+amount7+" "+coin7+" are somewhere in gain position.";
  98. var body = "Keep an eye on your "+coin7+"s, they're goin' up.";
  99. MailApp.sendEmail(email,subject,body);}
  100. };
  101.  
  102. function readCell() {
  103. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  104. var sheet1 = ss1.getSheetByName("AutoMail");
  105. var operationgain = sheet1.getRange("O2:O46").getValues(); // Modified
  106. var operationpurchase = sheet1.getRange("P2:P46").getValues(); // Modified
  107. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  108. var sheet2 = ss2.getSheetByName("YourData");
  109. var coin = sheet2.getRange("H3").getValue(); // Modified
  110. var amount = sheet2.getRange("H4").getValue(); // Modified
  111.  
  112. // Below script was added.
  113. var email, subject, body
  114. if (~Array.prototype.concat.apply([], operationgain).indexOf("gain position")) {
  115. email = "//my email here//";
  116. subject = "Your " + amount + " " + coin + " are somewhere in gain position.";
  117. body = "Keep an eye on your " + coin + "s, they're goin' up.";
  118. }
  119. if (~Array.prototype.concat.apply([], operationpurchase).indexOf("purchase position")) {
  120. email = "//my email here//";
  121. subject = "Purchase position for your " + amount + " " + coin + " somewhere there!";
  122. body = "Your " + coin + "s might be about to be sold, give them a look.";
  123. }
  124. if (email && subject && body) MailApp.sendEmail(email,subject,body);
  125. };
  126.  
  127. function readCell() {
  128. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  129. var sheet1 = ss1.getSheetByName("AutoMail");
  130. var operationgain1 = sheet1.getRange("C2:C46").getValue();
  131. var operationpurchase1 = sheet1.getRange("D2:D46").getValue();
  132. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  133. var sheet2 = ss2.getSheetByName("YourData");
  134. var coin1 = sheet2.getRange("B3");
  135. var amount1 = sheet2.getRange("B4");
  136. if(operationgain1="gain position") sendEmail(operationgain1);
  137. function sendEmail(operationgain1) {
  138. var email = "adrian@semeniuk.biz";
  139. var subject = "Your "+amount1+" "+coin1+" are somewhere in gain position.";
  140. var body = "Keep an eye on your "+coin1+"s, they're goin' up.";
  141. MailApp.sendEmail(email,subject,body);}
  142. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  143. var sheet1 = ss1.getSheetByName("AutoMail");
  144. var operationgain2 = sheet1.getRange("E2:E46").getValue();
  145. var operationpurchase2 = sheet1.getRange("F2:F46").getValue();
  146. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  147. var sheet2 = ss2.getSheetByName("YourData");
  148. var coin2 = sheet2.getRange("C3");
  149. var amount2 = sheet2.getRange("C4");
  150. if(operationgain2="gain position") sendEmail(operationgain2);
  151. function sendEmail(operationgain2) {
  152. var email = "adrian@semeniuk.biz";
  153. var subject = "Your "+amount2+" "+coin2+" are somewhere in gain position.";
  154. var body = "Keep an eye on your "+coin2+"s, they're goin' up.";
  155. MailApp.sendEmail(email,subject,body);}
  156. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  157. var sheet1 = ss1.getSheetByName("AutoMail");
  158. var operationgain3 = sheet1.getRange("G2:G46").getValue();
  159. var operationpurchase3 = sheet1.getRange("H2:H46").getValue();
  160. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  161. var sheet2 = ss2.getSheetByName("YourData");
  162. var coin3 = sheet2.getRange("D3");
  163. var amount3 = sheet2.getRange("D4");
  164. if(operationgain3="gain position") sendEmail(operationgain3);
  165. function sendEmail(operationgain3) {
  166. var email = "adrian@semeniuk.biz";
  167. var subject = "Your "+amount3+" "+coin3+" are somewhere in gain position.";
  168. var body = "Keep an eye on your "+coin3+"s, they're goin' up.";
  169. MailApp.sendEmail(email,subject,body);}
  170. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  171. var sheet1 = ss1.getSheetByName("AutoMail");
  172. var operationgain4 = sheet1.getRange("I2:I46").getValue();
  173. var operationpurchase4 = sheet1.getRange("J2:J46").getValue();
  174. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  175. var sheet2 = ss2.getSheetByName("YourData");
  176. var coin4 = sheet2.getRange("E3");
  177. var amount4 = sheet2.getRange("E4");
  178. if(operationgain4="gain position") sendEmail(operationgain4);
  179. function sendEmail(operationgain4) {
  180. var email = "adrian@semeniuk.biz";
  181. var subject = "Your "+amount4+" "+coin4+" are somewhere in gain position.";
  182. var body = "Keep an eye on your "+coin4+"s, they're goin' up.";
  183. MailApp.sendEmail(email,subject,body);}
  184. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  185. var sheet1 = ss1.getSheetByName("AutoMail");
  186. var operationgain5 = sheet1.getRange("K2:K46").getValue();
  187. var operationpurchase5 = sheet1.getRange("L2:L46").getValue();
  188. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  189. var sheet2 = ss2.getSheetByName("YourData");
  190. var coin5 = sheet2.getRange("F3");
  191. var amount5 = sheet2.getRange("F4");
  192. if(operationgain5="gain position") sendEmail(operationgain5);
  193. function sendEmail(operationgain5) {
  194. var email = "adrian@semeniuk.biz";
  195. var subject = "Your "+amount5+" "+coin5+" are somewhere in gain position.";
  196. var body = "Keep an eye on your "+coin5+"s, they're goin' up.";
  197. MailApp.sendEmail(email,subject,body);}
  198. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  199. var sheet1 = ss1.getSheetByName("AutoMail");
  200. var operationgain6 = sheet1.getRange("M2:M46").getValue();
  201. var operationpurchase6 = sheet1.getRange("N2:N46").getValue();
  202. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  203. var sheet2 = ss2.getSheetByName("YourData");
  204. var coin6 = sheet2.getRange("G3");
  205. var amount6 = sheet2.getRange("G4");
  206. if(operationgain6="gain position") sendEmail(operationgain6);
  207. function sendEmail(operationgain6) {
  208. var email = "adrian@semeniuk.biz";
  209. var subject = "Your "+amount6+" "+coin6+" are somewhere in gain position.";
  210. var body = "Keep an eye on your "+coin6+"s, they're goin' up.";
  211. MailApp.sendEmail(email,subject,body);}
  212. var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  213. var sheet1 = ss1.getSheetByName("AutoMail");
  214. var operationgain7 = sheet1.getRange("O2:O46").getValue();
  215. var operationpurchase7 = sheet1.getRange("P2:P46").getValue();
  216. var ss2 = SpreadsheetApp.getActiveSpreadsheet();
  217. var sheet2 = ss2.getSheetByName("YourData");
  218. var coin7 = sheet2.getRange("H3").getValue();
  219. var amount7 = sheet2.getRange("H4").getValue();
  220. if(operationgain7="gain position") sendEmail(operationgain7);
  221. function sendEmail(operationgain7) {
  222. var email = "adrian@semeniuk.biz";
  223. var subject = "Your "+amount7+" "+coin7+" are somewhere in gain position.";
  224. var body = "Keep an eye on your "+coin7+"s, they're goin' up.";
  225. MailApp.sendEmail(email,subject,body);}
  226. };
Add Comment
Please, Sign In to add comment