yepher

function countEmails() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear(); // Clear the sheet before writing new data
  sheet.appendRow(["Total Emails", "HTML Emails", "Text Emails", "[if (mso) in HTML"]);

  // Fetch emails from the Inbox
  const threads = GmailApp.getInboxThreads();
  let totalEmails = 0;
  let htmlEmails = 0;
  let ifMsoEmails = 0;