Google sheets script how to convert data from sheet to xl format or .csv?

Question

Google Apps Script

Please help with converting data from google spreadsheet to xl or .csv file for sending by email. Didn't find a suitable method.
My code throws an attachments argument error:
var sSheet = SpreadsheetApp.openById('xxxxxxxxxxxxxxxxxxx');
var sheetLink = sSheet.getActiveSheet();
var values ​​= sheetLink.getDataRange().getValues();
var text = ContentService.createTextOutput().append(values)
MailApp.sendEmail(
'[email protected]',
'Report',
'Catch',
{attachments: [text]}
);

Answer 1

Did something like this once.
There was one point - you need to save the sheet of the table in a new file and send it already in a certain format. Below is part of the code saving in xlsx format. Full code here

var ssSend     = ssNew.getId()
  var sendFile   = Drive.Files.get(ssSend);
  var url        = sendFile.exportLinks[MimeType.MICROSOFT_EXCEL];
  var token      = ScriptApp.getOAuthToken();
  var response   = UrlFetchApp.fetch(url, {
    headers: {
      'Authorization': 'Bearer ' +  token
    }
  }); 
   

  var blobs   = [response.getBlob().setName(sendFileName)];
//  var sizeBlob = blobs[0].getBytes();
  
  var subject = ssSourceName;
  var message = 'Файл подготовлен и отправлен: ' + Utilities.formatDate(d, timeZone,'dd.MM.yyyy HH:mm:ss'); 
  MailApp.sendEmail(toMail, subject, message , {attachments: blobs });