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); }
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter