Google Apps Script - Send Google Sheet as Email Attachment

Question

I am currently trying to send a google sheet as an email attachment using Google Apps Script. When I execute the code (shown below) it automatically sends it as a PDF even though I have not specified I want to send it in this format.

Is there a way to send the attachment in Google Sheet format?

{
    try
    {
      // Get file from Google Drive
      var googleSheet = DriveApp.getFileById("xxxxxxxxxxxxxxxx")

      // Send email with file attached
      MailApp.sendEmail("[email protected]", "Report", "Please see the attached report.", {attachments: googleSheet})
    }
    catch (exception)
    {
        Logger.log(exception);
    }
}

Answer 1

• The documentation for attachment specifies:

This is a regular Blob

• And the documentation about the contentType for blobs says:

contentType

The MIME type to convert to. For most blobs, 'application/pdf' is the only valid option.

There are two things you can do

• If you want to send your Google spreadsheet as a spreadsheet - you need to send the link to the file in the message body, rather than adding the file as attachment
• If you want to send the file as a different file format (e.g. xls) - you will need to convert it to such beforehand, manually - e.g. as done here