Guest User

Untitled

a guest
Oct 22nd, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. var SEARCH_QUERY = 'label:Inbox is:unread from:cotizar@todo.com.ar subject:Formulario ';
  2.  
  3. // Credit: https://gist.github.com/oshliaer/70e04a67f1f5fd96a708
  4.  
  5. function getEmails_(q) {
  6. var emails = [];
  7. var threads = GmailApp.search(q);
  8. for (var i in threads) {
  9. var msgs = threads[i].getMessages();
  10. for (var j in msgs) {
  11. emails.push([msgs[j].getBody().replace(/<.*?>/g,' ','/')
  12. ]);
  13. }
  14. }
  15. return emails;
  16. }
  17. function appendData_(sheet, array2d) {
  18. sheet.getRange(sheet.getLastRow() + 1, 1, array2d.length, array2d[0].length).setValues(array2d);
  19. }
  20. function run(){
  21. var array2d = getEmails_(SEARCH_QUERY);
  22. if (array2d) {
  23. var ss = SpreadsheetApp.openById("1c52lPT8oEu-lPloYu_n- apCWiTQgeYP7Wz9cdK2I3w");
  24. Logger.log(ss.getName());
  25. var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Potenciales');
  26. if (sheet != null) {
  27. Logger.log(sheet.getIndex());
  28. appendData_(SpreadsheetApp.getActiveSheet(), array2d);
  29. }
  30. markArchivedAsRead ();
  31. }
  32. function markArchivedAsRead() {
  33. var threads = GmailApp.search('label:Inbox is:unread from:cotizar@todo.com.ar subject:Formulario ');
  34. GmailApp.markThreadsRead(threads);
  35. }
  36. }
  37.  
  38. function getEmails_(q) {
  39. var emails = [];
  40. var threads = GmailApp.search(q);
  41. var messages = threads[0].getMessages();
  42.  
  43. for (var i = 0; i < messages.length; i++) {
  44. /*Solamente si es no leído lo incluimos en el array*/
  45. if(messages[i].isUnread()){
  46. emails.push([messages[i].getSubject()]);
  47. }
  48. }
  49. return emails;
  50. }
Add Comment
Please, Sign In to add comment