This is Google app scripts snippet to export Ingress Portal Submission Review Progression from your gmail inbox into a google spreadsheet

export Ingress Portal Submission Progress

function myFunction() {
    var youremail = "youremail@example.com";
    var mailtitle = "Portal Submission Review Progress";
  
    var subjectqueries = {
        "submit" : 'in:anywhere from:"Ingress Operations", subject:"Ingress Portal Submitted: "',
        "review" : 'in:anywhere from:"Ingress Operations", subject:"Portal review complete: "',
        "Live"   : 'in:anywhere from:"Ingress Operations", subject:"Ingress Portal Live: "',
        "Reject" : 'in:anywhere from:"Ingress Operations", subject:"Ingress Portal Rejected: "',
        "accept" : 'in:anywhere from:"Ingress Operations", "1000 AP"'
    };
    var result = {
        "submit" : 0,
        "review" : 0,
        "Live"   : 0,
        "Reject" : 0,
        "accept" : 0
    };
    var threads;
    var i;
    var keys = Object.keys(subjectqueries);
 
    for (var j = 0; j < keys.length ; j++) {
        i = 0;
        do{
            threads = GmailApp.search(subjectqueries[keys[j]], 500 * i, 500);
            result[keys[j]] += threads.length
            i++;
        } while (threads.length === 500);
    };
 
    var    submit = result.submit;
    var  reviewed = result.review + result.Live + result.Reject;
    var remaining = result.submit - result.review - result.Live - result.Reject;
    var      live = result.accept;
    var    reject = result.review - result.accept + result.Reject + result.Live;
  
    var msg = "Result is below." + "\n";
        msg += "Submissions: " + submit.toString() + "\n"
        msg += "Reviewed: " + reviewed.toString() + "\n"
        msg += "Remaining: " + remaining.toString()  + "\n"
        msg += "Live: " + live.toString()  + "\n"
        msg += "Rejected: " + reject.toString() + "\n"
        msg += "Last update: " + Date()
       
    GmailApp.sendEmail(youremail, mailtitle, msg);
}