CodeLeom/GmailToSheet.js

## 24 changes: 24 additions & 0 deletions GmailToSheet.js
@@ -0,0 +1,24 @@

    function logEmailsToSheet() {
function logEmailsToSheet() {

      // Specify the subject line to search for in Gmail
  // Specify the subject line to search for in Gmail

      var query = 'subject:"Feedback Submission"';
  var query = 'subject:"Feedback Submission"';

      // Access the active spreadsheet and the first sheet
  // Access the active spreadsheet and the first sheet

      var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

      // Search Gmail with the given query
  // Search Gmail with the given query

      var threads = GmailApp.search(query);
  var threads = GmailApp.search(query);


      for (var i = 0; i < threads.length; i++) {
  for (var i = 0; i < threads.length; i++) {

        var messages = threads[i].getMessages();
    var messages = threads[i].getMessages();


        for (var j = 0; j < messages.length; j++) {
    for (var j = 0; j < messages.length; j++) {

          var message = messages[j];
      var message = messages[j];

          // Extract date, sender, subject, and body from each email
      // Extract date, sender, subject, and body from each email

          var date = message.getDate();
      var date = message.getDate();

          var from = message.getFrom();
      var from = message.getFrom();

          var subject = message.getSubject();
      var subject = message.getSubject();

          var body = message.getPlainBody();
      var body = message.getPlainBody();


          // Append the data to the sheet
      // Append the data to the sheet

          sheet.appendRow([date, from, subject, body]);
      sheet.appendRow([date, from, subject, body]);

        }
    }

      }
  }

    }
}