This is a demo of a simple appScript to get an email message and push the data into a google sheet file

GmailToSheet.js

function logEmailsToSheet() {
  // Specify the subject line to search for in Gmail
  var query = 'subject:"Feedback Submission"';
  // Access the active spreadsheet and the first sheet
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  // Search Gmail with the given query
  var threads = GmailApp.search(query);
  
  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];
      // Extract date, sender, subject, and body from each email
      var date = message.getDate();
      var from = message.getFrom();
      var subject = message.getSubject();
      var body = message.getPlainBody();
      
      // Append the data to the sheet
      sheet.appendRow([date, from, subject, body]);
    }
  }
}