function onOpen() {
getTVID();
}
function getTVID() {
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(‘A1:Z100’).clearContent();
var threads = GmailApp.search(‘from:tv@gmail.com “TV on “‘);
for (var i=0; i < threads.length; i++)
{
var messages = threads[i].getMessages();
for (var j=0; j < messages.length; j++)
{
if (!messages[j].isUnread())
{
continue;
}
tid=messages[j].getSubject();
pid=messages[j].getSubject();
dte= messages[j].getDate();
tvid=tid.slice(tid.length-9, tid.length);
pvid=pid.slice(5, tid.length-12);
sheet.appendRow([dte,pvid,tvid]);
}
}
}
