Email the filter results from Google Apps Scripts

by

I have the following function (btw I am new to Google Apps Scripts).

function testing(){
  let thisSpreadsheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(thirtyMinuteWorksheet).getDataRange().getValues()

  let filterData = thisSpreadsheet.filter(function (row,index) {
      return row[11] >= 30
  });


if(filterData.length > 0){
      MailApp.sendEmail({
      to: 'email@gmail.com',
      subject: 'test',
      body: filterData,
      noReply: true
      });
  }

the filter data filters the sheet and returns all the rows that match the logic. Id like to be able to email those rows. if I run this, i get and email with this. (plus more, shorten it for simplicity).

{10=[Ljava.lang.Object;@7f7f43f6, 179=[Ljava.lang.Object;@d387470, 
83=[Ljava.lang.Object;@5daa185f, 54=[Ljava.lang.Object;@39ca2a17, }

i can see this is an object but I couldnt find anything on their API that pointed me in the right direction as to how to covert this results into the actual values

ps

Yes, if i console.log filterData i do get the correct objects. any ideas?

257 thoughts on “Email the filter results from Google Apps Scripts”

  119. Magnificent items from you, man. I have take into account
    your stuff previous to and you’re simply too wonderful.
    I actually like what you’ve acquired right here, certainly like
    what you’re saying and the best way by which you assert it.
    You’re making it entertaining and you continue to take care of
    to stay it sensible. I cant wait to read much more from
    you. This is actually a terrific site.

    Reply

  120. Hi! I simply wish to give you a huge thumbs up for your great information you’ve got right here on this post.
    I will be returning to your web site for more soon.

    Reply

  121. This is really interesting, You are a very skilled blogger.
    I’ve joined your rss feed and look forward to seeking more of your excellent post.
    Also, I have shared your web site in my social networks!

    Reply

  122. Hmm is anyone else experiencing problems with the pictures on this blog loading?
    I’m trying to find out if its a problem on my end
    or if it’s the blog. Any feedback would be greatly appreciated.

    Reply

  123. Good day! This post couldn’t be written any better!

    Reading this post reminds me of my previous room mate! He always kept chatting about
    this. I will forward this article to him. Pretty sure he
    will have a good read. Thanks for sharing!

    Reply

  124. Its like you read my thoughts! You appear to grasp a lot about
    this, like you wrote the book in it or something.
    I think that you can do with some percent to force the
    message house a bit, but instead of that, that
    is magnificent blog. A great read. I will certainly be back.

    Reply

  126. Sweet blog! I found it while surfing around on Yahoo News.
    Do you have any tips on how to get listed in Yahoo News?
    I’ve been trying for a while but I never seem to get there!

    Cheers

    Reply

  127. Thanks for the good writeup. It in reality was a leisure account
    it. Look complex to far brought agreeable from you! However, how can we keep up a correspondence?

    Reply