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); }