TypeError: Cannot read property "length" from undefined

Question

I am trying to use the code below that i got from this link:

Import emails that fit criteria to Google Spreadsheet using apps script

and it is giving me the error

TypeError: Cannot read property "length" from undefined.

Can someone help?

   function getMessagesWithLabel() {
     var destArray = new Array();
      var threads = GmailApp.getUserLabelByName('Facebook').getThreads(1,10);

      for(var n in threads){
            var msg = threads[n].getMessages();
            var destArrayRow = new Array();
            destArrayRow.push('thread has '+threads[n].getMessageCount()+' messages');
              for(var m in msg){
                         destArrayRow.push(msg[m].getSubject());
               }
      destArray.push(destArrayRow);           
            }
    Logger.log(destArray);
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sh = ss.getActiveSheet();
    if(ss.getLastRow()==0){sh.getRange(1,1).setValue('getMessagesWithLabel() RESULTS')};
    sh.getRange(ss.getLastRow()+1,1,destArray.length,destArray[0].length).setValues(destArray)
    }

If threads is empty (because GmailApp.getUserLabelByName has an empty result, then destArray will be empty, and destArray[0] will be non-existant (undefined). You'll want to check whether threads is not empty before proceeding. — user707650
– user707650, Commented Jun 9, 2015 at 3:35
Other people have used this code by only changing the label name. What am i doing wrong? — Desmond Tatilian
– Desmond Tatilian, Commented Jun 9, 2015 at 3:40
getUserLabelByName('Facebook'). do your Gmail labels include Facebook? — ScampMichael
– ScampMichael, Commented Jun 9, 2015 at 3:54
I found out the problem var threads = GmailApp.getUserLabelByName('Facebook').getThreads(1,10) should be var threads = GmailApp.getUserLabelByName('Facebook').getThreads(0,10) — Desmond Tatilian
– Desmond Tatilian, Commented Jun 9, 2015 at 3:56

Dylan Riley · Accepted Answer · 2019-04-03 01:38:49Z

1

The problem is if there are no elements in GmailApp.getUserLabelByName('Facebook').getThreads(1,10); then threads will be null and the loop for(var n in threads) will not work

this means that you need to type

var threads = GmailApp.getUserLabelByName('Facebook').getThreads(1,10);

if (threads != null) {
  for(var n in threads) {

answered Apr 3, 2019 at 1:38

Dylan Riley

4291 gold badge4 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

TypeError: Cannot read property "length" from undefined

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related