Untitled

spreedsheet script time limit
var sheet = SpreadsheetApp.getActiveSheet();
    var toShow=new Array()
    for (var i = 502; i < 550; i++) {
    var myThread = GmailApp.search("is:w-destino-mensajes")[i];
   if(myThread.length>0){
    var message = myThread.getMessages()[0];
    toShow.push([message.getDate(),message.getFrom(),message.getBody()]);
}
    }
    sheet.getRange(startRow,2,toShow.length,toShow[0].length).setValues(toShow)