var message;
//====================== Custom Menu function start ==========
function onOpen(e) {
  SpreadsheetApp.getUi()
      .createMenu('My Menu')
      .addItem('Get Email', 'getGmailEmails')
      .addToUi();
}
//=================== get Email function start ========
function getGmailEmails(){
var threads = GmailApp.getInboxThreads();
for(var i = 0; i < threads.length; i++){
    
    var messages = threads[i].getMessages();
var msgCount = threads[i].getMessageCount();
    
    // Logger.log("TH: "+ i + " =>" + msgCount);
for (var j = 0; j <messages.length; j++){
       message = messages[j];
      
      if (message.isInInbox()){
extractDetails(message,msgCount);
      }
   
    }
  }
  
}
//====================== Extract function start ==============
function extractDetails(message, msgCount){
var spreadSheetId='1bcVO43up7kp4MXP7yicywAxDr4NeICzJC1SLMaBTT0s';
   var sheetname = "Sheet1";
  
  var ss = SpreadsheetApp.openById(spreadSheetId);
  var timezone = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone();
var sheet = ss.getSheetByName(sheetname);
  const today = new Date();
// var dateTime = message.getDate();
  var dateTime = Utilities.formatDate(message.getDate(), timezone, "dd-MM-yyyy");
var subjectText = message.getSubject();
  var fromSend = message.getFrom();
  var toSend = message.getTo();
  var bodyContent = message.getPlainBody();
sheet.appendRow([dateTime, msgCount, fromSend, toSend, subjectText, bodyContent]);
   
}