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
| function convertSheet2Json(sheet) { | |
| // first line(title) | |
| var firstRange = sheet.getRange(1, 1, 1, sheet.getLastColumn()); | |
| var firstRowValues = firstRange.getValues(); | |
| var titleColumns = firstRowValues[0]; | |
| // after the second line(data) | |
| var lastRow = sheet.getLastRow(); | |
| var rowValues = []; | |
| for(var rowIndex=2; rowIndex<=lastRow; rowIndex++) { |
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
| var urls = [ | |
| 'http://www.example.com/', | |
| 'http://www.yahoo.com/', | |
| ]; | |
| var to = '[email protected]'; | |
| var sub = 'HTTP check failure'; | |
| var body = "The server seems to be down. Please check the server status.\n" ; | |
| function myFunction() |