Gmail Extract Recieved EMails

PHOTO EMBED

Sat Sep 09 2023 14:29:30 GMT+0000 (Coordinated Universal Time)

Saved by @menaheero

function extractEmailsToCSV() {
  // Use the Gmail service to fetch emails
  var threads = GmailApp.getInboxThreads(0, 10); // Get the first 10 threads from the inbox

  // Use the Google Sheets service to create a CSV file
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Sheet1');

  var csvData = [];

  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 sender = message.getFrom();
      var subject = message.getSubject();
      var body = message.getPlainBody();
      var emailData = [sender, subject, body];
      csvData.push(emailData);
    }
  }

  sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
content_copyCOPY