Skip to content

Instantly share code, notes, and snippets.

@takakabe
Created August 23, 2017 04:29
Show Gist options
  • Save takakabe/2ef0cc39699a74e16feaa77ee544cdb8 to your computer and use it in GitHub Desktop.
Save takakabe/2ef0cc39699a74e16feaa77ee544cdb8 to your computer and use it in GitHub Desktop.
Google Apps Script
function mail_send() {
var sheet = SpreadsheetApp.getActiveSheet();
var to_address = sheet.getRange(1,1).getValue();
var mail_subject = sheet.getRange(2,1).getValue();
var mail_body = sheet.getRange(3,1).getValue();
MailApp.sendEmail(to_address,mail_subject,mail_body);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment