Hoping to be able to automate an annoying part of my day...
The emails always come formatted the same ... here's the part of the email I'm looking to pull the data from.

Item#: SS10MM  

Product Description: 10mm SOCKET  

Vendor: Store  

Vendor Item Code: 10MSS  

Complaint: Lost another one, really wish you could put a GPS chip in these!

Is it possible to have a script pull that information and put each of those in a corresponding column?

I have attempted to work with some of the scripts I have found online when searching 'parse email to sheet', but those seem to be trying to bring the entire email over, which is obviously not what I'm looking for.

Help??

Edit: I guess current code might help, huh?

```
function getGmail() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var threads = GmailApp.search('in:inbox is:unread from:
(you@aol.com) "TEST EMAIL"');

for (var i = 0; i < threads.length; i++) {
var messages = GmailApp.getMessagesForThread(threads[i]);
for (var j = 0; j < messages.length; j++) {
var msg=messages[j].getPlainBody(); 
var msg=msg.trim() 
}
}
result1(msg)
}
function result1(range) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet1 = ss.getSheetByName("Sheet1")
var lr=sheet1.getLastRow()
var output=[]
var line=range.split("\n")
for(j=0;j<line.length;j++){
output.push(line[j].split(" "))
}
var output1=[]
for(k=0;k<output.length;k++){
if(output[k]!=""){
output1.push(output[k])
}}
sheet1.getRange(lr+1, 1, output1.length, 
output1[0].length).setValues(output1)
}

```