Gmail Extract Recieved EMails
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
Comments