77

var SEARCH_QUERY = "label:astronomia is:unread";

function getEmails_(q) {
    var emails = [];
    var emailsdata = [];
    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, '\n')
                .replace(/^\s*\n/gm, '').replace(/^\s*/gm, '').replace(/\s*\n/gm, '\n')

            ]);

        }
    }

    return emails;
}


function getEmailst_(p) {
    var emailst = [];
    var emailsdatat = [];
    var threadst = GmailApp.search(p);
    for (var it in threadst) {
        var msgst = threadst[it].getMessages();
        for (var jt in msgst) {
            emailst.push([msgst[jt].getDate()


            ]);

        }
    }

    return emailst;
}

function appendData_(sheet, array2d) {
    sheet.getRange(sheet.getLastRow() + 2, 1, array2d.length, array2d[0].length).setValues(array2d);
     sheet.getRange(1,1).setValue("TITULO");






}

function appendDatae_(sheet, dates) {

    sheet.getRange(2, 2, dates.length, dates[0].length).setValues(dates);
      sheet.getRange(1,2).setValue("FECHA");


}

function saveEmails() {
    var array2d = getEmails_(SEARCH_QUERY);
    var dates = getEmailst_(SEARCH_QUERY);
    if (array2d) {
        appendData_(SpreadsheetApp.getActiveSheet(), array2d);
    }
    if (dates) {
        appendDatae_(SpreadsheetApp.getActiveSheet(), dates);
    }
}