title: Is it possible to send multiple sheets from Google Sheets as an email attachment?
body: <p>I'm currently using the script bellow to export and send a workbook as an email attachment.
  Is it possible to send multiple sheets as one attachment instead of the whole workbook?</p>
  <pre><code>function emailauto() { 
  var date = Utilities.formatDate(new Date(), 'America/Santiago', 'yyyy-MM-dd HH:mm:ss')
  var emaila = ('email1@test.com,email2@test.com')
  var url = &quot;https://docs.google.com/spreadsheets/d/ + &quot;FileID&quot; + /export?format=xlsx&amp;access_token=&quot; + ScriptApp.getOAuthToken();
  var file = UrlFetchApp.fetch(url).getBlob().setName(&quot;Filename_&quot; + date + &quot;.xlsx&quot;);
  
  GmailApp.sendEmail(emaila, 'Test', 'Test date: ' + date + '.\n\nRegards.', {
      attachments: [file],
      name: 'Tester'
  });
  }
  </code></pre>