How to create an automatic email with attachment sending code in google spreadsheet
This is a small
Google script code
that send mail periodically (by setting timer) by having an attached pdf copy to a sender mail.Thanks to +bithesh soubhagya
function myFunction() {
// convert spread sheet to portable document format (pdf) with google spreadsheet
var sheetToPdf = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheet/ccc?key=7AuhngraNMxhdFpxT24WEJjN0FzMjMDEEP1AMzRYXRZNVE&usp=drive_web#gid=9");
Logger.log(" sheet name :::: "+SpreadsheetApp.getActiveSheet().getName());
MailApp.sendEmail('belazy1987atgmail.com', 'Testing automatic email with google spreadsheet ', 'Hi, this is subject automatic email sender in google spreadsheet script running', {
name: 'Google , Spreadsheet ',
attachments: sheetToPdf
});
Logger.log(" Email sent successfully !!! ");
}
Here is a small google script (.gs) function. the above code will sent the google spreadsheet as pdf document through mail. you can specify receivers mail id, subject etc in MailApp.sendEmail function.
Then, if you want to invoke the function automatically use timer button.
Sending alert while opening a file using google script
function sentOnOpen() {
var sheetToPdf = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheet/ccc?key=0AuhngraNMxhdFJnMANKALIGNBUnVUbTJVg2dE05Y0UEE&usp=drive_web#gid=0");
var todayDate = new Date();
Logger.log(" inside date "+todayDate);
var htmlBody = sheetToPdf.getViewers()+" opened the Report on "+todayDate;
var subject = " Report " ;
var optAdvancedArgs = {name: "VIPIN", htmlBody: htmlBody};
MailApp.sendEmail("belazy1987atgmaildotcom", subject , "Email Body" , optAdvancedArgs);
Logger.log(" Sending email ");
}
you can set the timer. The timer option available on the script page. run it.
The full source code available here, you can run the script and check the result
click here to run the script
http://javabelazy.blogspot.in/
