Google script to send e-mail

sendEmail.gs

/* ---- Script to send an E-Mail ---- */

function onlyToAddTheDriveScope() {
	DriveApp.getRootFolder();
}

function getDate() {
	var date = new Date();
	var dateofDay = new Date(date.getTime());
	return Utilities.formatDate(dateofDay, "GMT+05:30", "dd-MM-yyyy hh:mm:ss a"); // IST
}

function sendEmail()
{
	var ssID = SpreadsheetApp.getActiveSpreadsheet().getId();
	var sheetName = SpreadsheetApp.getActiveSpreadsheet().getName();

	var email = Session.getActiveUser().getEmail();
	var recipients = "firstname.lastname@companyname.com";
	var subject = "Auto generated Google Analytics report "+getDate();
	var body = "****NOTE: THIS IS AN AUTO COMPUTER-GENERATED REPORT****";
	var requestData = {"method": "GET", "headers":{"Authorization":"Bearer "+ScriptApp.getOAuthToken()}};
	var url = "https://docs.google.com/spreadsheets/d/"+ssID+"/export?format=xlsx&id="+ssID;
	var result = UrlFetchApp.fetch(url, requestData);
	var contents = result.getContent();

	MailApp.sendEmail(recipients, subject, body, {attachments:[{fileName:sheetName+".xls", content:contents, mimeType:"application//xls"}]});
}