Google App Script to export gmail to spreadsheet

exportLabel

function exportLabel() {
  var sheet = SpreadsheetApp.getActiveSheet();

  
  var label = GmailApp.getUserLabelByName("Export.MyExport");
  var threads = label.getThreads();
  for (var i = 0; i < threads.length; i++) {
    var messages = threads[i].getMessages();
    for (var j = 0; j < messages.length; j++) {
      var message = messages[j];
      var id = message.getId();
      var subject = message.getSubject();
      var content = message.getBody();
      var datetime = message.getDate();
      var f = message.getFrom();
      var t = message.getTo();
      var cc = message.getCc();
      var raw = message.getRawContent();

      sheet.appendRow([datetime, id, t, f, subject, content, cc, raw]);
    }
  }
}