Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var SEARCH_QUERY = 'label:Inbox is:unread from:cotizar@todo.com.ar subject:Formulario ';
- // Credit: https://gist.github.com/oshliaer/70e04a67f1f5fd96a708
- function getEmails_(q) {
- var emails = [];
- var threads = GmailApp.search(q);
- for (var i in threads) {
- var msgs = threads[i].getMessages();
- for (var j in msgs) {
- emails.push([msgs[j].getBody().replace(/<.*?>/g,' ','/')
- ]);
- }
- }
- return emails;
- }
- function appendData_(sheet, array2d) {
- sheet.getRange(sheet.getLastRow() + 1, 1, array2d.length, array2d[0].length).setValues(array2d);
- }
- function run(){
- var array2d = getEmails_(SEARCH_QUERY);
- if (array2d) {
- var ss = SpreadsheetApp.openById("1c52lPT8oEu-lPloYu_n- apCWiTQgeYP7Wz9cdK2I3w");
- Logger.log(ss.getName());
- var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Potenciales');
- if (sheet != null) {
- Logger.log(sheet.getIndex());
- appendData_(SpreadsheetApp.getActiveSheet(), array2d);
- }
- markArchivedAsRead ();
- }
- function markArchivedAsRead() {
- var threads = GmailApp.search('label:Inbox is:unread from:cotizar@todo.com.ar subject:Formulario ');
- GmailApp.markThreadsRead(threads);
- }
- }
- function getEmails_(q) {
- var emails = [];
- var threads = GmailApp.search(q);
- var messages = threads[0].getMessages();
- for (var i = 0; i < messages.length; i++) {
- /*Solamente si es no leído lo incluimos en el array*/
- if(messages[i].isUnread()){
- emails.push([messages[i].getSubject()]);
- }
- }
- return emails;
- }
Add Comment
Please, Sign In to add comment