Last active
March 14, 2017 18:01
-
-
Save maheshwarLigade/8908380c9adc249d958779bcbdc4a221 to your computer and use it in GitHub Desktop.
GoogleSpreadSheet read data from spreadsheet and send mail.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 = "[email protected]"; // 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