Pinned Loading

1. Find distance and driving time betwe... Find distance and driving time between locations stored in google spreadsheet by using Distance Matrix API

   1

   function onOpen() {//adds new menu item to active spreadsheet

   2

     var sheet = SpreadsheetApp.getActiveSpreadsheet();

   3

     var entries = [

   4

       {name : "Calculate distance", functionName : "findDistance"},

   5

       {name : "Clear distance", functionName : "clearIDs"}];

2. Copy google spreadsheet with all pro... Copy google spreadsheet with all protected ranges permissions

   1

   function Main() {

   2

     var template = DriveApp.getFileById('YOUR_SPREADSHEET_ID');              //template spreadsheet

   3

     var destination = DriveApp.getFolderById('COPY_DESTINATION_FOLDER_ID');  //the directory to copy the file into

   4

     var curDate = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), "yyyy-MM-dd");

   5

     var copyName = template.getName() + ' copy ' + curDate;                  //the filename that should be applied to the new copy (e.g. "My spreadsheet copy 2019-08-24")

3. GoogleScriptForm GoogleScriptForm Public

   HTML form created using google scripts

   HTML 3

4. gsheetvocab gsheetvocab Public

   Build vocabulary by adding words to google sheet

   JavaScript

5. yaoparallax yaoparallax Public

   yet another one experimental parallax scroll

   JavaScript