Skip to content

Instantly share code, notes, and snippets.

@maheshwarLigade
Last active March 14, 2017 18:01
Show Gist options
  • Save maheshwarLigade/8908380c9adc249d958779bcbdc4a221 to your computer and use it in GitHub Desktop.
Save maheshwarLigade/8908380c9adc249d958779bcbdc4a221 to your computer and use it in GitHub Desktop.
GoogleSpreadSheet read data from spreadsheet and send mail.
Google sheet to read last row values and column header and drop a mail.
To create script you need to use Tools -->script editor
After that you can copy and paste the below script and run it will drop you mail.
If you want to create the trigger then create trigger on same script where we can run this script when sheet is
updated or same data is updated.
To create trigger from script editor you need to navigate to
Edit -->Current Project's trigger.
##Sample code
function sendEmails() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var range = sheet.getRange(sheet.getLastRow(), 1, 1, sheet.getMaxColumns());
var columnName = sheet.getRange(1, 1, 1, sheet.getMaxColumns());
values = range.getValues();
headers = columnName.getValues();
var message = "";
// here I have 17 columns so I hardcoded value
for (var i = 0; i <17; i++) {
message += headers[0][i]+" == "+values[0][i]+"\n";
}
//Logger.log(values);
var emailAddress = "sample@mail.com"; // First column
var subject = "Meeting Insights Data";
MailApp.sendEmail(emailAddress, subject, message);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment