Reads Gmail into a Google Sheet

GmailReaderAppsScript.js

//
// date: 17.01.2020, jr
//
var SEARCH_QUERY = "label:inbox is:unread to:me";
var SEARCH_QUERY_ALL = "label:inbox to:me";

function getEmails_(q) {
    var email = []; 
    var threads = GmailApp.search(q);
    for (var i in threads) {
        var msgs = threads[i].getMessages();
        for (var j in msgs) {
            var mail = msgs[j];
            email.push([mail.getSubject(), mail.getFrom(), mail.getDate(), mail.isUnread(), mail.getPlainBody().substring(0, 100)]);
        }
    }
    return email;
}

function appendDataTest_(arr) {

    var mailSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Mail");
    var len = arr.length + 1;
    mailSheet.getRange("Mail!A2:E" + len ).setValues(arr); 
}

function saveEmails() {
    var array2d = getEmails_(SEARCH_QUERY);
    if (array2d) {
        appendDataTest_(array2d);
    }
}

function onOpen() {
	var spreadsheet = SpreadsheetApp.getActive();
	var menuItems = [
		{ name: "Read my Mail", functionName: "saveEmails" }
	];
	spreadsheet.addMenu("Admin", menuItems);    
}